Packetfilter Plugin Errors

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( 1316)+

  • at org.postgresql.core.v3.QueryExecutorImpl.execute(

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…


Looks like you are running into a known issue. This problem has been fixed in 2.0.2, for a work around please see :



That seemed to do the trick. Thank you much.