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" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> 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" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > 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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of > > [EMAIL PROTECTED] > > Sent: Friday, April 19, 2002 4:55 AM > > To: [EMAIL PROTECTED] > > 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:[EMAIL PROTECTED]] > > Sent: Wednesday, April 17, 2002 8:21 PM > > To: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of > > Costas A. Makris > > Sent: Wednesday, April 17, 2002 2:42 PM > > To: [EMAIL PROTECTED] > > 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 > [EMAIL PROTECTED] > http://mailman.jabber.org/listinfo/jadmin -- ||| ||| ||| ||| ||| Duncan Shannon Premier TechCorps _______________________________________________ jdev mailing list [EMAIL PROTECTED] http://mailman.jabber.org/listinfo/jdev