[JDEV] Jabber INST + xdb_sql (mysql) cannot load backend 'mysql'

[Daniel Diehl]

Hey ...

I´ve got a big prob an configure xdb_sql (1.2) in
my freeBSD Jabber Server 1.4.1

After 100 hours attemp to compile xdb_sql (Playing
much in Makefile) the Makefile seem to run..

It produce during make the output:
---------------------------------------------------------
make clean
rm -f 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 xdb_sql.so
rm -rf xdb_sql.1.0
bash-2.05$ make
gcc -I. -I../jabberd  -I/usr/local/include/mysql -g -Wall -I. -I.. -I/usr/ho
me/phaze/pth/include -fPIC -c xdb_sql.c
gcc -I. -I../jabberd  -I/usr/local/include/mysql -g -Wall -I. -I.. -I/usr/ho
me/phaze/pth/include -fPIC -c xdb_sql_auth0k.c
xdb_sql_auth0k.c: In function `xdbsql_auth0k_get':
xdb_sql_auth0k.c:70: warning: unused variable `rowcount'
gcc -I. -I../jabberd  -I/usr/local/include/mysql -g -Wall -I. -I.. -I/usr/ho
me/phaze/pth/include -fPIC -c xdb_sql_auth.c
xdb_sql_auth.c: In function `xdbsql_auth_get':
xdb_sql_auth.c:30: warning: unused variable `rowcount'
xdb_sql_auth.c: In function `xdbsql_user_exists':
xdb_sql_auth.c:233: warning: unused variable `rowcount'
gcc -I. -I../jabberd  -I/usr/local/include/mysql -g -Wall -I. -I.. -I/usr/ho
me/phaze/pth/include -fPIC -c xdb_sql_offline.c
gcc -I. -I../jabberd  -I/usr/local/include/mysql -g -Wall -I. -I.. -I/usr/ho
me/phaze/pth/include -fPIC -c xdb_sql_register.c
gcc -I. -I../jabberd  -I/usr/local/include/mysql -g -Wall -I. -I.. -I/usr/ho
me/phaze/pth/include -fPIC -c xdb_sql_config.c
gcc -I. -I../jabberd  -I/usr/local/include/mysql -g -Wall -I. -I.. -I/usr/ho
me/phaze/pth/include -fPIC -c xdb_sql_querydef.c
gcc -I. -I../jabberd  -I/usr/local/include/mysql -g -Wall -I. -I.. -I/usr/ho
me/phaze/pth/include -fPIC -c xdb_sql_roster.c
xdb_sql_roster.c: In function `xdbsql_roster_set':
xdb_sql_roster.c:435: warning: suggest explicit braces to avoid ambiguous
`else'
gcc -I. -I../jabberd  -I/usr/local/include/mysql -g -Wall -I. -I.. -I/usr/ho
me/phaze/pth/include -fPIC -c xdb_sql_last.c
gcc -I. -I../jabberd  -I/usr/local/include/mysql -g -Wall -I. -I.. -I/usr/ho
me/phaze/pth/include -fPIC -c xdb_sql_backend.c
gcc -I. -I../jabberd  -I/usr/local/include/mysql -g -Wall -I. -I.. -I/usr/ho
me/phaze/pth/include -fPIC -c xdb_sql_vcard.c
gcc -I. -I../jabberd  -I/usr/local/include/mysql -g -Wall -I. -I.. -I/usr/ho
me/phaze/pth/include -fPIC -c xdb_sql_filter.c
gcc -I. -I../jabberd  -I/usr/local/include/mysql -g -Wall -I. -I.. -I/usr/ho
me/phaze/pth/include -fPIC -c xdb_sql_generic.c
gcc -I. -I../jabberd  -I/usr/local/include/mysql -g -Wall -I. -I.. -I/usr/ho
me/phaze/pth/include -fPIC -c xdb_sql_mysql.c
gcc -I. -I../jabberd  -I/usr/local/include/mysql -g -Wall -I. -I.. -I/usr/ho
me/phaze/pth/include -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

db_sql_mysql.o -L/usr/home/phaze/pth/lib -L/usr/local/lib/mysql/ -static  -L
/usr/local/mysql/lib/mysql  -lmysqlclient
----------------------------------------------------------

Then I include the xdb Config in jabber.xml

----------------------------------------------------------
<xdb id="xdb_sql">
  <host/>
    <ns>jabber:iq:roster</ns>
    <ns>jabber:x:offline</ns>
    <ns>jabber:iq:filter</ns>
    <ns>jabber:iq:last</ns>
    <ns>jabber:iq:auth</ns>
    <ns>jabber:iq:auth:0k</ns>
    <ns>jabber:iq:register</ns>
    <ns>vcard-temp</ns>
    <load>
      <xdb_sql>./xdb_sql/xdb_sql.so</xdb_sql>
    </load>
    <jabberd:include>./xdb_sql/xdb_sql.xml</jabberd:include>
</xdb>
----------------------------------------------------------


On Starting jabberd I get the output:


[alert] (-internal): [xdbsql_config_init] cannot load backend 'mysql'


So .. no .. I´ve no idea more .... Can somebody give me a tip ???
Thanks A LOT !!!!!!!!!!!!!


bye,
Daniel

+++ -------------------------------------------- +++
+++ Daniel Diehl - daniel at pixel-city.net         +++
+++ Check out the upcoming PIXEL-CITY.NET !!!    +++
+++ -------------------------------------------- +++
    I´ve you don't start doing it, you will never
    get your dreams realized.