Atomicorp

Ok, I'm trying to add a Mambo or postnuke or.. database using either the sitebuilder or the application vault and when it gets to adding users the following errors pop up:

Unable to query: Unknown column 'Show_db_priv' in 'field list'

--------------------------------------------------------------------------------

0: /usr/local/psa/admin/plib/database_mysql.inc:1 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 "DBADMINNAME", string "DBADMINPW", string "plain")
2: /usr/local/psa/admin/htdocs/domains/databases/db_usr_edit.php3:2 database->adduser(string "MAMBOEDITOR", string "MAMBOEDITORPW")


MySQL info:
[root@gz po]# rpm -qa |grep mysql
mysql-compat-(none)-4.0.22-2.rhel3.art
mysql-debuginfo-(none)-4.0.20-art.2
mysql-server-(none)-4.0.22-2.rhel3.art
libdbi-dbd-mysql-(none)-0.6.5-5
mysql-devel-(none)-4.0.22-2.rhel3.art
php-mysql-(none)-4.3.10-1.rhel3.art
mysql-(none)-4.0.22-2.rhel3.art

Mambo info:
Mambo 4.5 1.0.7 1 - Mambo is an Open Source CMS system.

Tried to update mambo via yum and got:

[root@gz etc]# yum update mambo
Gathering header information file(s) from server(s)
Server: Atomic Rocket Turtle - 3ES - App Vault RPMS
Server: Atomic Rocket Turtle - 3ES - Atomic PSA-Compatible RPMS
Server: Atomic Rocket Turtle - 3ES - Atomic PSA
Server: Atomic Rocket Turtle - 3ES - Atomic PSA 7.1
Server: Atomic Rocket Turtle - 3ES - Base OS RPMS mirror
Server: Atomic Rocket Turtle - 3ES - OS Update RPMS mirror
Finding updated packages
Downloading needed headers
httpd-0-2.0.46-44.ent.WB1 100% |=========================| 19 kB 00:00
perl-3-5.8.5-9.rhel3.art. 100% |=========================| 76 kB 00:00
PostNuke-0-0.750-1.noarch 100% |=========================| 1.8 kB 00:00
phpBB-0-2.0.11-1.noarch.h 100% |=========================| 1.7 kB 00:00
Mambo-0-4.5.1a-1.noarch.h 100% |=========================| 1.9 kB 00:00
perl-suidperl-3-5.8.5-9.1 100% |=========================| 5.7 kB 00:00
php-pear-0-4.3.10-1.rhel3 100% |=========================| 11 kB 00:00
mod_ssl-1-2.0.46-44.ent.W 100% |=========================| 8.1 kB 00:00
php-mhash-0-4.3.10-1.rhel 100% |=========================| 5.8 kB 00:00
php-odbc-0-4.3.10-1.rhel3 100% |=========================| 6.0 kB 00:00
httpd-devel-0-2.0.46-44.e 100% |=========================| 12 kB 00:00
Cannot find any package matching mambo available to be updated.
No actions to take

Got these errors while trying to install a postnuke db.

Unable to query: Unknown column 'Show_db_priv' in 'field list'

--------------------------------------------------------------------------------

0: /usr/local/psa/admin/plib/database_mysql.inc:1 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 "identification", string "password", string "plain")
2: /usr/local/psa/admin/plib/SiteApps/class.SiteAppManager.php:2 database->adduser(string "identification", string "password")
3: /usr/local/psa/admin/plib/SiteApps/class.SiteAppPackageManager.php:2 siteappmanager->createresource(object of type siteapp, array, string "domain", integer "16")
4: /usr/local/psa/admin/htdocs/siteapp/siteapp_install.php:2 siteapppackagemanager->installsiteapp(object of type siteapppackage, string "domain", integer "16", integer "2", array, array, array

where do I need to fix this?

running mysql4? if so did you run the mysql_fix_privilege_tables script?

/blush, nope.. where do I find such a script please?

Ok, I found the script but when I run it I'm getting all kinds of errors as I run it as root or as admin:

[admin@gz bin]$ ./mysql_fix_privilege_tables
This scripts updates the mysql.user, mysql.db, mysql.host and the
mysql.func tables to MySQL 3.22.14 and above.

This is needed if you want to use the new GRANT functions,
CREATE AGGREGATE FUNCTION or want to use the more secure passwords in 3.23

If you get 'Access denied' errors, you should run this script again
and give the MySQL root user password as an argument!
Converting all privilege tables to MyISAM format
ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)

If your tables are already up to date or partially up to date you will
get some warnings about 'Duplicated column name'. You can safely ignore these!
ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)

Creating Grant Alter and Index privileges if they don't exists
You can ignore any Duplicate column errors
ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)

Adding columns needed by GRANT .. REQUIRE (openssl)
You can ignore any Duplicate column errors
ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)

Creating the new table and column privilege tables
ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)
Changing name of columns_priv.Type -> columns_priv.Column_priv
You can ignore any Unknown column errors from this
ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)

Fixing the func table
You can ignore any Duplicate column errors
ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)

Adding new fields used by MySQL 4.0.2 to the privilege tables
You can ignore any Duplicate column errors
ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)
ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)
ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)
ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)

Don't worry.

The script is trying to use the username root by default. Either edit the file and change the username to admin and the password to your plesk admin password, or you can use aguments in the command line but I can't remember that they are offhand. Have a search on the Plesk forum with the script's name as the search quiry and you'll find it.

NOTE: after you do this and run it, it is normal to get some errors -- see the output. It says not to worry about them.

Faris.

Ok, edited the file and tried to run it, got the following errors with and without pw. I've also searched google and plesks forums for this with no results.... search term mysql_fix_privilege_tables / mysql fix privilege tables.. both turned up no results...

Stumped.

[admin@gz bin]$ mysql_fix_privilege_tables --password XXXXXXXXX
Unknown argument '--password'
[admin@gz bin]$ mysql_fix_privilege_tables -pXXXXXXXXXX
This scripts updates the mysql.user, mysql.db, mysql.host and the
mysql.func tables to MySQL 3.22.14 and above.

This is needed if you want to use the new GRANT functions,
CREATE AGGREGATE FUNCTION or want to use the more secure passwords in 3.23

If you get 'Access denied' errors, you should run this script again
and give the MySQL admin user password as an argument!
Converting all privilege tables to MyISAM format
ERROR 1045: Access denied for user: 'admin@localhost' (Using password: YES)

If your tables are already up to date or partially up to date you will
get some warnings about 'Duplicated column name'. You can safely ignore these!
ERROR 1045: Access denied for user: 'admin@localhost' (Using password: YES)

Creating Grant Alter and Index privileges if they don't exists
You can ignore any Duplicate column errors
ERROR 1045: Access denied for user: 'admin@localhost' (Using password: YES)

Adding columns needed by GRANT .. REQUIRE (openssl)
You can ignore any Duplicate column errors
ERROR 1045: Access denied for user: 'admin@localhost' (Using password: YES)

Creating the new table and column privilege tables
ERROR 1045: Access denied for user: 'admin@localhost' (Using password: YES)
Changing name of columns_priv.Type -> columns_priv.Column_priv
You can ignore any Unknown column errors from this
ERROR 1045: Access denied for user: 'admin@localhost' (Using password: YES)

Fixing the func table
You can ignore any Duplicate column errors
ERROR 1045: Access denied for user: 'admin@localhost' (Using password: YES)

Adding new fields used by MySQL 4.0.2 to the privilege tables
You can ignore any Duplicate column errors
ERROR 1045: Access denied for user: 'admin@localhost' (Using password: YES)
ERROR 1045: Access denied for user: 'admin@localhost' (Using password: YES)
ERROR 1045: Access denied for user: 'admin@localhost' (Using password: YES)
ERROR 1045: Access denied for user: 'admin@localhost' (Using password: YES)
[admin@gz bin]$ mysql_fix_privilege_tables
This scripts updates the mysql.user, mysql.db, mysql.host and the
mysql.func tables to MySQL 3.22.14 and above.

This is needed if you want to use the new GRANT functions,
CREATE AGGREGATE FUNCTION or want to use the more secure passwords in 3.23

If you get 'Access denied' errors, you should run this script again
and give the MySQL admin user password as an argument!
Converting all privilege tables to MyISAM format
ERROR 1045: Access denied for user: 'admin@localhost' (Using password: NO)

If your tables are already up to date or partially up to date you will
get some warnings about 'Duplicated column name'. You can safely ignore these!
ERROR 1045: Access denied for user: 'admin@localhost' (Using password: NO)

Creating Grant Alter and Index privileges if they don't exists
You can ignore any Duplicate column errors
ERROR 1045: Access denied for user: 'admin@localhost' (Using password: NO)

Adding columns needed by GRANT .. REQUIRE (openssl)
You can ignore any Duplicate column errors
ERROR 1045: Access denied for user: 'admin@localhost' (Using password: NO)

Creating the new table and column privilege tables
ERROR 1045: Access denied for user: 'admin@localhost' (Using password: NO)
Changing name of columns_priv.Type -> columns_priv.Column_priv
You can ignore any Unknown column errors from this
ERROR 1045: Access denied for user: 'admin@localhost' (Using password: NO)

Fixing the func table
You can ignore any Duplicate column errors
ERROR 1045: Access denied for user: 'admin@localhost' (Using password: NO)

Adding new fields used by MySQL 4.0.2 to the privilege tables
You can ignore any Duplicate column errors
ERROR 1045: Access denied for user: 'admin@localhost' (Using password: NO)
ERROR 1045: Access denied for user: 'admin@localhost' (Using password: NO)
ERROR 1045: Access denied for user: 'admin@localhost' (Using password: NO)
ERROR 1045: Access denied for user: 'admin@localhost' (Using password: NO)
[admin@gz bin]$

Problem Solved.

I needed to run the mysql_fix_privilege_tables script on my psa box. The script is set for root to run so there were a few steps needed to be put in place before I could run the script.

By default only Admin on a psa box is setup. Root is not in the mysql user table, this is why you need to edit the script.

So, edit the script and replace root with admin in all instances.

Then you have a specific syntax to use to run the script as admin NOT root:

mysql_fix_privilege_tables --password=PASSWORD

PASSWORD is replaced by your admin PSA password.

Thanks to Scott who pointed me in the direction to solve this.

This is only needed if you upgrade your mysql and you get the errors above that I was getting.