conflict between mysql and psa

[mauro.i]

I'm attempting a fresh install of PSA version 6 on RH9 using yum. I get the conflict between mysql and psa error with or without installing mysql first. I've successfully installed PSA 6 by first updating the version of MySQL to 4.1.x (yum update mysql) but then I run into the incompatibility with Plesk 6 problem. I don't require version 4.1.x of MySQL as version 4.0 is fine. Below is output from rpm -qa, yum install psa and my yum.conf

Is there a way to install Plesk 6 on RH9 using yum and the archive? If not, which packages are needed to satisfy all the MySQL 4.0.25 dependencies? Thank you so much in advance.

---
[root@rh9 root]# rpm -aq |grep mysql
mysql-3.23.54a-11
mysql-server-3.23.54a-11

---
[root@rh9 root]# yum install psa
Gathering header information file(s) from server(s)
Server: Atomic Rocket Turtle - 9 - Atomic PSA-Compatible RPMS
Server: Red Hat Linux 9 base
Server: Fedora Legacy utilities for Red Hat Linux 9
Server: Atomic Rocket Turtle - 9 - SW-Soft PSA 6.0 RPMS
Server: Red Hat Linux 9 updates
Finding updated packages
Downloading needed headers
Resolving dependencies
...conflict between mysql and psa

---
/etc/yum.conf
[main]
cachedir=/var/cache/yum
debuglevel=2
logfile=/var/log/yum.log
pkgpolicy=newest
distroverpkg=redhat-release
tolerant=1
exactarch=1

[base]
name=Red Hat Linux $releasever base
baseurl=http://download.fedoralegacy.org/redhat ... /$basearch

[updates]
name=Red Hat Linux $releasever updates
baseurl=http://download.fedoralegacy.org/redhat ... /$basearch

[legacy-utils]
name=Fedora Legacy utilities for Red Hat Linux $releasever
baseurl=http://download.fedoralegacy.org/redhat ... /$basearch

[atomic]
name=Atomic Rocket Turtle - $releasever - Atomic PSA-Compatible RPMS
baseurl=http://3es.atomicrocketturtle.com/atomi ... eleasever/

[psa-6.0]
name=Atomic Rocket Turtle - $releasever - SW-Soft PSA 6.0 RPMS
baseurl=http://3es.atomicrocketturtle.com/atomi ... eleasever/

[scott]

Yep, its supposed to do that. You can only use mysql 4.1 on psa 7.5.4 and above.

[mauro.i]

Is there a way to prevent it from trying to update MySQL when installing PSA? I guess I don't follow why I would be required to change my MySQL version if I already have 3.x installed to begin with.

[scott]

Yep, just exclude= it. "man yum" for the docs

[mauro.i]

Thanks Scott. I was spoiled by being able to install psa 6.0 with one command. I'll just do it the old fashioned way by installing via RPM. Your archives (http://3es.atomicrocketturtle.com/atomi ... .0/9/RPMS/) make that process rather painless anyway.

If someone has a more elegant solution on how to get 'yum install psa' to work with RH9 and PSA 6.0, I'm all ears (eyes).

[breun]

I'm wondering why you're installing a RH9 with PSA6... RH9 will be EOL in a couple of months and PSA6 isn't exactly the latest version either. But well, I guess there can be reasons you'd want to install a system like that. Just wondering.

[mauro.i]

Just due to the fact that I have a system that has that configuration and in case I need to rebuild it quickly, due to any reason (say catastrophic failure), I would like to be in a position to have that choice. I have a backup of the content and an image of the server, but it's good to know I can rebuild it quickly even if it's just to do some testing on a system very similar in configuration to the production server.

[breun]

Well, that's indeed a reason. Still I'd be looking at migration paths right now. RH9 is in the process of being the EOLed by the Fedora Legacy project (see https://www.redhat.com/archives/fedora- ... 00012.html).

[mauro.i]

Oh I so agree with you. Unfortunately the owner of the server has delayed upgrading for a couple of years now. But, I'm in the process now of developing a migration path to at least the next version of PSA (7.x). Did I mention the many 'tweaks' that the owner had me put on the server and it's hosting several other domains? I've been playing with this most of the day and all I'm missing is getting mbstring support for PHP since it does not come compiled with the old red hat RPM's used to install PHP. I'd be pulling hair if I had any left. Maybe my next post will be asking for ideas for this migration.

[scott]

If this is a situation where you're at your hosters mercy on the OS they install, check out the AOOI Project page. That will let you put CentOS4 on the box without needing the install media, or console access.

[mauro.i]

Just in case someone is wondering how to actually do this, I’ve composed a quick and dirty howto which utilizes VMWare (now free) for virtualizing the installation and your favourite method of installing RedHat 9. Installing VMWare is not difficult but I’ll leave that up to you.

1.
Install VMWare

New Virtual Machine

• - next
  - Typical
  - Linux
  - Version Red Hat Linux
  - Name: Plesk 6 or whatever you like
  - Use Bridged Networking
  - Allocate 6 - 8 Gigs now
  - Finish

Now we will need to install the Operating System. I recommend using the boot.iso file for Red Hat 9.

• - Click on VM
  - Choose Settings
  - Select CD ROM
  - Use ISO image
  - Browse to boot.iso for Red Hat 9
  - Start this virtual machine

2.
Installing OS
We will use a very basic installation and meet the PSA requirements (rpm files) later.

Uncheck all boxes and proceed (size of install around 474 MB)

Complete RH 9 installation and confirm outside access to download other files.

Download and install libxml2-2.5.4-1.i386.rpm
Download and install libxml2-python-2.5.4-1.i386.rpm

• [root@rh9 root]# rpm -Uvh libxml2-2.5.4-1.i386.rpm
  [root@rh9 root]# rpm -Uvh libxml2-python-2.5.4-1.i386.rpm

Get yum and install it

• wget http://3es.atomicrocketturtle.com/packa ... noarch.rpm
  
  [root@rh9 root]# rpm -Uvh yum-2.0.7-1.rh90.art.noarch.rpm

Use yum.conf but comment out the atomic archives for now. For example:

[main]
cachedir=/var/cache/yum
debuglevel=2
logfile=/var/log/yum.log
pkgpolicy=newest
distroverpkg=redhat-release
tolerant=1
exactarch=1
exclude=*mysql* *php*

[base]
name=Red Hat Linux $releasever base
baseurl=http://download.fedoralegacy.org/redhat ... /$basearch

[updates]
name=Red Hat Linux $releasever updates
baseurl=http://download.fedoralegacy.org/redhat ... /$basearch

[legacy-utils]
name=Fedora Legacy utilities for Red Hat Linux $releasever
baseurl=http://download.fedoralegacy.org/redhat ... /$basearch

#[atomic]
#name=Atomic Rocket Turtle - $releasever - Atomic PSA-Compatible RPMS
#baseurl=http://3es.atomicrocketturtle.com/atomi ... eleasever/

#[psa-6.0]
#name=Atomic Rocket Turtle - $releasever - SW-Soft PSA 6.0 RPMS
#baseurl=http://3es.atomicrocketturtle.com/atomi ... eleasever/

Update System

• - yum -y update

3.
Get the PSA 6 files from http://3es.atomicrocketturtle.com/atomi ... .0/9/RPMS/

**I did not require the tomcat RPM files

To meet the dependencies for PSA, install the packages below.

• [root@rh9 atomic]# yum install fam bind httpd mod_perl mod_python mod_ssl mysql mysql-server ntp php php-imap php-mysql sharutils webalizer courier-imap

Install all the PSA files that you downloaded previously.

• rpm -Uvh psa*

You will now see the following, confirming a successful installation:

Congratulations!

• -- snip --
  -- snip --

8:psa-qmail-rblsmtpd ########################################### [100%]
===> Reading /etc/psa/psa.conf ...

Uncomment the atomic lines in /etc/yum.conf (remove the #). Be sure the exclude=*mysql* *php* line is in the configuration file. Upgrading mysql and php is to be avoided with RH9 and Plesk 6

Update System

• - yum -y update

Now you should have a RH9 OS running Plesk 6 installation.