Plesk crash after PHP/MySQL upgrade

[pfromaget]

(Sorry i'm french ...)

yum update
yum upgrade => upgrade of php from 4.3 to 5.1, mysql from 3.23 to 4.1

An now i'm unable to display the plesk login page :

ERROR: PleskMainDBException
MySQL query failed: Invalid default value for 'srv_bandwidth'

0: /usr/local/psa/admin/plib/common_func.php3:215
db_query(string 'ALTER TABLE `module_bf2_servers` MODIFY `hosting_address` varchar(255) CHARACTER SET binary NOT NULL default ''')
1: /usr/local/psa/admin/plib/mysql41/mysql41.php:35
mysql41_adopt_column(string 'module_bf2_servers', string 'hosting_address', string 'varchar(255)', string ' NOT NULL default ''', array)
2: /usr/local/psa/admin/plib/mysql41/mysql41.php:100
MySQL41TableUpgrader->_handleColumn(array)
3: /usr/local/psa/admin/plib/SQLParser.php:98
SQLParser->_parseLineInTable(string ' `hosting_address` varchar(255) NOT NULL default '',')
4: /usr/local/psa/admin/plib/SQLParser.php:52
SQLParser:arseLine(string ' `hosting_address` varchar(255) NOT NULL default '',', integer '3')
5: :
array_walk(array, array)
6: /usr/local/psa/admin/plib/SQLParser.php:23
SQLParser->getArray(array)
7: /usr/local/psa/admin/plib/SQLParser.php:30
SQLParser->handleDatabase()
8: /usr/local/psa/admin/plib/mysql41/mysql41.php:26
mysql41_adopt_database(array, string 'utf8', string 'utf8_general_ci')
9: /usr/local/psa/admin/plib/mysql41/MySQL41PSADBUpgrader.php:41
MySQL41PSADBUpgrader->run()
10: /usr/local/psa/admin/plib/mysql41/mysql41_psa.php:28
mysql41_adopt_psa_database(string 'php://stderr', boolean false)
11: /usr/local/psa/admin/auto_prepend/auth.php3:96

FTP is ok but apache doesn't start :

Démarrage de httpd :Syntax error on line 1 of /etc/httpd/conf.d/php.conf:
Cannot load /etc/httpd/modules/libphp4.so into server: /etc/httpd/modules/libphp4.so: cannot open shared object file: No such file or directory
[ÉCHOUÉ]

Somebody have an idea ?
Thanks

 

[blank_page]

Hello,


for plesk you backup the psa databse and define a default value where it asks:

ALTER TABLE `module_bf2_servers` MODIFY `hosting_address` varchar(255) CHARACTER SET binary NOT NULL default 0;

For the php ...

Yo changed from php4 to php5 that meens that some paths have changed. You have to troubleshoot yourself get the paths and the conf properly. Run updatedb so you can find the files easier. This can be corrected manually you oly need to use the error messages for starting point.

 

[pfromaget]

OK but what is the mysql user/password who have all rights on the psa database ?

 

[blank_page]

HEllo,

Same login as plesk admin.
admin/pleskpassword