PSA 7.5 + MySQL 4.0.22 problem

General Discussion of atomic repo and development projects.

Ask for help here with anything else not covered by other forums.
pirotess

PSA 7.5 + MySQL 4.0.22 problem

Unread post by pirotess »

I have been able to install yum and update my MySQL server to 4.0.22. Afterwards I was able to log into PSA and click around however when I tried to add a new database user to a database I got the following error. Username and password XXXXXXXX'd out.
0: /usr/local/psa/admin/plib/database_mysql.inc:2 psaerror(string "Unable to query: Unknown column 'Show_db_priv' in 'field list'")
1: /usr/local/psa/admin/plib/class.DataBase.php3:2 database_mysql->useradd(string "XXXXXXXX", string "XXXXXXXX", string "plain")
2: /usr/local/psa/admin/htdocs/domains/databases/db_usr_edit.php3:2 database->adduser(string "XXXXXXXX", string "XXXXXXXX")
Any idea how to fix this or should we not be using PSA to administer our DBs and just go with a direct install of phpMyAdmin?
scott
Atomicorp Staff - Site Admin
Atomicorp Staff - Site Admin
Posts: 8355
Joined: Wed Dec 31, 1969 8:00 pm
Location: earth
Contact:

Unread post by scott »

you need to run mysql_fix_privilege_tables
Post Reply