Bug #14141 Can not install MySQL 5 on Fedora Core 4 - Dependency
Submitted: 19 Oct 2005 14:21 Modified: 4 Jan 2006 19:04
Reporter: Fred Nelson Email Updates:
Status: Not a Bug Impact on me:
None 
Category:Connectors: DBD::mysql ( Perl ) Severity:S2 (Serious)
Version:5.0.13 + 5.0.18 OS:Linux (Fedora Core 4)
Assigned to: CPU Architecture:Any

[19 Oct 2005 14:21] Fred Nelson
Description:
I have been trying to get MySQL 5 installed on Fedora Core 4.

There is a dependency issue that makes this impossible.

If I attempt to install server, client, and shared by RPM:

# rpm -i MySQL-server-5.0.13-0.glibc23.i386.rpm \
            MySQL-client-5.0.13-0.glibc23.i386.rpm \
            MySQL-shared-5.0.13-0.glibc23.i386.rpm

I receive the message:

libmysqlclient.so.14 is needed by perl-DBD-MySQL-2.9007-1.i386

If I install this package with the package manager it also installs MySQL 4 which then prohibits the installation of MySQL 5.  (If I delete MySQL 4 it also deletes perl-DBD-MySQL)

-------------------------------------------------------

I also tired to "force" the installation and it didn't work:

# rpm -i --nodeps perl-DBD-MySQL-2.9007-1.i386.rpm

After that I could install MySQL5 however it would not start.

How to repeat:
1) Load Fedora Core 4 - Do not install MySQL (it would install V4)

2) rpm -i perl-DBI-1.48-4.rpm - (this will work fine)

3) rpm -i perl-DBD-MySQL-2.9007-1.i386.rpm

this will generate the error message shown above.

Suggested fix:
Provide and document a work around so that MySQL 5 can be installed on Fedora Core 4.
[19 Oct 2005 20:24] Alexander Keremidarski
Thank you for taking the time to write to us, but this is not
a bug. Please double-check the documentation available at
http://www.mysql.com/documentation/ and the instructions on
how to report a bug at http://bugs.mysql.com/how-to-report.php

Additional info:

Install MySQL-shared-compat RPM instead of MySQL-shared

http://dev.mysql.com/get/Downloads/MySQL-5.0/MySQL-shared-compat-5.0.13-0.i386.rpm/from/pi...
[19 Oct 2005 21:27] Fred Nelson
I built a new machine and installed the "compatible" RPM that you mentioned.  This resolve the dependency issue with perl.

The MySql server will not start!

Perhaps I'm taking the steps out of sequence - perhaps there is something I should have instalelled first?  I just don't know!

I have spent an entire week working on trying to get MySql 5 to run on Fedora Core 4.  There was no place on your site that mentioned the alternate RPM file.

Do you have ANY documentation on how to install on Fedora Core 4?

I have a version of it running on Windows and it's GREAT - I hope that it is possible to run it on Linux!

Thanks,

Fred
[3 Jan 2006 19:09] Keith Bennett
This is a problem for me too. More than 2 months after the original report, I see no solution to this problem.  I am trying to introduce MySQL to my organization, and the failure to resolve this problem is unhelpful, to say the least.

I have not found any help that works on the Internet, nor on the MySQL web site.  (I too was surprised that the library mentioned in the previous "answer" was nowhere to be found on your web site.)

I have heard a lot of good things about MySQL, and look forward to use it.  Please give Fedora Core 4 users the information we need to install it.

- Keith Bennett
[3 Jan 2006 19:25] Keith Bennett
In case this helps, I was amazed to find that the file it was looking for actually existed on my system!:

[kbennett@linus]/usr/lib/mysql% ls -ld libmysqlclient.*
-rw-r--r--  1 root root 1337024 Dec 17 03:42 libmysqlclient.a
lrwxrwxrwx  1 root root      24 Jan  3 13:43 libmysqlclient.so -> libmysqlclient.so.14.0.0
lrwxrwxrwx  1 root root      24 Aug 22 14:05 libmysqlclient.so.10 -> libmysqlclient.so.10.0.0
-rwxr-xr-x  1 root root  225312 Apr  8  2005 libmysqlclient.so.10.0.0
lrwxrwxrwx  1 root root      24 Jan  3 13:43 libmysqlclient.so.14 -> libmysqlclient.so.14.0.0
-rwxr-xr-x  1 root root 1174740 Dec 17 03:42 libmysqlclient.so.14.0.0

Perhaps someone who knows more than I do about Linux system administration can figure out a way to get this to work.  By the way, my system currently contains MySQL 4.  Am I correct in attempting to execute "rpm -Uvh *.rpm" for:

MySQL-bench-5.0.18-0.glibc23.i386.rpm
MySQL-client-5.0.18-0.glibc23.i386.rpm
MySQL-devel-5.0.18-0.glibc23.i386.rpm
MySQL-server-5.0.18-0.glibc23.i386.rpm
MySQL-shared-5.0.18-0.glibc23.i386.rpm

?  Thanks.

- Keith Bennett
[3 Jan 2006 20:13] Fred Nelson
This original question was about  V 5.0.13.  There are still no instructions on how to install the latest version 5.0.18 on Fedora 4 either.  I have posted a message asking for instructions in the installation forum and NEVER received a response.

I don't know what to do - if I stick with Fedora then I guess I will have to wait until Fedora 5 comes out and perhaps it will include MySQL 5 also as part of the distribution.  My present Fedora 4 installation won't upgrade from MySQL V4 using the update utilities.

I simply can't believe that it is not possible to load MySql on Fedora 4 however I have yet to see any evidence to the contrary.

If you find any instructions then please pass them on to me - I can't believe that they don't publish them or provide Fedora specific files for installation.

For now I am developing a system in the lab using Windows that works just fine.  Since there is a separate installation just for Sun Solaris 10 I am going to build a Sun machine and see if the installation works on that platform.

Like you I am trying to sell management on using this DB over MS-SQL - If they had any idea......
[3 Jan 2006 23:57] Sergey Zhukov
I had exactly the same problem, here's what I have done and it worked for me:
- Uninstall completely mysql in your Fedora Core 4
- Download Linux (non RPM package) Linux (x86) Standard - http://dev.mysql.com/downloads/mysql/5.0.html
- Follow instructions step by step from here - http://dev.mysql.com/doc/refman/5.0/en/installing-binary.html
- In your /etc/my.cnf set this:
====================================
  [client]
port            = 3306
socket          = /usr/local/mysql/mysql.sock
# The MySQL server
[mysqld]
port            = 3306
socket          = /usr/local/mysql/mysql.sock
===================================
- Do this just in case - "chown -R mysql.mysql /usr/share/mysql" (Folder where you installed mysql)

At this time you should be able to start your server by running "./bin/mysqld_safe --user=mysql" (cd to you mysql folder first)

Good luck,
Sergey.
[4 Jan 2006 17:19] Chip McVey
I will try to install like that on a test machine.  Thanks for the comment.  I wouldn't put too much time into it if it doesn't work though, since Fedora 5 is due out in March and I imagine it will come with MySQL 5 standard from the start.

Has anyone tried to build MySQL 5 from source on Fedora 4?
[4 Jan 2006 18:03] Fred Nelson
Follow up FYI:

I built 5.0.13 from source and couldn't get around the dependency issues.  I have not tried a source build with 5.0.18.

Thanks,

Fred
[4 Jan 2006 19:04] Fred Nelson
Thanks to Alexander, Keith, "Name Withheld" and Chip for all your comments recently to my original October post regarding installing MySQL 5 on Fedora 4.

I'm sure that Chip is correct that MySQL V5 will be part of Fedora 5.  Since it will be released in the March timeframe I am going to "give up" on my almost four month effort of getting V5 to run on Fedora 4.

I am working on a project using MySQL on a Windows server and this is working just fine for development.  There are four months to go so I can afford to wait.

When Fedora 5 (with MySQL 5) is released, I will evaluate the package and see if it is actually possible to install the software without all these problems.  If not then we will use Sun Solaris - or if that doesn't work - then Microsoft.

Documentation seems to be a BIG problem in general.  For example, in October I created bug report #14033 which showed a documentation error in the .NET connector.  This was confirmed to be a bug however I just checked and the documentation still has not been updated many months later.  This means that new folks who are trying to get the interface working may waste hours as I did - perhaps they may give up!

Anyhow:

Thanks and good luck to all who helped
[15 Jan 2006 3:04] Gabriel Hoffman
I am new to mysql, but I was able to install mysql 5.0.18 in Fedora Core 4.  Just follow the simple directions at http://wiki.astbill.com/wiki/Upgrade_Fedora_Core_4_with_Mysql_4.14_to_MySQL_5.0.15

Be sure to read the begining of the directions very carefully so that you close the current mysql program before insalling the new version.   Gook luck.
[15 Jan 2006 3:06] Gabriel Hoffman
Make sure you type in the entire link above, not just the highlighted part.  Or maybe it will work this time:
http://wiki.astbill.com/wiki/Upgrade_Fedora_Core_4_with_Mysql_4.14_to_MySQL_5.0.15
[16 Jan 2006 3:29] kj csb
Here's what worked for me:
yum remove mysql
(this also removed MySQL-python, dovecot, mysql-devel, mysql-server, perl-DBD-MySQL)

cd /tmp
wget http://mysql.planetmirror.com/Downloads/MySQL-5.0/MySQL-server-5.0.18-0.glibc23.i386.rpm
wget http://mysql.planetmirror.com/Downloads/MySQL-5.0/MySQL-client-5.0.18-0.glibc23.i386.rpm
wget http://mysql.planetmirror.com/Downloads/MySQL-5.0/MySQL-devel-5.0.18-0.glibc23.i386.rpm
wget http://mysql.planetmirror.com/Downloads/MySQL-5.0/MySQL-shared-5.0.18-0.glibc23.i386.rpm
wget http://mysql.planetmirror.com/Downloads/MySQL-5.0/MySQL-shared-compat-5.0.18-0.i386.rpm

rpm -U MySQL-server-5.0.18-0.glibc23.i386.rpm MySQL-client-5.0.18-0.glibc23.i386.rpm MySQL-devel-5.0.18-0.glibc23.i386.rpm MySQL-shared-5.0.18-0.glibc23.i386.rpm MySQL-shared-compat-5.0.18-0.i386.rpm

wget ftp://fr.rpmfind.net/linux/fedora/core/4/i386/os/Fedora/RPMS/perl-DBD-MySQL-2.9007-1.i386....
rpm -U perl-DBD-MySQL-2.9007-1.i386.rpm

yum install dovecot

Hope that helps
[29 Jan 2006 12:13] mark william
Hi [name withheld],

I don't quite understand the following line/s:

rpm -U MySQL-server-5.0.18-0.glibc23.i386.rpm
MySQL-client-5.0.18-0.glibc23.i386.rpm MySQL-devel-5.0.18-0.glibc23.i386.rpm
MySQL-shared-5.0.18-0.glibc23.i386.rpm MySQL-shared-compat-5.0.18-0.i386.rpm

Are these 3 lines just a one line command that just wrapped?
[17 Feb 2006 13:06] Michael Kofler
The problems reported here might have to do with SELinux, which is used by default on Fedora Core 4. 

I installed MySQL 5.0.18 (glibc-2.3-RPM packages). 

/etc/init.d/mysql start reported a failure.

I then started system-config-securitylevel, got into the SELinux tab and activated the option:

SELinux Service Protection|Disable SELinux protection for mysqld daemon. 

MySQL 5.0.18 now seems to work all right.
[25 Mar 2006 23:58] Conrad Schilbe
After installing the 5.x rpms you may have to run mysql_install_db and mysql_fix_privilege_tables as I did.
[13 Jul 2006 5:31] JR Herr
The comment on 16 Jan 4:29 worked great.  All I had to do was change the version numbers and viola!  It is up and running perfectly.
[25 Feb 2007 21:06] Cory Nemelka
Here's what worked for me.

I changed distros from Fedora to Ubuntu.