[JDEV] xdb_sql connection with two host

[Dillip Kumar Swain]

Hi Benoit.

I want to just clarify  my points..actually I  have two database(mysql) on different server like abc.com & xyz.com..I want to fetch data from both server....database setting is like this...From A--M users details are in one database and N-Z users details are in other ....

Please help me how will i configure it..? so that each user request can communicate its coressponding database...

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/a639479d/attachment-0002.htm>