RE: Accessing Mysql 5.0 from 4.0 server
"Logan, David (SST - Adelaide)" <[email protected]>
| Newsgroups | gmane.comp.db.mysql.perl |
|---|---|
| Message-ID | <25AD6215EF8A094182444A010D4A401F01D5A135@snoexc03.asiapacific.cpqcorp.net> |
Hi Trevor, I think your problem may be the version of the mysql client library. You mentioned your rpm version was 4.0.21. Please note the libmysqlclient.so comes in the MySQL-devel-4.0.21-0 rpm NOT in the MySQL-client-5.0.4-0 package. The mysql client would have connected because it was precompiled with a version 5 library. When you rebuilt the DBD::MySQL it would have picked up a version 4.0.21 library which would produce the error message that you describe. You may have to install the version 5 development rpm rather than the one that you have. http://dev.mysql.com/doc/mysql/en/old-client.html Regards David Logan Database Administrator HP Managed Services 148 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 - Work +61 417 268 665 - Mobile +61 8 8408 4259 - Fax -----Original Message----- From: Philip M. Golllucci [mailto:[email protected]] Sent: Wednesday, May 18, 2005 10:21 PM To: Trevor Price Cc: [email protected] Subject: Re: Accessing Mysql 5.0 from 4.0 server Trevor Price wrote: > I might have missed this in the start of the thread, but can you paste > the first 10 lines or so of the errors. Okay I looked back in the archives: >>DBI connect(...) failed: Client does not support authentication >>protocol requested by server; consider upgrading MySQL client at >>./test_db.pl line 7 My next thought is try: ldd mysql ldd mysqld make sure the libmysql match up accordingly. -- END ------------------------------------------------------------------------ --- What doesn't kill us can only make us stronger. Philip M. Gollucci [email protected] 301.254.5198 Consultant / http://p6m7g8.net/Resume/resume.shtml Senior Developer - Liquidity Services Inc. http://liquidityservicesinc.com <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] -- MySQL Perl Mailing List For list archives: http://lists.mysql.com/perl To unsubscribe: http://lists.mysql.com/[email protected]