Vesta Control Panel - Forum

vestacp89 wrote:Hello,

I reboot vps,
after mysql stop work,
I restart mysql,
then all work,
but today come and see website is down again mysql was down,
again restart mysql and now all work,
where i can see why this happend ?
and how i can fix this ?

This is messeage which i get on email:

Code: Select all

Can't connect to localhost
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

Thanks.

/var/log/mysqld.log

/var/log/mysql.log
/var/log/mysql/error.log

joem wrote:

vestacp89 wrote:Hello,

I reboot vps,
after mysql stop work,
I restart mysql,
then all work,
but today come and see website is down again mysql was down,
again restart mysql and now all work,
where i can see why this happend ?
and how i can fix this ?

This is messeage which i get on email:

Code: Select all

Can't connect to localhost
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

Thanks.

Centos

/var/log/mysqld.log

Ubuntu

/var/log/mysql.log
/var/log/mysql/error.log

Check out http://vestacp.com/docs/#config-log-loc ... hel-centos

turkey3 wrote:To view it in the CLI, type:

Code: Select all

nano /var/log/mysql.log

-bash: nano: command not found

vestacp89 wrote:

turkey3 wrote:To view it in the CLI, type:

Code: Select all

nano /var/log/mysql.log

i use ubuntu, when i enter this show me:

Code: Select all

-bash: nano: command not found

sudo apt-get install nano
sudo nano /var/log/mysql.log

joem wrote:

vestacp89 wrote:

turkey3 wrote:To view it in the CLI, type:

Code: Select all

nano /var/log/mysql.log

i use ubuntu, when i enter this show me:

Code: Select all

-bash: nano: command not found

Code: Select all

sudo apt-get install nano
sudo nano /var/log/mysql.log

^G Get Help               ^O WriteOut               ^R Read File              ^Y Prev Page              ^K Cut Text               ^C Cur Pos
^X Exit                   ^J Justify                ^W Where Is               ^V Next Page              ^U UnCut Text             ^T To Spell