Mysql.sock problem can't connect (solved)

General Help
1

Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (111)]

This is what I get when try to open freepbx.

Appreciate anyones help.

Thank you.

2

I am fine, Your good I hope…

Check the log file /var/log/mysqld.log

start mysql in safe mode if need be and check the log once more

3

thanks bubba. I checked the log to find the following.

Can’t start server: can’t create PID file: Permission denied

So I did a search and found this and fixed the problem.

chown -R mysql /var/run/mysqld/

So far so good.

Thanks again for all your help and kindness. I became a grandpa over the ThanksGiving weekend. Thanks again.

4

Glad u got it going…

Gran Papa Fun Fun,

5

Thank you Sir, how are you?

bubba something went wrong on this isntall with no warnings or anything yet when I do /etc/init.d/mysqld start it fails.

update from the log file.

Can’t start server: can’t create PID file: Permission denied

6

make sure mysql is running at start up
chkconfig mysqld on
if it is set to start and is just starting find out why

/usr/local/mysql/bin/safe_mysqld

and read the log for error

check the asterisk.conf file and make sure all the pathing is correct

/etc/asterisk/asterisk.conf

[directories]
astetcdir => /etc/asterisk
astmoddir => /usr/lib/asterisk/modules
astvarlibdir => /var/lib/asterisk
astagidir => /var/lib/asterisk/agi-bin
astspooldir => /var/spool/asterisk
astrundir => /var/run/asterisk
astlogdir => /var/log/asterisk

/etc/amportal.conf

very bottom

ASTETCDIR=/etc/asterisk
ASTMODDIR=/usr/lib/asterisk/modules
ASTVARLIBDIR=/var/lib/asterisk
ASTAGIDIR=/var/lib/asterisk/agi-bin
ASTSPOOLDIR=/var/spool/asterisk
ASTRUNDIR=/var/run/asterisk
ASTLOGDIR=/var/log/asterisk
AMPDBNAME=asterisk
AMPENGINE=asterisk

amportal chown