<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1"> <META content="MSHTML 5.50.4134.600" name=GENERATOR></HEAD> <BODY bgColor=#ffffff> <DIV><SPAN class=746184809-09042002><FONT face=Arial>Dear All,</FONT></SPAN></DIV> <DIV><SPAN class=746184809-09042002><FONT face=Arial></FONT></SPAN> </DIV> <DIV><SPAN class=746184809-09042002><FONT face=Arial>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.</FONT></SPAN></DIV> <DIV><SPAN class=746184809-09042002><FONT face=Arial></FONT></SPAN> </DIV> <DIV><SPAN class=746184809-09042002><FONT face=Arial>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:-</FONT></SPAN></DIV> <DIV><SPAN class=746184809-09042002><FONT face=Arial></FONT></SPAN> </DIV> <DIV><SPAN class=746184809-09042002><FONT face=Arial>user: jabber</FONT></SPAN></DIV> <DIV><SPAN class=746184809-09042002><FONT face=Arial>password:password</FONT></SPAN></DIV> <DIV><SPAN class=746184809-09042002><FONT face=Arial>domain:your.servername.com</FONT></SPAN></DIV> <DIV><SPAN class=746184809-09042002><FONT face=Arial>permission:all</FONT></SPAN></DIV> <DIV><SPAN class=746184809-09042002><FONT face=Arial></FONT></SPAN> </DIV> <DIV><SPAN class=746184809-09042002><FONT face=Arial>Edit the jabber.xml as follows after the starting <xdb id='xdb'>tag :-</FONT></SPAN></DIV> <DIV><SPAN class=746184809-09042002><FONT face=Arial></FONT></SPAN> </DIV> <DIV><SPAN class=746184809-09042002><FONT face=Arial><host/></FONT></SPAN></DIV> <DIV><SPAN class=746184809-09042002>    <FONT face=Arial><ns>jabber:iq:roster</ns></FONT></SPAN></DIV> <DIV><SPAN class=746184809-09042002>    <FONT face=Arial><ns>jabber:x:offline</ns></FONT></SPAN></DIV> <DIV><SPAN class=746184809-09042002>    <FONT face=Arial><ns>jabber:iq:filter</ns></FONT></SPAN></DIV> <DIV><SPAN class=746184809-09042002>    <FONT face=Arial><ns>jabber:iq:last</ns></FONT></SPAN></DIV> <DIV><SPAN class=746184809-09042002>    <FONT face=Arial><ns>jabber:iq:auth</ns></FONT></SPAN></DIV> <DIV><SPAN class=746184809-09042002>    <FONT face=Arial><ns>jabber:iq:auth:0k</ns></FONT></SPAN></DIV> <DIV><SPAN class=746184809-09042002>    <FONT face=Arial><ns>jabber:iq:register</ns></FONT></SPAN></DIV> <DIV><SPAN class=746184809-09042002>    <FONT face=Arial><ns>vcard-temp</ns></FONT></SPAN></DIV> <DIV><SPAN class=746184809-09042002><FONT face=Arial><load></FONT></SPAN></DIV> <DIV><SPAN class=746184809-09042002>    <FONT face=Arial><xdb_sql>./xdb_sql/xdb_sql.xo</xdb_sql></FONT></SPAN></DIV> <DIV><SPAN class=746184809-09042002><FONT face=Arial></load></FONT></SPAN></DIV> <DIV><SPAN class=746184809-09042002><FONT face=Arial><jabberd:include>./xdb_sql/xdb_sql.xml</jabberd:include></FONT></SPAN></DIV> <DIV><SPAN class=746184809-09042002><FONT face=Arial></FONT></SPAN> </DIV> <DIV><SPAN class=746184809-09042002><FONT face=Arial>Now modify the xdb_sql.xml </FONT></SPAN></DIV> <DIV><SPAN class=746184809-09042002><FONT face=Arial></FONT></SPAN> </DIV> <DIV><SPAN class=746184809-09042002><FONT face=Arial>        <xdb_sql xmlns="jabberd:xdb_sql:config"></FONT></SPAN></DIV> <DIV><SPAN class=746184809-09042002><FONT face=Arial>        </FONT></SPAN></DIV> <DIV><SPAN class=746184809-09042002>        <FONT face=Arial><backend>mysql</backend></FONT></SPAN></DIV> <DIV><SPAN class=746184809-09042002><FONT face=Arial></FONT></SPAN> </DIV> <DIV><SPAN class=746184809-09042002>        <FONT face=Arial></FONT></SPAN></DIV> <DIV><SPAN class=746184809-09042002>        <FONT face=Arial><connection></FONT></SPAN></DIV> <DIV><SPAN class=746184809-09042002>        <FONT face=Arial><host>your.servername.com</host></FONT></SPAN></DIV> <DIV><SPAN class=746184809-09042002>        <FONT face=Arial><db>jabber</db></FONT></SPAN></DIV> <DIV><SPAN class=746184809-09042002>        <FONT face=Arial><user>jabber</user></FONT></SPAN></DIV> <DIV><SPAN class=746184809-09042002>        <FONT face=Arial><pass>password</pass></FONT></SPAN></DIV> <DIV><SPAN class=746184809-09042002>        <FONT face=Arial></connection></FONT></SPAN></DIV> <DIV><SPAN class=746184809-09042002><FONT face=Arial></FONT></SPAN> </DIV> <DIV><SPAN class=746184809-09042002>On Starting jabberd I get the output:<BR><BR>[alert] (-internal): [xdbsql_config_init] cannot load backend 'mysql'<BR></SPAN><SPAN class=746184809-09042002></SPAN></DIV> <DIV><SPAN class=746184809-09042002><FONT face=Arial color=#0000ff size=2>Can anybody help me on this ?</FONT></SPAN></DIV> <DIV><SPAN class=746184809-09042002><FONT face=Arial color=#0000ff size=2></FONT></SPAN> </DIV> <DIV><SPAN class=746184809-09042002><FONT face=Arial color=#0000ff size=2>Regards,</FONT></SPAN></DIV> <DIV><SPAN class=746184809-09042002><FONT face=Arial color=#0000ff size=2></FONT></SPAN> </DIV> <DIV><SPAN class=746184809-09042002><FONT face=Arial color=#0000ff size=2>Mansur </FONT></DIV> <DIV><BR></DIV></SPAN> <DIV><SPAN class=746184809-09042002>    </SPAN></DIV> <DIV><SPAN class=746184809-09042002><FONT face=Arial></FONT></SPAN> </DIV> <DIV><SPAN class=746184809-09042002><FONT face=Arial><FONT color=#0000ff size=2></FONT><BR><BR> </DIV></FONT></SPAN></BODY></HTML> <BR> <P><FONT SIZE=2 FACE="Arial">===================================================== </FONT></P> <P><B><FONT SIZE=2 FACE="Arial">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.</FONT></B></P>