powered by Jive Software

Postgresql table schema: boolean -> smallint

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)

Thanks for the fix. I’ll roll it into the next version.

-Nate