Hi,

I have RHES3 and Plesk 7.0.1 control panel on my server.

Last night I ran up2date to bring the server up to date.

I then downloaded the MySQL 4.0.20 rpm and the MySQL 4.0.20-shared-compat to install them.

I installed the shared-compat rpm first then the MySQL server

with

rpm -Uvh blahblahblah.rpm

However after intallation I issued the mysql command and got a 'command not found' or something like that.

I rebooted the server, but still no joy.

Tried uninstalling the 4.0.20 package

rpm -e blahblahblah.rpm

but it came back with package not installed.

So tried re-installing it again

rpm -Uvh blahblahblah.rpm

but it came back saying it was already installed.

HELP!!!

:confused:

what rpm's did you install ??

these are the art packages that i use on my server they are only version 4.0.18 at the moment.

MySQL-Max-4.0.18-art.4.i386.rpm
MySQL-bench-4.0.18-art.4.i386.rpm
MySQL-client-4.0.18-art.4.i386.rpm <= needed
MySQL-devel-4.0.18-art.4.i386.rpm
MySQL-embedded-4.0.18-art.4.i386.rpm
MySQL-server-4.0.18-art.4.i386.rpm <= needed
MySQL-shared-4.0.18-art.4.i386.rpm <= needed
MySQL-shared-compat-4.0.18-art.4.i386.rpm <= needed


i think they are the basic 4 that you need whether you install from art or from mysql

Hi,

I just installed the following from mysql.com

MySQL-4.0/MySQL-server-4.0.20-0.i386.rpm
MySQL-4.0/MySQL-shared-compat-4.0.18-0.i386.rpm

so I guess I should try installing

MySQL-4.0/MySQL-shared-4.0.20-0.i386.rpm
MySQL-4.0/MySQL-client-4.0.20-0.i386.rpm

but doesn't explain why rpm -e reports that the package is not installed but it is.

try rpm -e MySQL-server

to check what the package is called run this

rpm -qa |grep -i mysql

this will give you the package name you need to uninstall

Thanks zacpac, I'll try that out tonight.

Mike

Also remember the Mysql.com RPM's don't just 'drop in' on a Plesk installation, because of some SSL-thingie they changed.

The ART RPM's are modified, and do drop in to a Plesk system without breaking things.

in the faq section of there website they state that plesk works with mysql 4 from version 7.0.1,

i have had a couple of problems with the mysql.com rpms giving me boot up errors so i have stuck with the art packages that just drop in perfectly

Hi,

Just tried to wget the ART rpms, unfortunately I think ART blocks all EV1 servers (don't know what all this is about).

Is there anywhere else they can be found?

(On dialup so don't want to download 9Mb rpm to then upload to my server)

Okay just installed all the 4.0.20 rpms from the mysql site. MySQL once again working.

From reading the AtomicRocketTurtle site it seems the problem with Plesk is the use of the word ssl as a column name, this has been added as a reserved word in MySQL.

Did a search on the plesk application files and it appears in about 5 files (select ssl from .....) so I am going to amend those files and put in back ticks ` around ssl (select `ssl` from ...) which will allow the queries to run properly.

Is this the only problem I should be aware of, or are there any other lurking?

i'm unsure as i dont run the mysql.com rpm's currently with the art ones i had to symlink mysql to mysqld in /etc/rc.d/init.d/ and switch the query cache on