Page 1 of 1

MySQL connect ERROR: Need Fixed

PostPosted: Sun Sep 06, 2009 2:34 pm
by hammobru
I was trying to set the alias for us to be able to click the recording links from the agents stats screen. I added th alias in /etc/httpd/conf.d/vicidial_recordings.conf It didnt work or (I did it wrong) so I found that I can do it in /etc/httpd/conf/httpd.conf so I created an alias there. I couldnt get either one to work so I placed them back. But now I get the following error when I try to go to my admin interface or any other screen.

MySQL connect ERROR: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

When I try to start, stop or restart mysql it shows fail.

Any help on this would be appreciated.

Thanks in advance for your help.

Running Vicidialnow latest version 2.0.5

Processors 8
Model Intel(R) Xeon(R) CPU E5405 @ 2.00GHz
CPU Speed 2 GHz
Cache Size 6.00 MB

PostPosted: Sun Sep 06, 2009 3:08 pm
by williamconley
this is posted in the wrong category. this is a request for SUPPORT not consultation.

i'd move it, but i apparently don't have that power :(

is your drive full or has mysql marked any tables crashed?

run this: (it will ask for your password, use the root password for mysql since you will be logged in as root).

Code: Select all
mysqlcheck --auto-repair asterisk -p
Perhaps more than once. then reboot.

PS: thanks for listing your server software and specs!

I get error 2002

PostPosted: Sun Sep 06, 2009 9:50 pm
by hammobru
mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) when trying to connect

PostPosted: Sun Sep 06, 2009 9:53 pm
by williamconley
is your drive full? have you rebooted? were there any errors during startup?

check the mysql logs to find out why it won't start?

did you try starting mysql manually to find out the error?

is there any OTHER software running on this machine (did you ADD anything?)