Re: [opennms-devel] Matching against NULL nodesysoid in categories.xml

Which version?
1.5.94 and earlier had a known problem with this
1.6 in SVN has an updated filter parser that should work (I think)

On Thu, Aug 07, 2008 at 01:04:59PM +0100, Alex Bennee wrote:
> I want to create a category for things that don't have a sysobjid
> associated with them. However the following creates a bad exception on
> startup:
> 
> Caused by: java.lang.reflect.UndeclaredThrowableException
>         at org.opennms.netmgt.dao.support.JdbcFilterDao.getIPList(JdbcFilterDao.java:290)
>         at org.opennms.netmgt.rtc.DataManager$RTCNodeProcessor.catConstructIpAddrs(DataManager.java:175)
>         at org.opennms.netmgt.rtc.DataManager$RTCNodeProcessor.catGetIpAddrs(DataManager.java:163)
>         at org.opennms.netmgt.rtc.DataManager$RTCNodeProcessor.catContainsIp(DataManager.java:156)
>         at org.opennms.netmgt.rtc.DataManager$RTCNodeProcessor.catContainsIfService(DataManager.java:152)
>         at org.opennms.netmgt.rtc.DataManager$RTCNodeProcessor.processIfService(DataManager.java:134)
>         at org.opennms.netmgt.rtc.DataManager$RTCNodeProcessor.processKey(DataManager.java:122)
>         at org.opennms.netmgt.rtc.DataManager$RTCNodeProcessor.processRow(DataManager.java:115)
>         at org.springframework.jdbc.core.JdbcTemplate$RowCallbackHandlerResultSetExtractor.extractData(JdbcTemplate.java:1249)
>         at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:600)
>         at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:538)
>         at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:588)
>         at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:617)
>         at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:633)
>         at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:641)
>         at org.opennms.netmgt.rtc.DataManager.populateNodesFromDB(DataManager.java:360)
>         at org.opennms.netmgt.rtc.DataManager.<init>(DataManager.java:406)
>         at org.opennms.netmgt.rtc.RTCManager.onInit(RTCManager.java:513)
>         ... 25 more
> Caused by: org.opennms.netmgt.filter.FilterParseException: Parse error in rule '(IPADDR != '0.0.0.0') & ((nodeSysOID is NULL | nodeSysOID == ''))': java.io.IOException: Pushback buffer overflow
>         at org.opennms.netmgt.dao.support.JdbcFilterDao.parseRule(JdbcFilterDao.java:353)
>         at org.opennms.netmgt.dao.support.JdbcFilterDao.getSQLStatement(JdbcFilterDao.java:367)
>         at org.opennms.netmgt.dao.support.JdbcFilterDao.getIPList(JdbcFilterDao.java:259)
>         ... 42 more
> 
> If I change the rule (or rather NULL to null) to:
> 
>  <rule><![CDATA[(nodeSysOID is null | nodeSysOID == '')]]></rule>
> 
> It starts up but doesn't match anything. Is this just the validator
> getting it's knickers in a twist?
> 
> 
> -- 
> Alex Bennee, Software Engineer
> UFOs are for real: the Air Force doesn't exist.
> 
> 
> -------------------------------------------------------------------------
> This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
> Build the coolest Linux based applications with Moblin SDK & win great prizes
> Grand prize is a trip for two to an Open Source event anywhere in the world
> http://moblin-contest.org/redirect.php?banner_id=100&url=/
> _______________________________________________
> Please read the OpenNMS Mailing List FAQ:
> http://www.opennms.org/index.php/Mailing_List_FAQ
> 
> opennms-devel mailing list
> 
> To *unsubscribe* or change your subscription options, see the bottom of this page:
> https://lists.sourceforge.net/lists/listinfo/opennms-devel
> 

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Please read the OpenNMS Mailing List FAQ:
http://www.opennms.org/index.php/Mailing_List_FAQ

opennms-devel mailing list

To *unsubscribe* or change your subscription options, see the bottom of this page:
https://lists.sourceforge.net/lists/listinfo/opennms-devel