Re: mysql.sock location

>>>>> "CF" == Charlie Farinella <cfarinella@xxxxxxxxxxxxxxxxxxxxxxxx> writes:

CF> Hi,
CF> I hope this isn't an FAQ, but I'm not able to find mention of it
CF> anywhere.  

CF> Calling MySQL from Mason, it's looking for mysql.sock in /tmp.  I have
CF> newer RedHat systems with a stock MySQL install and mysql.sock is
CF> created in /var/lib/mysql.  I have one of these systems temporarily
CF> fixed by linking one to the other, but I'd like to be able to avoid this
CF> in the future.

CF> Mason and it's pre-requisites were all installed via CPAN.
CF> What module is looking in /tmp, and how can I configure it to look in
CF> the proper place?

I assume you use DBI and DBD::mysql to query MySQL from your Mason
application.

Path to mysql.sock is compiled in MySQL client library
'libmysqlclient'. You need to rebuilt/update it to point to correct
location. If it is already up-to-date it may be that DBD::mysql was
statically linked to old version of client library - try to rebuild
DBD::mysql in this case.

Alternatively if you don't want rebuilt/reinstall anything you can
always specify path to mysql.sock via DSN. See perldoc DBD::mysql,
look for docs on connection parameter 'mysql_socket'.

P.S. It is hardly a Mason question, more DBI and MySQL question.

-- 
Ilya Martynov,  ilya@xxxxxxxxxxx
CTO IPonWEB (UK) Ltd
Quality Perl Programming and Unix Support
UK managed @ offshore prices - http://www.iponweb.net
Personal website - http://martynov.org


-------------------------------------------------------
This SF.Net email sponsored by: Free pre-built ASP.NET sites including
Data Reports, E-commerce, Portals, and Forums are available now.
Download today and enter to win an XBOX or Visual Studio .NET.
http://aspnet.click-url.com/go/psa00100003ave/direct;at.aspnet_072303_01/01