Wildfire errors - DNS, Unknown column, and Duplicate entry

Openfire Openfire Support
1

Hi,

We’‘re running Wildfire 2.6.1 and get these errors pretty consistently in the error log. Found others in the forum receiving similar errors, but no clear resolution. Wouldn’'t it be nice to live in a world without errors?

2006.04.26 09:57:59 [org.jivesoftware.wildfire.pubsub.PubSubPersistenceManager.createNode(PubSubPer sistenceManager.java:210)

]

java.sql.SQLException: Unknown column ‘‘contacts’’ in ‘‘field list’’

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928)

at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)

at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)

at com.mysql.jdbc.Connection.execSQL(Connection.java:2994)

at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:936)

at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1166)

at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1082)

at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1067)

at org.jivesoftware.wildfire.pubsub.PubSubPersistenceManager.createNode(PubSubPers istenceManager.java:207)

at org.jivesoftware.wildfire.pubsub.Node.saveToDB(Node.java:1665)

at org.jivesoftware.wildfire.pubsub.PubSubModule.initialize(PubSubModule.java:400)

at org.jivesoftware.wildfire.XMPPServer.initModules(XMPPServer.java:472)

at org.jivesoftware.wildfire.XMPPServer.start(XMPPServer.java:369)

at org.jivesoftware.wildfire.XMPPServer.(XMPPServer.java:142)

at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)

at java.lang.reflect.Constructor.newInstance(Unknown Source)

at java.lang.Class.newInstance0(Unknown Source)

at java.lang.Class.newInstance(Unknown Source)

at org.jivesoftware.wildfire.starter.ServerStarter.start(ServerStarter.java:88)

at org.jivesoftware.wildfire.starter.ServerStarter.main(ServerStarter.java:49)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at com.exe4j.runtime.LauncherEngine.launch(Unknown Source)

at com.exe4j.runtime.WinLauncher.main(Unknown Source)

2006.04.26 09:58:07 [org.jivesoftware.wildfire.server.OutgoingServerSession.createOutgoingSession(O utgoingServerSession.java:259)

] Error trying to connect to remote server: workgroup.[OurDomain.com](DNS lookup: workgroup.[OurDomain.com]:5269)

java.net.UnknownHostException: workgroup.[OurDomain.com]

at java.net.PlainSocketImpl.connect(Unknown Source)

at java.net.SocksSocketImpl.connect(Unknown Source)

at java.net.Socket.connect(Unknown Source)

at org.jivesoftware.wildfire.server.OutgoingServerSession.createOutgoingSession(Ou tgoingServerSession.java:254)

at org.jivesoftware.wildfire.server.OutgoingServerSession.authenticateDomain(Outgo ingServerSession.java:140)

at org.jivesoftware.wildfire.server.OutgoingSessionPromise.createSessionAndSendPac ket(OutgoingSessionPromise.java:126)

at org.jivesoftware.wildfire.server.OutgoingSessionPromise.access$300(OutgoingSess ionPromise.java:37)

at org.jivesoftware.wildfire.server.OutgoingSessionPromise$1$1.run(OutgoingSession Promise.java:91)

at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

at java.lang.Thread.run(Unknown Source)

2006.04.26 16:28:36 [org.jivesoftware.wildfire.server.OutgoingServerSession.createOutgoingSession(O utgoingServerSession.java:259)

] Error trying to connect to remote server: null(DNS lookup: null:5269)

java.net.UnknownHostException: null

at java.net.PlainSocketImpl.connect(Unknown Source)

at java.net.SocksSocketImpl.connect(Unknown Source)

at java.net.Socket.connect(Unknown Source)

at org.jivesoftware.wildfire.server.OutgoingServerSession.createOutgoingSession(Ou tgoingServerSession.java:254)

at org.jivesoftware.wildfire.server.OutgoingServerSession.authenticateDomain(Outgo ingServerSession.java:140)

at org.jivesoftware.wildfire.server.OutgoingSessionPromise.createSessionAndSendPac ket(OutgoingSessionPromise.java:126)

at org.jivesoftware.wildfire.server.OutgoingSessionPromise.access$300(OutgoingSess ionPromise.java:37)

at org.jivesoftware.wildfire.server.OutgoingSessionPromise$1$1.run(OutgoingSession Promise.java:91)

at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

at java.lang.Thread.run(Unknown Source)

2

Hi,

is it possible for you to upgrade to Wifi 2.6.2. If you want to use pubsub then you should do this, there are some MySQL issues with 2.6.1. Is it possible that you did run the update script more than once and have now two entries in a pubsub table?

Is there a user with a JID like foo@workgroup.OurDomain.com? It just looks like this, that’'s why Wifi tries to establish a s2s connection to workgroup.OurDomain.com. If you are not using s2s you may want to disable s2s completely.

LG

3

We originally tried to upgrade to 2.6.2, only to find that it’'s incompatible with Spark Manager 1.1. So we installed 2.6.1 instead. Can we find (and remove) the duplicate entry?

I don’‘t see a user with that type of JID. We’'ll try disabling s2s.

thanks

4

Hi,

I don’‘t have the 2.6.1 source any more, so it’'s hard to guess what are the statement in line 207 and 607, maybe Gato can tell us.

If you are not using pubsub you may stop Wifi, drop the five pubsub tables and recreate them using the update script.

LG