mysql5 anyone ??

[irzyxel]

Top five features in Plesk 8.1 for Linux/Unix:

# MySQL 5 Support - The Linux version of the software now supports MySQL 5 which delivers advanced SQL standard-compliant features.

but when trying to install it, i get a depencency problem with the mysql 4.1 rpm

so is this all just a marketing joke or what is the trick ?

 

[atomicturtle]

its in centos4's centosplus channel, and fc5 by default. Barring that Ive got rpms in my archive for other distros.

 

[irzyxel]

i saw it in centosplus, they have that evil dependencies circle php5 > mysql5 > postgres8 tho.

but their mysql5 has collisions:

Transaction Check Error: file /etc/my.cnf from install of mysql-5.0.27-1.el4.centos conflicts with file from package mysql-4.1.20-1.RHEL4.1
file /usr/bin/mysql_tableinfo from install of mysql-5.0.27-1.el4.centos conflicts with file from package mysql-4.1.20-1.RHEL4.1
file /usr/share/info/mysql.info.gz from install of mysql-5.0.27-1.el4.centos conflicts with file from package mysql-4.1.20-1.RHEL4.1
file /usr/share/man/man1/mysql.1.gz from install of mysql-5.0.27-1.el4.centos conflicts with file from package mysql-4.1.20-1.RHEL4.1
file /usr/share/man/man1/mysqlaccess.1.gz from install of mysql-5.0.27-1.el4.centos conflicts with file from package mysql-4.1.20-1.RHEL4.1
file /usr/share/man/man1/mysqladmin.1.gz from install of mysql-5.0.27-1.el4.centos conflicts with file from package mysql-4.1.20-1.RHEL4.1
file /usr/share/man/man1/mysqldump.1.gz from install of mysql-5.0.27-1.el4.centos conflicts with file from package mysql-4.1.20-1.RHEL4.1
file /usr/share/man/man1/mysqlshow.1.gz from install of mysql-5.0.27-1.el4.centos conflicts with file from package mysql-4.1.20-1.RHEL4.1
file /usr/share/mysql/charsets/Index.xml from install of mysql-5.0.27-1.el4.centos conflicts with file from package mysql-4.1.20-1.RHEL4.1
file /usr/share/mysql/czech/errmsg.sys from install of mysql-5.0.27-1.el4.centos conflicts with file from package mysql-4.1.20-1.RHEL4.1
file /usr/share/mysql/danish/errmsg.sys from install of mysql-5.0.27-1.el4.centos conflicts with file from package mysql-4.1.20-1.RHEL4.1
file /usr/share/mysql/dutch/errmsg.sys from install of mysql-5.0.27-1.el4.centos conflicts with file from package mysql-4.1.20-1.RHEL4.1
file /usr/share/mysql/english/errmsg.sys from install of mysql-5.0.27-1.el4.centos conflicts with file from package mysql-4.1.20-1.RHEL4.1
file /usr/share/mysql/estonian/errmsg.sys from install of mysql-5.0.27-1.el4.centos conflicts with file from package mysql-4.1.20-1.RHEL4.1
file /usr/share/mysql/french/errmsg.sys from install of mysql-5.0.27-1.el4.centos conflicts with file from package mysql-4.1.20-1.RHEL4.1
file /usr/share/mysql/german/errmsg.sys from install of mysql-5.0.27-1.el4.centos conflicts with file from package mysql-4.1.20-1.RHEL4.1
file /usr/share/mysql/greek/errmsg.sys from install of mysql-5.0.27-1.el4.centos conflicts with file from package mysql-4.1.20-1.RHEL4.1
file /usr/share/mysql/hungarian/errmsg.sys from install of mysql-5.0.27-1.el4.centos conflicts with file from package mysql-4.1.20-1.RHEL4.1
file /usr/share/mysql/italian/errmsg.sys from install of mysql-5.0.27-1.el4.centos conflicts with file from package mysql-4.1.20-1.RHEL4.1
file /usr/share/mysql/japanese/errmsg.sys from install of mysql-5.0.27-1.el4.centos conflicts with file from package mysql-4.1.20-1.RHEL4.1
file /usr/share/mysql/korean/errmsg.sys from install of mysql-5.0.27-1.el4.centos conflicts with file from package mysql-4.1.20-1.RHEL4.1
file /usr/share/mysql/norwegian-ny/errmsg.sys from install of mysql-5.0.27-1.el4.centos conflicts with file from package mysql-4.1.20-1.RHEL4.1
file /usr/share/mysql/norwegian/errmsg.sys from install of mysql-5.0.27-1.el4.centos conflicts with file from package mysql-4.1.20-1.RHEL4.1
file /usr/share/mysql/polish/errmsg.sys from install of mysql-5.0.27-1.el4.centos conflicts with file from package mysql-4.1.20-1.RHEL4.1
file /usr/share/mysql/portuguese/errmsg.sys from install of mysql-5.0.27-1.el4.centos conflicts with file from package mysql-4.1.20-1.RHEL4.1
file /usr/share/mysql/romanian/errmsg.sys from install of mysql-5.0.27-1.el4.centos conflicts with file from package mysql-4.1.20-1.RHEL4.1
file /usr/share/mysql/russian/errmsg.sys from install of mysql-5.0.27-1.el4.centos conflicts with file from package mysql-4.1.20-1.RHEL4.1
file /usr/share/mysql/serbian/errmsg.sys from install of mysql-5.0.27-1.el4.centos conflicts with file from package mysql-4.1.20-1.RHEL4.1
file /usr/share/mysql/slovak/errmsg.sys from install of mysql-5.0.27-1.el4.centos conflicts with file from package mysql-4.1.20-1.RHEL4.1
file /usr/share/mysql/spanish/errmsg.sys from install of mysql-5.0.27-1.el4.centos conflicts with file from package mysql-4.1.20-1.RHEL4.1
file /usr/share/mysql/swedish/errmsg.sys from install of mysql-5.0.27-1.el4.centos conflicts with file from package mysql-4.1.20-1.RHEL4.1
file /usr/share/mysql/ukrainian/errmsg.sys from install of mysql-5.0.27-1.el4.centos conflicts with file from package mysql-4.1.20-1.RHEL4.1

which then again scared me cause:

[root@server2 ~]# rpm -e --allmatches mysql-4.1.20-1.RHEL4.1
error: Failed dependencies:
libmysqlclient.so.14()(64bit) is needed by (installed) mysql-server-4.1.20-1.RHEL4.1.x86_64
libmysqlclient.so.14()(64bit) is needed by (installed) psa-ruby-mysql-2.7-200610081358.x86_64
libmysqlclient.so.14()(64bit) is needed by (installed) php51-mysql-5.1.4-20060823.rhas4_x86_64.x86_64
libmysqlclient.so.14()(64bit) is needed by (installed) php51-mysqli-5.1.4-20060823.rhas4_x86_64.x86_64
libmysqlclient.so.14()(64bit) is needed by (installed) php51-pdo_mysql-5.1.4-20060823.rhas4_x86_64.x86_64
libmysqlclient.so.14()(64bit) is needed by (installed) php-mysql-5.1.6-1.2.1.centos.x86_64
libmysqlclient.so.14(libmysqlclient_14)(64bit) is needed by (installed) mysql-server-4.1.20-1.RHEL4.1.x86_64
libmysqlclient.so.14(libmysqlclient_14)(64bit) is needed by (installed) psa-ruby-mysql-2.7-200610081358.x86_64
libmysqlclient.so.14(libmysqlclient_14)(64bit) is needed by (installed) php-mysql-5.1.6-1.2.1.centos.x86_64
libmysqlclient_r.so.14()(64bit) is needed by (installed) mysql-server-4.1.20-1.RHEL4.1.x86_64
libmysqlclient_r.so.14(libmysqlclient_14)(64bit) is needed by (installed) mysql-server-4.1.20-1.RHEL4.1.x86_64
mysql = 4.1.20-1.RHEL4.1 is needed by (installed) mysql-server-4.1.20-1.RHEL4.1.x86_64
mysql = 4.1.20-1.RHEL4.1 is needed by (installed) mysql-devel-4.1.20-1.RHEL4.1.x86_64
mysql = 4.1.20-1.RHEL4.1 is needed by (installed) mysql-bench-4.1.20-1.RHEL4.1.x86_64
mysql >= 4 is needed by (installed) xrms-1.19-80017.noarch

 

[atomicturtle]

Thats why you use yum!

 

[irzyxel]

the transaction error on top comes from yum ...

i just ran the rpm trying to resolve it and find out whats related

 

[atomicturtle]

Are you sure you're pulling from the right channel then? I only see that when i386 and x86_64 packages get all mixed together.

 

[irzyxel]

yup, 64 bit os and channel ...

yum update php

=============================================================================
Package Arch Version Repository Size
=============================================================================
Updating:
php x86_64 5.1.6-3.el4s1.5 centosplus 1.2 M
Installing for dependencies:
mysqlclient14 x86_64 4.1.22-1.el4s1.1 centosplus 1.2 M
php-cli x86_64 5.1.6-3.el4s1.5 centosplus 2.3 M
php-common x86_64 5.1.6-3.el4s1.5 centosplus 135 k
Updating for dependencies:
mysql x86_64 5.0.27-1.el4.centos centosplus 3.3 M
mysql-server x86_64 5.0.27-1.el4.centos centosplus 10 M
php-devel x86_64 5.1.6-3.el4s1.5 centosplus 489 k
php-gd x86_64 5.1.6-3.el4s1.5 centosplus 108 k
php-imap x86_64 5.1.6-3.el4s1.5 centosplus 50 k
php-ldap x86_64 5.1.6-3.el4s1.5 centosplus 33 k
php-mbstring x86_64 5.1.6-3.el4s1.5 centosplus 990 k
php-mysql x86_64 5.1.6-3.el4s1.5 centosplus 85 k
php-ncurses x86_64 5.1.6-3.el4s1.5 centosplus 39 k
php-odbc x86_64 5.1.6-3.el4s1.5 centosplus 50 k
php-pdo x86_64 5.1.6-3.el4s1.5 centosplus 228 k
php-pgsql x86_64 5.1.6-3.el4s1.5 centosplus 66 k
php-snmp x86_64 5.1.6-3.el4s1.5 centosplus 26 k
php-xmlrpc x86_64 5.1.6-3.el4s1.5 centosplus 52 k
postgresql x86_64 8.1.8-1.el4s1.1 centosplus 2.8 M
postgresql-libs x86_64 8.1.8-1.el4s1.1 centosplus 192 k
postgresql-server x86_64 8.1.8-1.el4s1.1 centosplus 4.0 M

Transaction Summary
=============================================================================
Install 3 Package(s)
Update 18 Package(s)
Remove 0 Package(s)
Total download size: 27 M
Is this ok [y/N]: y

--> mysql dep errors from above

 

[irzyxel]

ok, working quite good so far, removed mysql 4.1 with nodep, centosplus updates installed well. only problems seems to be:

Mar 2 00:35:01 crond[23966]: PAM adding faulty module: /lib64/security/pam_plesk.so
Mar 2 00:35:01 crond[23968]: PAM unable to dlopen(/lib64/security/pam_plesk.so)
Mar 2 00:35:01 crond[23968]: PAM [dlerror: libmysqlclient.so.14: cannot open shared object file: No such file or directory]

anyone know where libmysqlclient.so.14 should be ??
mines in /usr/lib64/mysql/libmysqlclient.so.14 after the update

 

[benji]

So, the only way to install MySQL 5, to make it work with Plesk 8.1.1 is using Yum?

I usually use up2date to install new packages and update rpm`s.


Also, after installing MySQL 5, will it be the only MySQL or will I have MySQL 4, and MySQL 5 running at same time, and plesk will handle which one to use for each domain?

... Thanks!.

 

[irzyxel]

just for completion, i had to install lib cient 12 to make it work ...

im using yum cause there is a centosplus repository for for centos which contains php5 and mysql5

and that(yum/rpm) will replace mysql 4

 

[benji]

Originally posted by irzyxel
just for completion, i had to install lib cient 12 to make it work ...

im using yum cause there is a centosplus repository for for centos which contains php5 and mysql5

and that(yum/rpm) will replace mysql 4

Thanks for the reply. And what can I do if I have RHEL 4 ?

 

[atomicturtle]

You can use the centos channels on rhel4. In fact thats frequently what people do when they dont have valid rhel subscriptions.

 

[benji]

Lol, I answered you on other post a minute ago.

Ok, but if packages are so similar, why dont you have a package for RHEL 4 on your RHEL 4 stable channel?

Thanks

 

[atomicturtle]

Because Im moving everything to a new server right now.

 

[benji]

Cool. Take it easy

I'm more or less at the same task, i'm getting ready my new server, and will be moving to it all the sites when its ready, i want it to be with latest technologies, since i wont reinstall SO at least in 2 years.

keep it going ART, thanks for your work.