Hi,

For some reason mysql fails to install after running "aptitude purge mysql-server --purge-unused". I want a clean, fresh mysql installation and don't care about what happens to the old mysql data/config files/etc. It appears the install scrip is looking for the old "/etc/mysql/conf.d/old_passwords.cnf" and fails since it doesn't exist.

Any ideas? Thanks



# uname -a
Linux testsrv 2.6.18-6-686 #1 SMP Sun Feb 10 22:11:31 UTC 2008 i686 GNU/Linux

# aptitude purge mysql-server --purge-unused
Reading package lists... Done
Building dependency tree... Done
Reading extended state information
Initializing package states... Done
Reading task descriptions... Done
Building tag database... Done
The following packages have been kept back:
postfix postfix-doc
0 packages upgraded, 0 newly installed, 0 to remove and 2 not upgraded.
Need to get 0B of archives. After unpacking 0B will be used.
Writing extended state information... Done

# aptitude install mysql-server
Reading package lists... Done
Building dependency tree... Done
Reading extended state information
Initializing package states... Done
Reading task descriptions... Done
Building tag database... Done
The following NEW packages will be automatically installed:
libdbd-mysql-perl libdbi-perl libnet-daemon-perl libplrpc-perl mysql-client-5.0 mysql-server-5.0
The following packages have been kept back:
postfix postfix-doc
The following NEW packages will be installed:
libdbd-mysql-perl libdbi-perl libnet-daemon-perl libplrpc-perl mysql-client-5.0 mysql-server mysql-server-5.0
0 packages upgraded, 7 newly installed, 0 to remove and 2 not upgraded.
Need to get 0B/33.5MB of archives. After unpacking 87.5MB will be used.
Do you want to continue? [Y/n/?] y
Writing extended state information... Done
Preconfiguring packages ...
Selecting previously deselected package libnet-daemon-perl.
(Reading database ... 51613 files and directories currently installed.)
Unpacking libnet-daemon-perl (from .../libnet-daemon-perl_0.38-1.1_all.deb) ...
Selecting previously deselected package libplrpc-perl.
Unpacking libplrpc-perl (from .../libplrpc-perl_0.2017-1.1_all.deb) ...
Selecting previously deselected package libdbi-perl.
Unpacking libdbi-perl (from .../libdbi-perl_1.53-1etch1_i386.deb) ...
Selecting previously deselected package libdbd-mysql-perl.
Unpacking libdbd-mysql-perl (from .../libdbd-mysql-perl_3.0008-1_i386.deb) ...
Selecting previously deselected package mysql-client-5.0.
Unpacking mysql-client-5.0 (from .../mysql-client-5.0_5.0.32-7etch5_i386.deb) ...
Selecting previously deselected package mysql-server-5.0.
Unpacking mysql-server-5.0 (from .../mysql-server-5.0_5.0.32-7etch5_i386.deb) ...
Selecting previously deselected package mysql-server.
Unpacking mysql-server (from .../mysql-server_5.0.32-7etch5_all.deb) ...
Setting up libnet-daemon-perl (0.38-1.1) ...
Setting up libplrpc-perl (0.2017-1.1) ...
Setting up libdbi-perl (1.53-1etch1) ...
Setting up libdbd-mysql-perl (3.0008-1) ...
Setting up mysql-client-5.0 (5.0.32-7etch5) ...
Setting up mysql-server-5.0 (5.0.32-7etch5) ...
Stopping MySQL database server: mysqld.
/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
dpkg: dependency problems prevent configuration of mysql-server:
mysql-server depends on mysql-server-5.0; however:
Package mysql-server-5.0 is not configured yet.
dpkg: error processing mysql-server (--configure):
dependency problems - leaving unconfigured
Errors were encountered while processing:
mysql-server-5.0
mysql-server
E: Sub-process /usr/bin/dpkg returned an error code (1)
A package failed to install. Trying to recover:
Setting up mysql-server-5.0 (5.0.32-7etch5) ...
Stopping MySQL database server: mysqld.
/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
dpkg: dependency problems prevent configuration of mysql-server:
mysql-server depends on mysql-server-5.0; however:
Package mysql-server-5.0 is not configured yet.
dpkg: error processing mysql-server (--configure):
dependency problems - leaving unconfigured
Errors were encountered while processing:
mysql-server-5.0
mysql-server



-- End of message -----------------------------------------------------








--
To UNSUBSCRIBE, email to debian-user-REQUEST@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmaster@lists.debian.org

> That line in the script reads:
>
> echo -e "# created by
> debconf
[mysqld]
old_passwords = $RET" >
> /etc/mysql/conf.d/old_passwords.cnf
>
> This does not seem to require that old_passwords.cnf exists
> beforehand.
> Is there still enough space on all the relevant partitions,

Yes, free space doesn't seem to be a problem, there's plenty of it.



> does the
> /etc/mysql/conf.d/ directory exist?

The "/etc/mysql" directory no longer exists, so no. As I remember the first time I tried to purge mysql the "/etc/mysql" directory wasn't purged as it had some files in it, so I removed it manually, I wanted a new, fresh, clean installation. That, perhaps, was the beginning of my downfall.


> Can you do this:
>
> touch /etc/mysql/conf.d/old_passwords.cnf

Nope, see above.

Basically I want a new, fresh, clean mysql installation. I want the old installation gone, completely, and that's why I used "purge" instead of "remove".


Thanks



-- End of message -----------------------------------------------------








--
To UNSUBSCRIBE, email to debian-user-REQUEST@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmaster@lists.debian.org

--- On Thu, 6/19/08, Florian Kulzer

> Maybe you can recreate the /etc/mysql/conf.d/ directory and
> the installation will be successful.

That was one of the first things I tried but it didn't work out, it leads to more problems.



> If that does not work then run
>
> dpkg -S etc/mysql
>
> to find out which packages on your system should have files

That was a brilliant suggestion. I knew about "dpkg -S" but somehow I assumed that everything related to mysql-server was removed when I purged it. Not so.

mysql-common was left over as some other packages depended on it and that was causing the problem. Purging mysql-common (and the dependent packages) and then reinstalling resolved the issue.

Thanks a lot for your help.


-- End of message -----------------------------------------------------






--
To UNSUBSCRIBE, email to debian-user-REQUEST@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmaster@lists.debian.org