Mysql commandline not working

[itrends]

Very weird problem here..

when a webpage try's to access mysql it uses '/var/tmp/mysql.sock' (as i want) and works fine. But when eximstats (or a user on shell) tries to use it it wants a '/tmp/mysql.sock' (wich DOES exist) and mysql just wont work.

root@bt2:/var/log# mysqladmin processlist
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)'
Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists!
root@bt2:/var/log#

root@bt2:/var/log# cat /tmp/mysql.sock
cat: /tmp/mysql.sock: Connection refused
root@bt2:/var/log#

root@bt2:/var/log# cat /var/tmp/mysql.sock
'
4.0.24"9:W(`,V,root@bt2:/var/log#

root@bt2:/var/log# ls -l /tmp | grep sock
srwxrwxrwx 1 mysql wheel 0 May 8 21:03 mysql.sock
root@bt2:/var/log#

root@bt2:/var/log# ls -l /var/tmp | grep sock
srwxrwxrwx 1 mysql wheel 0 May 8 21:03 mysql.sock
root@bt2:/var/log#

Now every 10 minutes eximstats and mysql both fail.. i hate the emails, can't find ANYthing wrong? Didn't change anything.

--
Using:
root@bt2:/var/log# uname -a
FreeBSD bt2.xxx.nl 5.4-PRERELEASE FreeBSD 5.4-PRERELEASE #0: Wed Mar 16 18:24:13 CET 2005 root@bt2.xxx.nl:/usr/obj/usr/src/sys/BONTEKOE i386
root@bt2:/var/log#


update
Found something:
root@bt2:/tmp# df

Filesystem 1K-blocks Used Avail Capacity Mounted on
/dev/ad12s1a 148526 76550 60094 56% /
devfs 1 1 0 100% /dev
/dev/ad4s1d 151368706 14598812 124660398 10% /backup
/dev/ad12s1e 71449510 12115312 53618238 18% /usr
/dev/ad12s1d 2026030 715556 1148392 38% /var
devfs 1 1 0 100% /var/named/dev
/dev/md0c 247726 770 227138 0% /tmp
/tmp 247726 770 227138 0% /var/tmp
procfs 4 4 0 100% /proc
root@bt2:/tmp#

I have never seen a /var/tmp partition before, no idea how that got there? It's not even in the FSTAB!

[itrends]

Anybody?

I need an sollution pretty bad

[itrends]

OK, seems that cpanel creates a 'nullfs' partition in the swapspace.. Just wondering why nobody of the cpanel team could have just told me so.

Now the only problem, it's not identical! mysql.sock files in /tmp and /var/tmp don't match, so mysql won't work.

[Radio_Head]

same problem here .... Darkorb ?!?!?

[itrends]

same problem here .... Darkorb ?!?!?

Yea.. cpanel supprt rox.. great!

I got somebody to help me out, at 75 € an hour. Just UNCOMMENT the 'nullfs' part in the securetmp script that cpanel provides.

[chirpy]

These forums are not the place to get support from cPanel. Posying here is simply asking other server admins who come here in their spare time if they can help. If you want cPanel help then you have to log a support ticket with cPanel or through your cPanel license provider.

[easyhoster1]

Yea.. cpanel supprt rox.. great!

I got somebody to help me out, at 75 € an hour. Just UNCOMMENT the 'nullfs' part in the securetmp script that cpanel provides.

Well...I have a machine now with the exact some problem...Cant find anywhere in /scripts/securetmp "nullfs"...Do you know what line its at??

[easyhoster1]

ticket submitted....