Problem with file permissions when reinstalling

Thank you for taking the time to report this bug and helping to make Ubuntu better.

Could you please provide the following information:

 * content of /var/log/daemon.log related to mysql processes:

    /var/log/daemon.log

 * apparmor audit messages related to mysqld. The output of the command:

   egrep 'audit\(|apparmor|selinux|security' /var/log/kern.log

 * mysqld apparmor profile:

    /etc/apparmor.d/usr.sbin.mysqld

 * list of mysqld apparmor profiles:

    ls -l /etc/apparmor.d/usr.sbin.mysqld*

 * mysql configuration stripped of private information (such as password):

    /etc/mysql/my.cnf

 * extra mysql configuration from the conf.d directory:

    /etc/mysql/conf.d/

 * directory listing of mysql datadir (by default /var/lib/mysql):

    ls -l /var/lib/mysql

my.cnf does not have any settings inside.

Best Regards,
Radek R.
tel. +48 600 282 225
Web: http://ndo.pl

2009/10/13 Mathias Gug <email address hidden>

> Thank you for taking the time to report this bug and helping to make
> Ubuntu better.
>
> Could you please provide the following information:
>
> * content of /var/log/daemon.log related to mysql processes:
>
> /var/log/daemon.log
>
> * apparmor audit messages related to mysqld. The output of the command:
>
> egrep 'audit\(|apparmor|selinux|security' /var/log/kern.log
>
> * mysqld apparmor profile:
>
> /etc/apparmor.d/usr.sbin.mysqld
>
> * list of mysqld apparmor profiles:
>
> ls -l /etc/apparmor.d/usr.sbin.mysqld*
>
> * mysql configuration stripped of private information (such as
> password):
>
> /etc/mysql/my.cnf
>
> * extra mysql configuration from the conf.d directory:
>
> /etc/mysql/conf.d/
>
> * directory listing of mysql datadir (by default /var/lib/mysql):
>
> ls -l /var/lib/mysql
>
>
> ** Changed in: mysql-dfsg-5.0 (Ubuntu)
> Status: New => Incomplete
>
> ** Changed in: mysql-dfsg-5.0 (Ubuntu)
> Importance: Undecided => Low
>
> --
> Problem with file permissions when reinstalling
> https://bugs.launchpad.net/bugs/447538
> You received this bug notification because you are a direct subscriber
> of the bug.
>
> Status in “mysql-dfsg-5.0” package in Ubuntu: Incomplete
>
> Bug description:
> What I did was flushing privileges after moving to another server, then my
> new root password changed to this from old server but i didnt know that and
> i did remove mysql-server and reinstall it again hoping to not use flush
> privileges again. This caused so horrible-many-hours-wasting problem. BUG
> REPORT!!!
> apt-get remove --purge mysql-server
>
> It was a few problems while reinstalling mysql-server
> 1. /var/lib/dpkg/info/mysql-server-5.0.postinst: line 143:
> /etc/mysql/conf.d/old_passwords.cnf: No such file or directory
> 2. Something like /lib/modules/apparmor could not be found
> 3. Something like /lib/modules/2.6.28***/** coun't be found because the
> directory 2.6.28 wasnt existed
>
> Some log (not mine):
> Setting up mysql-client-5.0 (5.0.51a-3ubuntu5.1) ...
> Setting up mysql-server-5.0 (5.0.51a-3ubuntu5.1) ...
> * Stopping MySQL database server mysqld [ OK ]
> /var/lib/dpkg/info/mysql-server-5.0.postinst: line 143:
> /etc/mysql/conf.d/old_passwords.cnf: No such file or directory
> dpkg: error processing mysql-server-5.0 (--configure):
> subprocess post-installation script returned error exit status 1
> Errors were encountered while processing:
> mysql-server-5.0
> E: Sub-process /usr/bin/dpkg returned an error code (1)
>
> How I fixed it?:
>
> sudo bash
> chown -R mysql:mysql /var/lib/mysql/mysql/
> (it was root:root)
> touch /etc/mysql/my.cnf
> chown -R mysql:mysql /etc/mysql/
> (it was root:root)
> apt-get install mysql-server
> /etc/init.d/mysql stop
> /etc/init.d/mysql start
> (it was fail before)
> .........[ OK ]
>
> !!!!!!!!!!!!!!...............
>
> Best Regards,
> grryf
>
> Very similar:
> http://ubuntuforums.org/showthread.php?t=891109&highlight=grryf
>
> ndo@ks31258:/lib/modules$ ls
> 2.6.24-24-generic
> (not .28)
>
>