[JDEV] Patch for Jabber Server v1.4

[Matt Diez]

I'm not sure as to how opposed you are to running 
Java as part of your server setup, but you might
also consider trying out xdb_java (http://www.sf.net/projects/xdbjava)
as a bridge between MS SQL Server 2000 and Jabber.

Of course, I haven't tried it with SQL Server yet,
but I have it running currently with PostgreSQL and
DB2.

If you could give it a shot, I'd be highly appreciative,
particularly if you meet with success.

Matthew D. Diez
matt at vedalabs.com

-----Original Message-----
From: Aurélien Gâteau [mailto:aurelien at notrefamille.com]
Sent: Friday, June 15, 2001 4:37 AM
To: jdev at jabber.org
Subject: [JDEV] Patch for Jabber Server v1.4


Hi !

I'm pretty new to this list (I just subscribed five minutes ago :o), so
please tell me if I don't do everything as I should.

My company is developping a peer-to-peer application for genealogists and we
are in the process of adding support for 
Instant Messaging, thanks to Jabber.

Our server is running MS SQL Server 2000. As it doesn't seem possible to get
Jabber use a SQL Server database for 
users yet, we decided to create/update/delete users on Jabber whenever the
SQL Server database was modified. I 
created a tool to register user on the Jabber server when such changes
happened and a tool to automatically recreate 
Jabber users from the SQL Server users to get the existing users up to date
and to be able to resynchronize Jabber in 
case anything bad happens... 
This tool was often getting connection limited by the Jabber server.
Therefore I modified the server to allow bypassing 
Karma for a specific address. In the xml config file, you need to do
something like this :
<jabber>
...
  <io>
...
    <karma>
      <bypass>12.13.14.15</bypass>
...
    </karma>
...
  </io>
...
</jabber>

It's a little rough right now (no multiple IP or masks) but it seems to work
well.
Could you tell me what you think about it ?

Regards,
  Aurelien
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://www.jabber.org/jdev/attachments/20010615/c85e02d2/attachment-0002.htm>