Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.0.15
-
None
-
Ubuntu 14.04 Trusty Tahr
Description
When attempting to pre-seed an installation with an administrative password, the generated files don't appear to be respecting the value set in debconf, while the server itself receives and updates the password.
Given the scenario, I generate a uuid as the root_password value, and set it with the following:
debconf-set-selections mariadb-server/root_password password $UUID
|
debconf-set-selections mariadb-server/root_password_again password $UUID
|
the generated cnf files for mysqladmin do not reflect this update, nor does the mariadb server successfully start from the /etc/init.d/mysql job:
- Starting MariaDB database server mysqld
...fail!
contents from /etc/mysql/debian.cnf
# Automatically generated for Debian scripts. DO NOT TOUCH!
|
[client]
|
host = localhost
|
user = debian-sys-maint
|
password = is5Y3MdDlUM3ZzNv
|
socket = /var/run/mysqld/mysqld.sock
|
[mysql_upgrade]
|
host = localhost
|
user = debian-sys-maint
|
password = is5Y3MdDlUM3ZzNv
|
socket = /var/run/mysqld/mysqld.sock
|
basedir = /usr
|
the mariadb root-password value is: 16974151-9e1d-4ca1-a585-2e4171de0e4e
Service refuses to start with the following in syslog:
Dec 11 17:29:05 charles-local-machine-4 /etc/mysql/debian-start[3166]: ERROR 2006 (HY000) at line 1731: MySQL server has gone away
|
Dec 11 17:29:05 charles-local-machine-4 /etc/mysql/debian-start[3166]: FATAL ERROR: Upgrade failed
|
Dec 11 17:29:05 charles-local-machine-4 /etc/mysql/debian-start[3224]: Checking for insecure root accounts.
|
Dec 11 17:29:37 charles-local-machine-4 /etc/init.d/mysql[3777]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
|
Dec 11 17:29:37 charles-local-machine-4 /etc/init.d/mysql[3777]: #007/usr/bin/mysqladmin: connect to server at 'localhost' failed
|
Dec 11 17:29:37 charles-local-machine-4 /etc/init.d/mysql[3777]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")'
|
Dec 11 17:29:37 charles-local-machine-4 /etc/init.d/mysql[3777]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
|
Dec 11 17:29:37 charles-local-machine-4 /etc/init.d/mysql[3777]:
|
Dec 11 17:30:08 charles-local-machine-4 /etc/init.d/mysql[4342]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
|
Dec 11 17:30:08 charles-local-machine-4 /etc/init.d/mysql[4342]: #007/usr/bin/mysqladmin: connect to server at 'localhost' failed
|
Dec 11 17:30:08 charles-local-machine-4 /etc/init.d/mysql[4342]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")'
|
Dec 11 17:30:08 charles-local-machine-4 /etc/init.d/mysql[4342]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
|
Dec 11 17:30:08 charles-local-machine-4 /etc/init.d/mysql[4342]:
|