I have purged mysql-server mysql-client using the following command : *# aptitude purge --purge-unused mysql-server mysql-client *
and then i issued command : *# updatedb* I have again tried to install both of the packages, instead of downloading packages, i has took me directly to provide password for mysql and mysql is not configured properly. I have changed the debian mirrors, *my mirror list is* : # # deb cdrom:[Debian GNU/Linux 5.0.0 _Lenny_ - Official i386 DVD Binary-1 20090214-16:54]/ lenny contrib main #deb cdrom:[Debian GNU/Linux 5.0.0 _Lenny_ - Official i386 DVD Binary-1 20090214-16:54]/ lenny contrib main #deb cdrom:[Debian GNU/Linux 5.0.0 _Lenny_ - Official i386 DVD Binary-2 20090214-16:54]/ lenny contrib main #deb cdrom:[Debian GNU/Linux 5.0.0 _Lenny_ - Official i386 DVD Binary-3 20090214-16:54]/ lenny contrib main #deb cdrom:[Debian GNU/Linux 5.0.0 _Lenny_ - Official i386 DVD Binary-4 20090214-16:54]/ lenny contrib main #deb cdrom:[Debian GNU/Linux 5.0.0 _Lenny_ - Official i386 DVD Binary-5 20090214-16:54]/ lenny contrib main #deb cdrom:[Debian GNU/Linux 5.0.4 Update DVD 20100202: i386 DVD 1]/ lenny contrib main non-free # Line commented out by installer because it failed to verify: deb-src ftp://ftp.jp.debian.org/debian/ lenny main contrib deb http://security.debian.org/ lenny/updates main contrib non-free deb http://ftp.jp.debian.org/debian/ lenny main contrib non-free # Line commented out by installer because it failed to verify: #deb-src http://security.debian.org/ lenny/updates main contrib non-free # Line commented out by installer because it failed to verify: #deb http://volatile.debian.org/debian-volatile lenny/volatile main contrib non-free # Line commented out by installer because it failed to verify: #deb-src http://volatile.debian.org/debian-volatile lenny/volatile main contrib non-free. The output of the *# aptitude install mysql-server mysql-client* Script started on Friday 19 March 2010 09:13:19 AM IST admin:/home/user# aptitude install mysql-serb[Kver ap[K[Kmysql-client Reading package lists... 0% Reading package lists... 100% Reading package lists... Done Building dependency tree... 0% Building dependency tree... 0% Building dependency tree... 50% Building dependency tree... 50% Building dependency tree Reading state information... 0% Reading state information... 0% Reading state information... Done Reading extended state information... 0% Reading extended state information... 77% Reading extended state information Initializing package states... 0% Initializing package states... Done Reading task descriptions... 0% Reading task descriptions... 0% Reading task descriptions... Done The following NEW packages will be installed: libhtml-template-perl{a} mysql-server mysql-server-5.0{a} 0 packages upgraded, 3 newly installed, 0 to remove and 0 not upgraded. Need to get 0B/26.8MB of archives. After unpacking 84.0MB will be used. Do you want to continue? [Y/n/?] Y Writing extended state information... 0% Writing extended state information... 1% Writing extended state information... Done Preconfiguring packages ... [?1049h[1;38r[4l[?25l[m(B[37m[40m[1;38r[H[2J[1;1H[1m[37m[44m[K [K [K [K [K [K [K [K [K [K [K [K [K [K [K [K [K [K [K [K [K [K [K [K [K [K [K [K [K [K [K [K [K [K [K [K [K [K[1;1H[?25l[?12l[?25h[m(B[37m[44mPackage configuration[14;5H[30m[47m┌─────────────────────────────────────────┤ [31mConfiguring mysql-server-5.0[30m ├─────────────────────────────────────────┐[15;5H│ While not mandatory, it is highly recommended that you set a password for the MySQL administrative "root" user. │[1m[37m[40m [16;5H[m(B[30m[47m│ │[1m[37m[40m [17;5H[m(B[30m[47m│ If that field is left blank, the password will not be changed. │[1m[37m[40m [18;5H[m(B[30m[47m│ │[1m[37m[40m [19;5H[m(B[30m[47m│ New password for the MySQL "root" user: │[1m[37m[40m [20;5H[m(B[30m[47m│ │[1m[37m[40m [21;5H[m(B[30m[47m│ [37m[44m________________________________________________________________________________________________________________[30m[47m │[1m[37m[40m [22;5H[m(B[30m[47m│ │[1m[37m[40m [23;5H[m(B[30m[47m│ <Ok> │[1m[37m[40m [24;5H[m(B[30m[47m│ │[1m[37m[40m [25;5H[m(B[30m[47m└──────────────────────────────────────────────────────────────────────────────────────────────────────────────────┘[1m[37m[40m [26;6H [21;7H[m(B[37m[44m**************[?25l[?12l[?25h[38;1H[40m[m(B[39;49m [K [?1049l[?1049h[1;38r[4l[?25l[m(B[37m[40m[1;38r[H[2J[1;1H[1m[37m[44m[K [K [K [K [K [K [K [K [K [K [K [K [K [K [K [K [K [K [K [K [K [K [K [K [K [K [K [K [K [K [K [K [K [K [K [K [K [K[1;1H[?25l[?12l[?25h[m(B[37m[44mPackage configuration[15;40H[30m[47m┌──────┤ [31mConfiguring mysql-server-5.0[30m ├───────┐[16;40H│ │[1m[37m[40m [17;40H[m(B[30m[47m│ │[1m[37m[40m [18;40H[m(B[30m[47m│ Repeat password for the MySQL "root" user: │[1m[37m[40m [19;40H[m(B[30m[47m│ │[1m[37m[40m [20;40H[m(B[30m[47m│ [37m[44m___________________________________________[30m[47m │[1m[37m[40m [21;40H[m(B[30m[47m│ │[1m[37m[40m [22;40H[m(B[30m[47m│ <Ok> │[1m[37m[40m [23;40H[m(B[30m[47m│ │[1m[37m[40m [24;40H[m(B[30m[47m└─────────────────────────────────────────────┘[1m[37m[40m [25;41H [20;42H[m(B[37m[44m**************[?25l[?12l[?25h[38;1H[40m[m(B[39;49m [K [?1049lSelecting previously deselected package mysql-server-5.0. (Reading database ... 68599 files and directories currently installed.) Unpacking mysql-server-5.0 (from .../mysql-server-5.0_5.0.51a-24+lenny3_i386.deb) ... Selecting previously deselected package libhtml-template-perl. Unpacking libhtml-template-perl (from .../libhtml-template-perl_2.9-1_all.deb) ... Selecting previously deselected package mysql-server. Unpacking mysql-server (from .../mysql-server_5.0.51a-24+lenny3_all.deb) ... Processing triggers for man-db ... Setting up mysql-server-5.0 (5.0.51a-24+lenny3) ... Stopping MySQL database server: mysqld. /var/lib/dpkg/info/mysql-server-5.0.postinst: line 144: /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 Setting up libhtml-template-perl (2.9-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.51a-24+lenny3) ... Stopping MySQL database server: mysqld. /var/lib/dpkg/info/mysql-server-5.0.postinst: line 144: /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 Reading package lists... 0% Reading package lists... 0% Reading package lists... 0% Reading package lists... Done Building dependency tree... 0% Building dependency tree... 0% Building dependency tree... 30% Building dependency tree... 50% Building dependency tree... 50% Building dependency tree Reading state information... 0% Reading state information... 0% Reading state information... Done Reading extended state information... 0% Reading extended state information... 35% Reading extended state information Initializing package states... 0% Initializing package states... Done Writing extended state information... 0% Writing extended state information... 26% Writing extended state information... Done Reading task descriptions... 0% Reading task descriptions... Done admin:/home/user# exit Script done on Friday 19 March 2010 09:14:18 AM IST The output of *# dpkg-reconfigure mysql-server-5.0* /usr/sbin/dpkg-reconfigure: mysql-server-5.0 is broken or not fully installed. I hope the above might make some sense :)
