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.java: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.java: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!
packetfilter_postgresql.sql.patch (460 Bytes)