Database Error after Upgrade to PHP5.2

[teddy]

Hello,

im updated php 5.1.6 on CentOS 5.4 to php.5.2.13
now all existent databases, websites e.g. works correctly

but i have an error on the plesk - admin panel.
when i will make a change (e.g. adminpassword, create a new mysql database or user or change a mysqlpassword) a have an error "Table 'mysql.servers' doesn't exist"

also a directly access to the mysql databases from the start-page on the plesk panel doesn´t works.

How is the problem - what can i do to fix this.

I think other applications have also a problem with the access - i will test it.

Thanx for help

 

[teddy]

Fixed

Hi

the Problem is fixed.

now - the error "mysql.server doesn´t exist" is not a bug in plesk.
i updated php 5 with the atomicorp repo.
wget -q -O - http://www.atomicorp.com/installers/atomic |sh

now i updated also mysql with yum update and in this version ( 5.1.48-1.el5.art ) the mysql server use a table "server" in the database "mysql"

i fixed this with

CREATE TABLE `servers` (
`Server_name` char(64) NOT NULL,
`Host` char(64) NOT NULL,
`Db` char(64) NOT NULL,
`Username` char(64) NOT NULL,
`Password` char(64) NOT NULL,
`Port` int(4) DEFAULT NULL,
`Socket` char(64) DEFAULT NULL,
`Wrapper` char(64) NOT NULL,
`Owner` char(64) NOT NULL,
PRIMARY KEY (`Server_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
COMMENT='MySQL Foreign Servers table';



restart the mysql server - and it works.

 

[Michael neese]

did you run this mysql upgrade after the yum upgrade?

http://www.atomicorp.com/wiki/index.php/Mysql