Which platform/installer is this? Thanks, Matt Ray Zenoss Community Manager community.zenoss.com [email protected]
On Feb 9, 2009, at 1:38 AM, mura wrote: > my zenaction.log: > >> >> 2009-02-08 04:02:18 INFO zen.ZenActions: Processed 0 commands in >> 0.000042 >> 2009-02-08 04:02:18 WARNING zen.ZenActions: SELECT >> firstTime,component,device)s% >> (ipAddress,summary,device,message,ipAddress,severity >> ,summary, evid FROM status WHERE (prodState = 1000) and (eventState >> = 0) and (severity >= 4) and (systems like '%|/mail%') AND evid >> NOT IN (SELECT evid FROM alert_state WHERE userid='mailadmin' >> AND rule='[email protected]' ) >> 2009-02-08 04:02:18 ERROR zen.ZenActions: action:[email protected] >> Traceback (most recent call last): >> File "/opt/zenoss/Products/ZenEvents/zenactions.py", line 220, in >> processRules >> self.processEvent(zem, ar, actfunc) >> File "/opt/zenoss/Products/ZenEvents/zenactions.py", line 246, in >> processEvent >> for result in self.query(q): >> File "/opt/zenoss/Products/ZenEvents/zenactions.py", line 182, in >> query >> curs.execute(stmt) >> File "/opt/zenoss/lib/python/MySQLdb/cursors.py", line 137, in >> execute >> self.errorhandler(self, exc, value) >> File "/opt/zenoss/lib/python/MySQLdb/connections.py", line 33, in >> defaulterrorhandler >> raise errorclass, errorvalue >> ProgrammingError: (1064, "You have an error in your SQL syntax; >> check the manual that corresponds to your MySQL server version for t >> he right syntax to use near ')s% >> (ipAddress,summary,device,message,ipAddress,severity,summary, evid >> FROM statu' at line 1") >> 2009-02-08 04:02:18 WARNING zen.ZenActions: SELECT >> firstTime,ipAddress)s% >> (summary,component,summary,device,message,ipAddress,severit >> y,summary, evid FROM status WHERE (prodState = 1000) and >> (eventState = 0) and (severity >= 4) and (systems like '%|/mail%') >> AND evid >> NOT IN (SELECT evid FROM alert_state WHERE userid='mailadmin' >> AND rule='[email protected]' ) >> > > > > > > -------------------- m2f -------------------- > > Read this topic online here: > http://forums.zenoss.com/viewtopic.php?p=31073#31073 > > -------------------- m2f -------------------- > > > > _______________________________________________ > zenoss-users mailing list > [email protected] > http://lists.zenoss.org/mailman/listinfo/zenoss-users _______________________________________________ zenoss-users mailing list [email protected] http://lists.zenoss.org/mailman/listinfo/zenoss-users
