[JDEV] Re: Problem with xdb_mysql : cannot load backend 'mysql'

[Benoit Decaudin]

This message has been sent to this list by mistake. Forget it.

Benoît

> Hello.
> 
> I have a problem when trying to start the server with a xdb_sql module.
> The server returns that error :
> 
> 20020625T16:35:45: [alert] (-internal): [xdbsql_config_init] cannot load
> backend 'mysql'
> 
> I just don't know why. I did not found much information about the </backend>
> tag in the xdb_sql.xml configuration file. I have added the following lines
> to my jabber.xml file (I've replaced my.hostname.com, of course) :
> 
> <xdb id="xdb_sql">
> <host>my.hostname.com</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>/etc/jabber/xdb_sql.xml</jabberd:include>
> </xdb>
> 
> <xdb id="xdb_file">
> <host>jud.localhost</host>
> <host>msn.localhost</host>
> <host>icq.localhost</host>
> <host>aim.localhost</host>
> <host>irc.localhost</host>
> <host>yahoo.localhost</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_file>./xdb_file/xdb_file.so</xdb_file>
> </load>
> <!-- there is no line break below... -->
> <xdb_file xmlns="jabber:config:xdb_file">
> <spool><jabberd:cmdline
> flag='s'>/var/lib/jabber</jabberd:cmdline></spool>
> </xdb_file>
> </xdb>
> 
> 
> And here is the beginning of the xdb_sql.xml file :
> 
> <xdb_sql xmlns="jabberd:xdb_sql:config">
> 
> <backend>mysql</backend>
> 
> <connection>
> <host>localhost</host>
> <db>jabber</db>
> <user>daemon</user>
> <pass></pass>
> </connection>
> 
> [etc...]
> 
> 
> I've tested different settings for </host>, </user> and </password> (real
> hostname, localhost, root user with root password, root user w/o password,
> etc) but I still have the same error message.
> 
> My jabber database has a daemon at localhost user with no password.
> 
> Any help will be really appreciated !
> Thanks.
> 
> 
> Benoît