I installed test server for LinkSQL 3.0.0 on Win XP SP2 with ActivePerl 5.8.6.811, mySQL 4.1.11 & IIS 5.1 running...

hmmm... LinkSQL unable to connect to mySQL... after some researching... looks like linksql does not support new password hash used by mySQL 4.X version. I unstalled it & reinstall latest 3.X verion of mySQL... worked fine. NO issues

Message: Error: Could not connect to database: Client does not support authentication protocol requested by server; consider upgrading MySQL client

Is this an issue with Unix system also?

btw... when I backup LinkSQL from production & tried to restore to local LinkSQL... issues came along... some fields were not their with original 3.X cause some plugins in production created new fields... I tried creating... no luck... I think LinkSQL need to create new fields as needed when restoring... that way it corrects the problem...
anyway... after hrs of researching on the net found a MS DOS command...
backup database using myphpAdmin... creating .sql file...
coping locally & running command to restore it... worked like charm
here is the command for starter if needed...
mysql -udbuser -p < dump.sql

dbuser is a username most likely "root" & dump.sql is a name of backup file.

Hi,


This is due to the DBD::mysql module being compiled against an older version of MySQL. You'll need to compile it yourself or set your password to be an old style password in mysql. See:

http://dev.mysql.com/...l/en/old-client.html

for more information.

Cheers,

Alex
--
Gossamer Threads Inc.

yep... already read that before... since I am running mySQL as NT Service...
how to run it with .... --old-passwords
....
Other then that I tried everything on that page... anyway... I am happy with old one also... since this is anyway test system... good to know... it's not LinkSQL issue, otherwise big problems on production sites running mySQL 4.X version.

Hi,

Sorry, didn't read closely enough. =) Yes, it's a DBD::mysql issue, and not a Gossamer Links issue. If DBD::mysql was compiled against a 4.1 MySQL, then Gossamer Links would work fine (not sure if Activestate provides a ppm for this or not).

Cheers,

Alex
--
Gossamer Threads Inc.

thanks Alex for the info.

here is a fix for Servers running IIS & mySQL 4.1.11 & LinkSQL 3.0.0 & ActivePerl.

it is a DBD-mysql issue... ActivePerl module is very old... 3-4 years

here is a fix...
at Command prompt....
C:\>ppm uninstall DBD-mysql
C:\>ppm install http://theoryx5.uwinnipeg.ca/ppms/DBD-mysql.ppd

U should be fine... is it working 100% now.