Softaculous

Topic : critical EMERGENCY HELP

Posted By: wikihostingpk on February 3, 2016, 9:21 pm

Hello,

We are trying to login to virtualizor server and we are getting this erorr:

Our Virtualizor Admin Panel and Customer Panel are not accessible.

We are getting this error:

Error!: SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/usr/local/emps/var/mysql/mysql.sock' (2)

Please help urgently!

thankssss

Posted By: asim_shaikh on February 4, 2016, 6:59 am | Post: 1

Hi,

Can you please check if there is enough space on your "/" parition (atleast 50 MB) ?

Can you run "service virtualizor restart" on your server and check ?

Can you check the mysql error logs in /usr/local/emps/var/log/mysqld.log for the exact error message.

If you are unable to resolve it then please open a support ticket we will fix it asap.

-----------------------
Regards,
Virtualizor Team
http://www.virtualizor.com

Posted By: gemisu on December 19, 2018, 2:26 pm | Post: 2

Sorry to reopen.
I have the same problem.

Error!: SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/usr/local/emps/var/mysql/mysql.sock' (111)

[root@localhost ~]# service virtualizor restart
Stopping php-fpm: Done...
Stopping nginx: Done...
ERROR! MySQL server PID file could not be found!
Starting php-fpm: Done...
Starting nginx: Done...
Starting MySQL.. ERROR! The server quit without updating PID file (/usr/local/emps/var/mysql/mysqld.pid).
[root@localhost ~]#

Posted By: jevingala on December 20, 2018, 8:31 am | Post: 3

Hi,
Can you check the mysql error logs in /usr/local/emps/var/log/mysqld.log for the exact error message.
Also provide output of df -Th command.

-----------------------
Regards,
Virtualizor Team.
http://virtualizor.com/

Posted By: sonwebhost on May 22, 2019, 3:28 pm | Post: 4

Error!: SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/usr/local/emps/var/mysql/mysql.sock' (2)

same here been down for three days now with no fix from support just lots of reasions why they keep telling me what I should do to fix it but they are not fixing it I mean why should I contact suport and submit a ticket then with all my website and customers calling me losing money they support department ask me what issues are you facing after three days what kind off issues do you think I would be facing worce yet they tell you which I already know that the support deparment dont know if it will work you should free up space hey do they know that I am here saying you are the one in charge of this program why dont you free up some space and make it work I am wondering if people are in contact with the mind or just sitting on computers to get away from home.

Posted By: millenniumtree on September 27, 2021, 10:16 pm | Post: 5

In my case, the drive was not full, and I still got this mysql error.

If you have an error in /usr/local/emps/var/log/mysqld.log that looks like:
InnoDB: Error: log file ./ib_logfile0 is of different size 0 8388608 bytes
InnoDB: than specified in the .cnf file 0 5242880 bytes!

Here's what fixed it for me:

Log into the server as root

service virtualizor stop
cd /usr/local/emps/var/mysql
cp -a ib_logfile0 ib_logfile0.bak
cp -a ib_logfile1 ib_logfile1.bak
rm ib_logfile0 ib_logfile1
service virtualizor start

I hope that helps.