The MySQL library cannot be found

SimonT · 02-09-2007, 08:05 PM

I am running ./configure for a program that I am about to compile but it fails with
the following.

Code:

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.

I have MYSQL installed and use it all the time but yet when the check was made it say the client can not be found

type mysql at the command line works linux noob so please go slow :-)

Tinkster · 02-09-2007, 08:57 PM

What's your distro?

If you do an ldconfig -v and look for libmysql ... can you see
it - which directory is it in.

Cheers,
Tink

SimonT · 02-09-2007, 10:41 PM

Thank you for the fast reply here is the output of that command
libmysqlclient is in /usr/lib/mysql

Code:

[root@]# ldconfig -v
/usr/lib/mysql:
        libmysqlclient_r.so.14 -> libmysqlclient_r.so.14.0.0
        libmysqlclient.so.14 -> libmysqlclient.so.14.0.0

Quote:

CentOS release 4.4 (Final)
OS type: Linux i686
Kernel: 2.6.9-42.0.3.EL 05:59:54
Processor: 1 GenuineIntel 534MHz Celeron(Mendocino)
Memory: 254988 kB Swap: 779144 kB

Tinkster · 02-09-2007, 10:47 PM

The next question would be what version of mysql the program
you're trying to install requires.

Cheers,
Tink

SimonT · 02-09-2007, 10:54 PM

I dont know I looked on there website but found nothing the server is a trixbox server so dont want to hack up the MYSQL install too much

Code:

mysql -V
mysql  Ver 14.7 Distrib 4.1.20, for redhat-linux-gnu (i686) using readline 4.3

SimonT · 02-09-2007, 11:50 PM

Here is what is in the configure file for the mysql check

Code:

echo "$as_me:$LINENO: checking for main in -lmysqlclient" >&5
echo $ECHO_N "checking for main in -lmysqlclient... $ECHO_C" >&6
if test "${ac_cv_lib_mysqlclient_main+set}" = set; then
  echo $ECHO_N "(cached) $ECHO_C" >&6
else
  ac_check_lib_save_LIBS=$LIBS
LIBS="-lmysqlclient  $LIBS"
cat >conftest.$ac_ext <<_ACEOF
/* confdefs.h.  */
_ACEOF
cat confdefs.h >>conftest.$ac_ext
cat >>conftest.$ac_ext <<_ACEOF
/* end confdefs.h.  */

SimonT · 02-11-2007, 05:44 PM

Any one have any ideas >?