PrivacyLists and Database possible problems?


I test the wildfire 3.1.0 Beta 2 NB 20.09.2006 (the same is also in the 3.0.1 wildfire) on windows server 2003 and MS-SQL as database.

i see some problems with the database and I try to explain it.

It seems that the database connections are not working after playing with blocking, unblocking, privacy lists etc.

What happened is that during the login procedure the client is hanging and wildfire is not responding.

Nobody can login. But the already logged users are working normally for some time.

If i try to activate from the admin console the database link then nothing is happened.

Every action depends to the database is failed. And the wildfire is dieing more and more with every action.

I believe that this Info Query message could be the problem.

i send

<iq xmlns=“jabber:client” id=“agsXMPP_5” type=“get” from="">

<query xmlns=“jabber:iq:privacy” />


I receive

&<iq xmlns=“jabber:client” to="" type=“result” id=“agsXMPP_5”>

<query xmlns=“jabber:iq:privacy”>

<list name=“normal-list” />

<list name=“invisible-list” />



I don’'t know how i attache a file.

so i put some errors in this message.

( and I hope that this will help you. ???)

For the time i have take out of the login procedure the above IQ message and since some hours the wildfire is stable.

there is only few users on this server (max 7 at the same time)

Please let me know if I am wrong.

Thanks in advance



2006.09.28 20:04:01 Unable to get warning for connection:

java.sql.SQLException: Invalid state, the Connection object is closed.

at net.sourceforge.jtds.jdbc.ConnectionJDBC2.checkOpen(

at net.sourceforge.jtds.jdbc.ConnectionJDBC2.getWarnings( )


at Source)


Error loading default privacy list of username: xxxxxxx

java.sql.SQLException: I/O Error: Connection reset by peer: socket write error

at net.sourceforge.jtds.jdbc.TdsCore.executeSQL(

at net.sourceforge.jtds.jdbc.TdsCore.microsoftPrepare(

at net.sourceforge.jtds.jdbc.ConnectionJDBC2.prepareSQL(

at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatem

at org.jivesoftware.wildfire.privacy.PrivacyListProvider.loadDefaultPrivacyList(Pr

at org.jivesoftware.wildfire.privacy.PrivacyListManager.getDefaultPrivacyList(Priv

at org.jivesoftware.wildfire.IQRouter.handle(

at org.jivesoftware.wildfire.IQRouter.route(

at org.jivesoftware.wildfire.spi.PacketRouterImpl.route(


at ava:51)



at 62)


at Source)

Caused by: Connection reset by peer: socket write error

at Method)

at Source)

at Source)

at Source)

at net.sourceforge.jtds.jdbc.SharedSocket.sendNetPacket(

at net.sourceforge.jtds.jdbc.RequestStream.putPacket(

at net.sourceforge.jtds.jdbc.RequestStream.flush(

at net.sourceforge.jtds.jdbc.TdsCore.executeSQL(

… 15 more


this seems to be a M$ problem and not a Wildfire problem.

Could you please try the same using another database, e.g. the embedded one?


i am sorry for this message.

Wildfire works very well.

It was not an error in the Privacy lists.

It was my plugin that in one case was not closing the database connection.

Wildfire is excellent with the plugin possibilities.

Thanks and sorry again