We just upgraded to Wildfire 3.1.1. I believe I also need to run scripts to make changes to the db schema. I can’'t seem to find anything in the installation guide in regards to doing the db upgrade. I see a folder “Program Files\Wildfire\resources\database\upgrade” and see multiple folders in here (1, 2, 3…). Do each of the database specific scripts from these folders need to be run (like wildfire_sqlserver.sql in our case)?
Thanks!
For most cases, you do not need to run the script as it will be done in the installation. Sometime the scripts has some problems. Do post again if you still cannot get it through
Hi,
Wildfire does run the updates automatically so there is no need to do this manually. The Wildfire update process is really easy for an administrator.
LG
I have run into this situation while upgrading to 3.1.1. My DB’'s did not get upgraded in MySQL. When I try to start the server I get errors about missing tables etc. Which directory am I supposed to use to upgrade the DB and what is the proper commend to run? Here is an excerpt from my error.log file:
2006.12.26 12:52:32 org.jivesoftware.wildfire.pubsub.PubSubPersistenceManager.loadDefaultConfigurati on(PubSubPersistenceManager.java:1099)
java.sql.SQLException: Table ‘‘Jabber.pubsubDefaultConf’’ doesn’'t exist
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.executeQuery(PreparedStatement.java:1030)
at org.jivesoftware.wildfire.pubsub.PubSubPersistenceManager.loadDefaultConfigurat ion(PubSubPersistenceManager.java:1072)
at org.jivesoftware.wildfire.pubsub.PubSubModule.initialize(PubSubModule.java:326)
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.install4j.runtime.Launcher.main(Unknown Source)
Thanks in advance,
Claud1e
Hi,
the scripts are in the /path_to_wildfire/resources/database/upgrade directory.
LG
It looks like there are 10 directories to choose from (1 - 10) in /path_to_wildfire/resources/database/upgrade, each with a script for MySQL. Which one am I to use?
Thanks,
Claud1e
Hi,
check the current version and apply then one script after the other.
You find the current version in table JIVEVERSION:
JIVEVERSION may contain “wildfire”, “8” - then you need to run the 9/ and the 10/ scripts.
LG
Excellent, thanks!
Regards,
Claud1e