Hi All
I’m using mysql 4.0 with openfire3.6.3 and packet filter 2.0.2. I installed the packetfilter plugin and ran the sql file that came with it to create the table. I got an error that there is an sql syntax error near boolean. This is the sql file:
CREATE TABLE ofPfRules (
id BIGINT NOT NULL AUTO_INCREMENT,
ruleorder BIGINT ,
type varchar(255) ,
tojid varchar(255) ,
fromjid varchar(255) ,
rulef varchar(255) ,
disabled boolean,
log boolean,
description varchar(255),
sourcetype varchar(255),
desttype varchar(255),
PRIMARY KEY (id)
);
INSERT INTO ofVersion(name,version) values(‘packetfilter’,2);
When I add a rule, nothing happens.
When I tried changing lines 8 and 9 to:
disabled ENUM(‘true’,‘false’),
log ENUM(‘true’,‘false’),
it ran without error and I could now add rules etc. but I cannot get logging to work.
Any help would be appreciated.