[JDEV] Re: xdb_sql

[Hernux]

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
>