<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=windows-1252" http-equiv=Content-Type>
<META content="MSHTML 5.00.2314.1000" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV> </DIV>
<DIV><FONT size=3><EM>Hi Benoit.</EM></FONT></DIV>
<DIV><FONT size=3><EM></EM></FONT> </DIV>
<DIV><FONT size=3><EM>I want to just clarify my points..actually
I</EM></FONT><EM> 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 ....</EM></DIV>
<DIV> </DIV>
<DIV><EM>Please help me how will i configure it..? so that each user request can
communicate its coressponding database...</EM></DIV>
<DIV> </DIV>
<DIV><EM><FONT size=3>awaiting your reply</FONT></EM></DIV>
<DIV><EM>Thanx</EM></DIV>
<DIV><EM>dillip</EM></DIV>
<DIV><EM> </DIV></EM>
<DIV><FONT size=3><EM>Message: 3<BR>From: Benoit Orihuela <<A
href="mailto:borihuela@idealx.com">borihuela@idealx.com</A>><BR>Date: Fri, 27
Apr 2001 12:34:39 +0200<BR>To: <A
href="mailto:jdev@jabber.org">jdev@jabber.org</A><BR>Subject: Re: [JDEV] xdb_sql
connection with two
hast<BR><000901c0cdd3$95ce6960$1b01a8c0@dsf><BR>Reply-To: <A
href="mailto:borihuela@idealx.com">borihuela@idealx.com</A><BR>Reply-To: <A
href="mailto:jdev@jabber.org">jdev@jabber.org</A></EM></FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=3><EM><BR>> Let me know..whether can I use connection with
two different host(differnet<BR>> database server) on mysql
module...how?<BR>you can use different database servers according to
namespaces.<BR>for instance, I use a configuration like that :</EM></FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=3><EM> <xdb id="xdb_auth"><BR>
<host/><BR>
<ns>jabber:iq:auth</ns><BR>
<ns>jabber:iq:profile</ns><BR>
<ns>yahootrans:data</ns><BR>
<load><xdb_sql>/home/jabber/lib/jabber/xdb_sql.so</xdb_sql></load><BR>
</xdb></EM></FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=3><EM> <xdb id="xdb_roster"><BR>
<host/><BR>
<ns>jabber:iq:roster</ns><BR>
<ns>jabber:iq:filter</ns><BR>
<load><xdb_sql>/home/jabber/lib/jabber/xdb_sql.so</xdb_sql></load><BR>
</xdb></EM></FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=3><EM>and so on ...</EM></FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=3><EM>Regards,</EM></FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=3><EM><BR>Benoit.</EM></FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=3><EM>-- <BR>Benoit
Orihuela <BR>IDEALX
S.A.S.</EM></FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=3><EM>--__--__--</EM></FONT></DIV></BODY></HTML>