Hi
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="kyri2@ipxgate.com/MyMoo">
<query xmlns=“jabber:iq:privacy” />
</iq>
I receive
&<iq xmlns=“jabber:client” to="kyri2@ipxgate.com/MyMoo" type=“result” id=“agsXMPP_5”>
<query xmlns=“jabber:iq:privacy”>
<list name=“normal-list” />
<list name=“invisible-list” />
</query>
</iq>
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
Kyri
info.log**************
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(ConnectionJDBC2.java:1494)
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.getWarnings(ConnectionJDBC2.java:2068 )
at org.jivesoftware.database.ConnectionPool.run(ConnectionPool.java:254)
at java.lang.Thread.run(Unknown Source)
stderror.log**********
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(TdsCore.java:1049)
at net.sourceforge.jtds.jdbc.TdsCore.microsoftPrepare(TdsCore.java:1175)
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.prepareSQL(ConnectionJDBC2.java:646)
at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatem ent.java:692)
at org.jivesoftware.wildfire.privacy.PrivacyListProvider.loadDefaultPrivacyList(Pr ivacyListProvider.java:205)
at org.jivesoftware.wildfire.privacy.PrivacyListManager.getDefaultPrivacyList(Priv acyListManager.java:106)
at org.jivesoftware.wildfire.IQRouter.handle(IQRouter.java:239)
at org.jivesoftware.wildfire.IQRouter.route(IQRouter.java:96)
at org.jivesoftware.wildfire.spi.PacketRouterImpl.route(PacketRouterImpl.java:67)
at org.jivesoftware.wildfire.net.SocketReader.processIQ(SocketReader.java:250)
at org.jivesoftware.wildfire.net.ClientSocketReader.processIQ(ClientSocketReader.j ava:51)
at org.jivesoftware.wildfire.net.SocketReader.process(SocketReader.java:216)
at org.jivesoftware.wildfire.net.BlockingReadingMode.readStream(BlockingReadingMod e.java:156)
at org.jivesoftware.wildfire.net.BlockingReadingMode.run(BlockingReadingMode.java: 62)
at org.jivesoftware.wildfire.net.SocketReader.run(SocketReader.java:123)
at java.lang.Thread.run(Unknown Source)
Caused by: java.net.SocketException: Connection reset by peer: socket write error
at java.net.SocketOutputStream.socketWrite0(Native Method)
at java.net.SocketOutputStream.socketWrite(Unknown Source)
at java.net.SocketOutputStream.write(Unknown Source)
at java.io.DataOutputStream.write(Unknown Source)
at net.sourceforge.jtds.jdbc.SharedSocket.sendNetPacket(SharedSocket.java:656)
at net.sourceforge.jtds.jdbc.RequestStream.putPacket(RequestStream.java:560)
at net.sourceforge.jtds.jdbc.RequestStream.flush(RequestStream.java:508)
at net.sourceforge.jtds.jdbc.TdsCore.executeSQL(TdsCore.java:1036)
… 15 more