AnsweredAssumed Answered

Cannot create Packet Filter rules

Question asked by nbrowning on Sep 16, 2009
Latest reply on Oct 5, 2009 by natep

When I attempt to create a PacketFilter rule (fill in the form and click Create Rule) nothing happens, it just takes me back to the empty list of Packet Filter rules and I get this in my error log.  I noticed that the INSERT statement has ?s for values.

Any thoughts from anyone?

 

[EDIT]

Is there a way to create rules by inserting SQL directly?  If so what values do I need to enter?  I'd like one rule to allow a group to send messages to all and then another rule to reject messages from all to all.

 

2009.09.16 14:12:04 [org.jivesoftware.openfire.plugin.rules.DbRuleManager.addRule(DbRuleManager.jav a:253)
]                  
java.sql.SQLException: Attempt to insert null into a non-nullable column: column: ID table: OFPFRULES in statement [INSERT INTO ofPfRules(ruleorder,type,tojid,fromjid,rulef,disabled,log,description,sourcetyp e,desttype) VALUES(?,?,?,?,?,?,?,?,?,?)]         
at org.hsqldb.jdbc.Util.throwError(Unknown Source)                 
at org.hsqldb.jdbc.jdbcPreparedStatement.execute(Unknown Source)                 
at sun.reflect.GeneratedMethodAccessor47.invoke(Unknown Source)                 
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)                 
at java.lang.reflect.Method.invoke(Unknown Source)                 
at org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:100)                  
at org.logicalcobwebs.proxool.ProxyStatement.intercept(ProxyStatement.java:57)                  
at $java.sql.Statement$$EnhancerByProxool$$ae0a4a06.execute(<generated>)                  
at org.jivesoftware.openfire.plugin.rules.DbRuleManager.addRule(DbRuleManager.java :248)
at org.jivesoftware.openfire.plugin.rules.DbRuleManager.addRule(DbRuleManager.java :207)
at org.jivesoftware.openfire.plugin.rules.RuleManagerProxy.addRule(RuleManagerProx y.java:34)
at org.jivesoftware.openfire.plugin.packetFilter.rule_002dform_jsp._jspService(rul e_002dform_jsp.java:192)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)                  
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)                 
at org.jivesoftware.openfire.container.PluginServlet.handleJSP(PluginServlet.java: 229)
at org.jivesoftware.openfire.container.PluginServlet.service(PluginServlet.java:87 )
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)                 
at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:487)                  
at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.ja va:1093)                 
at org.jivesoftware.admin.PluginFilter.doFilter(PluginFilter.java:70)
at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.ja va:1084)                 
at org.jivesoftware.admin.AuthCheckFilter.doFilter(AuthCheckFilter.java:146)
at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.ja va:1084)                 
at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:11 8)                 
at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:52)                  
at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.ja va:1084)                 
at org.jivesoftware.util.LocaleFilter.doFilter(LocaleFilter.java:66)
at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.ja va:1084)                 
at org.jivesoftware.util.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingF ilter.java:42)
at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.ja va:1084)                 
at org.jivesoftware.admin.PluginFilter.doFilter(PluginFilter.java:70)
at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.ja va:1084)                 
at org.jivesoftware.admin.AuthCheckFilter.doFilter(AuthCheckFilter.java:146)
at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.ja va:1084)                 
at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:360)                  
at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)                  
at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)                  
at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:726)                  
at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:405)                  
at org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHandlerCollect ion.java:206)                 
at org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:114)                  
at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)                  
at org.mortbay.jetty.Server.handle(Server.java:324)                 
at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:505)                  
at org.mortbay.jetty.HttpConnection$RequestHandler.headerComplete(HttpConnection.j ava:829)                 
at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:514)                 
at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:211)                  
at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:380)                  
at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:395)                  
at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:488)

 

Message was edited by: nbrowning

Outcomes