[JDEV] Re: xdb_sql ...

Andrew Kornak akornak at rapidmedianetwork.com
Fri Apr 26 15:03:28 CDT 2002


Chris,

    Thanks for the info. I managed to get xdb_sql working with Jabber
without
transports and using xdb_file with the transports. Still, it would be nice
to have
the transports talking to the database. Has anyone on this list had any luck
using
xdb_sql with any transport? I managed to register the logon and it writes
the
record into the database, but, when trying to logon again it fails. When
running
in debug mode and starting the Jabber server and the transport I see a
reponse
from Jabber and the transport. When re-logging in to the transport there is
no
debug output at all. It's as if there is no longer any communication present
with
the transport. I am at a complete loss. Are the current maintainers of the
xdb_sql
project on this list? Any help would be greatly appreciated. Thank you.

Regards,
Andrew Kornak

----- Original Message -----
From: "Chris McDonald" <phx-jabber at mindspring.com>
To: <jdev at jabber.org>; <jadmin at jabber.org>
Sent: Wednesday, April 24, 2002 3:34 PM
Subject: RE: [JDEV] Re: [jadmin] xdb_sql ...


> There was some talk of this in the last week or so, basically from my
> experience, xdb_sql doesn't work with the transports properly.  You need
two
> xdb_<stuff> sections...xdb_sql to handle the jabber stuff and xdb_file to
> handle the transports.  You use the <host>...</host> sections to designate
> which db handles which traffic.  Check the archives for the last week or
so,
> I posted what a sample <xdb> section would look like with both parts in
> there.
>
> Chris McDonald
> mcdonc at corp.earthlink.net
> MIS-Intranet Development
> EarthLink Phoenix Call Center
>
> -----Original Message-----
> From: jdev-admin at jabber.org [mailto:jdev-admin at jabber.org]On Behalf Of
> Andrew Kornak
> Sent: Wednesday, April 24, 2002 12:28 PM
> To: jadmin at jabber.org; jdev at jabber.org
> Subject: [JDEV] Re: [jadmin] xdb_sql ...
>
> All,
>
>     To those who have managed to get xdb_sql working with transports;
> my congratulations and a plea for assistance. I managed to get the jabber
> server running fine. I even manage to register transports with a MySQL
> database. But, when logging out and logging in again, failure. The
transport
> is not registered. I am running the transports in seperate server
processes.
> My configuration in jabber.xml is:
>
>  === xdb section ===
> <xdb id="xdb_sql">
>     <host>jabber.server.com</host>
>     <host>yahoo.server.com</host>
>     <ns>jabber:iq:roster</ns>
>     <ns>jabber:x:offline</ns>
>     <ns>jabber:iq:filter</ns>
>     <ns>jabber:iq:last</ns>
>     <ns>jabber:iq:auth</ns>
>     <ns>jabber:iq:auth:0k</ns>
>     <ns>jabber:iq:register</ns>
>     <ns>vcard-temp</ns>
>     <load>
>       <xdb_sql>./xdb_sql/xdb_sql.so</xdb_sql>
>     </load>
>     <jabberd:include>./xdb_sql/xdb_sql.xml</jabberd:include>
>     <load>
>       <xdb_file>./xdb_file/xdb_file.so</xdb_file>
>     </load>
>     <xdb_file xmlns="jabber:config:xdb_file">
>       <spool><jabberd:cmdline flag='s'>./spool</jabberd:cmdline></spool>
>     </xdb_file>
>   </xdb>
>
> === yahoo ===
>   <service id="yahootrans">
>     <host>yahoo.server.com</host>
>     <accept>
>       <ip>127.0.0.1</ip>
>       <port>5236</port>
>       <secret>secret</secret>
>     </accept>
>   </service>
>
>
> Thank you.
>
> Regards,
> Andrew Kornak
> ---
>
> ----- Original Message -----
> From: "Andrew Kornak" <akornak at rapidmedianetwork.com>
> To: <jadmin at jabber.org>
> Sent: Friday, April 19, 2002 1:34 PM
> Subject: Re: [jadmin] ICQv7 and xdb_sql
>
>
> > Chris,
> >
> >     In the example sql code in xdb_sql the code creates a yahoo table
with
> a
> > login id and password, etc. Is it even possible to use xdb_sql with
> > transports? I have had very little
> > success. I added a <host> tag for yahoo.someserver.com in the xdb_sql
> > section of jabber.xml
> > and yahoo complains about "no logon information". I can get jabber
working
> > wihtout the yahoo transport incorporated. I would like to be able to
> > administer jabber as well as the transports in a
> > database. I am using jabber-1.4.2 and xdb_sql-1.2. I tried other
versions
> > with various
> > combinations and these work the best for me so far. Any help or success
> > stories would be
> >  greatly appreciated! Thanks.
> >
> > Regards,
> >
> > Andrew Kornak
> >
> > ----- Original Message -----
> > From: "Chris McDonald" <phx-jabber at mindspring.com>
> > To: <jadmin at jabber.org>
> > Sent: Friday, April 19, 2002 10:03 AM
> > Subject: RE: [jadmin] ICQv7 and xdb_sql
> >
> >
> > > You'll basically have two xdb_xxx sections, each one relying on the
> > <host/>
> > > tag to specify what it's responsible for...
> > >
> > >
> > >
> > >
> > >         <xdb id="xdb_sql">
> > >         <host>your.servername.com</host>
> > >         <ns>jabber:iq:roster</ns>
> > >         <ns>jabber:x:offline</ns>
> > >         <ns>jabber:iq:filter</ns>
> > >         <ns>jabber:iq:last</ns>
> > >         <ns>jabber:iq:auth</ns>
> > >         <ns>jabber:iq:auth:0k</ns>
> > >         <ns>jabber:iq:register</ns>
> > >         <ns>vcard-temp</ns>
> > >         <load>
> > >         <xdb_sql>/path/to/xdb_sql.so</xdb_sql>
> > >         </load>
> > >         <jabberd:include>/path/to/xdb_sql.xml</jabberd:include>
> > >         </xdb>
> > >
> > >         <xdb id="xdb_file">
> > >         <host>msn.your.servername.com</host>
> > >         <host>yahoo.your.servername.com</host>
> > >         <host>icq.your.servername.com</host>
> > >         <host>irc.your.servername.com</host>
> > >         <host>aim.your.servername.com</host>
> > >         <host>jud.your.servername.com</host>
> > >         <ns>jabber:iq:roster</ns>
> > >         <ns>jabber:x:offline</ns>
> > >         <ns>jabber:iq:filter</ns>
> > >         <ns>jabber:iq:last</ns>
> > >         <ns>jabber:iq:auth</ns>
> > >         <ns>jabber:iq:auth:0k</ns>
> > >         <ns>jabber:iq:register</ns>
> > >         <ns>vcard-temp</ns>
> > >         <load>
> > >         <xdb_file>./xdb_file/xdb_file.so</xdb_file>
> > >         </load>
> > >         <xdb_file xmlns="jabber:config:xdb_file">
> > >         <spool><jabberd:cmdline
> flag='s'>./spool</jabberd:cmdline></spool>
> > >         </xdb_file>
> > >         </xdb>
> > >
> > >
> > > Or something like that...This may be a bit outdated, so it may require
> > some
> > > tinkering...but you should get the idea...
> > >
> > >
> > > Chris McDonald
> > > MIS-Intranet Development
> > > Jabber Project
> > > Earthlink Phoenix Call Center
> > >
> > > -----Original Message-----
> > > From: jadmin-admin at jabber.org [mailto:jadmin-admin at jabber.org]On
Behalf
> Of
> > > ralonso at lis.state.oh.us
> > > Sent: Friday, April 19, 2002 4:55 AM
> > > To: jadmin at jabber.org
> > > Subject: RE: [jadmin] ICQv7 and xdb_sql
> > >
> > > In a message on JDEV the other day
> > > (http://mailman.jabber.org/pipermail/jdev/2002-April/011201.html),
> someone
> > > said that xdb_sql only works for vcard information and you have to use
> > > xdb_file for the JUD.  Can anyone confirm or deny this?  Chris, how
did
> > you
> > > configure your server in order to get xdb_sql to work for JUD?
> > >
> > > Thanks,
> > > Robert
> > >
> > > -----Original Message-----
> > > From: Chris McDonald [mailto:phx-jabber at mindspring.com]
> > > Sent: Wednesday, April 17, 2002 8:21 PM
> > > To: jadmin at jabber.org
> > > Subject: RE: [jadmin] ICQv7 and xdb_sql
> > >
> > >
> > > You have to run xdb_sql as the db for your jabber users and xdb_file
for
> > the
> > > transports.  At least, that's how I had to do it back in the day when
I
> > was
> > > using it.
> > >
> > > Chris McDonald
> > > MIS-Intranet Development
> > > Jabber Project
> > > Earthlink Phoenix Call Center
> > >
> > > -----Original Message-----
> > > From: jadmin-admin at jabber.org [mailto:jadmin-admin at jabber.org]On
Behalf
> Of
> > > Costas A. Makris
> > > Sent: Wednesday, April 17, 2002 2:42 PM
> > > To: jadmin at jabber.org
> > > Subject: [jadmin] ICQv7 and xdb_sql
> > >
> > > Can ICQv7 and xdb_sql coexist and co-operate on the same server? If
> > > yes, is there any extra  configuration needed to make them work
> > > together in addition to the configurations done to make each of the
> > > add-ons work independently?
> > >
> > > Best Regards
> > >
> > > Costas
> On Mon, 2002-04-08 at 10:33, Benoit Orihuela wrote:
> > hi,
> >
> > > 2.  I need the user to log in (the very first time) and have their
> > > users there for them... no subscribing to a group or anyting.
> > this can be simply done with a sql script (at least as simple as doing
it
> for
> > xml files with a perl script ...)
>
> Ok, can you start me in that direction with a pointer where to start?
>
> >
> > > Otherwise, it appears that xdb_sql/mod_groups would be great. (also,
> > > its not really ready to roll production-wise is it?)
> > xdb_sql does not currently support mod_groups related namespaces but it
> supports
> > roster groups (don't know if it is enough for what you need).
> > otherwise, xdb_sql has already been used in production environments with
> more
> > than 10000 connected users so I think it's ready to roll production-wise
> :) ...
> >
>
> 10000 users sounds production ready to me too!  From the sounds of it
> Roster Groups would be enough.... I dont need the ability to subscribe
> to a group... i just need to be able to create users, that are
> auto-magically subscribed to everyone, and everyone auto-magically gets
> 'newuser' added to their roster.
>
> I can surely take my 3rd or 4th stab at xdb_sql...  ive tried, and
> posted to the list... its frustrating w/o a central place for all things
> xdb_sql.  I feel i installed it correctly, edited my Makefile correctly
> (for mysql)... the db just never ends up with any user data (and i
> believe i was having problems registering users) so something obvioulsy
> wasnt quite right.
>
> and just to be complete, here are the links to my files!
>
> http://sodatrain.com/jabber.xml.txt
> http://sodatrain.com/xdb_sql.xml.txt
> http://sodatrain.com/Makefile
>
>
> Thank you-
>
>
> > regards,
> >
> >
> > Benoit.
> > _______________________________________________
> > jadmin mailing list
> > jadmin at jabber.org
> > http://mailman.jabber.org/listinfo/jadmin
> --
> |||  |||  |||  |||  |||
> Duncan Shannon
> Premier TechCorps
>
>
>
>
>
> _______________________________________________
> jdev mailing list
> jdev at jabber.org
> http://mailman.jabber.org/listinfo/jdev
>
> _______________________________________________
> jadmin mailing list
> jadmin at jabber.org
> http://mailman.jabber.org/listinfo/jadmin




More information about the JDev mailing list