RE: Accessing Mysql 5.0 from 4.0 server
"Trevor Price" <[email protected]>
| Newsgroups | gmane.comp.db.mysql.perl |
|---|---|
| Message-ID | <[email protected]> |
That is the best free service I have ever received. Thanks for the quick reply. However I have the same problem. I tried perl Makefile.PL --libs="-L/usr/lib -L/usr/lib/mysql -lmysqlclient_r -lpthread -lz -lcrypt -lnsl -lm -lpthread -lc -lnss_files -lnss_dns -lresolv -lc -lnss_files -lnss_dns -lresolv" The only change from mysql_config is -L/usr/lib which is where the libmysqlclient.so's are, however isn't /usr/lib default? I also tried without -L/usr/lib/mysql and without -lmysqlclient_r All of these different combinations cause many failures in make test. Is the problem DBD is choosing libmysqlclient.so.10 instead of libmysqlclient.so.14 ? I thought the DBD driver actually chooses whether to use libmysqlclient.so.10,12,14 depending upon the server it connects to. Is their a way for me to specify explicitly the library to use? In earnest, Trevor -----Original Message----- From: Rudy Lippan [mailto:[email protected]] Sent: Wednesday, May 18, 2005 4:23 PM To: Trevor Price Cc: [email protected] Subject: Re: Accessing Mysql 5.0 from 4.0 server On Wed, 18 May 2005, Trevor Price wrote: > When I try to connect to a 5.0 server with perl I get > > DBI connect(...) failed: Client does not support authentication protocol > requested by server; consider upgrading MySQL client at ./test_db.pl > line 7 Recompile DBD::mysql against the new client libraries, and make sure that Makefile.PL is picking up the correct libraries, specifing --libs & friends if you have to. Rudy <html> <body> <span style="font-size:8.0pt;font-family:Arial">---------------------------------------------------------------------------------------------------------------------------------------------</span> <span style="font-size:8.0pt;font-family:Arial">DEMANDTEC EMAIL NOTICE:</span> <p><span style="font-size:8.0pt;font-family:Arial">NOTICE: This email transmission and all attached files contain information intended for the designated individual or entity to whom it is addressed and may contain information that is proprietary, privileged and/or exempt from disclosure under applicable law. If you are not the intended recipient or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution, copying, or other use of this email or its attachments is strictly prohibited. If you have received this email in error, please notify the sender immediately by replying to this message and please delete the original message without making any copies.</span> <p><span style="font-size:8.0pt;font-family:Arial">WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. Although we have taken reasonable precautions to ensure that this email and all attachments are free from viruses, we accept no liability for any loss or damage arising from the use of this email or its attachments.</span> </body> </html> -- MySQL Perl Mailing List For list archives: http://lists.mysql.com/perl To unsubscribe: http://lists.mysql.com/[email protected]