[Bug 305107] Re: mysql refuses to start because a missing optional config dir

[Henning Sprang]

** Summary changed:

- mysql refuses to start after security update
+ mysql refuses to start because a missing optional config dir

** Description changed:

+ root at xnote:~# lsb_release -rd
+ Description:	Ubuntu 8.04
+ Release:	8.04
+ 
+ henning at xnote:~$ apt-cache policy mysql-server-5.0
+ mysql-server-5.0:
+   Installed: 5.0.51a-3ubuntu5.4
+   Candidate: 5.0.51a-3ubuntu5.4
+   Version table:
+  *** 5.0.51a-3ubuntu5.4 0
+         500 file: hardy-security/main Packages
+         100 /var/lib/dpkg/status
+      5.0.51a-3ubuntu5 0
+         500 file: hardy/main Packages
+ 
+ Corecting name and adding the state of things at the beginning:
+ 
+ mysqld is not starting when /etc/mysql/conf.d is not empty, even though
+ it contains only optional information.
+ 
+ In conjunction with bug 305107 this leads to mysql failing to start
+ after a security upgrade from the default version in the normal apt
+ repository to the newest security update version.
+ 
+ More explanation below:
+ 
+ 
+ ---
+ 
  I just did a security upgrade for my Hardy system, and after the reboot,
  mysql refuses to start!
  
  Errors already appear at system start, here the output of the command
  when I try to start the server manually after system start(errors are
  the same):
  
  /etc/init.d/mysql restart
  open: Permission denied
   * Stopping MySQL database server mysqld                                        /usr/sbin/mysqld: Can't read dir of '/etc/mysql/conf.d/' (Errcode: 2)
  Fatal error in defaults handling. Program aborted
  /usr/sbin/mysqld: Can't read dir of '/etc/mysql/conf.d/' (Errcode: 2)
  Fatal error in defaults handling. Program aborted
  open: Permission denied
                                                                           [ OK ]
  /usr/sbin/mysqld: Can't read dir of '/etc/mysql/conf.d/' (Errcode: 2)
  Fatal error in defaults handling. Program aborted
  open: Permission denied
   * Starting MySQL database server mysqld                                        /usr/sbin/mysqld: Can't read dir of '/etc/mysql/conf.d/' (Errcode: 2)
  Fatal error in defaults handling. Program aborted
  /usr/sbin/mysqld: Can't read dir of '/etc/mysql/conf.d/' (Errcode: 2)
  Fatal error in defaults handling. Program aborted
  /usr/sbin/mysqld: Can't read dir of '/etc/mysql/conf.d/' (Errcode: 2)
  Fatal error in defaults handling. Program aborted
  /usr/sbin/mysqld: Can't read dir of '/etc/mysql/conf.d/' (Errcode: 2)
  Fatal error in defaults handling. Program aborted
  /usr/sbin/mysqld: Can't read dir of '/etc/mysql/conf.d/' (Errcode: 2)
  Fatal error in defaults handling. Program aborted
  /usr/sbin/mysqld: Can't read dir of '/etc/mysql/conf.d/' (Errcode: 2)
  Fatal error in defaults handling. Program aborted
  /usr/sbin/mysqld: Can't read dir of '/etc/mysql/conf.d/' (Errcode: 2)
  Fatal error in defaults handling. Program aborted
  /usr/sbin/mysqld: Can't read dir of '/etc/mysql/conf.d/' (Errcode: 2)
  Fatal error in defaults handling. Program aborted
  /usr/sbin/mysqld: Can't read dir of '/etc/mysql/conf.d/' (Errcode: 2)
  Fatal error in defaults handling. Program aborted
  /usr/sbin/mysqld: Can't read dir of '/etc/mysql/conf.d/' (Errcode: 2)
  Fatal error in defaults handling. Program aborted
  /usr/sbin/mysqld: Can't read dir of '/etc/mysql/conf.d/' (Errcode: 2)
  Fatal error in defaults handling. Program aborted
  /usr/sbin/mysqld: Can't read dir of '/etc/mysql/conf.d/' (Errcode: 2)
  Fatal error in defaults handling. Program aborted
  /usr/sbin/mysqld: Can't read dir of '/etc/mysql/conf.d/' (Errcode: 2)
  Fatal error in defaults handling. Program aborted
  /usr/sbin/mysqld: Can't read dir of '/etc/mysql/conf.d/' (Errcode: 2)
  Fatal error in defaults handling. Program aborted
  /usr/sbin/mysqld: Can't read dir of '/etc/mysql/conf.d/' (Errcode: 2)
  Fatal error in defaults handling. Program aborted
  /usr/sbin/mysqld: Can't read dir of '/etc/mysql/conf.d/' (Errcode: 2)
  Fatal error in defaults handling. Program aborted
  open: Permission denied
                                                                           [fail]
  
  
  root at xnote:~# lsb_release -rd
  Description:	Ubuntu 8.04
  Release:	8.04
  
  
  root at xnote:~# dpkg -l mysql*
  Desired=Unknown/Install/Remove/Purge/Hold
  | Status=Not/Installed/Config-f/Unpacked/Failed-cfg/Half-inst/t-aWait/T-pend
  |/ Err?=(none)/Hold/Reinst-required/X=both-problems (Status,Err: uppercase=bad)
  ||/ Name                              Version                           Description
  +++-=================================-=================================-==================================================================================
  ii  mysql-admin                       5.0~rc12-2ubuntu1                 GUI tool for intuitive MySQL administration
  un  mysql-admin-common                <none>                            (no description available)
  ii  mysql-client                      5.0.51a-3ubuntu5.4                MySQL database client (meta package depending on the latest version)
  un  mysql-client-4.1                  <none>                            (no description available)
  ii  mysql-client-5.0                  5.0.51a-3ubuntu5.4                MySQL database client binaries
  ii  mysql-common                      5.0.51a-3ubuntu5.4                MySQL database common files
  un  mysql-community-client-5.0        <none>                            (no description available)
  un  mysql-community-server-5.0        <none>                            (no description available)
  un  mysql-doc-5.0                     <none>                            (no description available)
  un  mysql-enterprise-client-5.0       <none>                            (no description available)
  un  mysql-enterprise-server-5.0       <none>                            (no description available)
  un  mysql-gpl-client                  <none>                            (no description available)
  ii  mysql-gui-tools-common            5.0~rc12-2ubuntu1                 Architecture independent files for MySQL GUI Tools
  un  mysql-navigator                   <none>                            (no description available)
  un  mysql-proxy                       <none>                            (no description available)
  ii  mysql-query-browser               5.0~rc12-2ubuntu1                 Official GUI tool to query MySQL database
  un  mysql-query-browser-common        <none>                            (no description available)
  ii  mysql-server                      5.0.51a-3ubuntu5.4                MySQL database server (meta package depending on the latest version)
  un  mysql-server-4.1                  <none>                            (no description available)
  ii  mysql-server-5.0                  5.0.51a-3ubuntu5.4                MySQL database server binaries
  un  mysqltcl                          <none>                            (no description available)

-- 
mysql refuses to start because a missing (optional) config dir /etc/mysql/conf.d/
https://bugs.launchpad.net/bugs/305107
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed to mysql-dfsg-5.0 in ubuntu.