[JDEV] Jabber INST + xdb_sql (mysql) cannot load backend 'mysql'
Daniel Diehl
daniel at pixel-city.net
Sun Jan 27 04:43:23 CST 2002
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.
More information about the JDev
mailing list