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
