during update on a virtual server I get this error
Code:
I seguenti pacchetti saranno aggiornati:
mysql-server
1 aggiornati, 0 installati, 0 da rimuovere e 18 non aggiornati.
8 non completamente installati o rimossi.
È necessario prendere 0B/55,1kB di archivi.
Dopo quest'operazione, verranno occupati 0B di spazio su disco.
Lettura dei changelog... Fatto
(Lettura del database ... 34163 file e directory attualmente installati.)
Mi preparo a sostituire mysql-server 5.0.51a-24+lenny1 (con .../mysql-server_5.0.51a-24+lenny2_all.deb) ...
Stopping MySQL database server: mysqld failed!
invoke-rc.d: initscript mysql, action "stop" failed.
invoke-rc.d returned 1
There is a MySQL server running, but we failed in our attempts to stop it.
Stop it yourself and try again!
dpkg: errore processando /var/cache/apt/archives/mysql-server_5.0.51a-24+lenny2_all.deb (--unpack):
il sottoprocesso pre-installation script ha restituito un codice di errore 1
Sono occorsi degli errori processando:
/var/cache/apt/archives/mysql-server_5.0.51a-24+lenny2_all.deb
E: Sub-process /usr/bin/dpkg returned an error code (1)
dpkg.log
Code:
2009-09-12 09:21:23 startup archives unpack
2009-09-12 09:21:23 upgrade mysql-server 5.0.51a-24+lenny1 5.0.51a-24+lenny2
2009-09-12 09:21:23 status half-configured mysql-server 5.0.51a-24+lenny1
2009-09-12 09:21:23 status unpacked mysql-server 5.0.51a-24+lenny1
2009-09-12 09:21:23 status half-installed mysql-server 5.0.51a-24+lenny1
2009-09-12 09:21:23 status unpacked mysql-server 5.0.51a-24+lenny1
2009-09-12 09:21:23 status installed mysql-server 5.0.51a-24+lenny1
on various forums have said to put
exit 0 at the beginning of the file /var/lib/dpkg/info/file.postrm, but nothing has changed.
-----------------------------
1. erase the password entries in /etc/mysql/debian.cnf for user debian-sys-maint
2. log into mysql, using the mysql database, and reset the password for the user:
grant all privileges on *.* to 'debian-sys-maint'@'localhost' identified by '' with grant option;
3. flush privileges;
4. quit