I upgraded from wildfire 2.4.2 (maybe 2.4.1) to 2.5.0. I use postgres 8.0 as the backend, on SuSE 10.0.
When I login with gajim 0.9.1 I get the following error:
org.jivesoftware.wildfire.privacy.PrivacyListProvider.loadDefaultPrivacyList(Pri vacyListProvider.java:168) Error loading default privacy list of username: andrew.diederich
org.postgresql.util.PSQLException: ERROR: relation “jiveprivacylist” does not exist
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl .java:1512)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java: 1297)
I do not see a jiveprivacylist table in the db:
wildfire=# \d
List of relations
Schema | Name | Type | Owner
*----
*-----+–
public | jiveextcomponentconf | table | andrew
public | jivegroup | table | andrew
public | jivegroupprop | table | andrew
public | jivegroupuser | table | andrew
public | jiveid | table | andrew
public | jiveoffline | table | andrew
public | jiveprivate | table | andrew
public | jiveproperty | table | andrew
public | jiveremoteserverconf | table | andrew
public | jiveroster | table | andrew
public | jiverostergroups | table | andrew
public | jiveuser | table | andrew
public | jiveuserprop | table | andrew
public | jivevcard | table | andrew
public | jiveversion | table | andrew
public | mucaffiliation | table | andrew
public | mucconversationlog | table | andrew
public | mucmember | table | andrew
public | mucroom | table | andrew
public | mucroomprop | table | andrew
(20 rows)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java :430)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2State ment.java:346)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement .java:250)
at org.jivesoftware.wildfire.privacy.PrivacyListProvider.loadDefaultPrivacyList(Pr ivacyListProvider.java:159)
at org.jivesoftware.wildfire.privacy.PrivacyListManager.getDefaultPrivacyList(Priv acyListManager.java:105)
at org.jivesoftware.wildfire.IQRouter.handle(IQRouter.java:232)
at org.jivesoftware.wildfire.IQRouter.route(IQRouter.java:94)
at org.jivesoftware.wildfire.PacketRouter.route(PacketRouter.java:65)
at org.jivesoftware.wildfire.net.SocketReader.processIQ(SocketReader.java:394)
at org.jivesoftware.wildfire.net.SocketReader.readStream(SocketReader.java:262)
at org.jivesoftware.wildfire.net.SocketReader.run(SocketReader.java:119)
at java.lang.Thread.run(Unknown Source)
I installed both the original 2.4 wildfire, and the upgrade, with the rpm.
Basically it looks like wildfire_postgresql.sql didn’‘t run at all in the /resources/database/upgrade/2.4_to_2.5 directory. The database says I’'m still on 2.4.
wildfire=# select * from jiveVersion;
majorversion | minorversion
±—
2 | 4
Should I just run the sql file and call it good? It looks like the only db changes are updating the jiveVersion table, adding the jivePrivacyList table, and adding an index for it.
–
andrewdied