powered by Jive Software

Jiveprivacylist error after upgrading to 2.5.0, postgres

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

Yes, you should run that script. It only adds a few things, so its safe.