MySQL issues with Fedora 14

[Roebuc]

Hello,

I am having trouble with MySQL on a newly installed Fedora 14. I have found that there are several issues with MySQL on Fedora but none of the issues I have found have exactly fit my situation. To start off, when I installed Fedora, I chose the Web Server addition. I was under the impression that this would install Apache, MySQL, and PHP. Apache was fine, I was able to get that up and running no problem. PHP is supposedly installed my php files do not run. I have not started looking into that yet. For now, I am focusing on MySQL.

I get the following when trying to run mysql:

bash: mysql: command not found...

So I tried running yum -y install mysql. I get the following after that:

Loaded plugins: langpacks, presto, refresh-packagekit
Adding en_US to language list
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package mysql.x86_64 0:5.1.52-1.fc14 set to be installed
--> Processing Dependency: mysql-libs = 5.1.52-1.fc14 for package: mysql-5.1.52-1.fc14.x86_64
--> Running transaction check
---> Package mysql-libs.i686 0:5.1.52-1.fc14 set to be installed
--> Processing Dependency: libc.so.6(GLIBC_2.3.4) for package: mysql-libs-5.1.52-1.fc14.i686
--> Processing Dependency: libc.so.6(GLIBC_2.4) for package: mysql-libs-5.1.52-1.fc14.i686
--> Processing Dependency: libc.so.6(GLIBC_2.1) for package: mysql-libs-5.1.52-1.fc14.i686
--> Processing Dependency: libc.so.6(GLIBC_2.1.2) for package: mysql-libs-5.1.52-1.fc14.i686
--> Processing Dependency: libc.so.6(GLIBC_2.1.3) for package: mysql-libs-5.1.52-1.fc14.i686
--> Processing Dependency: libm.so.6 for package: mysql-libs-5.1.52-1.fc14.i686
--> Processing Dependency: libc.so.6(GLIBC_2.2) for package: mysql-libs-5.1.52-1.fc14.i686
--> Processing Dependency: libssl.so.10 for package: mysql-libs-5.1.52-1.fc14.i686
--> Processing Dependency: libpthread.so.0(GLIBC_2.2) for package: mysql-libs-5.1.52-1.fc14.i686
--> Processing Dependency: libz.so.1 for package: mysql-libs-5.1.52-1.fc14.i686
--> Processing Dependency: libc.so.6 for package: mysql-libs-5.1.52-1.fc14.i686
--> Processing Dependency: libcrypto.so.10 for package: mysql-libs-5.1.52-1.fc14.i686
--> Processing Dependency: libcrypt.so.1 for package: mysql-libs-5.1.52-1.fc14.i686
--> Processing Dependency: libnsl.so.1 for package: mysql-libs-5.1.52-1.fc14.i686
--> Processing Dependency: libc.so.6(GLIBC_2.0) for package: mysql-libs-5.1.52-1.fc14.i686
--> Processing Dependency: libpthread.so.0(GLIBC_2.0) for package: mysql-libs-5.1.52-1.fc14.i686
--> Processing Dependency: libpthread.so.0(GLIBC_2.1) for package: mysql-libs-5.1.52-1.fc14.i686
--> Processing Dependency: libpthread.so.0 for package: mysql-libs-5.1.52-1.fc14.i686
--> Processing Dependency: libpthread.so.0(GLIBC_2.3.2) for package: mysql-libs-5.1.52-1.fc14.i686
--> Running transaction check
---> Package glibc.i686 0:2.12.90-21 set to be installed
--> Processing Dependency: libfreebl3.so for package: glibc-2.12.90-21.i686
--> Processing Dependency: libfreebl3.so(NSSRAWHASH_3.12.3) for package: glibc-2.12.90-21.i686
---> Package openssl.i686 0:1.0.0c-1.fc14 set to be installed
--> Processing Dependency: libk5crypto.so.3(k5crypto_3_MIT) for package: openssl-1.0.0c-1.fc14.i686
--> Processing Dependency: libkrb5.so.3 for package: openssl-1.0.0c-1.fc14.i686
--> Processing Dependency: libgssapi_krb5.so.2 for package: openssl-1.0.0c-1.fc14.i686
--> Processing Dependency: libk5crypto.so.3 for package: openssl-1.0.0c-1.fc14.i686
--> Processing Dependency: libcom_err.so.2 for package: openssl-1.0.0c-1.fc14.i686
--> Processing Dependency: libkrb5.so.3(krb5_3_MIT) for package: openssl-1.0.0c-1.fc14.i686
---> Package zlib.i686 0:1.2.5-2.fc14 set to be installed
--> Running transaction check
---> Package krb5-libs.i686 0:1.8.2-7.fc14 set to be installed
--> Processing Dependency: libkeyutils.so.1(KEYUTILS_0.3) for package: krb5-libs-1.8.2-7.fc14.i686
--> Processing Dependency: libselinux.so.1 for package: krb5-libs-1.8.2-7.fc14.i686
--> Processing Dependency: libkeyutils.so.1 for package: krb5-libs-1.8.2-7.fc14.i686
---> Package libcom_err.i686 0:1.41.12-6.fc14 set to be installed
---> Package nss-softokn-freebl.i686 0:3.12.8-1.fc14 set to be installed
--> Running transaction check
---> Package keyutils-libs.i686 0:1.2-6.fc12 set to be installed
---> Package libselinux.i686 0:2.0.96-6.fc14.1 set to be installed
--> Finished Dependency Resolution

Dependencies Resolved

================================================================================================================================================================
 Package                                     Arch                            Version                                     Repository                        Size
================================================================================================================================================================
Installing:
 mysql                                       x86_64                          5.1.52-1.fc14                               updates                          889 k
Installing for dependencies:
 glibc                                       i686                            2.12.90-21                                  updates                          4.3 M
 keyutils-libs                               i686                            1.2-6.fc12                                  fedora                            18 k
 krb5-libs                                   i686                            1.8.2-7.fc14                                updates                          693 k
 libcom_err                                  i686                            1.41.12-6.fc14                              updates                           34 k
 libselinux                                  i686                            2.0.96-6.fc14.1                             updates                          107 k
 mysql-libs                                  i686                            5.1.52-1.fc14                               updates                          1.2 M
 nss-softokn-freebl                          i686                            3.12.8-1.fc14                               updates                          112 k
 openssl                                     i686                            1.0.0c-1.fc14                               updates                          1.4 M
 zlib                                        i686                            1.2.5-2.fc14                                fedora                            82 k

Transaction Summary
================================================================================================================================================================
Install      10 Package(s)

Total size: 8.8 M
Installed size: 26 M
Downloading Packages:
Running rpm_check_debug
Running Transaction Test


Transaction Check Error:
  package mysql-libs-5.1.52-2.fc14.x86_64 (which is newer than mysql-libs-5.1.52-1.fc14.i686) is already installed

Error Summary

service mysqld start results in:

mysqld: unrecognized service

chkconfig mysqld on

error reading information on service mysqld: Bad file descriptor

So I also tried, yum remove mysql which results in:

Loaded plugins: langpacks, presto, refresh-packagekit
Adding en_US to language list
Setting up Remove Process
No Match for argument: mysql
Package(s) mysql available, but not installed.
No Packages marked for removal

I am kind of stuck. I am not an expert at Linux systems but I did set up a LAMP server using Debian GNU and Ubuntu. This is the first time I chose webserver in the initial install though. When I trying doing this through Add/Remove programs through the GUI, it shows MySQL is not installed.

Any help would be appreciated.

Thanks!

[Moncky]

If you run:

-bash-3.00$ rpm -qa | grep mysql
mysql-server-4.1.22-2.el4_8.4
php-mysql-4.3.9-3.31
mysql-devel-4.1.22-2.el4_8.4
mysql-4.1.22-2.el4_8.4

you will see what packages with mysql in their name are installed.

What you are looking for is mysql-server, which is the package that contains the server.

The mysql package is for the mysql client.

If you have no mysql-server package then try:

yum install mysql-server

The reason you are getting the error when you try to install mysql is that the version of mysql-libs on your system is newer than that in the repository.

Have you added other repositories or maybe installed an rpm directly rather than using yum?

[Roebuc]

Thanks for the reply Moncky.

My server is off line right now but I will try that when I get home and update with the results.

The only things I have done around mysql are the commands listed above. I did try clearing the cache of yum update packages but that did not work. I am assuming nothing installed through yum since I received the newer version error.

The only thing I did different this time then with my other servers was choose the easy path of selecting web server in the initial install of the Fedora OS. I am sure this installed mysql or at least downloaded the packages. I just dont know how to complete the install without using yum install. I am guessing the resolution of this issue is basically the same steps I will need to take to complete the install of PHP.

Thanks again.

[Roebuc]

So when I do rpm -qa | grep mysql I get:

php-mysql-5.3.4-1.fc14.1.x86_64
mysql-libs-5.1.52-2.fc14.x86_64

I tried running yum -y mysql-server and got the same error I did with yum -y install mysql.

Any other thoughts?

[Moncky]

As I mentioned the version of mysql-libs is newer than that in the repo you are using.

I would install the library package and then install the server and client packages from there.

There is a yum command that I can't remember off the top of my head that checks to see what packages depend on others. I think its yum depends package.

Check to make sure your not going to break anything you have installed already first.

[Roebuc]

Ok...I was able to get it installed. I used your:

rpm -qa | grep mysql

I then did:

rpm -e mysql-libs-5.1.52-2.fc14.x86_64

This resulted in dependency errors. All of the dependencies were on php, which is not working either at this point, I worked my way down each dependency removing mysql and php. When I was done, I re-tired:

yum -y install mysql

And now it is installed. Interesting that yum install does not download the most up to date version of mysql and that the OS Installation of a Web Server downloads a different version.