Scott or anyone with any insight on this problem?

General Discussion of atomic repo and development projects.

Ask for help here with anything else not covered by other forums.
Galactic Zero
Forum Regular
Forum Regular
Posts: 471
Joined: Mon Dec 06, 2004 10:43 pm

Scott or anyone with any insight on this problem?

Unread post by Galactic Zero »

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?
Franklyn Halamka
Still learning my way around Linux Security.
http://www.galacticzero.net
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 »

running mysql4? if so did you run the mysql_fix_privilege_tables script?
Galactic Zero
Forum Regular
Forum Regular
Posts: 471
Joined: Mon Dec 06, 2004 10:43 pm

Unread post by Galactic Zero »

/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)
Franklyn Halamka
Still learning my way around Linux Security.
http://www.galacticzero.net
faris
Long Time Forum Regular
Long Time Forum Regular
Posts: 2321
Joined: Thu Dec 09, 2004 11:19 am

Unread post by faris »

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.
Galactic Zero
Forum Regular
Forum Regular
Posts: 471
Joined: Mon Dec 06, 2004 10:43 pm

Unread post by Galactic Zero »

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]$
Last edited by Galactic Zero on Thu Jan 06, 2005 4:08 pm, edited 1 time in total.
Franklyn Halamka
Still learning my way around Linux Security.
http://www.galacticzero.net
Galactic Zero
Forum Regular
Forum Regular
Posts: 471
Joined: Mon Dec 06, 2004 10:43 pm

Unread post by Galactic Zero »

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.
Franklyn Halamka
Still learning my way around Linux Security.
http://www.galacticzero.net
Post Reply