Have a Raq4 all patches up to date.
Was able to install MySql and PHP without any problems set up and account and all was working after about 30 days wanted to bounce sereve so I did a reboot from the front server display. After this MySql stopped working. I get

Test connecton failed

Error: -2147418113
Description: Chili!ASP ADO control - build 3.4.1 Open call failed

(In the Test option)

I already tryed removing and reinstaling the packege but no change.

Any other suggestions

This is another error from a script on the site that was working before.

MySQL said:


MySQL Connection Failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111)


Are the .Sock files my prolem??

Thanks
Enrique

Enrique , try this (the problem is probably either the socket in the tmp is being cleared out (tmp -> temporary :D) or mysql is configure with th ewrong paths. Anyway, try:

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

If your sock file is in a different place, replace it in the /home/mysql above. Use: find / -name "mysql.sock"

allending

I did the search and it tells me both are thare, but when I ftp I see it in the /tmp/mysql.sock <-- folder short cut not a file.

And I do not see anything in the /home/mysql/mysql.sock <-- nothing via ftp.

I do see the dbase folder I created though.


Is this normal ??

Thanks
Enrique

When you do the find, does it return both files?

go to the /tmp directory. ln -ls should say that mysql.sock points to somewhereelse/mysql.sock. Is this what is happenening? Check and make sure that it is pointing to the correct file.

allending, this is what I get..

[root tmp]# find / -name "mysql.sock"
/home/tmp/mysql.sock
/home/mysql/mysql.sock
find: /proc/6/fd: Permission denied
You have new mail in /var/spool/mail/admin
[root tmp]#

=========================================================================
IS the info below normal???

[root tmp]# dir
chili-psm phpBHPRjC phpJt098g phpUvXqw7 phpfxmDsw phppearCm
install.log phpBpoqec phpKPh7yS phpUz6ezJ phphRLB9e phprFJSse
mysql.sock phpBtkksx phpKiomKe phpV053VA phphUHu7h phprxTEhj
php06ogL8 phpBwvRgy phpKuBpaC phpVKKnJC phphmQ0lU phpsub9cb
php0N7gP3 phpCEW45o phpLBuK3R phpWgaImj phphseTvc phpt2L9qP
php0N9XOT phpCGOFnI phpLbLjGZ phpXCoaV9 phpi6QreR phptJQdak
php1HXXUN phpCbJAZE phpO43o3i phpXFFgpw phpiZHsUi phptSJvoF
php2Buovg phpCm4Zb0 phpOJjAd5 phpXmKQw9 phpivWPaO phptXfZAc
php2CqLFs phpDBac57 phpPXpp1J phpYNg4ec phpjHrdWZ phpuLyUf5
php2wlZYp phpDCxl61 phpPY6Ts8 phpYlBHE7 phpjJhKNQ phpv8f1sO
php3ejF0x phpDJkfnj phpQFJZqI phpZ7aPWU phpjqhaRZ phpwNvvwK
php3kTX6a phpE9RgTq phpRc8XVa phpZn2gXY phpkmoVG6 phpwdhNjd
php58vu6k phpEQ2vGW phpRszVbP phpail8ct phplTqraj phpy6QVmL
php5muy0n phpFPVl61 phpSF0hEN phpbMPt9g phplcB0SU phpyLDpRh
php7d3NeP phpFSDB1g phpSH4zoU phpbyxOCk phpmJdhJ2 phpylSiQN
php7vGTqm phpG9UJqd phpSWOW6a phpcEaoXg phpmS1LI0 phpzKmW1j
php7ymzDd phpGHEDST phpSp9zON phpcRW7fJ phpmYktyh phpzyYzxM
php88HVaz phpGnmODd phpT6yGc2 phpcioWaM phpmeaWqf vbavatar8zIiy8
php8BVkqc phpHTYV6i phpTO0QJp phpclQjWg phpml6lEv vbavatar9cDh8B
php8ITl1C phpIFfJqj phpTQ9gqx phpcs6vhr phpn1TUF4 vbavatarQu5NnJ
php8Qk8Xt phpIc81Fi phpTncymK phpcsgYQi phpnHwLFg vbavatarVb3kDa
php8Qq3pY phpIit5Ej phpTntvbM phpdQv0Wd phpnzi0I2 vbavatarYAVcJ8
php8YzEiW phpIukjKF phpU5iu1i phpe9iW4n phpobRerk vbavatarhlLQFA
php94VvLM phpJMgguC phpU73NSD phpf73b4k phppIYM9A
php9c1T1a phpJWEznz phpU8WsDX phpfDXh4O phppYBmi8
phpBAiXSf phpJrbEU1 phpUYEAL3 phpfmEzPh phppacEOw
[root tmp]#

==========================================================================

[root mysql]# dir
digital mysql mysql.sock ns2.midwestoracle.com.err slingto test vBulletin
[root mysql]#


Thanks for all your help...

I could not get the above command you posted. this was the closest I was able to get it to.

[root tmp]# ln -s "mysql.sock
ln: ./mysql.sock: File exists
[root tmp]#


is the command ln -ls <--Is or Ls ??

:eek:

Hi,

try doing a ls -al in your /tmp directory. It should show something like mysql.sock -> /home/mysql/mysql.sock . Is it showing that?

When i said ln -s , I meant putting a symlink in the temp directory pointing to the real location of the sock file

Yes this is what I get.

lrwxrwxrwx 1 root root 22 Dec 11 08:37 mysql.sock -> /home/mysql/mysql.sock
lrwxrwxrwx 1 root root 10 Dec 11 17:30 mysql>sock -> mysql>sock

Should it be 0 ????

==========================================

[root mysql]# ls -al
total 22
drwxr-xr-x 7 mysql root 1024 Dec 11 08:37 .
drwxr-xr-x 15 root root 1024 Nov 21 21:46 ..
drwx------ 2 mysql root 4096 Dec 1 17:26 digital
drwx------ 2 mysql root 1024 Nov 21 22:45 mysql
srwxrwxrwx 1 mysql root 0 Dec 11 08:37 mysql.sock
-rw-r--r-- 1 mysql root 7961 Dec 11 08:37 ns2.midwestoracle.com.err
drwx------ 2 mysql root 3072 Dec 8 20:37 slingto
drwxr-xr-x 2 mysql root 1024 Nov 21 21:46 test
drwx------ 2 mysql root 3072 Nov 22 18:23 vBulletin
[root mysql]#