config

• openfire 3.4.3

• packet filter 2.0

• postgresql 7.4.17 (debian etch)

• java 1.5.0_10 (debian etch)

symptoms

• gui will allow the addition of rules, but will not display them (because they were not successfully added to the database)

• no gui error message

• error log exception excerpts:

2008.01.09 12:26:46 [org.jivesoftware.openfire.plugin.rules.DbRuleManager.addRule(DbRuleManager.jav a:249)]
org.postgresql.util.PSQLException: ERROR: column "disabled" is of type boolean but expression is of type smallint

2008.01.09 12:49:24 [org.jivesoftware.openfire.plugin.rules.DbRuleManager.addRule(DbRuleManager.jav a:249)]
org.postgresql.util.PSQLException: ERROR: column "log" is of type boolean but expression is of type smallint

i can send full exception backtraces if necessary.

solution

change the columns from boolean to smallint in postgresql.

schema patch attached (though i haven't actually used it as i simply dropped and readded the affected columns as smallint).

thanks for the packet filter plugin!