MySQL connect ERROR: Need Fixed

All installation and configuration problems and questions

Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N

MySQL connect ERROR: Need Fixed

Postby hammobru » Sun Sep 06, 2009 2:34 pm

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
hammobru
 
Posts: 32
Joined: Tue Sep 23, 2008 12:00 pm

Postby williamconley » Sun Sep 06, 2009 3:08 pm

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!
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294
williamconley
 
Posts: 20018
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

I get error 2002

Postby hammobru » Sun Sep 06, 2009 9:50 pm

mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) when trying to connect
hammobru
 
Posts: 32
Joined: Tue Sep 23, 2008 12:00 pm

Postby williamconley » Sun Sep 06, 2009 9:53 pm

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?)
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294
williamconley
 
Posts: 20018
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)


Return to Support

Who is online

Users browsing this forum: No registered users and 70 guests