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

[Benoit Decaudin]

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