Plesk Datenbank

peterle1984

New Member
Hallo,

Ich habe ein Plesk Update gemacht nun startet die DB nicht mehr.

Vielleicht kann mir jemand helfen.

HTML:
ERROR: Zend_Db_Adapter_Exception: SQLSTATE[HY000] [2002] No such file or directory

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] [2002] No such file or directory' in /usr/local/psa/admin/externals/Zend/Db/Adapter/Pdo/Abstract.php:129 Stack trace: #0 /usr/local/psa/admin/externals/Zend/Db/Adapter/Pdo/Abstract.php(129): PDO->__construct('mysql:dbname=ps...', 'admin', '$AES-128-CBC$GG...', Array) #1 /usr/local/psa/admin/externals/Zend/Db/Adapter/Pdo/Mysql.php(111): Zend_Db_Adapter_Pdo_Abstract->_connect() #2 /usr/local/psa/admin/externals/Zend/Db/Adapter/Abstract.php(460): Zend_Db_Adapter_Pdo_Mysql->_connect() #3 /usr/local/psa/admin/externals/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('select param, v...', Array) #4 /usr/local/psa/admin/plib/Db/Adapter/Pdo/Mysql.php(30): Zend_Db_Adapter_Pdo_Abstract->query('select param, v...', Array) #5 /usr/local/psa/admin/plib/db.php(36): Db_Adapter_Pdo_Mysql->query('select param, v...') #6 /usr/local/psa/admin/plib/db.php(212): db_query('select param, v...', false) #7 /usr/local/psa/admin/plib/Plesk/Mode.php(4 (Abstract.php:144)

Search for related Knowledge Base articles
 

peterle1984

New Member
Lässt sich leider nicht Installieren :-(

HTML:
yum list php-pdo
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
 * atomic: www4.atomicorp.com
Available Packages
php-pdo.x86_64                                                                                5.4.45-56.el7.art                                                                                atomic
[root@baby-lala ~]# yum install php-pdo
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
 * atomic: www4.atomicorp.com
Resolving Dependencies
There are unfinished transactions remaining. You might consider running yum-complete-transaction, or "yum-complete-transaction --cleanup-only" and "yum history redo last", first to finish them. If those don't work you'll have to try removing/installing packages by hand (maybe package-cleanup can help).
The program yum-complete-transaction is found in the yum-utils package.
--> Running transaction check
---> Package php-pdo.x86_64 0:5.4.45-56.el7.art will be installed
--> Processing Dependency: php-common(x86-64) = 5.4.45-56.el7.art for package: php-pdo-5.4.45-56.el7.art.x86_64
--> Running transaction check
---> Package php-common.x86_64 0:5.4.45-56.el7.art will be installed
--> Processing Conflict: php56w-common-5.6.31-1.w7.x86_64 conflicts php-common < 5.6
--> Finished Dependency Resolution
Error: php56w-common conflicts with php-common-5.4.45-56.el7.art.x86_64
 You could try using --skip-broken to work around the problem
 You could try running: rpm -Va --nofiles --nodigest
 

marce

Well-Known Member
Sieht aus, als solltest Du eine Repos mal in Ordnung bringen. Oder aus dem richtigen Repo installieren per Direktive...
 

peterle1984

New Member
habe ich gemacht :)

Jetzt bekomme ich die Meldung

HTML:
 yum update
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
No packages marked for update
 
D

Deleted member 15972

Guest
Prüfe bitte auch, welche php pdo Pakete ggfls. zusätzlich verfügbar sind. Es könnte z.B. sein, dass ein zugehöriges Paket verfügbar ist, welches explizit für PHP Version 5.6 gedacht ist.
 

peterle1984

New Member
Bin gerade etwas verzweifelt :confused:

Plesk will nicht Starten.
Die DB auch nicht.

HTML:
service mariadb start
Redirecting to /bin/systemctl start  mariadb.service
Job for mariadb.service failed because the control process exited with error code. See "systemctl status mariadb.service" and "journalctl -xe" for details.
 
D

Deleted member 15972

Guest
Dann mach doch bitte einmal das, was Dir vorgeschlagen wird und poste das Ergebnis hier. Ohne Details können wir nämlich schwer sagen, was genau schief geht.
 

peterle1984

New Member
Kannst was aus dem Log raus finden ?
Code:
19:39:33 [Note] Plugin 'FEEDBACK' is disabled.
170821 19:39:33 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
170821 19:39:33 [Note] Server socket created on IP: '127.0.0.1'.
170821 19:39:33 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
170821 19:39:33 mysqld_safe mysqld from pid file /var/run/mariadb/mariadb.pid ended
170821 20:11:36 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
170821 20:11:36 [Note] /usr/libexec/mysqld (mysqld 5.5.52-MariaDB) starting as process 26362 ...
170821 20:11:36 InnoDB: The InnoDB memory heap is disabled
170821 20:11:36 InnoDB: Mutexes and rw_locks use GCC atomic builtins
170821 20:11:36 InnoDB: Compressed tables use zlib 1.2.7
170821 20:11:36 InnoDB: Using Linux native AIO
170821 20:11:36 InnoDB: Initializing buffer pool, size = 128.0M
170821 20:11:36 InnoDB: Completed initialization of buffer pool
170821 20:11:36 InnoDB: highest supported file format is Barracuda.
170821 20:11:36  InnoDB: Waiting for the background threads to start
170821 20:11:37 Percona XtraDB ([URL]http://www.percona.com[/URL]) 5.5.49-MariaDB-38.0 started; log sequence number 7099779569
170821 20:11:37 [Note] Plugin 'FEEDBACK' is disabled.
170821 20:11:37 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
170821 20:11:37 [Note] Server socket created on IP: '127.0.0.1'.
170821 20:11:37 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
170821 20:11:38 mysqld_safe mysqld from pid file /var/run/mariadb/mariadb.pid ended
170821 20:11:51 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
170821 20:11:51 [Note] /usr/libexec/mysqld (mysqld 5.5.52-MariaDB) starting as process 26697 ...
170821 20:11:51 InnoDB: The InnoDB memory heap is disabled
170821 20:11:51 InnoDB: Mutexes and rw_locks use GCC atomic builtins
170821 20:11:51 InnoDB: Compressed tables use zlib 1.2.7
170821 20:11:51 InnoDB: Using Linux native AIO
170821 20:11:51 InnoDB: Initializing buffer pool, size = 128.0M
170821 20:11:51 InnoDB: Completed initialization of buffer pool
170821 20:11:51 InnoDB: highest supported file format is Barracuda.
170821 20:11:51  InnoDB: Waiting for the background threads to start
170821 20:11:52 Percona XtraDB ([URL]http://www.percona.com[/URL]) 5.5.49-MariaDB-38.0 started; log sequence number 7099779569
170821 20:11:52 [Note] Plugin 'FEEDBACK' is disabled.
170821 20:11:52 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
170821 20:11:52 [Note] Server socket created on IP: '127.0.0.1'.
170821 20:11:52 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
170821 20:11:52 mysqld_safe mysqld from pid file /var/run/mariadb/mariadb.pid ended
170821 20:11:53 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
170821 20:11:53 [Note] /usr/libexec/mysqld (mysqld 5.5.52-MariaDB) starting as process 26963 ...
170821 20:11:53 InnoDB: The InnoDB memory heap is disabled
170821 20:11:53 InnoDB: Mutexes and rw_locks use GCC atomic builtins
170821 20:11:53 InnoDB: Compressed tables use zlib 1.2.7
170821 20:11:53 InnoDB: Using Linux native AIO
170821 20:11:53 InnoDB: Initializing buffer pool, size = 128.0M
170821 20:11:53 InnoDB: Completed initialization of buffer pool
170821 20:11:53 InnoDB: highest supported file format is Barracuda.
170821 20:11:53  InnoDB: Waiting for the background threads to start
170821 20:11:54 Percona XtraDB ([URL]http://www.percona.com[/URL]) 5.5.49-MariaDB-38.0 started; log sequence number 7099779569
170821 20:11:54 [Note] Plugin 'FEEDBACK' is disabled.
170821 20:11:54 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
170821 20:11:54 [Note] Server socket created on IP: '127.0.0.1'.
170821 20:11:54 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
170821 20:11:54 mysqld_safe mysqld from pid file /var/run/mariadb/mariadb.pid ended
170821 20:17:47 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
170821 20:17:48 [Note] /usr/libexec/mysqld (mysqld 5.5.52-MariaDB) starting as process 3307 ...
170821 20:17:48 InnoDB: The InnoDB memory heap is disabled
170821 20:17:48 InnoDB: Mutexes and rw_locks use GCC atomic builtins
170821 20:17:48 InnoDB: Compressed tables use zlib 1.2.7
170821 20:17:48 InnoDB: Using Linux native AIO
170821 20:17:48 InnoDB: Initializing buffer pool, size = 128.0M
170821 20:17:48 InnoDB: Completed initialization of buffer pool
170821 20:17:48 InnoDB: highest supported file format is Barracuda.
170821 20:17:57  InnoDB: Waiting for the background threads to start
170821 20:17:58 Percona XtraDB ([URL]http://www.percona.com[/URL]) 5.5.49-MariaDB-38.0 started; log sequence number 7099779569
170821 20:17:58 [Note] Plugin 'FEEDBACK' is disabled.
170821 20:17:58 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
170821 20:17:58 [Note] Server socket created on IP: '127.0.0.1'.
170821 20:17:58 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
170821 20:17:58 mysqld_safe mysqld from pid file /var/run/mariadb/mariadb.pid ended
170821 20:17:58 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
170821 20:17:58 [Note] /usr/libexec/mysqld (mysqld 5.5.52-MariaDB) starting as process 3949 ...
170821 20:17:58 InnoDB: The InnoDB memory heap is disabled
170821 20:17:58 InnoDB: Mutexes and rw_locks use GCC atomic builtins
170821 20:17:58 InnoDB: Compressed tables use zlib 1.2.7
170821 20:17:58 InnoDB: Using Linux native AIO
170821 20:17:58 InnoDB: Initializing buffer pool, size = 128.0M
170821 20:17:58 InnoDB: Completed initialization of buffer pool
170821 20:17:58 InnoDB: highest supported file format is Barracuda.
170821 20:17:59  InnoDB: Waiting for the background threads to start
170821 20:18:00 Percona XtraDB ([URL]http://www.percona.com[/URL]) 5.5.49-MariaDB-38.0 started; log sequence number 7099779569
170821 20:18:00 [Note] Plugin 'FEEDBACK' is disabled.
170821 20:18:00 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
170821 20:18:00 [Note] Server socket created on IP: '127.0.0.1'.
170821 20:18:00 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
170821 20:18:00 mysqld_safe mysqld from pid file /var/run/mariadb/mariadb.pid ended
170821 20:21:06 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
170821 20:21:06 [Note] /usr/libexec/mysqld (mysqld 5.5.52-MariaDB) starting as process 4997 ...
170821 20:21:06 InnoDB: The InnoDB memory heap is disabled
170821 20:21:06 InnoDB: Mutexes and rw_locks use GCC atomic builtins
170821 20:21:06 InnoDB: Compressed tables use zlib 1.2.7
170821 20:21:06 InnoDB: Using Linux native AIO
170821 20:21:06 InnoDB: Initializing buffer pool, size = 128.0M
170821 20:21:06 InnoDB: Completed initialization of buffer pool
170821 20:21:06 InnoDB: highest supported file format is Barracuda.
170821 20:21:06  InnoDB: Waiting for the background threads to start
170821 20:21:07 Percona XtraDB ([URL]http://www.percona.com[/URL]) 5.5.49-MariaDB-38.0 started; log sequence number 7099779569
170821 20:21:07 [Note] Plugin 'FEEDBACK' is disabled.
170821 20:21:07 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
170821 20:21:07 [Note] Server socket created on IP: '127.0.0.1'.
170821 20:21:07 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
170821 20:21:07 mysqld_safe mysqld from pid file /var/run/mariadb/mariadb.pid ended
170821 20:22:09 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
170821 20:22:09 [Note] /usr/libexec/mysqld (mysqld 5.5.52-MariaDB) starting as process 5493 ...
170821 20:22:09 InnoDB: The InnoDB memory heap is disabled
170821 20:22:09 InnoDB: Mutexes and rw_locks use GCC atomic builtins
170821 20:22:09 InnoDB: Compressed tables use zlib 1.2.7
170821 20:22:09 InnoDB: Using Linux native AIO
170821 20:22:09 InnoDB: Initializing buffer pool, size = 128.0M
170821 20:22:09 InnoDB: Completed initialization of buffer pool
170821 20:22:09 InnoDB: highest supported file format is Barracuda.
170821 20:22:09  InnoDB: Waiting for the background threads to start
170821 20:22:10 Percona XtraDB ([URL]http://www.percona.com[/URL]) 5.5.49-MariaDB-38.0 started; log sequence number 7099779569
170821 20:22:10 [Note] Plugin 'FEEDBACK' is disabled.
170821 20:22:10 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
170821 20:22:10 [Note] Server socket created on IP: '127.0.0.1'.
170821 20:22:10 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
170821 20:22:10 mysqld_safe mysqld from pid file /var/run/mariadb/mariadb.pid ended
 
Last edited by a moderator:
D

Deleted member 15972

Guest
Ja, dafür müsstest Du es allerdings erst mal posten.
Die von Dir gepostete Zeile enthält genau *NULL* sinnvolle Informationen.
Dort steht aber auch, wie Du mehr Details anzeigen kannst und genau die brauchen wir :).
 

peterle1984

New Member
Sorry mein PC hatte sich aufgehängt.
Log ist jetzt da :)


HTML:
pam_unix(sshd:session): session opened for user root by (uid=0)
Aug 21 20:50:30  sshd[11163]: pam_unix(sshd:auth): authentication failure; logname= uid=0 euid=0 tty=ssh ruser= rhost=116.31.116.33  user=root
Aug 21 20:50:30  sshd[11163]: Unable to connect to Plesk Database: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Aug 21 20:50:30  sshd[11163]: pam_succeed_if(sshd:auth): requirement "uid >= 1000" not met by user "root"
Aug 21 20:50:31  sshd[11180]: pam_unix(sshd:auth): authentication failure; logname= uid=0 euid=0 tty=ssh ruser= rhost=116.31.116.33  user=root
Aug 21 20:50:31  sshd[11180]: Unable to connect to Plesk Database: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Aug 21 20:50:31  sshd[11180]: pam_succeed_if(sshd:auth): requirement "uid >= 1000" not met by user "root"
Aug 21 20:50:32  sshd[11163]: Failed password for root from 116.31.116.33 port 57948 ssh2
Aug 21 20:50:32  sshd[11163]: Unable to connect to Plesk Database: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Aug 21 20:50:32  sshd[11163]: pam_succeed_if(sshd:auth): requirement "uid >= 1000" not met by user "root"
Aug 21 20:50:33  sshd[11163]: Failed password for root from 116.31.116.33 port 57948 ssh2
Aug 21 20:50:33  sshd[11163]: Unable to connect to Plesk Database: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Aug 21 20:50:33  sshd[11163]: pam_succeed_if(sshd:auth): requirement "uid >= 1000" not met by user "root"
Aug 21 20:50:33  sshd[11180]: Failed password for root from 116.31.116.33 port 59381 ssh2
Aug 21 20:50:34  sshd[11180]: Unable to connect to Plesk Database: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Aug 21 20:50:34  sshd[11180]: pam_succeed_if(sshd:auth): requirement "uid >= 1000" not met by user "root"
Aug 21 20:50:35  sshd[11163]: Failed password for root from 116.31.116.33 port 57948 ssh2
Aug 21 20:50:35  sshd[11163]: Received disconnect from 116.31.116.33: 11:  [preauth]
Aug 21 20:50:35  sshd[11163]: PAM 2 more authentication failures; logname= uid=0 euid=0 tty=ssh ruser= rhost=116.31.116.33  user=root
Aug 21 20:50:36  sshd[11180]: Failed password for root from 116.31.116.33 port 59381 ssh2
Aug 21 20:50:36  sshd[11180]: Unable to connect to Plesk Database: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Aug 21 20:50:36  sshd[11180]: pam_succeed_if(sshd:auth): requirement "uid >= 1000" not met by user "root"
~
 

NetRat

Member
Moin Peterle,

für mich sieht es so aus als wäre die Datenbank kaputt.

Code:
170821 20:21:07 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist

Wenn die Tabelle mysql.host wirklich nicht existiert, sind dir zu irgend einem Zeitpunk Daten verloren gegangen. Wenn du ein Backup hast, spiel es zurück. Alles andere wird tendenziell eher schmerzhaft.

Mich würde interessieren wie du die Aktualisierung angegangen bist. Ich habe die Erfahrung gemacht, dass es am ehesten zu Fehlern kommt wenn man mit dem Plesk Autoinstaller updated ohne vorher über den System-Paket-Manager zu aktualisieren. Wenn man mit den System-Paketen zu weit hinterher ist, macht das gerne was kaputt. Würde mich mal interessieren wie du es gemacht hast.

Grüße,
NetRat
 
Last edited by a moderator:

Joe User

Zentrum der Macht
Oh Oh Oh, da hat jemand konsequent die Doku ignoriert und nach keinem Update `mysql_upgrade` ausgeführt.

Ein letzter Versuch, der unter Umständen viel zu spät kommt:
Code:
mysql_upgrade --force


Doku lesen wird völlig zu Recht überbewertet, denn dort steht ja eh nur unwichtiges Zeugs drin...
 
Top