Good morning and Happy Holidays-
I am running wildfire-2.6.2-1 installed from an rpm on RedHat EL 3 and would like to upgrade to version 3.1.1.
Is upgrading as simple as running rpm -Uvh wildfire_3_1_1.rpm or should the ‘‘freshen’’ option be used?
Thanks in advance,
Claud1e
Hi,
rpm -Uvh should work fine. I did never hear of one using the freshen option.
LG
Thanks for the reply…
I ran the Upgrade command for the rpm and it went with no errors. But now when try to get to my admin interface (https://wildfire.mydomain.com:9091) I get a page with the following error:
HTTP ERROR: 500
java/util/Hashtable$ValueCollection
RequestURI=/login.jsp
Powered by Jetty://
Did I miss something?
Thanks,
Claud1e
I also cannot get to http://wildfire.mydomain.com:9090…it just continually says loading, but the page never loads.
service wildfired status tells me the server is running, and I can login, as well as the only other user in the office right now; but we cannot send messages to each other.
I’'m basically dead in the water right now. I had it setup to use mysql DB when it was working with wildfire 2.6.2 and have a DUMP of that DB on my desktop as a backup as well as the entire /opt/wildfire/ directory…
I’‘m wondering if I’'m going to have to rpm -evh wildfire_3_1_1.rpm and re-install using rpm -ivh wildfire_3_1_1.rpm? If I did that would it blow away my database?
Thanks in advance,
Claud1e
Hi,
did you restart Wildfire after the upgrade? You should see meaningful error messages in the log file if something goes wrong.
Take a look at the database upgrade scripts before downgrade - I think there were no changes which prevent a downgrade.
LG
Yes, I did restart the server after upgrade, both wildfired and mysqld. The server started up and I could even login, but couldn’'t send/receive any messages, and could not connect to the web admin interface via 9090 or 9091.
I was able to get the server up and running again in version 2.6.2 by restoring the old directory from backup. Problem is, now my machine says wildfire_3_1_1.rpm is installed, with 2.6.2 running, and a database that is questionable. I’‘m hoping I can just run one of the db upgrade scripts in /path_to_wildfire/resources/database/upgrade but I’'m not sure which one and how to do it?
Any help would be greatly appreciated.
Thanks,
Claud1e
OK…I’‘m not exactly sure why it’'s working now but here is what I did:
I had 2.6.2 server running from restored directory, so I shut down ‘‘service wildfired stop’’
Moved off that working directory ‘‘mv /opt/wildfire /opt/wildfire2.6.2’’
Renamed the wildfire directory installed with wildfire_3_1_1.rpm ‘‘mv /opt/wildfireNEW /opt/wildfire’’
/opt/wildfire/bin/extra/redhat-postinstall.sh
service wildfired start
Tails from logs:
###########################################################
Wildfire info.log
###########################################################
2006.12.27 07:10:42 Found old database version 6 for wildfire. Upgrading to version 10…
2006.12.27 07:10:43 Multi User Chat domain: conference.wildfire.mydomain.com
2006.12.27 07:10:43 Publish-Subscribe domain: pubsub.wildfire.mydomain.com
2006.12.27 07:10:43 Started server (unencrypted) socket on port: 5269
2006.12.27 07:10:43 Started plain (unencrypted) socket on port: 5222
2006.12.27 07:10:44 Started SSL (encrypted) socket on port: 5223
2006.12.27 07:10:44 Wildfire 3.1.1
2006.12.27 07:10:49 Admin console listening at:
http://wildfire.mydomain.com:9090
https://wildfire.mydomain.com:9091
2006.12.27 07:10:49 Initializing Asterisk-IM Plugin
2006.12.27 07:10:49 Initializing Hibernate for Asterisk-IM
###########################################################
Wildfire error.log
###########################################################
2006.12.27 07:10:42 org.jivesoftware.database.SchemaManager.checkSchema(SchemaManager.java:249)
java.sql.SQLException: Too big column length for column ‘‘contacts’’ (max = 255). Use BLOB instead
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2975)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1600)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1695)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2998)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2927)
at com.mysql.jdbc.Statement.execute(Statement.java:535)
at org.jivesoftware.database.SchemaManager.executeSQLScript(SchemaManager.java:332 )
at org.jivesoftware.database.SchemaManager.checkSchema(SchemaManager.java:246)
at org.jivesoftware.database.SchemaManager.checkWildfireSchema(SchemaManager.java: 66)
at org.jivesoftware.database.DbConnectionManager.setConnectionProvider(DbConnectio nManager.java:449)
at org.jivesoftware.database.DbConnectionManager.getConnection(DbConnectionManager .java:74)
at org.jivesoftware.util.JiveProperties.loadProperties(JiveProperties.java:269)
at org.jivesoftware.util.JiveProperties.init(JiveProperties.java:67)
at org.jivesoftware.util.JiveProperties.(XMPPServer.java:147)
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:93)
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.install4j.runtime.Launcher.main(Unknown Source)
2006.12.27 07:10:43 org.jivesoftware.wildfire.pubsub.PubSubPersistenceManager.loadDefaultConfigurati on(PubSubPersistenceManager.java:1101)
java.sql.SQLException: Table ‘‘Jabber.pubsubDefaultConf’’ doesn’'t exist
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2975)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1600)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1695)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3004)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1128)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1222)
at org.jivesoftware.wildfire.pubsub.PubSubPersistenceManager.loadDefaultConfigurat ion(PubSubPersistenceManager.java:1074)
at org.jivesoftware.wildfire.pubsub.PubSubModule.initialize(PubSubModule.java:326)
at org.jivesoftware.wildfire.XMPPServer.initModules(XMPPServer.java:482)
at org.jivesoftware.wildfire.XMPPServer.start(XMPPServer.java:374)
at org.jivesoftware.wildfire.XMPPServer.(XMPPServer.java:147)
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:93)
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.install4j.runtime.Launcher.main(Unknown Source)
2006.12.27 07:10:43 org.jivesoftware.wildfire.pubsub.PubSubPersistenceManager.createDefaultConfigura tion(PubSubPersistenceManager.java:1151)
java.sql.SQLException: Table ‘‘Jabber.pubsubDefaultConf’’ doesn’'t exist
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2975)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1600)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1695)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3004)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1128)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1357)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1274)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1259)
at org.jivesoftware.wildfire.pubsub.PubSubPersistenceManager.createDefaultConfigur ation(PubSubPersistenceManager.java:1148)
at org.jivesoftware.wildfire.pubsub.PubSubModule.initialize(PubSubModule.java:344)
at org.jivesoftware.wildfire.XMPPServer.initModules(XMPPServer.java:482)
at org.jivesoftware.wildfire.XMPPServer.start(XMPPServer.java:374)
at org.jivesoftware.wildfire.XMPPServer.(XMPPServer.java:147)
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:93)
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.install4j.runtime.Launcher.main(Unknown Source)
2006.12.27 07:10:43 org.jivesoftware.wildfire.pubsub.PubSubPersistenceManager.loadDefaultConfigurati on(PubSubPersistenceManager.java:1101)
java.sql.SQLException: Table ‘‘Jabber.pubsubDefaultConf’’ doesn’'t exist
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2975)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1600)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1695)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3004)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1128)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1222)
at org.jivesoftware.wildfire.pubsub.PubSubPersistenceManager.loadDefaultConfigurat ion(PubSubPersistenceManager.java:1074)
at org.jivesoftware.wildfire.pubsub.PubSubModule.initialize(PubSubModule.java:347)
at org.jivesoftware.wildfire.XMPPServer.initModules(XMPPServer.java:482)
at org.jivesoftware.wildfire.XMPPServer.start(XMPPServer.java:374)
at org.jivesoftware.wildfire.XMPPServer.(XMPPServer.java:147)
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:93)
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.install4j.runtime.Launcher.main(Unknown Source)
2006.12.27 07:10:43 org.jivesoftware.wildfire.pubsub.PubSubPersistenceManager.createDefaultConfigura tion(PubSubPersistenceManager.java:1151)
java.sql.SQLException: Table ‘‘Jabber.pubsubDefaultConf’’ doesn’'t exist
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2975)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1600)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1695)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3004)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1128)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1357)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1274)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1259)
at org.jivesoftware.wildfire.pubsub.PubSubPersistenceManager.createDefaultConfigur ation(PubSubPersistenceManager.java:1148)
at org.jivesoftware.wildfire.pubsub.PubSubModule.initialize(PubSubModule.java:365)
at org.jivesoftware.wildfire.XMPPServer.initModules(XMPPServer.java:482)
at org.jivesoftware.wildfire.XMPPServer.start(XMPPServer.java:374)
at org.jivesoftware.wildfire.XMPPServer.(XMPPServer.java:147)
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:93)
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.install4j.runtime.Launcher.main(Unknown Source)
2006.12.27 07:10:43 org.jivesoftware.wildfire.pubsub.PubSubPersistenceManager.loadNodes(PubSubPersis tenceManager.java:515)
java.sql.SQLException: Table ‘‘Jabber.pubsubNode’’ doesn’'t exist
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2975)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1600)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1695)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3004)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1128)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1222)
at org.jivesoftware.wildfire.pubsub.PubSubPersistenceManager.loadNodes(PubSubPersi stenceManager.java:452)
at org.jivesoftware.wildfire.pubsub.PubSubModule.initialize(PubSubModule.java:370)
at org.jivesoftware.wildfire.XMPPServer.initModules(XMPPServer.java:482)
at org.jivesoftware.wildfire.XMPPServer.start(XMPPServer.java:374)
at org.jivesoftware.wildfire.XMPPServer.(XMPPServer.java:147)
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:93)
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.install4j.runtime.Launcher.main(Unknown Source)
2006.12.27 07:10:43 org.jivesoftware.wildfire.pubsub.PubSubPersistenceManager.createNode(PubSubPersi stenceManager.java:224)
java.sql.SQLException: Table ‘‘Jabber.pubsubNode’’ doesn’'t exist
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2975)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1600)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1695)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3004)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1128)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1357)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1274)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1259)
at org.jivesoftware.wildfire.pubsub.PubSubPersistenceManager.createNode(PubSubPers istenceManager.java:218)
at org.jivesoftware.wildfire.pubsub.Node.saveToDB(Node.java:1693)
at org.jivesoftware.wildfire.pubsub.PubSubModule.initialize(PubSubModule.java:381)
at org.jivesoftware.wildfire.XMPPServer.initModules(XMPPServer.java:482)
at org.jivesoftware.wildfire.XMPPServer.start(XMPPServer.java:374)
at org.jivesoftware.wildfire.XMPPServer.(XMPPServer.java:147)
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:93)
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.install4j.runtime.Launcher.main(Unknown Source)
2006.12.27 07:10:43 org.jivesoftware.wildfire.pubsub.PubSubPersistenceManager.saveAffiliation(PubSub PersistenceManager.java:771)
java.sql.SQLException: Table ‘‘Jabber.pubsubAffiliation’’ doesn’'t exist
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2975)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1600)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1695)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3004)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1128)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1357)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1274)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1259)
at org.jivesoftware.wildfire.pubsub.PubSubPersistenceManager.saveAffiliation(PubSu bPersistenceManager.java:758)
at org.jivesoftware.wildfire.pubsub.Node.saveToDB(Node.java:1698)
at org.jivesoftware.wildfire.pubsub.PubSubModule.initialize(PubSubModule.java:381)
at org.jivesoftware.wildfire.XMPPServer.initModules(XMPPServer.java:482)
at org.jivesoftware.wildfire.XMPPServer.start(XMPPServer.java:374)
at org.jivesoftware.wildfire.XMPPServer.(XMPPServer.java:147)
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:93)
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.install4j.runtime.Launcher.main(Unknown Source)
2006.12.27 07:10:43 org.jivesoftware.wildfire.pubsub.PubSubPersistenceManager.saveSubscription(PubSu bPersistenceManager.java:891)
java.sql.SQLException: Table ‘‘Jabber.pubsubSubscription’’ doesn’'t exist
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2975)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1600)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1695)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3004)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1128)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1357)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1274)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1259)
at org.jivesoftware.wildfire.pubsub.PubSubPersistenceManager.saveSubscription(PubS ubPersistenceManager.java:850)
at org.jivesoftware.wildfire.pubsub.Node.saveToDB(Node.java:1702)
at org.jivesoftware.wildfire.pubsub.PubSubModule.initialize(PubSubModule.java:381)
at org.jivesoftware.wildfire.XMPPServer.initModules(XMPPServer.java:482)
at org.jivesoftware.wildfire.XMPPServer.start(XMPPServer.java:374)
at org.jivesoftware.wildfire.XMPPServer.(XMPPServer.java:147)
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:93)
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.install4j.runtime.Launcher.main(Unknown Source)
2006.12.27 07:10:49 org.jivesoftware.wildfire.container.PluginManager.loadPlugin(PluginManager.java: 467) Error loading plugin
java.lang.NoSuchFieldError: postgres
at org.jivesoftware.phone.database.HibernateUtil.getDialect(HibernateUtil.java:308 )
at org.jivesoftware.phone.database.HibernateUtil.getFullConfiguration(HibernateUti l.java:275)
at org.jivesoftware.phone.database.HibernateUtil.init(HibernateUtil.java:62)
at org.jivesoftware.phone.asterisk.AsteriskPlugin.init(AsteriskPlugin.java:100)
at org.jivesoftware.phone.asterisk.AsteriskPlugin.initializePlugin(AsteriskPlugin. java:92)
at org.jivesoftware.wildfire.container.PluginManager.loadPlugin(PluginManager.java :406)
at org.jivesoftware.wildfire.container.PluginManager.access$200(PluginManager.java :49)
at org.jivesoftware.wildfire.container.PluginManager$PluginMonitor.run(PluginManag er.java:907)
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
at java.util.concurrent.FutureTask$Sync.innerRunAndReset(Unknown Source)
at java.util.concurrent.FutureTask.runAndReset(Unknown Source)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$101 (Unknown Source)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.runPeriodi c(Unknown Source)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknow n Source)
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.12.27 07:10:49 org.jivesoftware.wildfire.container.PluginManager.loadPlugin(PluginManager.java: 467) Error loading plugin
java.lang.ClassNotFoundException: org.jivesoftware.wildfire.plugin.SearchPlugin
at java.net.URLClassLoader$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at org.jivesoftware.wildfire.container.PluginClassLoader.loadClass(PluginClassLoad er.java:156)
at org.jivesoftware.wildfire.container.PluginManager.loadPlugin(PluginManager.java :347)
at org.jivesoftware.wildfire.container.PluginManager.access$200(PluginManager.java :49)
at org.jivesoftware.wildfire.container.PluginManager$PluginMonitor.run(PluginManag er.java:907)
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
at java.util.concurrent.FutureTask$Sync.innerRunAndReset(Unknown Source)
at java.util.concurrent.FutureTask.runAndReset(Unknown Source)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$101 (Unknown Source)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.runPeriodi c(Unknown Source)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknow n Source)
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)
I’‘m not sure why it’‘s working now and didn’'t yesterday, but other than those errors it seems to be fine.
Thanks for your help!
Claud1e
Hi,
so it seems that Wildfire did fail to create some of the pubsub tables and pubsub may likely not work.
Once again a problem with one of these scripts, you may want to fix this error “Too big column length for column ‘‘contacts’’ (max = 255)” by looking for the definition of ‘‘contacts’’ in the update script.
Wildfire 2.6.2 is rather old … maybe it is (was) a known issue for mysql users who did upgrade.
LG