Upgrade to plesk 10.4.4 : Table 'mysql.servers' doesn't exist

[mindor]

Hey,

I'm running plesk 10.3.1 and try to upgrade to 10.4.4. During pre-check it says : WARNING: Table "servers" in database "mysql" does not exists. Please, check http://kb.parallels.com/en/112290 for more details.

The kb didn't helped me to solve the issue.
I tried to run : mysql_upgrade -T --debug-check -u admin -p`cat /etc/psa/.psa.shadow` mysql

And it stops saying :
atmail.awl
Error : Table 'atmail.awl' doesn't exist
status : Operation failed
atmail.recurrencePatterns OK
FATAL ERROR: Upgrade failed

How should I treat this alert ?

Thanks for any hint,

 

[IgorG]

There is no table 'atmail.awl' in AtMail 1.04 which installed with Plesk 10.3.1 or Plesk 10.4.4.
But this table presence in AtMail 6 and you can try to create awl table as described here http://www.atmail.com/support/index.php/Atmail6/DatabaseSchema by following SQL query:

CREATE TABLE `awl` (
`username` varchar(100) NOT NULL default '', `email` varchar(200) NOT NULL default '', `ip` varchar(10) NOT NULL default '', `count` int(11) default '0', `totscore` float default '0', `IndexDate` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, PRIMARY KEY (`username`,`email`,`ip`) );

and run mysql_upgrade again.