I am running Openfire 3.5.2 wth a PostgreSQL backend. I have been trying to get the PacketFilter (2.0.1) to work with my setup. The plugin says that it’s installed properly but when I try to create new rules (click on “Create rule”), nothing shows up when it’s “done”. I continue to have an empty rules list. When I look the Openfire log, error.log, I see the following:
2008.06.25 10:32:50 [org.jivesoftware.openfire.plugin.rules.DbRuleManager.addRule(DbRuleManager.jav a:252)
org.postgresql.util.PSQLException: ERROR: column “disabled” is of type boolean but expression is of type smallint
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl .java:1548)+
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java: 1316)+
when I look at Info.log, I get:
2008.06.25 10:29:27 Openfire 3.5.2
2008.06.25 10:29:36 Admin console listening at:
2008.06.25 10:29:40 Found old database version 0 for packetfilter. Upgrading to version 1…
2008.06.25 10:29:41 Database update successful.
2008.06.25 10:29:41 Packet Filter loaded…
2008.06.25 10:29:43 Started server (unencrypted) socket on port: 5269
2008.06.25 10:29:43 Started plain (unencrypted) socket on port: 5222
2008.06.25 10:29:43 Started SSL (encrypted) socket on port: 5223
Anyone have a sample of Packetfilter rules as the appear in the database table (pfrules)? Or perhaps explain the boolean value error I show in my first snippet above if possible?
Thanks in advance…