Scheduled Maintenance: We are aware of an issue with Google, AOL, and Yahoo services as email providers which are blocking new registrations. We are trying to fix the issue and we have several internal and external support tickets in process to resolve the issue. Please see: viewtopic.php?t=158230

 

 

 

Impossible de relancer le service Mysql sur Debian

If none of the specific sub-forums seem right for your thread, ask here.
Post Reply
Message
Author
stefaan77
Posts: 1
Joined: 2018-06-13 09:09

Impossible de relancer le service Mysql sur Debian

#1 Post by stefaan77 »

Bonjour,

Ce matin j'ai la mauvaise surprise de trouver mon serveur Debian sans accès aux bases de données. Si je relance le service mySql il m'indique une erreur et je n'arrive pas à relancer. (petit détail supplémentaire, il semble que j'ai eu la visite de quelques IP chinoises que j'ai bloquée avant que cela ne fonctionne plus).

Voici les informations:

utilisateur@monserver:~# service mysql start
Job for mariadb.service failed. See 'systemctl status mariadb.service' and 'journalctl -xn' for details.


utilisateur@monserver:~# systemctl status mariadb.service
● mariadb.service - MariaDB database server
Loaded: loaded (/lib/systemd/system/mariadb.service; enabled)
Drop-In: /run/systemd/generator/mysql.service.d
└─50-mariadb-$database.conf
Active: failed (Result: exit-code) since mer. 2018-06-13 10:47:20 CEST; 2min 34s ago
Process: 2201 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE)
Process: 2119 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`/usr/bin/galera_recovery`; [ $? -eq 0 ] && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, status=0/SUCCESS)
Process: 2114 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 2113 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
Main PID: 2201 (code=exited, status=1/FAILURE)
Status: "MariaDB server is down"

juin 13 10:47:14 monserver systemd[1]: Starting MariaDB database server...
juin 13 10:47:14 monserver mysqld[2201]: 2018-06-13 10:47:14 139821878537280 [Note] Using unique option prefix 'key_buffer' is error-prone and can break in the future. Please use the full name '...size' instead.
juin 13 10:47:14 monserver mysqld[2201]: 2018-06-13 10:47:14 139821878537280 [Note] /usr/sbin/mysqld (mysqld 10.1.26-MariaDB-0+deb9u1) starting as process 2201 ...
juin 13 10:47:20 monserver systemd[1]: mariadb.service: main process exited, code=exited, status=1/FAILURE
juin 13 10:47:20 monserver systemd[1]: Failed to start MariaDB database server.
juin 13 10:47:20 monserver systemd[1]: Unit mariadb.service entered failed state.
Hint: Some lines were ellipsized, use -l to show in full.


utilisateur@monserver:~# journalctl -xn
-- Logs begin at mer. 2018-06-13 09:25:21 CEST, end at mer. 2018-06-13 10:51:21 CEST. --
juin 13 10:51:17 monserver sshd[2242]: Failed password for root from 182.100.67.82 port 49620 ssh2
juin 13 10:51:20 monserver sshd[2242]: Failed password for root from 182.100.67.82 port 49620 ssh2
juin 13 10:51:20 monserver sshd[2242]: error: maximum authentication attempts exceeded for root from 182.100.67.82 port 49620 ssh2 [preauth]
juin 13 10:51:20 monserver sshd[2242]: Disconnecting: Too many authentication failures [preauth]
juin 13 10:51:20 monserver sshd[2242]: PAM 5 more authentication failures; logname= uid=0 euid=0 tty=ssh ruser= rhost=182.100.67.82 user=root
juin 13 10:51:20 monserver sshd[2242]: PAM service(sshd) ignoring max retries; 6 > 3
juin 13 10:51:21 monserver sshd[2244]: rexec line 19: Deprecated option KeyRegenerationInterval
juin 13 10:51:21 monserver sshd[2244]: rexec line 20: Deprecated option ServerKeyBits
juin 13 10:51:21 monserver sshd[2244]: rexec line 31: Deprecated option RSAAuthentication
juin 13 10:51:21 monserver sshd[2244]: rexec line 38: Deprecated option RhostsRSAAuthentication




utilisateur@monserver:~# vdir /var/lib/mysql/
total 305588
drwxrwxrwx 2 mysql mysql 12288 juin 7 21:09 EB0077
-rwxrwxrwx 1 mysql mysql 16384 juin 13 11:00 aria_log.00000001
-rwxrwxrwx 1 mysql mysql 52 juin 13 11:00 aria_log_control
-rwxrwxrwx 1 root root 0 avril 20 22:12 debian-10.1.flag
drwxrwxrwx 2 mysql mysql 4096 avril 3 11:31 onahf
-rwxrwxrwx 1 mysql mysql 211812352 juin 13 11:00 ibdata1
-rwxrwxrwx 1 mysql mysql 50331648 juin 13 07:27 ib_logfile0
-rwxrwxrwx 1 mysql mysql 50331648 juin 13 03:59 ib_logfile1
-rwxrwxrwx 1 mysql mysql 0 avril 20 22:12 multi-master.info
drwxrwxrwx 2 mysql mysql 4096 avril 20 22:12 mysql
-rwxrwxrwx 1 mysql mysql 6 oct. 22 2017 mysql_upgrade_info
drwxrwxrwx 2 mysql mysql 4096 avril 20 22:12 performance_schema
drwxrwxrwx 2 mysql mysql 4096 mars 4 2016 phpmyadmin
drwxrwxrwx 2 mysql mysql 4096 avril 20 22:14 postfixadmin
drwxrwxrwx 2 mysql mysql 16384 juin 21 2016 prestashop
drwxrwxrwx 2 mysql mysql 12288 mai 2 23:32 oiduts
drwxrwxrwx 2 mysql mysql 12288 avril 20 21:53 oiduts@002dbackup
-rwxrwxrwx 1 mysql mysql 24576 mai 22 16:32 tc.log
drwxrwxrwx 2 mysql mysql 4096 mars 4 2016 machin

Je rame complètement. Quelqu'un peut-il m'aider svp?

Merci d'avance

Wheelerof4te
Posts: 1454
Joined: 2015-08-30 20:14

Re: Impossible de relancer le service Mysql sur Debian

#2 Post by Wheelerof4te »

Here we speak English. Debian's French mail lists are here:
https://lists.debian.org/debian-user-french/

Post Reply