[JDEV] Jabber and user database

[raditha dissanayake]

Hi daniel,
the good news for your is that xdb_sql can easily be extended by added 
new queries to xdb_sql.xml if you use v2 quries you often end up without 
having to do any coding at all.


Daniel Chote wrote:

> Actually.. I found that this issue occurs when a client probes for a 
> namespace that is not handeled by the jabber server, when your using 
> xdb_sql..
>
> The thing I found that did it was iq:private, when a client requested 
> iq:private, jabberd would sit there and do nothing until the xdb 
> request timed out... the solution to this was to run xdb_sql along 
> side xdb_file, and map the relevant namespaces to each.
>
> raditha dissanayake wrote:
>
>> Hi,
>> my experience is that xdb_sql is a triffle slower than xdb_file. 
>> However i haven't had it dying on me like this.
>> One of the reasons for the performance drop is that when ever you add 
>> or remove a roster item the whole roster is created and inserted again.
>> That is if you have 25 memebers in your roster and you add another, 
>> there will be one delete followed by 26 inserts!!
>> However this is NOT a shortcoming of xdb_sql, xdb_file needs this 
>> behaviour and xdb_sql has to live with it.
>> The good news is that you can tweak things a bit and eliminate all 
>> these extra inserts.
>>
>>
>> Yanming Xiao wrote:
>>
>>> Hi guys,
>>>
>>> How the performance of xdb_sql? I am runing it with jabber-1.4.2 on 
>>> RH 7.3,
>>> but it always causes sudden death of jabber when a new user tries
>>> to register.
>>>
>>> -Yanming
>>>
>>> ----- Original Message -----
>>> From: "raditha dissanayake" <jabber at raditha.com>
>>> To: <jdev at jabber.org>
>>> Sent: Saturday, November 09, 2002 2:42 PM
>>> Subject: Re: [JDEV] Jabber and user database
>>>
>>>
>>>
>>>
>>>> Hi Bart,
>>>> I have good news for you, xdb_sql is extremely flexible with it's
>>>> database design. In fact it's not an exageration to say the database
>>>> structure is completely abtracted from the xdb_sql code. All the 
>>>> queries
>>>> are defined in xdb_sql.xml and you can change this so that it can work
>>>> with your phpdb database.
>>>>
>>>> btw: can i join your phpdb jabber integration effort?
>>>>
>>>>
>>>> Bart van Bragt wrote:
>>>>
>>>>
>>>>> Master Brian wrote:
>>>>>
>>>>>> I hope that I can use a user database that I've already in use under
>>>>>> MySql. The user database is mantained by my forum, made in phpbb (do
>>>>>>
>>>>> you
>>>>>
>>>>>> know it?).
>>>>>>
>>>>> I'm one of the senior developers of phpBB. I've been playing with the
>>>>> same idea. Haven't had time to implement this yet. Main reason is that
>>>>> I don't want to run jabberd on my main server (on domain.com) to do
>>>>> that my client (Psi) first needs to support SRV DNS entries.
>>>>>
>>>>> When this is done I'm probably going to try to accomplish this. I
>>>>> already saw that jabberd can use MySQL for keeping track of things. I
>>>>> don't know how trivial it would be to link the phpBB user table with
>>>>> the Jabberd process. Of course you could alter profile.php to make it
>>>>> insert/delete/update approriate rows when a user creates, deletes or
>>>>> alters a username.
>>>>>
>>>>> BTW you will have to make some modifications to phpBB. You'll at least
>>>>> need to limit the usernames that users can't choos (i.e. disallow
>>>>> spaces, etc).
>>>>>
>>>>> Curious if someone else can tell us how (non-)trivial it would be to
>>>>> link jabberd to another user database.
>>>>>
>>>>>
>>>> _______________________________________________
>>>> 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
>>>
>>>
>>
>>
>> _______________________________________________
>> jdev mailing list
>> jdev at jabber.org
>> http://mailman.jabber.org/listinfo/jdev
>
>
> -- 
>
> • Daniel Chote
> email/jabber: daniel at chote.net
> web: www.chote.net
>