The MySQL library cannot be found

Issues related to software problems.
Post Reply
dthimm
Posts: 5
Joined: 2007/10/25 13:12:18
Location: Germany

The MySQL library cannot be found

Post by dthimm » 2007/11/01 18:12:55

Hi there,

i try to compile on my brand new CentOs 5 (i386) Box.

After many problems i can handel, there is one i cant!

I try to find information in the forum and over google, but all i can find is for Centos 4.XX

Can you help me?

This is what the Configure Script says:

.....
------- MySQL Logging Is Enabled ------
checking mysql/mysql.h usability... no
checking mysql/mysql.h presence... no
checking for mysql/mysql.h... no
checking for main in -lmysqlclient... no
configure: error: The MySQL library cannot be found.
........

Greetings Dieter

pjwelsh
Posts: 2589
Joined: 2007/01/07 02:18:02
Location: Central IL USA

The MySQL library cannot be found

Post by pjwelsh » 2007/11/01 18:43:19

~]# yum provides mysql/mysql.h

mysql-devel.i386 4.1.20-2.RHEL4.1.0.1 update
Matched from:
/usr/include/mysql/mysql.h


run "yum install mysql-devel" or choose 64bit is you need.

dthimm
Posts: 5
Joined: 2007/10/25 13:12:18
Location: Germany

Re: The MySQL library cannot be found

Post by dthimm » 2007/11/01 19:22:08

Hi pjwelsh,
thank you for your help.
I try to run "yum install mysql-devel"

Installing:
mysql-devel i386 5.0.22-2.1.0.1 updates 2.4 M
Installing for dependencies:
e2fsprogs-devel i386 1.39-8.el5 base 560 k
krb5-devel i386 1.5-29 updates 1.7 M
openssl-devel i386 0.9.8b-8.3.el5_0.2 updates 1.8 M
zlib-devel i386 1.2.3-3 base 101 k

Transaction Summary
=============================================================================
Install 5 Package(s)
Update 0 Package(s)
Remove 0 Package(s)

... and:
------- MySQL Logging Is Enabled ------
checking mysql/mysql.h usability... yes
checking mysql/mysql.h presence... yes
checking for mysql/mysql.h... yes
checking for main in -lmysqlclient... no
configure: error: The MySQL library cannot be found.

but the mysqlclient in Centos5 seems to be a problem!

How can i use a 64bit program on a i386 Iron?

Any other idea?

Dieter

pjwelsh
Posts: 2589
Joined: 2007/01/07 02:18:02
Location: Central IL USA

Re: The MySQL library cannot be found

Post by pjwelsh » 2007/11/01 19:46:14

The "yum provides" was an effort to help you with this ;)

"yum provides mysqlclient"
...
mysql.i386 4.1.20-2.RHEL4.1.0.1 update
Matched from:
/usr/lib/mysql/libmysqlclient_r.so.14
/usr/lib/mysql/libmysqlclient.so.14.0.0
/usr/lib/mysql/libmysqlclient.so.14
/usr/lib/mysql/libmysqlclient_r.so.14.0.0
libmysqlclient.so.14(libmysqlclient_14)
libmysqlclient_r.so.14(libmysqlclient_14)
libmysqlclient.so.14
libmysqlclient_r.so.14

Is ONE of the listed items (there are older version, also), but:
"yum install mysql"
will get you into the next step.

No, you can not run 64bit on 32bit OS...

dthimm
Posts: 5
Joined: 2007/10/25 13:12:18
Location: Germany

Re: The MySQL library cannot be found

Post by dthimm » 2007/11/01 20:35:58

i am sorry, but there is no difference.
after the steps you give me, there is always the same error.

yum provides mysqlclient

Loading "installonlyn" plugin
Setting up repositories
Reading repository metadata in from local files
Importing additional filelist information

mysql.i386 5.0.22-2.1 base
Matched from:
/usr/lib/mysql/libmysqlclient_r.so.15
/usr/lib/mysql/libmysqlclient.so.15.0.0
/usr/lib/mysql/libmysqlclient.so.15
/usr/lib/mysql/libmysqlclient_r.so.15.0.0
libmysqlclient_r.so.15(libmysqlclient_15)
libmysqlclient.so.15(libmysqlclient_15)
libmysqlclient.so.15
libmysqlclient_r.so.15

mysql-devel.i386 5.0.22-2.1 base
Matched from:
/usr/lib/mysql/libmysqlclient_r.a
/usr/lib/mysql/libmysqlclient.so
/usr/lib/mysql/libmysqlclient_r.so
/usr/lib/mysql/libmysqlclient.a

mysql.i386 5.0.22-2.1 base
Matched from:
/usr/lib/mysql/libmysqlclient_r.so.15
/usr/lib/mysql/libmysqlclient.so.15.0.0
/usr/lib/mysql/libmysqlclient.so.15
/usr/lib/mysql/libmysqlclient_r.so.15.0.0
libmysqlclient_r.so.15(libmysqlclient_15)
libmysqlclient.so.15(libmysqlclient_15)
libmysqlclient.so.15
libmysqlclient_r.so.15

mysql.i386 5.0.22-2.1.0.1 updates
Matched from:
/usr/lib/mysql/libmysqlclient_r.so.15
/usr/lib/mysql/libmysqlclient.so.15.0.0
/usr/lib/mysql/libmysqlclient.so.15
/usr/lib/mysql/libmysqlclient_r.so.15.0.0
libmysqlclient.so.15(libmysqlclient_15)
libmysqlclient.so.15
libmysqlclient_r.so.15(libmysqlclient_15)
libmysqlclient_r.so.15

mysql.i386 5.0.22-2.1.0.1 updates
Matched from:
/usr/lib/mysql/libmysqlclient_r.so.15
/usr/lib/mysql/libmysqlclient.so.15.0.0
/usr/lib/mysql/libmysqlclient.so.15
/usr/lib/mysql/libmysqlclient_r.so.15.0.0
libmysqlclient.so.15(libmysqlclient_15)
libmysqlclient.so.15
libmysqlclient_r.so.15(libmysqlclient_15)
libmysqlclient_r.so.15

mysql-devel.i386 5.0.22-2.1.0.1 updates
Matched from:
/usr/lib/mysql/libmysqlclient_r.a
/usr/lib/mysql/libmysqlclient.so
/usr/lib/mysql/libmysqlclient_r.so
/usr/lib/mysql/libmysqlclient.a

mysql.i386 5.0.22-2.1.0.1 installed
Matched from:
/usr/lib/mysql/libmysqlclient.so.15
/usr/lib/mysql/libmysqlclient.so.15.0.0
/usr/lib/mysql/libmysqlclient_r.so.15
/usr/lib/mysql/libmysqlclient_r.so.15.0.0
libmysqlclient.so.15
libmysqlclient.so.15(libmysqlclient_15)
libmysqlclient_r.so.15
libmysqlclient_r.so.15(libmysqlclient_15)

mysql-devel.i386 5.0.22-2.1.0.1 installed
Matched from:
/usr/lib/mysql/libmysqlclient.a
/usr/lib/mysql/libmysqlclient.so
/usr/lib/mysql/libmysqlclient_r.a
/usr/lib/mysql/libmysqlclient_r.so
[root@localhost ]# ldconfig
[root@localhost ]# ldconfig -v
/usr/lib/mysql:
libmysqlclient_r.so.15 -> libmysqlclient_r.so.15.0.0
libmysqlclient.so.15 -> libmysqlclient.so.15.0.0


And so on.....
So i think the libs are there.
I have made as root an ldconfig.
no effect.

Do you have another idea?

Dieter

pjwelsh
Posts: 2589
Joined: 2007/01/07 02:18:02
Location: Central IL USA

Re: The MySQL library cannot be found

Post by pjwelsh » 2007/11/02 03:34:42

Sorry dude, I got fixated on the CentOS 4.4 comment in the beginning. I'm not a compile guy, but I would bet the thing (unknown at this point) you are trying to compile is not liking the mysql 5 and the newer /usr/lib/mysql/libmysqlclient.so.15. You may be able to "ln -s /usr/lib/mysql/libmysqlclient.so.15 /usr/lib/mysql/libmysqlclient.so". Maybe not...

Post Reply