PDA

View Full Version : Running with MySQL on Windows



JJZolx
2005-04-09, 23:52
Trying to get SlimServer running under Windows with MySQL. I think I have most everything in place, but SlimServer won't start and gives the following error message in the Application Event Log:

The description for Event ID ( 0 ) in Source ( Application ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: DBI connect('database=slimserver','slimserver',...) failed: Client does not support authentication protocol requested by server; consider upgrading MySQL client at /PerlApp/Slim/DataStores/DBI/DataModel.pm line 106.First I created the database in MySQL 4.1.10a, then created the schema using the SQL statements from \server\SQL\mysql\dbcreate.sql.

I have the correct dbusername/dbpassword/dbsource in slimsserver.pref:

> dbpassword = slim
> dbsource = dbi:mysql:database=slimserver
> dbusername = slimserver

Following Vidur's instructions from http://forums.slimdevices.com/showthread.php?t=13021

I've extracted the files from the archive in /blib/arch/auto/DBD/mysql/ to

C:\Program Files\SlimServer\server\CPAN\arch\5.8\MSWin32-x86-multi-thread\auto\DBD\mysql\

under the assumption that they should be in a directory next to the directory for SQLite.

And I've extracted the files from /blib/lib/ to

C:\Program Files\SlimServer\server\CPAN\

I'm running the 6.0.1 04/09 nightly. Any ideas about the authentication protocol error?
________
buy silversurfer vaporizer (http://vaporizers.net/silver-surfer-vaporizer)

BKDotCom
2005-04-10, 01:04
See this:
http://dev.mysql.com/doc/mysql/en/old-client.html

To take care of this I edited my.ini
under [mysqld] I added
old-passwords

I guess you could run this statement
SET PASSWORD FOR 'slimserver'@'localhost' = OLD_PASSWORD('slim');
to "fix" it specifically for slimserver

I just experienced success by running slim.exe from the command line.. (up til now I haven't had any luck as a service)... will give that a shot as soon as library scan is complete

JJZolx
2005-04-10, 11:37
See this:
http://dev.mysql.com/doc/mysql/en/old-client.html
Thanks. That worked.

I changed the password to an "old style" password and SlimServer started up.

Why, if MySQL 4.1 is recommended, does SlimServer use old style passwords rather than the type introduced in MySQL 4.1? I'm guessing the password style is actually in the ActiveState Perl modules downloaded, so maybe a different package is needed with MySQL 4.1, or perhaps a configuration setting somewhere is needed.
________
herbalaire reviews (http://vaporizers.net/herbalaire-vaporizer)

BKDotCom
2005-04-10, 12:14
Not Windows specific, but can slimserversql.db be safely deleted after switching to MySQL?

Christian Pernegger
2005-04-10, 12:23
> Not Windows specific, but can slimserversql.db be safely deleted after
> switching to MySQL?

I'd guess so... worked on linux :)

C.

Dan Sully
2005-04-10, 12:57
* BKDotCom shaped the electrons to say...

>Not Windows specific, but can slimserversql.db be safely deleted after
>switching to MySQL?

Yes.

-D
--
<iNoah> you know, most free operating systems come preinstalled with their own high horse.