[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 <borihuela at idealx.com>
Date: Fri, 27 Apr 2001 12:34:39 +0200
To: jdev at jabber.org
Subject: Re: [JDEV] xdb_sql connection with two hast
<000901c0cdd3$95ce6960$1b01a8c0 at dsf>
Reply-To: borihuela at idealx.com
Reply-To: jdev at jabber.org


> 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.

--__--__--
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://www.jabber.org/jdev/attachments/20010426/29c6bd26/attachment-0002.htm>