[JDEV] Re: [jadmin] xdb_sql ...
Chris McDonald
phx-jabber at mindspring.com
Wed Apr 24 15:34:54 CDT 2002
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
More information about the JDev
mailing list