Divers problème

Bonjour,

je reviens vers vous suite à différents problèmes que je rencontre,

En premier lieu j’ai encore des problème avec mysql la base ne redémarre pas lors d’un redémarrage de yunohost à moins de lancer "sudo mysqld_safe --user=root --skip-grant-tables"
en SSH après cela j’ai accès à mes applications qui on besoin de mysql mais je ne peux pas installer Etherpad Mypads l’installation ce passe sans problème mais à la fin il m’indique:

La configuration de SSOwat a été générée

  • echo 'The user etherpad_mypads was not found’
    The user etherpad_mypads was not found
  • getent passwd etherpad_mypads

Voilà mes différents soucis quelqu’un à une idée?

Merci d’avance pour vos idées.

Bonne journée.

didier58

Salut,

du coup si tu essayes de démarrer mysql normalement (systemctl mysql start), tu vois quel genre de message d’erreur ? (Soit via systemctl mysql status ou via tail -n 100 /var/lib/mysql/*.err)

Salut @Aleks,

pour le premier:

root@didiercl:~# systemctl mysql start
Unknown operation ‘mysql’.

pour le deuxieme:

root@didiercl:~# systemctl mysql status
Unknown operation ‘mysql’.

pour le troisième:

root@didiercl:~# tail -n 100 /var/lib/mysql/*.err
==> /var/lib/mysql/didiercl.me.err <==
180105 23:32:19 [Note] InnoDB: Not using CPU crc32 instructions
180105 23:32:19 [Note] InnoDB: Initializing buffer pool, size = 128.0M
180105 23:32:19 [Note] InnoDB: Completed initialization of buffer pool
180105 23:32:19 [Note] InnoDB: Highest supported file format is Barracuda.
180105 23:32:20 [Note] InnoDB: 128 rollback segment(s) are active.
180105 23:32:20 [Note] InnoDB: Waiting for purge to start
180105 23:32:20 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.36-82.1 started; log sequence number 580254842
180105 23:32:20 [Note] Plugin ‘FEEDBACK’ is disabled.
180105 23:32:20 [ERROR] Can’t open the mysql.plugin table. Please run mysql_upgrade to create it.
180105 23:32:20 [Note] Server socket created on IP: ‘::’.
180105 23:32:20 [ERROR] Fatal error: Can’t open and lock privilege tables: File ‘./mysql/host.MYD’ not found (Errcode: 13 “Permission denied”)
180105 23:32:20 mysqld_safe mysqld from pid file /var/lib/mysql/didiercl.me.pid ended
180109 18:13:35 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
180109 18:13:36 [Note] /usr/sbin/mysqld (mysqld 10.0.32-MariaDB-0+deb8u1) starting as process 1184 …
180109 18:13:37 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

180109 18:13:37 [Note] InnoDB: Using mutexes to ref count buffer pool pages
180109 18:13:37 [Note] InnoDB: The InnoDB memory heap is disabled
180109 18:13:37 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
180109 18:13:37 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
180109 18:13:37 [Note] InnoDB: Compressed tables use zlib 1.2.8
180109 18:13:37 [Note] InnoDB: Using Linux native AIO
180109 18:13:37 [Note] InnoDB: Not using CPU crc32 instructions
180109 18:13:37 [Note] InnoDB: Initializing buffer pool, size = 128.0M
180109 18:13:37 [Note] InnoDB: Completed initialization of buffer pool
180109 18:13:37 [Note] InnoDB: Highest supported file format is Barracuda.
180109 18:13:39 [Note] InnoDB: 128 rollback segment(s) are active.
180109 18:13:39 [Note] InnoDB: Waiting for purge to start
180109 18:13:39 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.36-82.1 started; log sequence number 588486685
180109 18:13:39 [Note] Plugin ‘FEEDBACK’ is disabled.
180109 18:13:39 [ERROR] Can’t open the mysql.plugin table. Please run mysql_upgrade to create it.
180109 18:13:39 [Note] Server socket created on IP: ‘::’.
180109 18:13:39 [ERROR] Fatal error: Can’t open and lock privilege tables: File ‘./mysql/host.MYD’ not found (Errcode: 13 “Permission denied”)
180109 18:13:40 mysqld_safe mysqld from pid file /var/lib/mysql/didiercl.me.pid ended
180109 18:48:10 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
180109 18:48:11 [Note] /usr/sbin/mysqld (mysqld 10.0.32-MariaDB-0+deb8u1) starting as process 3554 …
180109 18:48:11 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

180109 18:48:11 [Note] InnoDB: Using mutexes to ref count buffer pool pages
180109 18:48:11 [Note] InnoDB: The InnoDB memory heap is disabled
180109 18:48:11 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
180109 18:48:11 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
180109 18:48:11 [Note] InnoDB: Compressed tables use zlib 1.2.8
180109 18:48:11 [Note] InnoDB: Using Linux native AIO
180109 18:48:11 [Note] InnoDB: Not using CPU crc32 instructions
180109 18:48:11 [Note] InnoDB: Initializing buffer pool, size = 128.0M
180109 18:48:11 [Note] InnoDB: Completed initialization of buffer pool
180109 18:48:11 [Note] InnoDB: Highest supported file format is Barracuda.
180109 18:48:12 [Note] InnoDB: 128 rollback segment(s) are active.
180109 18:48:12 [Note] InnoDB: Waiting for purge to start
180109 18:48:12 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.36-82.1 started; log sequence number 588486685
180109 18:48:12 [Note] Plugin ‘FEEDBACK’ is disabled.
180109 18:48:12 [ERROR] Can’t open the mysql.plugin table. Please run mysql_upgrade to create it.
180109 18:48:12 [Note] Server socket created on IP: ‘::’.
180109 18:48:12 [ERROR] Fatal error: Can’t open and lock privilege tables: File ‘./mysql/host.MYD’ not found (Errcode: 13 “Permission denied”)
180109 18:48:12 mysqld_safe mysqld from pid file /var/lib/mysql/didiercl.me.pid ended
180109 19:33:42 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
180109 19:33:42 [Note] /usr/sbin/mysqld (mysqld 10.0.32-MariaDB-0+deb8u1) starting as process 4347 …
180109 19:33:42 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

180109 19:33:42 [Note] InnoDB: Using mutexes to ref count buffer pool pages
180109 19:33:42 [Note] InnoDB: The InnoDB memory heap is disabled
180109 19:33:42 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
180109 19:33:42 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
180109 19:33:42 [Note] InnoDB: Compressed tables use zlib 1.2.8
180109 19:33:42 [Note] InnoDB: Using Linux native AIO
180109 19:33:42 [Note] InnoDB: Not using CPU crc32 instructions
180109 19:33:42 [Note] InnoDB: Initializing buffer pool, size = 128.0M
180109 19:33:42 [Note] InnoDB: Completed initialization of buffer pool
180109 19:33:42 [Note] InnoDB: Highest supported file format is Barracuda.
180109 19:33:43 [Note] InnoDB: 128 rollback segment(s) are active.
180109 19:33:43 [Note] InnoDB: Waiting for purge to start
180109 19:33:43 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.36-82.1 started; log sequence number 588486685
180109 19:33:43 [Note] Plugin ‘FEEDBACK’ is disabled.
180109 19:33:43 [ERROR] Can’t open the mysql.plugin table. Please run mysql_upgrade to create it.
180109 19:33:43 [Note] Server socket created on IP: ‘::’.
180109 19:33:43 [ERROR] Fatal error: Can’t open and lock privilege tables: File ‘./mysql/host.MYD’ not found (Errcode: 13 “Permission denied”)
180109 19:33:43 mysqld_safe mysqld from pid file /var/lib/mysql/didiercl.me.pid ended
180109 19:35:01 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
180109 19:35:01 [Note] /usr/sbin/mysqld (mysqld 10.0.32-MariaDB-0+deb8u1) starting as process 4971 …
180109 19:35:01 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

180109 19:35:01 [Note] InnoDB: Using mutexes to ref count buffer pool pages
180109 19:35:01 [Note] InnoDB: The InnoDB memory heap is disabled
180109 19:35:01 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
180109 19:35:01 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
180109 19:35:01 [Note] InnoDB: Compressed tables use zlib 1.2.8
180109 19:35:01 [Note] InnoDB: Using Linux native AIO
180109 19:35:01 [Note] InnoDB: Not using CPU crc32 instructions
180109 19:35:01 [Note] InnoDB: Initializing buffer pool, size = 128.0M
180109 19:35:01 [Note] InnoDB: Completed initialization of buffer pool
180109 19:35:01 [Note] InnoDB: Highest supported file format is Barracuda.
180109 19:35:01 [Note] InnoDB: 128 rollback segment(s) are active.
180109 19:35:01 [Note] InnoDB: Waiting for purge to start
180109 19:35:01 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.36-82.1 started; log sequence number 588486685
180109 19:35:01 [Note] Plugin ‘FEEDBACK’ is disabled.
180109 19:35:01 [ERROR] Can’t open the mysql.plugin table. Please run mysql_upgrade to create it.
180109 19:35:01 [Note] Server socket created on IP: ‘::’.
180109 19:35:01 [ERROR] Fatal error: Can’t open and lock privilege tables: File ‘./mysql/host.MYD’ not found (Errcode: 13 “Permission denied”)
180109 19:35:02 mysqld_safe mysqld from pid file /var/lib/mysql/didiercl.me.pid ended

==> /var/lib/mysql/yunohost.yunohost.org.err <==
170327 22:07:38 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
170327 22:07:39 [Note] /usr/sbin/mysqld (mysqld 10.0.30-MariaDB-0+deb8u1) starting as process 18090 …
170327 22:07:39 [Note] InnoDB: Using mutexes to ref count buffer pool pages
170327 22:07:39 [Note] InnoDB: The InnoDB memory heap is disabled
170327 22:07:39 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
170327 22:07:39 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
170327 22:07:39 [Note] InnoDB: Compressed tables use zlib 1.2.8
170327 22:07:39 [Note] InnoDB: Using Linux native AIO
170327 22:07:39 [Note] InnoDB: Not using CPU crc32 instructions
170327 22:07:39 [Note] InnoDB: Initializing buffer pool, size = 128.0M
170327 22:07:39 [Note] InnoDB: Completed initialization of buffer pool
170327 22:07:39 [Note] InnoDB: Highest supported file format is Barracuda.
170327 22:07:39 [Note] InnoDB: 128 rollback segment(s) are active.
170327 22:07:39 [Note] InnoDB: Waiting for purge to start
170327 22:07:39 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.35-80.0 started; log sequence number 1616827
170327 22:07:39 [Note] Plugin ‘FEEDBACK’ is disabled.
170327 22:07:39 [Note] Server socket created on IP: ‘::’.
170327 22:07:39 [Note] /usr/sbin/mysqld: ready for connections.
Version: ‘10.0.30-MariaDB-0+deb8u1’ socket: ‘/var/run/mysqld/mysqld.sock’ port: 3306 (Debian)
root@didiercl:~#

voici les différents résultats.

didier58

Salut,

My bad, le “mysql” devait être à la fin de la commande et non au milieu, mais peu importe, il y a l’info que je cherchais dans la troisième commande :wink:

Du coup le problème vient de :

Je pense que c’est un effet non anticipé de ce que l’on avait fait dans ce thread : Problème avec ma mysql - #3 by Didier58

Est-ce que tu peux vérifier qui est le propriétaire du fichier host.MYD avec cette commande ?

ls -l /var/lib/mysql/mysql/host.MYD

Je pense que tu devrais voir quelque chose comme : -rw-rw---- 1 root root 0 Aug 14 14:31 host.MYD, c’est-à-dire que le propriétaire est root alors qu’il devrait être mysql…

Tu devrais pouvoir fixer le problème en faisant :

chown mysql:mysql /var/lib/mysql/mysql/host.MYD

Ensuite, pour redémarrer mysql et verifier qu’il tourne bien :

systemctl start mysql
systemctl status mysql

Salut Aleks,

avec la commande ls -l /var/lib/mysql/mysql/host.MYD le résultat et le suivant:

-rw-rw---- 1 mysql mysql 0 déc. 27 20:37 /var/lib/mysql/mysql/host.MYD

avec

root@didiercl:~# systemctl start mysql
Job for mysql.service failed. See ‘systemctl status mysql.service’ and ‘journalctl -xn’ for details.

et avec

root@didiercl:~# systemctl status mysql
● mysql.service - LSB: Start and stop the mysql database server daemon
Loaded: loaded (/etc/init.d/mysql)
Active: failed (Result: exit-code) since mer. 2018-01-10 19:42:46 CET; 56s ago
Process: 3309 ExecStart=/etc/init.d/mysql start (code=exited, status=1/FAILURE)

janv. 10 19:42:14 didiercl.me systemd[1]: Starting LSB: Start and stop the m…
janv. 10 19:42:46 didiercl.me mysql[3309]: Starting MariaDB database server:…!
janv. 10 19:42:46 didiercl.me systemd[1]: mysql.service: control process exi…1
janv. 10 19:42:46 didiercl.me systemd[1]: Failed to start LSB: Start and sto…
janv. 10 19:42:46 didiercl.me systemd[1]: Unit mysql.service entered failed …
Hint: Some lines were ellipsized, use -l to show in full.
root@didiercl:~#

voilà le résutat.

didier58

Arf bon … visiblement mon pronostic n’était pas le bon :confused:

Je viens de voir qu’un autre message dans le log précédent recommende d’executer la commande suivante : mysql_upgrade

Il se passe quoi si tu fais ça ?

root@didiercl:~# mysql_upgrade
Version check failed. Got the following error when calling the ‘mysql’ command line client
ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2 “No such file or directory”)
FATAL ERROR: Upgrade failed
root@didiercl:~#

ça n’a pas l’air mieux!

didier58