[JDEV] Re: Re: xdb_sql

[Anton Raharja]

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