Linux Plesk Centos 6.5 (Abstract.php:144) Error

[Erkan_Nasir]

Hi all,

Plesk panel at a time, I get the following error

ERROR: Zend_Db_Adapter_Exception: SQLSTATE[HY000] [2002] No such file or directory (Abstract.php:144)

I did what I didn't

Please urgent help.

3 Days access panel I can't

Link : http://213.238.176.157:8880/

 

[FiberDC]

I'm having the same problem
I couldn't find a solution

 

[UFHH01]

Hi Erkan_Nasir and FiberDC,

maybe this solution might help from: ERROR: Zend_Db_Adapter_Exception: SQLSTATE[HY000] [2002] No such file or directory ( KB - article 120 312 )

 

[FiberDC]

Hi Erkan_Nasir and FiberDC,

maybe this solution might help from: ERROR: Zend_Db_Adapter_Exception: SQLSTATE[HY000] [2002] No such file or directory ( KB - article 120 312 )

This is the process I did before
but the problem still continues

login as: root
[email protected]'s password:
Last login: Fri Dec 19 18:46:58 2014 from 212.253.107.6
[root@server ~]# grep pdo_mysql /usr/local/psa/admin/conf/php.ini
[root@server ~]# ps ax | grep mysql.sock | grep -v grep
[root@server ~]# grep socket /etc/my.cnf
socket=/var/lib/mysql/mysql.sock
[root@server ~]# grep -i socket /etc/psa/psa.conf
MYSQL_SOCKET /var/lib/mysql/mysql.sock
[root@server ~]# /etc/init.d/sw-engine restart
Stopping sw-engine-fpm: [ OK ]
Starting sw-engine-fpm: [ OK ]
[root@server ~]# /etc/init.d/sw-cp-server restart
Stopping sw-cp-serverd: [ OK ]
Starting sw-cp-serverd: [ OK ]
[root@server ~]#

 

[UFHH01]

Hi FiberDC,

did you edit something? Is it a fresh installation? For what operating system? And did you make sure, that your mysql - server is running?

Consider to have a look at "/var/lib/mysql/" to make sure that the unix socket exists as "mysql.sock" like defined.

 

[FiberDC]

Hi FiberDC,

did you edit something? Is it a fresh installation? For what operating system? And did you make sure, that your mysql - server is running?

Consider to have a look at "/var/lib/mysql/" to make sure that the unix socket exists as "mysql.sock" like defined.

Hi
This problem happened suddenly
Centos 6.5 on linux operating system
var/lib/mysql, we see that

[root@server ~]# service mysql restart
mysql: unrecognized service

 

[UFHH01]

Hi FiberDC,

please use the OS specific command "service mysqld restart" (or: /etc/init.d/mysqld restart ) for CentOS.

 

[FiberDC]

Hi,

The command I tried, but I couldn't get a result

[root@server ~]# /etc/init.d/mysqld restart
-bash: /etc/init.d/mysqld: No such file or directory

 

[UFHH01]

Hi FiberDC,

please let's work here a bit TOGETHER, FiberDC, to fix your issues. If you don't find the startup script for your mysql - server at "/etc/init.d/" ( either mysql or mysqld ), then please locate your mysql configuration files and have a look inside them, to investigate what's going wrong. It will be very hard to suggest work - arounds, if you just paste the command suggestions into your system, without investigating why the suggestions don't work for you. As I mentioned before, paths and names may vary on linux systems.
As well you can always have a look with the command "ps -aux | grep mysql" if your mysql - server is running or not and I see as well, that your webserver is inactive as well.

 

[FiberDC]

I use the same command structure plesk server is working smoothly
The command output is as follows

'' ps -aux | grep mysql''

[root@server ~]# ps -aux | grep mysql
Warning: bad syntax, perhaps a bogus '-'? See /usr/share/doc/procps-3.2.8/FAQ
root 19423 0.0 0.0 2276 560 pts/0 S+ 21:29 0:00 grep mysql
[root@server ~]#


the server root, can I submit information

This problem continues for 5 days
couldn't figure out

log in to the server and plz help me

 

[UFHH01]

Sorry FiberDC,

but I am not a team - member from Parallels, I just assist with free suggestions and work-arounds here in the forums.

You might consider opening a support - ticket ( Parallels - Support ), so that a Parallels supporter may take care of your request.

 

[FiberDC]

Support to buy I don't have the budget to
Please tell me about this plz help me

 

[UFHH01]

Hi FiberDC,

you will find a lot of log - files, configuration paths and commands here:

Parallels Plesk Panel for Linux services logs and configuration files ( KB - article: 111 283 )​

Try to investigate the error - logs in "/var/log/..." as well or post the errors here in the thread, if you would like suggestions. Be aware that some services depend on others, so if mysqld is not running, then you web - content might not work... and if the webserver is not running, then you won't get any reply if you try to open the URLs... and so on... try to restart all services and try as well the bootstrapper repair and the autoinstaller - command and consider as well to read the Plesk 12 documentation:

/usr/local/psa/bootstrapper/pp12.0.18-bootstrapper/bootstrapper.sh repair​

/usr/local/psa/admin/bin/autoinstaller --select-product-id plesk --select-release-current --reinstall-patch --install-component base​

Parallels Plesk - Documentations
​

After you did some of the commands, you might see other or additional errors in the log - files, so please investigate the log - files after performing the above commands and a good idea is as well to have a look at the

Parallels Knowledgebase​

and

Parallels Forums Search​

 

[FiberDC]

Hi,

This is the process I did before

I get the following error

/usr/local/psa/bootstrapper/pp12.0.18-bootstrapper/bootstrapper.sh repair

The following command has been successfully completed

but the problem still continues

/usr/local/psa/admin/bin/autoinstaller --select-product-id plesk --select-release-current --reinstall-patch --install-component base

/var/log/mysqld.log of the last records



141219 19:07:40 [Warning] No argument was provided to --log-bin, and --log-bin-index was not used; so repli$
141219 19:07:40 [Note] Plugin 'FEDERATED' is disabled.
141219 19:07:40 [ERROR] innobase_buffer_pool_size can't be over 4GB on 32-bit systems
141219 19:07:40 [ERROR] Plugin 'InnoDB' init function returned error.
141219 19:07:40 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
141219 19:07:40 [ERROR] /usr/libexec/mysqld: unknown option '--skip-locking'
141219 19:07:40 [ERROR] Aborting

141219 19:07:40 [Note] /usr/libexec/mysqld: Shutdown complete

141219 19:07:40 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended


mysql-uadmin-p /etc/psa/.the psa.shadow`

The above command I get the following error

[root@server ~]# mysql -uadmin -p`cat /etc/psa/.psa.shadow`
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
[root@server ~]#

 

[UFHH01]

Hi FiberDC,

according to your screenshot 1, there is no bootstrapper repair completion. You either have some "copy & paste" - failures when you try to paste the command ( unwanted spaces, unvisible symbols... or what ever ), or something else doesn't work here. Try to TYPE the command, without copy & paste, to be sure, that the bootstrapper repair will be done as expected.

According to your mysql - log... your mysql is not running because of misconfigurations. Please either correct your configuration, or un-install and re-install your mysqld - server. You never will be able to connect to the Plesk database, when the mysqld - server is not running! And you won't be able to login to your mysqld - server over the command line either, when it's not running... I wonder why you even tried it.

141219 19:07:40 [Note] /usr/libexec/mysqld: Shutdown complete

141219 19:07:40 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended

 

[FiberDC]

Hi FiberDC,

according to your screenshot 1, there is no bootstrapper repair completion. You either have some "copy & paste" - failures when you try to paste the command ( unwanted spaces, unvisible symbols... or what ever ), or something else doesn't work here. Try to TYPE the command, without copy & paste, to be sure, that the bootstrapper repair will be done as expected.

According to your mysql - log... your mysql is not running because of misconfigurations. Please either correct your configuration, or un-install and re-install your mysqld - server. You never will be able to connect to the Plesk database, when the mysqld - server is not running! And you won't be able to login to your mysqld - server over the command line either, when it's not running... I wonder why you even tried it.

The error log : /var/log/plesk/install/plesk_12.0.18_repair.log

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

ERROR while trying to establish test connection
Check the error reason(see log file: /var/log/plesk/install/plesk_12.0.18_repair.log), fix and try again


**** Product repair failed.

***** problem report *****
ERROR while trying to establish test connection
Check the error reason(see log file: /var/log/plesk/install/plesk_12.0.18_repair.log), fix and try again
STOP Bootstrapper 12.0.18 repair AT Thu Dec 18 19:17:05 EET 2014

 

[JohnnyU]

Got the same error after doing a Plesk Backup of my website on a CentOS 6 VPS with 50 GB free space

tried to restart mysql. it stopped fine but failed to start - service mysqld restart. then in mysqld.log it found this:

[ERROR] /usr/libexec/mysqld: Error writing file '/var/run/mysqld/mysqld.pid' (Errcode: 28)
[ERROR] Can't start server: can't create PID file: No space left on device

checked size with df -h then in /var/lib/psa/dumps where backups are store deleted a 20 GB file then restarted mysql and all is working again

 

[Mark Asher]

[Solved]
Guys, I have been having the same issue as well and I have managed to resolve it. Thanks to UFHH01's suggestion, I looked at /var/log/mysqld.log and paid attention to the last dozen or so entries. I noticed that mysql was unable to start due to being unable to write to pid file. This was due to no leftover disk space!

So I went back into my disk management and followed instructions on the following link:
https://help.1and1.com/servers-c376...e-the-size-of-the-logical-volume-a756168.html

Resized the hdd volume and voila! It started the mysqld service on next attempt.

It may or may not be related to your problem but I thought I'd share it here in case someone does have the same issue.