[SOLVED] update last version trunk 12/09/2009 [dpkg returned an error code (1)]

[theprincy]

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

[Nuxwin]

Hi ;

The error is not related to ispCP but the maintenance scripts Debian package. It is an error located in the script "preinst" of the new mysql server package ( 5.0.51a-24+lenny2 ).

I'll check this script for you. Please wait my feedback.

THX

[theprincy]

I saw it in the end I managed to solve, the interesting thing was that user debian-sys-maint was not present, I do not know how she can be successful, the log of mysql does not say much.