Find the answer to your Linux question:
Results 1 to 4 of 4
Hi, I'm new to linux and this forum, and I have an issue with mysql For this sa-mp server i am trying to get running on my centos server, I ...
Enjoy an ad free experience by logging in. Not a member yet? Register.
  1. #1
    Just Joined!
    Join Date
    Oct 2012
    Posts
    2

    Downgrading mysql


    Hi, I'm new to linux and this forum,
    and I have an issue with mysql

    For this sa-mp server i am trying to get running on my centos server, I need mysql, I installed the following packages:

    yum list installed *mysql*

    Installed Packages
    MySQL-python.i686
    mysql.i686
    mysql-libs.i686
    mysql-server.i686
    perl-DBD-MySQL.i686
    php-mysql.i686


    But my server gave errors like:
    Missing libmysqlclient_r.so.15

    I looked around and found libmysqlclient.so.16 and libmysqlclient_r.so.16 at /usr/lib/mysql
    I made a link from /usr/lib/libmysqlclient_r.so.15 to /usr/lib/mysql/libmysqlclient_r.so.16 and from /usr/lib/libmysqlclient.so.15 to /usr/lib/mysql/libmysqlclient.so.16

    Now though, I get errors like this:
    /usr/lib/libmysqlclient_r.so.15: version `libmysqlclient_15' not found

    When I remove the two links, it give the error "Missing libmysqlclient_r.so.15"

    I think I need to downgrade my mysql to 5.1.5, but I don't know how...
    I tried yum downgrade mysql, but that didn't work...

    Does anyone know how to solve my issue?

  2. #2
    Trusted Penguin
    Join Date
    May 2011
    Posts
    4,353
    Hello and welcome!

    If I were you, I'd rip out all the mysql packages and start over.

    First try to remove packages with yum:
    Code:
    yum erase MySQL-python.i686 mysql.i686 mysql-libs.i686 mysql-server.i686 perl-DBD-MySQL.i686 php-mysql.i686
    if that doesn't work, force the removal with rpm, e.g.:
    Code:
    rpm -e --nodeps MySQL-python.i686 mysql.i686 mysql-libs.i686 mysql-server.i686 perl-DBD-MySQL.i686 php-mysql.i686
    once that is done, look for remaining lib files:
    Code:
    find /usr/lib* -type f -name '*mysql*' -exec ls -l {} \;
    any of those files you can probably safely just remove, but you can post the list here first if you want.

    Edit: How did you install mysql in the first place? It is odd that you are having this conflict. Do you have any non-standard repos installed?
    Last edited by atreyu; 10-30-2012 at 03:08 AM. Reason: non-standard install?

  3. #3
    Just Joined!
    Join Date
    Oct 2012
    Posts
    2
    Thank you for your reply!

    I did install mysql with yum install mysql.

    I've found how to sole my issue already, I've installed an older (5.1.5) version of mysql-client with rpm, and that worked.

    Thqnk you anyways

  4. #4
    Trusted Penguin
    Join Date
    May 2011
    Posts
    4,353
    Quote Originally Posted by ikkentim View Post
    I've found how to sole my issue already, I've installed an older (5.1.5) version of mysql-client with rpm, and that worked.
    Excellent. Going forward, be sure to always use yum to install packages, versus downloading and installing packages with the rpm command (you have experienced why!).

    Will mark this thread as solved for you.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •