[JDEV] Re: Re: xdb_sql

[Sonic98]

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
> >