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" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
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 (doyouknow 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 [EMAIL PROTECTED] http://mailman.jabber.org/listinfo/jdev_______________________________________________ jdev mailing list [EMAIL PROTECTED] http://mailman.jabber.org/listinfo/jdev_______________________________________________ jdev mailing list [EMAIL PROTECTED] http://mailman.jabber.org/listinfo/jdev-- � Daniel Chote email/jabber: [EMAIL PROTECTED] web: www.chote.net
_______________________________________________ jdev mailing list [EMAIL PROTECTED] http://mailman.jabber.org/listinfo/jdev
