MySQL upgrade didnt work :(

[dotcomdewd]

Ok,
I upgraded php and mysql per the instructions on this website. the php went fine and the mysql said it went fine. I did see a note at the bottom of the instructions on having issues creating a database user and what to do. I did what the instructions said but this is where it gets weird. No matter what password i use, whether it is the one the machine was setup with or the new admin pass, i cannot access mysql as root. I have tried everything. Now when i try and create a db user i get:

ERROR
Unable to query: Unknown column 'Show_db_priv' in 'field list'
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 "testing", string "defc0n1", string "plain")
2: /usr/local/psa/admin/htdocs/domains/databases/db_usr_edit.php3:2 database->adduser(string "testing", string "defc0n1")



Does anyone have any suggestions on this? I am willing to pay for help to get this fixed.

Thanks

[scott]

run mysql_fix_privilege_tables --user=admin --password=`cat /etc/psa/.psa.shadow`

That was from memory, so verify the options and names first.

[dotcomdewd]

That did it.
Thanks a lot for everything!

[phatPhrog]

I just ran yum to upgrade MySQL-MAX 4.0.18-art.4 to mysql 4.0.23a-1.rhfc1.art.

1) in Plesk, my component info shows:

Fedora Core 1/Plesk 7.04

mysql Component was not installed

but it is installed...As a matter-a-fact I used ART yum to install it sometime ago.

Version Information
mysql Ver 12.22 Distrib 4.0.18, for pc-linux (i686)

PHPinfo
mysql client api 3.23.58

yum update mysql*

Looking in Available Packages:
Name Arch Version Repo
--------------------------------------------------------------------------------
MySQL-python i386 0.9.1-9 base
mysql i386 4.0.23a-1.rhfc1.art atomic
mysql-bench i386 3.23.58-4 base
mysql-compat i386 4.0.23a-1.rhfc1.art atomic
mysql-server i386 4.0.23a-1.rhfc1.art atomic

Looking in Installed Packages:
Name Arch Version Repo
--------------------------------------------------------------------------------
MySQL-Max i386 4.0.18-art.4 db
MySQL-client i386 4.0.18-art.4 db
MySQL-server i386 4.0.18-art.4 db
MySQL-shared-compat i386 4.0.18-art.4 db
mysql-devel i386 4.0.23a-1.rhfc1.art db

After trying yum update, yum upgrade I finally tried

# yum install MySQL-python mysql mysql-bench mysql-compat mysql-server
Gathering header information file(s) from server(s)
Server: Atomic Rocket Turtle - 1 - Atomic PSA-Compatible RPMS
Server: Atomic Rocket Turtle - 1 - Base OS RPMS mirror
Server: Atomic Rocket Turtle - 1 - SW-Soft PSA 7.0 RPMS
Server: Atomic Rocket Turtle - 1 - OS Update RPMS mirror
Finding updated packages
Downloading needed headers
Resolving dependencies

and received the following.

.conflict between mysql-compat and MySQL-shared-compat
Package MySQL-Max needs MySQL >= 4.0, this is not available.

What is causing mySQL to not show up in plesk and not upgrade or install the latest version?

[scott]

ah thats an old legacy naming issue, yum doesnt enforce Obsoletes by default, try using: yum upgrade

Dont specify mysql, or anything else, just see what that gets you.

[phatPhrog]

Thank you for your help, but I'm still having problems.

I ran

# yum upgrade
Gathering header information file(s) from server(s)
Server: Atomic Rocket Turtle - 1 - Atomic PSA-Compatible RPMS
Server: Atomic Rocket Turtle - 1 - Base OS RPMS mirror
Server: Fedora Legacy utilities for Fedora Core 1
Server: Atomic Rocket Turtle - 1 - SW-Soft PSA 7.0 RPMS
Server: Atomic Rocket Turtle - 1 - OS Update RPMS mirror
Server: Fedora Core 1 - i386 - Released Updates
Finding updated packages
Downloading needed headers
Finding obsoleted packages
Resolving dependencies
..Dependencies resolved
I will do the following:
[update: compat-db 4.0.14-2.i386]
[update: spamassassin 1:3.0.2-1.rhfc1.art.i386]
I will install/upgrade these to satisfy the dependencies:
[deps: dcc 1.2.63-1.rhfc1.art.i386]
[deps: perl-Net-DNS 0.31-3.2.noarch]
[deps: perl-Digest-Nilsimsa 0.06-1.rhfc1.art.i386]
[deps: perl-Digest-HMAC 1.01-11.noarch]
[deps: razor-agents 2.61-2.rhfc1.art.i386]
[deps: perl-Time-HiRes 1.38-4.i386]

and all was installed, but after running yum upgrade again, it finds nothing to upgrade.

I ran yum install again and received the same message:

Resolving dependencies
.conflict between mysql-compat and MySQL-shared-compat
Package MySQL-Max needs MySQL >= 4.0, this is not available.

Plesk still shows mysql not installed in the component info.

Don't know why, but I tried up2date and received

up2date mysql

Testing package set / solving RPM inter-dependencies...
There was a package dependency problem. The message was:

Unresolvable chain of dependencies:
MySQL-Max-4.0.18-art.4 requires MySQL >= 4.0

What do I have to do to upgrade mySQL?

[scott]

Just remove the MySQL rpms with rpm -e then

[phatPhrog]

Guess I screwed things up. Now spamassasin won't start.

unable to make action: unable to manage service by spamd: empty error message from utility.

[phatPhrog]

Just remove the MySQL rpms with rpm -e then

This is fun

rpm -e mysql
error: package mysql is not installed

error: package /var/cache/yum/atomic-psa/packages/MySQL-client-4.0.18-art.4.i386.rpm is not installed
error: package /var/cache/yum/atomic-psa/packages/MySQL-Max-4.0.18-art.4.i386.rpm is not installed
error: package /var/cache/yum/atomic-psa/packages/MySQL-server-4.0.18-art.4.i386.rpm is not installed
error: package /var/cache/yum/atomic-psa/packages/MySQL-shared-compat-4.0.18-art.4.i386.rpm is not installed

[phatPhrog]

Do the problems with mySQL-MAX, Plesk and my attempts to upgrade mySQL have anything to do with the rpms installed with YUM?

If nothing else, I'd like to be able to get Plesk to recognize that mySQL 4.0 > is indeed installed.

Everything relating to mySQL can't be upgraded or removed. When attempting to install, I get messages that the packages are installed. When attempting to upgrade, I get messages that 4.0>= is needed/isn't available and when attempting to remove them, messages are displayed the packages are "not" installed.

The server has and continues to work since running the YUM install for mySQL-MAX without problems, which confuses me even more.

Does anyone have any idea what is going on?

[scott]

If you need a hand with this just let me know, my company handles supporting problems like this. That being said, youve got to remove MySQL-Max and any MySQL rpms. Remember unix is case sensitive, MySQL is not the same as mysql

[phatPhrog]

So exactly what are the benefits of using YUM and up2date if the installs/upgrades aren't reflected in Plesk and upgrading isn't possible without first removing stuff.

Will have to talk with my partner about getting help.

I'm sure he's gonna say it would have been nice to know this before using the server to upgrade stuff, . . . but will do my best.

Thanks a bunch Scott. You're the greatest!

[scott]

well the mysql rpm does Obsolete (RPM speak for removes the obsoleted rpm before installing the new one) MySQL-*. Yum should remove it when my newer style mysql rpms were installed (assuming yum was used to install them). Thats something I tested quite a bit when I rolled out the new format. Other things that could be screwing up the mix, the rpm database is corrupted, or some other 3rd party rpms are invloved that have conflicting dependencies, epochs (a way of overriding versions), or names.