[cobalt-users] Re: Problem with PHP on raq4

[Bruce Timberlake <bruce@xxxxxxxxxx>]

William E. Moore wrote:

> Warning: Can't connect to local MySQL server through socket 
> '/tmp/mysql.sock' (111) in /home/sites/site5/web/cfaq/functions.php on 
> line 14
>
> Warning: MySQL Connection Failed: Can't connect to local MySQL server 
> through socket '/tmp/mysql.sock' (111) in 
> /home/sites/site5/web/cfaq/functions.php on line 14
>
> Warning: Supplied argument is not a valid MySQL-Link resource in 
> /home/sites/site5/web/cfaq/functions.php on line 17
> Couldn't open organizer: Can't connect to local MySQL server through 
> socket '/tmp/mysql.sock' (111)
>
> I can user perl and connect correctly to mysql  with the socket 
> /home/mysql/mysql.sock
> I figure that php has it defined wrong but damn if I know where to 
> change it.  anyone out there know ?

I recommend setting up a symlink to your existing socket:

	ln -s /home/mysql/mysql.sock /tmp/mysql.sock

You also *could* edit /etc/my.cnf and make this entry:

	socket = /home/mysql/mysql.sock

in the "[client]" section (if you edit my.cnf, restart MySQL to load the new 
info), but I think leaving the socket in /tmp is better...