[JDEV] xdb_sql connection with two host

[Dillip Kumar Swain]

Hi Benoit. I didn't get you..can you please clarify....actually I have two database(mysql) on different server like abc.com & xyz.com..I want to fetch data from both server.... can I configure in xdb_sql.xml on xdb_sql like this...   <xdb_sql xmlns="jabberd:xdb_sql:config">     <!-- Backend to use -->     <backend>mysql</backend>       <!-- Configure information about the SQL connection -->     <connection>       <host>abc.com</host>       <db>jabber</db>       <user>abc</user>       <pass>abc123</pass>     </connection>       <connection>       <host>xyx.com</host>       <db>jabber</db>       <user>xyx</user>       <pass>xyx123</pass>     </connection> so..on..   awaiting your reply Thanx dillip   Message: 3 From: Benoit Orihuela <[EMAIL PROTECTED]> Date: Fri, 27 Apr 2001 12:34:39 +0200 To: [EMAIL PROTECTED] Subject: Re: [JDEV] xdb_sql connection with two hast <000901c0cdd3$95ce6960$1b01a8c0@dsf> Reply-To: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED]   > Let me know..whether can I use connection with two different host(differnet > database server) on mysql module...how? you can use different database servers according to namespaces. for instance, I use a configuration like that :     <xdb id="xdb_auth">     <host/>     <ns>jabber:iq:auth</ns>     <ns>jabber:iq:profile</ns>     <ns>yahootrans:data</ns>     <load><xdb_sql>/home/jabber/lib/jabber/xdb_sql.so</xdb_sql></load>   </xdb>     <xdb id="xdb_roster">     <host/>     <ns>jabber:iq:roster</ns>     <ns>jabber:iq:filter</ns>     <load><xdb_sql>/home/jabber/lib/jabber/xdb_sql.so</xdb_sql></load>   </xdb>   and so on ...   Regards,   Benoit.   -- Benoit Orihuela         IDEALX S.A.S.   --__--__--