[JDEV] Re: Re: Re: xdb_sql

[Sonic98]

I'm not sure I'm getting you. I actually haven't played around with xdb_sql
at all. I'm still trying to learn about it. All I know is I want to add the
PHP/Jabber webmessenger I saw on my site, and I don't the memebers in my
site's database to have to register seperarely for the jabber server. Too
bad all the jabber servers that use databases instead of files are
commercial.

"Anton Raharja" <anton at ngoprek.org> wrote in message
news:200307210330330090.013B9B97 at 192.168.0.6...
> ok now you know that xdb_sql sent you user at domain but your PHP script more
> to 'user' and 'domain' separately saved
> my choice is to let PHP keep old setting and xdb_sql tricked
> heres some example of my jabber-sql.xml:
>
>     <queries>
>       <!-- Authentication get query (all queries have standard names) -->
>       <querydef name="auth-get">
>         <text>SELECT PersonPassword FROM tblPerson WHERE PersonUsername =
> SUBSTRING_INDEX('$$username$$','@',1)</text>
>         <bindvar name="user">$$username$$</bindvar>
>         <bindcol name="password" offset="0"/>
>       </querydef>
>
>       <!-- Authentication set query -->
>       <querydef name="auth-set">
>         <text>UPDATE tblPerson SET PersonPassword = '$$p$$' WHERE
> PersonUsername = SUBSTRING_INDEX('$$username$$','@',1)</text>
>         <bindvar name="user">$$username$$</bindvar>
>         <bindvar name="password">$$p$$</bindvar>
>       </querydef>
>    ...
>    ...
>    </queries>
>
> there, when user auth xdb_sql pass user at domain replacing $$username$$ but
> than SUBSTRING_INDEX makes the query only recognize 'user' part
> do some changes on xml file to suite your needs
>
> *********** REPLY SEPARATOR  ***********
>
> On 20/07/2003 at 11:24 Sonic98 wrote:
>
> >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