<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1"> <META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2653.12"> <TITLE>RE: [JDEV] Patch for Jabber Server v1.4</TITLE> </HEAD> <BODY> 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 (<A HREF="http://www.sf.net/projects/xdbjava" TARGET="_blank">http://www.sf.net/projects/xdbjava</A>) 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@vedalabs.com -----Original Message----- From: Aurélien Gâteau [<A HREF="mailto:aurelien@notrefamille.com">mailto:aurelien@notrefamille.com</A>] Sent: Friday, June 15, 2001 4:37 AM To: jdev@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 </BODY> </HTML>