<!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><FONT size=3><EM>Hi Benoit.</EM></FONT></DIV>
<DIV><EM>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...</EM></DIV>
<DIV> </DIV>
<DIV><EM><xdb_sql xmlns="jabberd:xdb_sql:config"><BR>
<!-- Backend to use --><BR>
<backend>mysql</backend></EM></DIV>
<DIV> </DIV>
<DIV><EM> <!-- Configure information about the SQL
connection --><BR>
<connection><BR>
<host>abc.com</host><BR>
<db>jabber</db><BR>
<user>abc</user><BR>
<pass>abc123</pass><BR>
</connection></EM></DIV>
<DIV> </DIV>
<DIV><EM> <connection><BR>
<host>xyx.com</host><BR>
<db>jabber</db><BR>
<user>xyx</user><BR>
<pass>xyx123</pass><BR>
</connection><BR><FONT size=3><STRONG>so..on..</STRONG></FONT></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>