Hello,
encouraged by two successfull migrations from mysql to mariadb on
testing and jessie, I tried to do the same on my production server
(jessie). To my great shock, it failed:
% sudo dpkg --configure -a
Setting up mariadb-server-10.0 (10.0.27-0+deb8u1) ...
[ ok ] Stopping MariaDB database server: mysqld.
dpkg: error processing package mariadb-server-10.0 (--configure):
subprocess installed post-installation script returned error exit status 7
dpkg: dependency problems prevent configuration of mariadb-server:
mariadb-server depends on mariadb-server-10.0 (>= 10.0.27-0+deb8u1); however:
Package mariadb-server-10.0 is not configured yet.
dpkg: error processing package mariadb-server (--configure):
dependency problems - leaving unconfigured
Errors were encountered while processing:
mariadb-server-10.0
mariadb-server
I added a set -x to the mariadb-server-10.0 post-install script:
I really hope, you can help me to find this error...
# dpkg --configure -a
Setting up mariadb-server-10.0 (10.0.27-0+deb8u1) ...
+ . /usr/share/debconf/confmodule
++ '[' '!' '' ']'
++ PERL_DL_NONLAZY=1
++ export PERL_DL_NONLAZY
++ '[' '' ']'
++ exec /usr/share/debconf/frontend
/var/lib/dpkg/info/mariadb-server-10.0.postinst configure ''
+ . /usr/share/debconf/confmodule
++ '[' '!' 1 ']'
++ '[' -z '' ']'
++ exec
++ '[' '' ']'
++ exec
++ DEBCONF_REDIR=1
++ export DEBCONF_REDIR
+ '[' -n '' ']'
+ export
PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/sbin:/usr/sbin:/bin:/usr/bin
+
PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/sbin:/usr/sbin:/bin:/usr/bin
+ ERR_LOGGER='logger -p daemon.err -t mysqld_safe -i'
+ set -o pipefail
+ MYSQL_BOOTSTRAP='/usr/sbin/mysqld --bootstrap --user=mysql --disable-log-bin
--skip-grant-tables --default-storage-engine=myisam'
+ set +e
+ invoke stop
+ '[' -x /usr/sbin/invoke-rc.d ']'
+ invoke-rc.d mysql stop
[ ok ] Stopping MariaDB database server: mysqld.
+ set -e
+ case "$1" in
+ mysql_datadir=/usr/share/mysql
+ mysql_statedir=/var/lib/mysql
+ mysql_rundir=/var/run/mysqld
+ mysql_logdir=/var/log
+ mysql_cfgdir=/etc/mysql
+ mysql_newlogdir=/var/log/mysql
+ mysql_upgradedir=/var/lib/mysql-upgrade
+ for dir in DATADIR LOGDIR
+ '[' DATADIR = DATADIR ']'
+ targetdir=/var/lib/mysql
+ savelink=/var/lib/mysql-upgrade/DATADIR.link
+ '[' -L /var/lib/mysql-upgrade/DATADIR.link ']'
+ rmdir /var/lib/mysql-upgrade
+ true
+ for dir in DATADIR LOGDIR
+ '[' LOGDIR = DATADIR ']'
+ targetdir=/var/log/mysql
+ savelink=/var/lib/mysql-upgrade/LOGDIR.link
+ '[' -L /var/lib/mysql-upgrade/LOGDIR.link ']'
+ rmdir /var/lib/mysql-upgrade
+ true
+ '[' '!' -d /var/lib/mysql -a '!' -L /var/lib/mysql ']'
+ '[' '!' -d /var/lib/mysql/mysql -a '!' -L /var/lib/mysql/mysql ']'
+ '[' '!' -d /var/log/mysql -a '!' -L /var/log/mysql ']'
+ set +e
+ chown -R 0:0 /usr/share/mysql
+ chown -R mysql /var/lib/mysql
+ chown -R mysql:adm /var/log/mysql
+ chmod 2750 /var/log/mysql
+ for i in log err
+ touch /var/log/mysql.log
+ chown mysql:adm /var/log/mysql.log
+ chmod 0640 /var/log/mysql.log
+ for i in log err
+ touch /var/log/mysql.err
+ chown mysql:adm /var/log/mysql.err
+ chmod 0640 /var/log/mysql.err
+ set -e
+ db_set mysql-server/postrm_remove_database false
+ _db_cmd 'SET mysql-server/postrm_remove_database' false
+ _db_internal_IFS='
'
+ IFS=' '
+ printf '%s\n' 'SET mysql-server/postrm_remove_database false'
+ IFS='
'
+ IFS='
'
+ read -r _db_internal_line
+ RET='10 mysql-server/postrm_remove_database doesn'\''t exist'
+ case ${_db_internal_line%%[ ]*} in
+ return 10
+ true
+ rm -f /var/lib/mysql/debian-10.0.flag
+ touch /var/lib/mysql/debian-10.0.flag
+ set +e
+ bash /usr/bin/mysql_install_db --rpm --user=mysql --disable-log-bin
+ logger -p daemon.err -t mysqld_safe -i
+ set -e
+ dc=/etc/mysql/debian.cnf
++ fgrep mysql_upgrade /etc/mysql/debian.cnf
+ '[' -e /etc/mysql/debian.cnf -a -n '[mysql_upgrade]' ']'
++ sed -n 's/^[ ]*password *= *// p' /etc/mysql/debian.cnf
++ head -n 1
+ pass=ovVKCuwwrT9XbSrm
+ chown 0:0 /etc/mysql/debian.cnf
+ chmod 0600 /etc/mysql/debian.cnf
++ /bin/echo -e 'USE mysql;\n' 'ALTER TABLE user CHANGE Password Password
char(41) character set latin1 collate latin1_bin DEFAULT '\'''\'' NOT NULL;'
+ password_column_fix_query='USE mysql;
ALTER TABLE user CHANGE Password Password char(41) character set latin1
collate latin1_bin DEFAULT '\'''\'' NOT NULL;'
++ /bin/echo -e 'USE mysql;\n' 'SET sql_mode='\'''\'';\n' 'REPLACE INTO user
SET ' ' host='\''localhost'\'', user='\''debian-sys-maint'\'',
password=password('\''ovVKCuwwrT9XbSrm'\''), ' ' Select_priv='\''Y'\'',
Insert_priv='\''Y'\'', Update_priv='\''Y'\'', Delete_priv='\''Y'\'', ' '
Create_priv='\''Y'\'', Drop_priv='\''Y'\'', Reload_priv='\''Y'\'',
Shutdown_priv='\''Y'\'', ' ' Process_priv='\''Y'\'', File_priv='\''Y'\'',
Grant_priv='\''Y'\'', References_priv='\''Y'\'', ' ' Index_priv='\''Y'\'',
Alter_priv='\''Y'\'', Super_priv='\''Y'\'', Show_db_priv='\''Y'\'', ' '
Create_tmp_table_priv='\''Y'\'', Lock_tables_priv='\''Y'\'',
Execute_priv='\''Y'\'', ' ' Repl_slave_priv='\''Y'\'',
Repl_client_priv='\''Y'\'', Create_view_priv='\''Y'\'', ' '
Show_view_priv='\''Y'\'', Create_routine_priv='\''Y'\'',
Alter_routine_priv='\''Y'\'', ' ' Create_user_priv='\''Y'\'',
Event_priv='\''Y'\'', Trigger_priv='\''Y'\'',' ' ssl_cipher='\'''\'',
x509_issuer='\'''\'', x509_subject='\'''\'';'
+ replace_query='USE mysql;
SET sql_mode='\'''\'';
REPLACE INTO user SET host='\''localhost'\'',
user='\''debian-sys-maint'\'', password=password('\''ovVKCuwwrT9XbSrm'\''),
Select_priv='\''Y'\'', Insert_priv='\''Y'\'', Update_priv='\''Y'\'',
Delete_priv='\''Y'\'', Create_priv='\''Y'\'', Drop_priv='\''Y'\'',
Reload_priv='\''Y'\'', Shutdown_priv='\''Y'\'', Process_priv='\''Y'\'',
File_priv='\''Y'\'', Grant_priv='\''Y'\'', References_priv='\''Y'\'',
Index_priv='\''Y'\'', Alter_priv='\''Y'\'', Super_priv='\''Y'\'',
Show_db_priv='\''Y'\'', Create_tmp_table_priv='\''Y'\'',
Lock_tables_priv='\''Y'\'', Execute_priv='\''Y'\'',
Repl_slave_priv='\''Y'\'', Repl_client_priv='\''Y'\'',
Create_view_priv='\''Y'\'', Show_view_priv='\''Y'\'',
Create_routine_priv='\''Y'\'', Alter_routine_priv='\''Y'\'',
Create_user_priv='\''Y'\'', Event_priv='\''Y'\'', Trigger_priv='\''Y'\'',
ssl_cipher='\'''\'', x509_issuer='\'''\'', x509_subject='\'''\'';'
++ /bin/echo -e 'USE mysql;\n' 'CREATE TABLE IF NOT EXISTS plugin (name
char(64) COLLATE utf8_bin NOT NULL DEFAULT '\'''\'', ' ' dl char(128) COLLATE
utf8_bin NOT NULL DEFAULT '\'''\'', ' ' PRIMARY KEY (name)) ENGINE=MyISAM
DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='\''MySQL plugins'\'';'
+ install_plugins='USE mysql;
CREATE TABLE IF NOT EXISTS plugin (name char(64) COLLATE utf8_bin NOT NULL
DEFAULT '\'''\'', dl char(128) COLLATE utf8_bin NOT NULL DEFAULT '\'''\'',
PRIMARY KEY (name)) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin
COMMENT='\''MySQL plugins'\'';'
+ echo 'USE mysql;
ALTER TABLE user CHANGE Password Password char(41) character set latin1
collate latin1_bin DEFAULT '\'''\'' NOT NULL;'
+ /usr/sbin/mysqld --bootstrap --user=mysql --disable-log-bin
--skip-grant-tables --default-storage-engine=myisam
+ logger -p daemon.err -t mysqld_safe -i
dpkg: error processing package mariadb-server-10.0 (--configure):
--
Markus Grunwald
http://www.the-grue.de
Fragen zur Mail? http://www.the-grue.de/mail_und_co
http://www.the-grue.de/~markus/markus_grunwald.gpg
