Barnyard-0.2 with mysql - configure fails - Please help!

Dear Sir/Madam,

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?

1. barnyard used: barnyard-0.2.0.tar.gz 
2. my system: uname -a: Linux mysystem 2.6.8-24.11-smp
#1 SMP Fri Jan 14 13:01:26 UTC 2005 x86_64 x86_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:39libmysqlclient_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

---

Do you Yahoo!?
 
Yahoo! Mail - You care about security. So do we.