Question Failed to call Plesk

[sandy30j]

Hello,
I have a problem, I have a database password changed and now I come no more on Plesk. I get this error:

ERROR: Zend_Db_Adapter_Exception: SQLSTATE[HY000] [1045] Access denied for user 'admin'@'localhost' (using password: YES)

Additionally, an exception has occurred while trying to report this error: Zend_Exception
No entry is registered for key 'translate' (Abstract.php:144)

Search for related Knowledge Base articles

ERROR: Uncaught exception 'PDOException' with message 'SQLSTATE[HY000] [1045] Access denied for user 'admin'@'localhost' (using password: YES)' in /opt/psa/admin/externals/Zend/Db/Adapter/Pdo/Abstract.php:129 Stack trace: #0 /opt/psa/admin/externals/Zend/Db/Adapter/Pdo/Abstract.php(129): PDO->__construct('mysql:dbname=ps...', 'admin', '$AES-128-CBC$dQ...', Array) #1 /opt/psa/admin/externals/Zend/Db/Adapter/Pdo/Mysql.php(111): Zend_Db_Adapter_Pdo_Abstract->_connect() #2 /opt/psa/admin/externals/Zend/Db/Adapter/Abstract.php(460): Zend_Db_Adapter_Pdo_Mysql->_connect() #3 /opt/psa/admin/externals/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('select param, v...', Array) #4 /opt/psa/admin/plib/Db/Adapter/Pdo/Mysql.php(30): Zend_Db_Adapter_Pdo_Abstract->query('select param, v...', Array) #5 /opt/psa/admin/plib/db.php(36): Db_Adapter_Pdo_Mysql->query('select param, v...') #6 /opt/psa/admin/plib/db.php(212): db_query('select param, v...', false) #7 /opt/psa/admin/plib/Plesk/Mode.php(423): get_param( (Abstract.php:144)

Search for related Knowledge Base articles

Please help me ,the articels do not work!
Server ist ubuntu 14.04 LTS

 

[Bitpalast]

Have you tried the resolution described in
https://support.plesk.com/hc/en-us/articles/213364309
?

 

[sandy30j]

Yes i have but it dosent work.
If I point 3 follow I get an error:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
If I then add skip-grant-tables to the my.cnf I get lots of errors and nothing is more.

 

[Bitpalast]

Is your MySQL service up and running? Probably not, so what are the error messages when starting the service?
# service mariadb status

 

[sandy30j]

Yes is runnig,
# /etc/init.d/mysql restart
* Stopping MySQL Community Server 5.7.17
...
* MySQL Community Server 5.7.17 is stopped
* Re-starting MySQL Community Server 5.7.17
No directory, logging in with HOME=/
..
* MySQL Community Server 5.7.17 is started

 

[Bitpalast]

Look for where the socket should be:
# ps -fea | grep mysqld

Verify that this is the same location as in /my.cnf:
# grep socket /etc/my.cnf

Look into your file structure to verify that it is really there where it should be (in /var/run/mysqld/). Does it have the correct permissions, e.g.
srwxrwxrwx 1 mysql mysql 0 Dec 26 18:00 mysql.sock

 

[sandy30j]

When I enter # ps -fea | grep mysqld I get this:

mysql 7960 1 0 18:05 ? 00:00:00 /bin/sh /usr/bin/mysqld_safe
mysql 8137 7960 0 18:05 ? 00:00:11 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib/mysql/plugin --log-error=/var/log/mysql/error.log --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/run/mysqld/mysqld.sock --log-syslog=1 --log-syslog-facility=daemon --log-syslog-tag=
root 8770 8754 0 18:35 pts/2 00:00:00 grep --color=auto mysqld

My.cnf is located under /etc /mysql and has this Content:
# Copyright (c) 2016, Oracle and/or its affiliates. All rights reserved.
#
# This program is free software; you can redistribute it and/or modify
# it under the terms of the GNU General Public License as published by
# the Free Software Foundation; version 2 of the License.
#
# This program is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
# GNU General Public License for more details.
#
# You should have received a copy of the GNU General Public License
# along with this program; if not, write to the Free Software
# Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA
!includedir /etc/mysql/conf.d/
!includedir /etc/mysql/mysql.conf.d/

and mysql.sock under /var/run/mysqld/
drwxr-xr-x 24 root root 4096 Dec 26 14:11

 

[Bitpalast]

You should look into the include files to find out what the socket definition is. It is probably correct, but just to make sure ...

As you can tell from your socket file permissions, there could be a chance that the permissions and ownership of that file are not the ones that it should have. From what you have posted, your mysqld must run as root to be able to use the socket (you mention drwxr-xr-x, so if the mysqld is not running as root it cannot write to that socket, because the group is not allowed to write to it; and according to the ps output, your MySQL is not running as root, but as mysql. I am not at all an Ubuntu expert, but for example if your MySQL server runs as group "mysql", it is probably not working when you prohibit write access for that group to the socket. If I was you, next step I'd try to

# chmod 777 /var/run/mysqld/mysql.sock

Then restart the mysqld service and see if the socket issue is solved.