RE: Accessing Mysql 5.0 from 4.0 server
"Trevor Price" <[email protected]>
| Newsgroups | gmane.comp.db.mysql.perl |
|---|---|
| Message-ID | <[email protected]> |
Thanks Phillip, I just deleted /usr/lib/libmysql*so.10* and /usr/lib/libmysql*so.12* This leaves only so.14 and the libmysqlclient.so,libmysqlclient_r.so which are a soft links to libmysqlclient.so.14 However, this did not work after recompiling DBD and reinstalling. Which I find confusing, unless it is using the libs in /usr/lib/mysql? Keep the ideas coming. I am ready to try them. Trevor -----Original Message----- From: Philip M. Golllucci [mailto:[email protected]] Sent: Wednesday, May 18, 2005 9:31 PM To: Trevor Price Cc: Rudy Lippan; [email protected] Subject: Re: Accessing Mysql 5.0 from 4.0 server Trevor Price wrote: > 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 DBD does not choose the library in run time :) If both libraries are in your -L paths which ever one it finds first will be used. You might try temporarily renaming/moving the ones you don't want out of the way while you compile. 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]