Dear Sir/Madam,
It is a repost: as my earlier post doesn't seem to be readable.
I am trying to compile barnyard-0.20 with mysql support on X86_64 Dell PowerEdge 2850 with SuSE 9.2. and failing to link libmysqlclient in the ./configure script. I have spent a lot of time trying different things and following suggestions in the mailing lists, but No success as of now. Can you please help to solve my problem? Does anyone of you have success in using barnyard for X84_64 platforms?
1. barnyard used: barnyard-0.2.0.tar.gz
2. my system: uname -a: Linux mysystem 2.6.8-.11-smp#1 SMP Fri Jan 14 13:01:26 UTC 2005 x86_64 86_64 x86_64 GNU/Linux
3. I have following mysql rpms installed:
mysql-client-4.0.21-4.2.i586.rpm
mysql-shared-4.0.21-4.2.i586.rpm
mysql-devel-4.0.21-4.2.i586.rpm
4. I have zlib and openssl rpms installed:
zlib-1.2.1-74
openssl-0.9.7d-25
5. ls -al /usr/lib/mysql
mysystem:/usr/local/barnyard-0.2.0 # ls -al
/usr/lib/mysql/
total 1629
drwxr-xr-x 2 root root 728 Feb 28 11:46 .
drwxr-xr-x 29 root root 8448 Feb 28 11:46 ..
-rw-r--r-- 1 root root 12646 Oct 28 15:39 libdbug.a
-rw-r--r-- 1 root root 41120 Oct 28 15:39 libheap.a
-rw-r--r-- 1 root root 17282 Oct 28 15:39 libmerge.a
-rw-r--r-- 1 root root 314380 Oct 28 15:39 libmyisam.a
-rw-r--r-- 1 root root 30508 Oct 28 15:39 libmyisammrg.a
-rw-r--r-- 1 root root 342374 Oct 28 15:39 libmysqlclient.a
-rw-r--r-- 1 root root 866 Oct 28 15:06 libmysqlclient.la
lrwxrwxrwx 1 root root 27 Feb 28 11:46 libmysqlclient.so -> ../libmysqlclient.so.12.0.0
lrwxrwxrwx 1 root root 27 Feb 28 11:46 libmysqlclient.so.12 -> ../libmysqlclient.so.12.0.0
lrwxrwxrwx 1 root root 27 Feb 28 11:46 libmysqlclient.so.12.0.0 -> ../libmysqlclient.so.12.0.0
-rw-r--r-- 1 root root 350494 Oct 28 15:39 libmysqlclient_r.a
-rw-r--r-- 1 root root 900 Oct 28 15:05 libmysqlclient_r.la
lrwxrwxrwx 1 root root 29 Feb 28 11:46 libmysqlclient_r.so -> ../libmysqlclient_r.so.12.0.0
lrwxrwxrwx 1 root root 29 Feb 28 11:46 libmysqlclient_r.so.12 ->
../libmysqlclient_r.so.12.0.0
lrwxrwxrwx 1 root root 29 Feb 28 11:46 libmysqlclient_r.so.12.0.0 ->
../libmysqlclient_r.so.12.0.0
-rw-r--r-- 1 root root 118120 Oct 28 15:39 libmystrings.a
-rw-r--r-- 1 root root 270912 Oct 28 15:39 libmysys.a
-rw-r--r-- 1 root root 121722 Oct 28 15:39 libnisam.a
-rw-r--r-- 1 root root 6814 Oct 28 15:39 libvio.a
6. Configure script error:
mysystem:/usr/local/barnyard-0.2.0 #./configure --enable-mysql
loading cache ./config.cache
checking for a BSD compatible install...
/usr/bin/install -c
checking whether build environment is sane... yes
checking whether make sets ${MAKE}... yes
checking for working aclocal-1.4... missing
checking for working autoconf... found
checking for working automake-1.4... missing
checking for working autoheader... found
checking for working makeinfo... missing
checking for gcc... gcc
checking whether the C compiler (gcc ) works... yes
checking whether the C compiler (gcc ) is a
cross-compiler... no
checking whether we are using GNU C... yes
checking whether gcc accepts -g... yes
checking for gcc option to accept ANSI C... none
needed
checking for ranlib... ranlib
checking for gcc... (cached) gcc
checking whether the C compiler (gcc -g -O2 ) works...
yes
checking whether the C compiler (gcc -g -O2 ) is a
cross-compiler... no
checking whether we are using GNU C... (cached) yes
checking whether gcc accepts -g... (cached) yes
checking host system type... x86_64-unknown-linux-gnu
checking whether byte ordering is bigendian... no
checking how to run the C preprocessor... gcc -E
checking for strings.h... yes
checking for string.h... yes
checking for stdlib.h... yes
checking for unistd.h... yes
checking for sys/sockio.h... no
checking for paths.h... yes
checking for socket in -lsocket... no
checking whether printf must be declared... no
checking whether fprintf must be declared... no
checking whether syslog must be declared... no
checking whether puts must be declared... no
checking whether fputs must be declared... no
checking whether fputc must be declared... no
checking whether fopen must be declared... no
checking whether fclose must be declared... no
checking whether fwrite must be declared... no
checking whether fflush must be declared... no
checking whether getopt must be declared... no
checking whether bzero must be declared... no
checking whether bcopy must be declared... no
checking whether memset must be declared... no
checking whether strtol must be declared... no
checking whether strcasecmp must be declared... no
checking whether strncasecmp must be declared... no
checking whether strerror must be declared... no
checking whether perror must be declared... no
checking whether socket must be declared... no
checking whether sendto must be declared... no
checking whether vsnprintf must be declared... no
checking whether snprintf must be declared... no
checking whether strtoul must be declared... no
checking for snprintf... yes
checking for strlcpy... no
checking for strlcat... no
checking for strerror... yes
checking for /usr/include/mysql/mysql.h... yes
checking for mysql_real_connect in -lmysqlclient... no
**********************************************
ERROR: unable to find mysqlclient library
checked in the following places
/usr/lib/mysql
**********************************************
7. my /etc/ld.so.conf file has /usr/lib/mysql and i
have done ldconfig.
#vi /etc/ld.so.conf
/usr/X11R6/lib64/Xaw95
/usr/X11R6/lib64/Xaw3d
/usr/X11R6/lib64
/usr/X11R6/lib/Xaw95
/usr/X11R6/lib/Xaw3d
/usr/X11R6/lib
/usr/x86_64-suse-linux/lib64
/usr/x86_64-suse-linux/lib
/usr/local/lib
/usr/openwin/lib
/opt/kde/lib
/opt/kde2/lib
/opt/kde3/lib
/opt/gnome/lib
/opt/gnome2/lib
/lib64
/lib
/usr/lib64
/usr/lib
/usr/local/lib64
/usr/openwin/lib64
/opt/kde/lib64
/opt/kde2/lib64
/opt/kde3/lib64
/opt/gnome/lib64
/opt/gnome2/lib64
/usr/lib/mysql
/usr/lib64/mysql
8. I have also tried to remove -lz and -lssl in the
configure script as suggested in other posts but there
is no difference.
Can someone please help me? If you would like to
know anymore details, please let me know.
Many Thanks in Advance,
sisa