make = undefined reference to `mysql_connect'

[SM777]

I'm trying to compile dbf2mysql 1.14 and I'm getting:

server:/temp/dbf2mysql # make

gcc -O2 -Wall -s -L. -L/usr/lib/mysql -o dbf2mysql dbf2mysql.o -ldbf -lmysqlclient -lm

dbf2mysql.o(.text+0x1046): In function `do_inserts':
: the use of `tempnam' is dangerous, better use `mkstemp'

dbf2mysql.o(.text+0x14cd): In function `main':
: undefined reference to `mysql_connect'
/usr/lib/mysql/libmysqlclient.a(my_compress.o)(.text+0xbc):
In function `my_compress_alloc':
: undefined reference to `compress'
/usr/lib/mysql/libmysqlclient.a(my_compress.o)(.text+0x13a): In function `my_uncompress':
: undefined reference to `uncompress'
collect2: ld returned 1 exit status
make: *** [dbf2mysql] Error 1

---

I have had dbf2mysql working on a debian system using apt and that works fine. But now I'm using SuSE and it just won't compile.

There is an RPM for version 1.10 but that has some features missing which I require in 1.14.

Any ideas?

 

[SM777]

I solved this by removing MySQL 4 and installing version 3.23. This created the correct libraries which are required for dbfmysql.

Once compiled, I could then remove 3.23 and install 4 again. But also need to install mysql-shared-compat-4.x as this includes libmysqlclient10 files which are required at runtime for dbfmysql.