failed dependency for libmysqlclient_r.so

[nemir nemiria]

*sigh*

I have done all that I know how....

I am using fedora core1,  I believe.  I have updated the MySQL version to 4.0.17-0.

I am trying this:

rpm -i MySQL-python2.1-0.9.2-1.i386.rpm
warning: MySQL-python2.1-0.9.2-1.i386.rpm: V3 DSA signature: NOKEY, key ID 930b8ab6
error: Failed dependencies:
        libmysqlclient_r.so.10 is needed by MySQL-python2.1-0.9.2-1

I have created symlinks to this file in /usr/lib and also in /usr/local/bin,  in the hopes that it would make a difference.   I even paid enough attention to detail to notice that the file in question was itself a symlink and created symlinks directly to the root file.  still the same error.

Unfortunately,  I notice my python version is 2.2.3.  So I try to install from the tarball....

I get the following errors:

python setup.py build
running build
running build_py
creating build
creating build/lib.linux-i686-2.2
copying CompatMysqldb.py -> build/lib.linux-i686-2.2
copying _mysql_exceptions.py -> build/lib.linux-i686-2.2
creating build/lib.linux-i686-2.2/MySQLdb
copying MySQLdb/__init__.py -> build/lib.linux-i686-2.2/MySQLdb
copying MySQLdb/converters.py -> build/lib.linux-i686-2.2/MySQLdb
copying MySQLdb/connections.py -> build/lib.linux-i686-2.2/MySQLdb
copying MySQLdb/cursors.py -> build/lib.linux-i686-2.2/MySQLdb
copying MySQLdb/sets.py -> build/lib.linux-i686-2.2/MySQLdb
copying MySQLdb/times.py -> build/lib.linux-i686-2.2/MySQLdb
creating build/lib.linux-i686-2.2/MySQLdb/constants
copying MySQLdb/constants/__init__.py -> build/lib.linux-i686-2.2/MySQLdb/constants
copying MySQLdb/constants/CR.py -> build/lib.linux-i686-2.2/MySQLdb/constants
copying MySQLdb/constants/FIELD_TYPE.py -> build/lib.linux-i686-2.2/MySQLdb/constants
copying MySQLdb/constants/ER.py -> build/lib.linux-i686-2.2/MySQLdb/constants
copying MySQLdb/constants/FLAG.py -> build/lib.linux-i686-2.2/MySQLdb/constants
copying MySQLdb/constants/REFRESH.py -> build/lib.linux-i686-2.2/MySQLdb/constants
copying MySQLdb/constants/CLIENT.py -> build/lib.linux-i686-2.2/MySQLdb/constants
running build_ext
building '_mysql' extension
creating build/temp.linux-i686-2.2
gcc -DNDEBUG -O2 -g -pipe -march=i386 -mcpu=i686 -D_GNU_SOURCE -fPIC -fPIC -I/usr/include/mysql -I/usr/local/include/mysql -I/usr/local/mysql/include/mysql -I/usr/include/python2.2 -c _mysql.c -o build/temp.linux-i686-2.2/_mysql.o
_mysql.c:41:19: mysql.h: No such file or directory
_mysql.c:42:26: mysqld_error.h: No such file or directory
_mysql.c:43:20: errmsg.h: No such file or directory
_mysql.c:73: error: syntax error before "MYSQL"
_mysql.c:73: warning: no semicolon at end of struct or union
_mysql.c:76: error: syntax error before '}' token
_mysql.c:76: warning: data definition has no type or storage class....

This is only the beginning,  it seems to find hundreds of syntax errors along the way.

I have no coder skill at all, and only a moderate level of admin skill.  The box itself I have built,  it is not yet in production and I can do *anything* to it.

I am hoping for suggestions....

[Anonymous]

Had the same problem... the include and library directories are not correct according to the install readme file in mysql binary distribution.  open setup.py in the tarball and make the following modifications...

include_dirs = [
    '/usr/include/mysql', '/usr/local/include/mysql',
    '/usr/local/mysql/include/mysql'
    ]
->
include_dirs = [
    '/usr/include/mysql', '/usr/local/include/mysql',
    '/usr/local/mysql/include/mysql','/usr/local/mysql/include'
    ]

library_dirs = [
    '/usr/lib/mysql', '/usr/local/lib/mysql',
    '/usr/local/mysql/lib/mysql'
    ]
->
library_dirs = [
    '/usr/lib/mysql', '/usr/local/lib/mysql',
    '/usr/local/mysql/lib/mysql','/usr/local/mysql/lib'
    ]