[PROBLEM] Mysql upgrade to 5 broke my panel

[scislaghi]

Hello,

I'm running plesk 9 under Debian Etch. I've just upgraded my Mysql from 4.0 to 5.0 and now when I try to login into my panel I get this error:

ERROR: PleskFatalException
bad column in table: `backup_time` time NOT NULL default '00:00:00',

0: /opt/psa/admin/plib/common_func.php3:108
psaerror(string 'bad column in table: `backup_time` time NOT NULL default '00:00:00',')
1: /opt/psa/admin/plib/SQLParser.php:128
SQLParser->parseError(string ' `backup_time` time NOT NULL default '00:00:00',')
2: /opt/psa/admin/plib/SQLParser.php:114
SQLParser->_parseLineInTable(string ' `backup_time` time NOT NULL default '00:00:00',')
3: /opt/psa/admin/plib/SQLParser.php:45
SQLParser->parseLine(string ' `backup_time` time NOT NULL default '00:00:00',', integer '16')
4: :
array_walk(array, array)
5: /opt/psa/admin/plib/SQLParser.php:16
SQLParser->getArray(array)
6: /opt/psa/admin/plib/SQLParser.php:23
SQLParser->handleDatabase()
7: /opt/psa/admin/plib/mysql41/mysql41.php:16
mysql41_adopt_database(array, string 'utf8', string 'utf8_general_ci')
8: /opt/psa/admin/plib/mysql41/MySQL41PSADBUpgrader.php:33
MySQL41PSADBUpgrader->run()
9: /opt/psa/admin/plib/mysql41/mysql41_psa.php:17
mysql41_adopt_psa_database(string 'php://stderr', boolean false)
10: /opt/psa/admin/auto_prepend/auth.php3:99


Connecting to ssh and running mysql41upgrade utility produces:

server-02:/opt/psa/bin# ./mysql41upgrade --upgrade
PHP Fatal error: Call to undefined function set_active_button() in /opt/psa/admin/plib/Navigation.php on line 41


Any hint? I'm locked!


Thanks
Stefano

 

[danliker]

is mysql update the only thing you have done ?
how have you updated, with dotdeb or an other way ?

 

[scislaghi]

apt-get install mysql-server-5.0
And I've updated only this one (and its own dependencies as mysql-client-5.0).


Stefano

 

[danliker]

can you try

apt-get remove psa-backup-manager
apt-get install psa-backup-manager

 

[scislaghi]

Done, but without success.....see below

server-02:~# apt-get remove psa-backup-manager
Lettura della lista dei pacchetti in corso... Fatto
Generazione dell'albero delle dipendenze in corso... Fatto
I seguenti pacchetti saranno RIMOSSI:
psa-backup-manager
0 aggiornati, 0 installati, 1 da rimuovere e 40 non aggiornati.
È necessario prendere 0B di archivi.
Dopo l'estrazione, verranno liberati 3912kB di spazio su disco.
Continuare? [S/n] s
(Lettura del database ... 190769 file e directory attualmente installati.)
Rimuovo psa-backup-manager ...
Trying to start service mysql... done
Trying to establish test connection... connected
done
Trying to establish test connection... connected
Trying to remove /opt/psa/admin/sbin/backupmng from crontab... done
Trying to clear temporaray database storage... done
server-02:~# /etc/init.d/psa
psa psa-firewall psa-firewall-forward psa-spamassassin
server-02:~# /etc/init.d/psa stop
Stopping Plesk... done
server-02:~# /etc/init.d/psa start
Starting xinetd service... done
Starting bind9 service... done
Starting mysql service... done
Starting postgresql service... not installed
Starting psa-spamassassin service... done
Plesk: Starting Mail Server... already started
Starting Plesk... done
server-02:~# apt-get install psa-backup-manager
Lettura della lista dei pacchetti in corso... Fatto
Generazione dell'albero delle dipendenze in corso... Fatto
I seguenti pacchetti NUOVI (NEW) saranno installati:
psa-backup-manager
0 aggiornati, 1 installati, 0 da rimuovere e 40 non aggiornati.
È necessario prendere 0B/1257kB di archivi.
Dopo l'estrazione, verranno occupati 3912kB di spazio su disco.
Selezionato il pacchetto psa-backup-manager, che non lo era.
(Lettura del database ... 190371 file e directory attualmente installati.)
Spacchetto psa-backup-manager (da .../psa-backup-manager_9.0.0-debian4.0.build90081208.07_i386.deb) ...
Configuro psa-backup-manager (9.0.0-debian4.0.build90081208.07) ...
Trying to start service mysql... done
Trying to establish test connection... connected
done
Trying to establish test connection... connected
Trying to create temporary database storage... done
Trying to upgrade persistent database storage... done
chown: cannot access `/opt/psa/admin/conf/ssl.crt': No such file or directory
chmod: cannot access `/opt/psa/admin/conf/ssl.crt': No such file or directory
find: /opt/psa/admin/conf/ssl.crt: No such file or directory

server-02:~# /etc/init.d/psa stop
Stopping Plesk... done
server-02:~# /etc/init.d/psa start
Starting xinetd service... done
Starting bind9 service... done
Starting mysql service... done
Starting postgresql service... not installed
Starting psa-spamassassin service... done
Plesk: Starting Mail Server... already started
Starting Plesk... done
server-02:~#

Problem persists.

Stefano

 

[danliker]

maybe the problem is here:

chown: cannot access `/opt/psa/admin/conf/ssl.crt': No such file or directory
chmod: cannot access `/opt/psa/admin/conf/ssl.crt': No such file or directory
find: /opt/psa/admin/conf/ssl.crt: No such file or directory

 

[scislaghi]

mmmm... strange, I know, there's a way to regenerate it?

Ste