[JDEV] Re: Re: Re: xdb_sql

[Sonic98]

I guess I could just use seperate tables for my forum and jabber. I already
have ibf_members. I could add jabber_members table. I could copy the user
names and passwords from ibf_members to jabber_members, and just change my
registration page so that new members automatically are registered with
both.

But then again, it would be easier, whether I was going to use a DB or not
if someoone had a script that would pull the user names and passwords out of
my DB then automatically register it with the jabber server(basically add
them to the jabber_members table or create the folder/xml file on the
server)

"Sonic98" <raymondcox at redlasertech.com> wrote in message
news:bfej0i$ohj$1 at main.gmane.org...
> Oh, that was you. I guess I'll have to have my current members register
for
> the server also, but change my script so when new people register they
also
> register for the server. I'll also have to find a way to make it
> automatically login to the IM, if they try to launch it while already
logged
> into the website.
>
> "Hernux" <hernuz at etherac.com.ar> wrote in message
> news:000d01c34ee0$20cfdc80$0200a8c0 at acer...
> > I don't like it too...
> > I tried to modify it, but It's almost imposible... some one told me, I
was
> > going to blood from ears....
> > ;-)
> >
> >
> >
> > ----- Original Message -----
> > From: "Sonic98" <raymondcox at redlasertech.com>
> > To: <jdev at jabber.org>
> > Sent: Sunday, July 20, 2003 1:24 PM
> > Subject: [JDEV] Re: Re: xdb_sql
> >
> >
> > > So, what you're saying is that when a user registers and it stores
thier
> > > information in the database it stores it as "user at site.com" ? That
would
> > be
> > > ok for my exisiting memebers cause I could just make a PHP script use
> pull
> > > out the username but stick @site.com on the end of it? But for new
> members
> > > it would be no good because it would create a new user in my database
> for
> > my
> > > site, but then jabber would also store "user at site.com" in the
database.
> I
> > > don't know if I want it doing that. There has to be another way. I
would
> > > really hate to have my users have to register seperately for the
jabber
> > > client.
> > >
> > > "Hernux" <hernuz at etherac.com.ar> wrote in message
> > > news:001501c34ed6$5017f0e0$0200a8c0 at acer...
> > > >
> > > > Yes. You can use an existing DB.
> > > > I've tried it, but not too much...you just need to set your queries
to
> > the
> > > > table where you have your usernames and password...thats all you
need,
> > > other
> > > > data is created automatically by de server.
> > > >
> > > > The problem I found, which made it unsuitable for me, is that it
looks
> > for
> > > > usernames in the way "user = 'user at foo.com'" and I think I'd be
better
> > > > looking for "user = 'user' AND domain = 'foo.com'".  This way, I can
> use
> > > the
> > > > domain as identifier of the user's company....or may be better, just
> > > making
> > > > a join at the select and look for the domain in other table
(companies
> > > table
> > > > may be).
> > > >
> > > > Anyway, now I'm trying LDAP authentication.  And it doesn't work the
> way
> > I
> > > > need too.
> > > > :'(
> > > >
> > > > Hernux
> > > >
> > > >
> > > > ----- Original Message -----
> > > > From: "Sonic98" <raymondcox at redlasertech.com>
> > > > To: <jdev at jabber.org>
> > > > Sent: Sunday, July 20, 2003 12:16 PM
> > > > Subject: [JDEV] Re: xdb_sql
> > > >
> > > >
> > > > > Anyway to get this to work with a current database? I think this
> > > > > documentation is for setting up a new database to work with your
> > jabber
> > > > > server. What about if you already have a database with member
> > > information
> > > > > already in it? Can you make is just pull usernames and passwords
> from
> > > that
> > > > > database?
> > > > >
> > > > >
> > > > > "Raymond Cox" <raymondcox at redlasertech.com> wrote in message
> > > > > news:bfe9vp$jt9$1 at main.gmane.org...
> > > > > > That is actually one of the sites I'd looked at already. I was
> > hoping
> > > > for
> > > > > > just a little bit more docuomentation about xdb_sql and how it
> works
> > > > > because
> > > > > > I know nothing about it. Plus, I'm using PHP not Perl although
the
> > > > syntax
> > > > > is
> > > > > > similar.
> > > > > > "Anton Raharja" <anton at ngoprek.org> wrote in message
> > > > > > news:200307201422380651.01B941D8 at 192.168.0.6...
> > > > > > > this site gave me right direction:
> > > > > > > http://docs.myjabber.net/howto/mysql.htm
> > > > > > >
> > > > > > > *********** REPLY SEPARATOR  ***********
> > > > > > >
> > > > > > > On 20/07/2003 at 0:43 Raymond Cox wrote:
> > > > > > >
> > > > > > > >I downloaded the files and read the readme. It's kind of a
poor
> > > > excuse
> > > > > > for
> > > > > > > >documenation. Where can I go to really find some information
on
> > > > > xdb_sql,
> > > > > > > >how
> > > > > > > >it works, what it does, and whether I really need it or not.
> > > > >
> > > > >
> > > > >
> > > > > _______________________________________________
> > > > > jdev mailing list
> > > > > jdev at jabber.org
> > > > > http://mailman.jabber.org/listinfo/jdev
> > > > >
> > >
> > >
> > >
> > > _______________________________________________
> > > jdev mailing list
> > > jdev at jabber.org
> > > http://mailman.jabber.org/listinfo/jdev
> > >