[rhelv6-list] Installing MySQLdb for python2.7 in RHEL 6

[Brown, Hugh M]

-----Original Message-----
From: rhelv6-list-bounces at redhat.com [mailto:rhelv6-list-bounces at redhat.com] On Behalf Of Larry Martell
Sent: Tuesday, February 23, 2016 6:25 AM
To: Red Hat Enterprise Linux 6 (Santiago) discussion mailing-list <rhelv6-list at redhat.com>
Subject: Re: [rhelv6-list] Installing MySQLdb for python2.7 in RHEL 6

On Tue, Feb 23, 2016 at 3:48 AM, Gabriel S. Craciun
<gcraciun at transfond.ro> wrote:
> Do ypu have some custom repos enabled? ...like http://rpms.famillecollet.com/enterprise/6/remi/x86_64/ ? ..where from you installed  those.remi. packages?

This is a machine I just inherited and I really know nothing about it.
It was running a Semantic Media Wiki (which uses MySQL and PHP), and I
have broken that and now am frantically trying to fix it. I did this:

# yum shell --enablerepo=remi
> remove php-mysql
> install php-mysqlnd
> run

Followed by this:

yum install mysql-devel
/usr/local/bin/pip2.7 install MySQL-python

Now the MySQL server is down and will not come up. It fails with this:

Fatal error: mysql.user table is damaged. Please run mysql_upgrade

Looks like 5.7 is now installed whereas before it was running 5.5
(Server version: 5.5.44 MySQL Community Server (GPL) by Remi') It
fails on start up with Fatal error: mysql.user table is damaged.
Please run mysql_upgrade But how can I run mysql_upgrade if I can't
start the server?



I've got a stock RHEL6 system and mysql is at version 5.1 on that system. The mysql-community packages aren't from RedHat. It sounds like you have a variety of channels and custom repos enabled with a lot of conflicts. If you can, I'd reinstall the versions of mysql that were there, run a backup of the mysql db and the whole system. I'd then install the mysql-devel package from the same source as the remi packages you had before. This should allow your MySQL-python to be installed.

Once you are back up and running, I'd probably build a new system that's a little cleaner. It looks like you have multiple repos providing mysql and the current system is a bit of a mess.

Hugh