PDA

View Full Version : Sol 10 x86, mysql prob with SlimServer_v6.5.4



Blue_Atom
2007-09-18, 02:32
Morning all,

as per the title I have been unable to get the latest version of SlimServer working with my existing MySQL instance.

Slimserver 6.5.3 works fine, and 6.5.4 works fine using the embedded instance, but adding the db lines to my pref file ( see http://wiki.slimdevices.com/index.cgi?ExistingMySQLInstance), I get the following error;

$ ./slimserver.pl
2007-09-18 10:10:03.4143 ERROR: DBI Connection failed: DBI connect('database=slimserver:mysql_socket=/tmp/mysql.sock','slimserver',...) failed: Client does not support authentication protocol requested by server; consider upgrading MySQL client at /data/tmp/SlimServer_v6.5.4/CPAN/DBIx/Class/Storage/DBI.pm line 652

2007-09-18 10:10:03.4147 ERROR: Backtrace follows:

2007-09-18 10:10:03.4151 Backtrace:

frame 0: Slim::Schema::Storage::throw_exception (/data/tmp/SlimServer_v6.5.4/CPAN/DBIx/Class/Storage/DBI.pm line 658)
frame 1: DBIx::Class::Storage::DBI::_connect (/data/tmp/SlimServer_v6.5.4/CPAN/DBIx/Class/Storage/DBI.pm line 616)
frame 2: DBIx::Class::Storage::DBI::_populate_dbh (/data/tmp/SlimServer_v6.5.4/CPAN/DBIx/Class/Storage/DBI.pm line 543)
frame 3: DBIx::Class::Storage::DBI::ensure_connected (/data/tmp/SlimServer_v6.5.4/Slim/Schema/Storage.pm line 28)
frame 4: (eval) (/data/tmp/SlimServer_v6.5.4/Slim/Schema/Storage.pm line 28)
frame 5: Slim::Schema::Storage::dbh (/data/tmp/SlimServer_v6.5.4/Slim/Schema.pm line 118)
frame 6: Slim::Schema::init (/data/tmp/SlimServer_v6.5.4/Slim/Music/Info.pm line 71)
frame 7: Slim::Music::Info::init (./slimserver.pl line 373)
frame 8: main::init (./slimserver.pl line 450)
frame 9: main::main (./slimserver.pl line 1076)

2007-09-18 10:10:03.7261 ERROR: Couldn't connect to database! Fatal error: [] Exiting!


If I revert back to my 6.5.3 instance it works fine again. The error suggests to my inexpert eye that SlimServer is trying to connect using an old protocol which it wasn't trying to do in previous versions. Has something changed between SlimServer versions that I should be aware of?


Edit: mysql version;
PKGINST: CSWmysql5
NAME: mysql5 - MySQL 5 database management system - server files
CATEGORY: application
ARCH: i386
VERSION: 5.0.37,REV=2007.03.17
BASEDIR: /
VENDOR: http://www.mysql.com/ packaged for CSW by Alex Moore
PSTAMP: thor20070317160854
INSTDATE: Apr 04 2007 11:35
HOTLINE: http://www.blastwave.org/bugtrack/
EMAIL: asmoore@blastwave.org
STATUS: completely installed
FILES: 144 installed pathnames
5 shared pathnames
1 linked files
37 directories
37 executables
54898 blocks used (approx)


Thanks,

Richard

4mula1
2007-09-20, 03:54
Take a look at the Solaris wiki entry:

http://wiki.slimdevices.com/index.cgi?SolarisInstallationGuide

That error looks familiar to me (it's been awhile admittedly) but I suspect the part about the old_password in the MySQL section will be of interest to you.

Blue_Atom
2007-09-20, 07:03
Thanks - that sorted it. I didn't know that there was a Solaris Wiki entry so top marks for that one.
cheers,
Rich