Strange error after update

[SeLLeRoNe]

Hi,

ive update/reinstall apache/php and all by build system, but, after update, mysql stop working fine O_O

I know that that is impossible, the error on websites was that cannot find mysqld.sock ... ive checked and mysql was started and mysql.sock was in /tmp directory.. directadmin work fine and mysqld too.. but websites was looking for that sock in /var/run/mysqld/mysqld.sock so.. ive check php.ini and all config but i dont see anywhere this command line, ive made a symbolic link from /tmp/mysql.sock to /var/run/mysqld/mysqld.sock and now it work, but, when mysql get restarted, symbolic link will be automatic deleted.. how it is possible and how i can solve it?

Before php update all was wokring fine..

ive check other boxes all with Debian 4.0 and no-one of those box have this symbolic link...

Ive tryed to put in php.ini the path of mysql.sock but nothing changed...

Can someone help me or say me how can i make a permanent link between /tmp/mysql.sock to /var/run/mysqld/mysqld.sock?

Thanks all

Regards

 

[quleek]

Change the sock location in the my.cnf file.
Its a simple task.
Under[mysqld]
socket=/var/run/mysqld/mysqld.sock

At the end add
[client]
socket=//var/run/mysqld/mysqld.sock

 

[SeLLeRoNe]

Ok, now i got a new problem... with a different box so i dont waste post and i write on same 3d for future ppl with same issue

Lets explain

New box, mysql just installed put him sock in /tmp and i would like to move that in /var/run/mysqld/mysqld.sock

so i thought that was just necessary modify /etc/my.cnd and /usr/local/directadmin/conf/mysql.conf

after changed this two file with new socket position ive restarted mysql...

sock file is in the directory i decide.. directadmin work fine.. but.. customers website have error message that say "cannot connect to mysql"

i dont know why it is happening, in my.cnf i put the

[client]
socket=/var/run/mysqld/mysqld.sock

so i think is everything correct... maybe there is another place where ive to specify sock file path?

thanks for all reply