[JDEV] Jabber Server can not load mysql as the Backend Database

[Mansur Ali]

Dear All,
 
I´ve got a big prob an configure xdb_sql (1.2) in my Jabber Server 1.4.2.
I am having Redhat 7.2.
 
My Jabber Server is working fine but the connection to mysql database is
fail.  I have compiled the xdb_sql-1.2 and made the sample sql databse in
mysql. And set the user and password for the database as follows:-
 
user: jabber
password:password
domain:your.servername.com
permission:all
 
Edit the jabber.xml as follows after the starting <xdb id='xdb'>tag :-
 
<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.xo</xdb_sql>
</load>
<jabberd:include>./xdb_sql/xdb_sql.xml</jabberd:include>
 
Now modify the xdb_sql.xml 
 
        <xdb_sql xmlns="jabberd:xdb_sql:config">
        <!--Backend to use-->
        <backend>mysql</backend>
 
        <!--Configure information about the SQL connection-->
        <connection>
        <host>your.servername.com</host>
        <db>jabber</db>
        <user>jabber</user>
        <pass>password</pass>
        </connection>
 
On Starting jabberd I get the output:

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

Can anybody help me on this ?
 
Regards,
 
Mansur 

    
 


 

===================================================== 
DISCLAIMER: Information contained in this mail are the sole responsibilty of
the sender. The information contained in this mail is private & confidential
and is intended solely to the person or organisation to whom it is
addressed. If this message is not intended for you, then you are requested
to destroy this message immediately & kindly notify the sender by return
mail. The sender is in no way responsible for any virus that might be
transmitted through this message. It is recommended to check attachments,if
any, received with this message for virus before opening them. Opinions,
conclusions and other information in this message that do not relate to the
official business of I.T.Integrated Solutions Ltd. shall be understood as
neither given nor endorsed by it.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://www.jabber.org/jdev/attachments/20020409/7f3e9d93/attachment-0002.htm>