[JDEV] xdb_sql - undefined symbol: mysql_init problem

[Vladimir Collak]

I am trying to get the xdb_sql working and having hard
time. The make compiled and links fine but when I
start jabberd, I get this message: 

/opt/jabber/install/jabber-1.4.2/jabberd/jabberd:
error while loading shared libraries: ./xdb_sql/xd
b_sql.so: undefined symbol: mysql_init


I tried different things such as using $(LIBS) -static
-lmysqlclient, but that didn't work either. Any ideas?

Thank you, 
Vladimir


***** make output *******

gcc -I. -I../jabberd -g -Wall -I. -I..
-I/opt/jabber/install/jabber-1.4.2/jabberd/pth-1.4.0
-fPIC  -
shared -o xdb_sql.so xdb_sql.o xdb_sql_auth0k.o
xdb_sql_auth.o xdb_sql_offline.o xdb_sql_register.o
xdb_sql_config.o xdb_sql_querydef.o xdb_sql_roster.o
xdb_sql_last.o xdb_sql_backend.o xdb_sql_vcard.
o xdb_sql_filter.o xdb_sql_generic.o xdb_sql_mysql.o  
-ldl -lresolv -static -L/usr/lib/mysql/libmys
qlclient.so


***** Makefile *****

include ../platform-settings

# Uncomment the flags that are needed for your DB
CFLAGS:= -I. -I../jabberd $(CFLAGS)

# Uncomment the flags that are needed for your DB
CPPFLAGS= -DMYSQL_BACKEND

# Uncomment the file that corresponds to your DB
xdb_sql_OBJECTS= \
        xdb_sql.o \
        xdb_sql_auth0k.o \
        xdb_sql_auth.o \
        xdb_sql_offline.o \
        xdb_sql_register.o \
        xdb_sql_config.o \
        xdb_sql_querydef.o \
        xdb_sql_roster.o \
        xdb_sql_last.o \
        xdb_sql_backend.o \
        xdb_sql_vcard.o \
        xdb_sql_filter.o \
        xdb_sql_generic.o \
        xdb_sql_mysql.o

all: xdb_sql.so

# Uncomment the lib that is used by your DB
xdb_sql.so: $(xdb_sql_OBJECTS)
        $(CC) $(CFLAGS) $(MCFLAGS) -o xdb_sql.so
$(xdb_sql_OBJECTS) $(LDFLAGS) $(LIBS) -static -L/us
r/lib/mysql/libmysqlclient.so


clean:
        rm -f $(xdb_sql_OBJECTS) xdb_sql.so
        rm -rf xdb_sql.1.0

dist: all
        mkdir xdb_sql.1.0
        cat FILES | cut -d":" -f 1 | xargs cp
--target-directory=xdb_sql.1.0/
        tar cvzf xdb_sql.1.0.tar.gz xdb_sql.1.0

__________________________________________________
Do you Yahoo!?
Yahoo! News - Today's headlines
http://news.yahoo.com