I yesterday updated my server. Now mysql does not start. /etc/init.d/msql status says "stopped". /etc/init.d/msql start says "[FAIL] Starting mySQL .............". This apparently only affects email. I tried re-installing mysql-server and mysql-client. How can I fix this problem?
Hi Till, Yesterday's automatic Debian upgrade from Mysql 5.5.49 to Mysql 5.5.53 Before Upgrade: Mysql 5.5.53 Nov 11 17:37:10 server-2 kernel: [ 37.701942] ppdev: user-space parallel port driver Nov 11 17:37:11 server-2 mysqld_safe: Starting mysqld daemon with databases from /var/lib/mysql Nov 11 17:37:11 server-2 mysqld: 161111 17:37:11 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead. Nov 11 17:37:11 server-2 mysqld: 161111 17:37:11 [Note] /usr/sbin/mysqld (mysqld 5.5.49-0+deb8u1) starting as process 3554 ... Nov 11 17:37:12 server-2 spamd[3576]: logger: removing stderr method Nov 11 17:37:12 server-2 mysqld: 161111 17:37:12 [Warning] Using unique option prefix myisam-recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead. Nov 11 17:37:13 server-2 mysqld: 161111 17:37:13 [Note] Plugin 'FEDERATED' is disabled. Nov 11 17:37:13 server-2 mysqld: 161111 17:37:13 InnoDB: The InnoDB memory heap is disabled Nov 11 17:37:13 server-2 mysqld: 161111 17:37:13 InnoDB: Mutexes and rw_locks use GCC atomic builtins Nov 11 17:37:13 server-2 mysqld: 161111 17:37:13 InnoDB: Compressed tables use zlib 1.2.8 Nov 11 17:37:13 server-2 mysqld: 161111 17:37:13 InnoDB: Using Linux native AIO Nov 11 17:37:13 server-2 mysqld: 161111 17:37:13 InnoDB: Initializing buffer pool, size = 128.0M Nov 11 17:37:13 server-2 mysqld: 161111 17:37:13 InnoDB: Completed initialization of buffer pool Nov 11 17:37:13 server-2 mysqld: 161111 17:37:13 InnoDB: highest supported file format is Barracuda. Nov 11 17:37:14 server-2 spamd[3636]: spamd: server started on port 783/tcp (running version 3.3.2) Nov 11 17:37:14 server-2 spamd[3636]: spamd: server pid: 3636 Nov 11 17:37:14 server-2 spamd[3636]: spamd: server successfully spawned child process, pid 3670 Nov 11 17:37:14 server-2 spamd[3636]: spamd: server successfully spawned child process, pid 3671 Nov 11 17:37:14 server-2 spamd[3636]: prefork: child states: II Nov 11 17:37:15 server-2 mysqld: 161111 17:37:15 InnoDB: Waiting for the background threads to start Nov 11 17:37:15 server-2 kernel: [ 42.836000] postgres (3688): /proc/3688/oom_adj is deprecated, please use /proc/3688/oom_score_adj instead. Nov 11 17:37:16 server-2 mysqld: 161111 17:37:16 InnoDB: 5.5.49 started; log sequence number 1595755 Nov 11 17:37:16 server-2 mysqld: 161111 17:37:16 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306 Nov 11 17:37:16 server-2 mysqld: 161111 17:37:16 [Note] - '0.0.0.0' resolves to '0.0.0.0'; Nov 11 17:37:16 server-2 mysqld: 161111 17:37:16 [Note] Server socket created on IP: '0.0.0.0'. Nov 11 17:37:16 server-2 mysqld: 161111 17:37:16 [Note] Event Scheduler: Loaded 0 events Nov 11 17:37:16 server-2 mysqld: 161111 17:37:16 [Note] /usr/sbin/mysqld: ready for connections. Nov 11 17:37:16 server-2 mysqld: Version: '5.5.49-0+deb8u1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Debian) Nov 11 17:37:16 server-2 /etc/mysql/debian-start[3744]: Upgrading MySQL tables if necessary. Nov 11 17:37:16 server-2 /etc/mysql/debian-start[3747]: /usr/bin/mysql_upgrade: the '--basedir' option is always ignored Nov 11 17:37:16 server-2 /etc/mysql/debian-start[3747]: Looking for 'mysql' as: /usr/bin/mysql Nov 11 17:37:16 server-2 /etc/mysql/debian-start[3747]: Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck Nov 11 17:37:16 server-2 /etc/mysql/debian-start[3747]: This installation of MySQL is already upgraded to 5.5.49, use --force if you s$ Nov 11 17:37:16 server-2 /etc/mysql/debian-start[3763]: Checking for insecure root accounts. Nov 11 17:37:16 server-2 /etc/mysql/debian-start[3769]: Triggering myisam-recover for all MyISAM tables Nov 11 17:37:17 server-2 dovecot: master: Dovecot v2.1.7 starting up (core dumps disabled) Nov 11 17:37:18 server-2 postfix/master[4147]: daemon started -- version 2.9.6, configuration /etc/postfix Nov 11 17:38:01 server-2 /USR/SBIN/CRON[4194]: (root) CMD (/usr/local/ispconfig/server/server.sh 2>&1 > /dev/null | while read line; do echo `/bin/date` "$line" >> /var/log/ispconfig/cron.log; done) After Upgrade: Mysql 5.5.53 Nov 11 16:43:59 server-2 dbus[2894]: [system] Successfully activated service 'org.freedesktop.ConsoleKit' Nov 11 16:44:00 server-2 mysqld_safe: Starting mysqld daemon with databases from /var/lib/mysql Nov 11 16:44:00 server-2 mysqld: 161111 16:44:00 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead. Nov 11 16:44:00 server-2 mysqld: /usr/sbin/mysqld: Error on realpath() on '/var/lib/mysql-files' (Error 2) Nov 11 16:44:00 server-2 mysqld: 161111 16:44:00 [ERROR] Failed to access directory for --secure-file-priv. Please make sure that directory exists and is accessible by MySQL Server. Supplied value : /var/lib/mysql-files Nov 11 16:44:00 server-2 mysqld: 161111 16:44:00 [ERROR] Aborting Nov 11 16:44:00 server-2 mysqld: Nov 11 16:44:00 server-2 mysqld_safe: mysqld from pid file /var/run/mysqld/mysqld.pid ended Nov 11 16:44:01 server-2 /USR/SBIN/CRON[3590]: (root) CMD (/usr/local/ispconfig/server/server.sh 2>&1 > /dev/null | while read line; do echo `/bin/date` "$line" >> /var/log/ispconfig/cron.log; done) Nov 11 16:44:02 server-2 spamd[3583]: logger: removing stderr method SOLVED: Mysql 5.5.53 reqires '/var/lib/mysql-files' instead of '/var/lib/mysql'! Solved by renaming '/var/lib/mysql' to '/var/lib/mysql-files'. This should have been done by the upgrade software. I look after a number of gentoo system. There the change is either done automatically by 'emerge --update ..." or a error/warning message is printed. Any chance that ISPconfig will again support Gentoo?
