So, what you're saying is that when a user registers and it stores thier information in the database it stores it as "[EMAIL PROTECTED]" ? 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 "[EMAIL PROTECTED]" 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" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > > 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 = '[EMAIL PROTECTED]'" 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" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > 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" <[EMAIL PROTECTED]> wrote in message > > news:[EMAIL PROTECTED] > > > 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" <[EMAIL PROTECTED]> wrote in message > > > news:[EMAIL PROTECTED] > > > > 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 > > [EMAIL PROTECTED] > > http://mailman.jabber.org/listinfo/jdev > > _______________________________________________ jdev mailing list [EMAIL PROTECTED] http://mailman.jabber.org/listinfo/jdev
