weird problems after upgrade

[bob-0]

Hi all,
I'm in a bit of a quandary and I was hoping you could help.

I upgraded my apache+php and now I'm getting weird mysql behaviour...

I tried to run a mysql backup script but I got this at the command line as root:
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/m
ysql.sock'

so as root I went to go to the source and find out what the trouble might be so as root I typed
mysql -umyname -pmypass which normally would drop me
into the mysql command line..but instead I get the same error...

Now I know that mysql is in fact running, I can communicate with it via phpmyadmin and mysqlman, My forums and everything else is working perfectly but heres the deal.....

I cant find mysql.sock anywhere... not in /var/lib/mysql not in /tmp
in fact it is nowhere on my server....

Here is some of the output from phpinfo on my server...

./configure' '--with-apxs2=/usr/local/apache2/bin/apxs' '--with-mysql=/usr/local/mysql'

Registered PHP Streams php, http, ftp, compress.zlib

MYSQL_SOCKET /tmp/mysql.sock

MYSQL_INCLUDE -I/usr/local/mysql/include/mysql

MYSQL_LIBS -L/usr/local/mysql/lib/mysql -lmysqlclient

Here is my my.cnf file
[mysqld]
datadir=/usr/local/mysql/var
socket=/tmp/mysql.sock

[mysql.server]
user=mysql
basedir=/usr/local/mysql

[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
and my server info

Apache/2.0.47 (Unix) PHP/4.3.2 mysql Client API version 3.23.40

linux, redhat 7.3 updated files and kernal

Any one??? thanks
bob-0

Thread Resolved

[LordShryku]

Usually a restart of mysqld or reboot of the server will restore the mysql.sock for you....

[bob-0]

Sorry I forgot to mention that I had restarted mysql several times and rebooted the server twice... there is no mysql.sock but mysql is running??? I've tried locate mysql.sock and find /-uname mysql.sock... I even ran updatedb before the search... heres another weird thing... Before I upgraded the apache and php I'm sure my my.con file pointed the sock file to /var/lib/mysql now it at /tmp????

[bob-0]

Ok.. heh..heh
For some reason while looking for the file via cute ftp it would not see the file...
ls with a telnet client did:rolleyes:
what I did after I found it was just add a symlink in /var/lib/mysql
to the sock file in /tmp after making sure the +t bit was set on the /tmp directory and all was well again...
Thanks for the reply LordShryku...

Hope this helps some other poor soul....

Peace

Bob-0