Court Harris
2012-10-09 15:57:02 UTC
Court Harris [http://community.zenoss.org/people/courtneyjh] created the discussion
"Event commands in Core 4 problems"
To view the discussion, visit: http://community.zenoss.org/message/68919#68919
--------------------------------------------------------------
I am having a problem getting event commands to work in Core 4. I have successfully created a trigger and linked it to an email notification which works flawlessly. Now I am trying to take that same trigger and apply it to an event command using iSQL to update a monitor log database we use. The command text works fine from the command line terminal, but when placed inside the Zenoss event command and linked to the trigger I only get an error email sent saying it is unable to execute:
System Failure - Error executing action Command.
The command text includes the following:
isql -v data sa 1234
use DMBugLog
insert into servererrors VALUES ('2010-10-7', '1234', 'testing', '1')
I am sure I am missing something regarding using an elevated user at the command line or something of that matter, but I am unable to find any documentation outside of the basic Core 4 admin documentation which isn't very thorough on this subject. Has anyone ever accomplished something like this in Core 4? The command above is just a sample. I need to be able to use iSQL to update our servererrors table with the device and datestamp of the event when it occurs.
Any advice is greatly appreciated as I am pretty stuck on this now.
--------------------------------------------------------------
Reply to this message by replying to this email -or- go to the discussion on Zenoss Community
[http://community.zenoss.org/message/68919#68919]
Start a new discussion in zenoss-users by email
[discussions-community-forums-zenoss--***@community.zenoss.org] -or- at Zenoss Community
[http://community.zenoss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2003]
"Event commands in Core 4 problems"
To view the discussion, visit: http://community.zenoss.org/message/68919#68919
--------------------------------------------------------------
I am having a problem getting event commands to work in Core 4. I have successfully created a trigger and linked it to an email notification which works flawlessly. Now I am trying to take that same trigger and apply it to an event command using iSQL to update a monitor log database we use. The command text works fine from the command line terminal, but when placed inside the Zenoss event command and linked to the trigger I only get an error email sent saying it is unable to execute:
System Failure - Error executing action Command.
The command text includes the following:
isql -v data sa 1234
use DMBugLog
insert into servererrors VALUES ('2010-10-7', '1234', 'testing', '1')
I am sure I am missing something regarding using an elevated user at the command line or something of that matter, but I am unable to find any documentation outside of the basic Core 4 admin documentation which isn't very thorough on this subject. Has anyone ever accomplished something like this in Core 4? The command above is just a sample. I need to be able to use iSQL to update our servererrors table with the device and datestamp of the event when it occurs.
Any advice is greatly appreciated as I am pretty stuck on this now.
--------------------------------------------------------------
Reply to this message by replying to this email -or- go to the discussion on Zenoss Community
[http://community.zenoss.org/message/68919#68919]
Start a new discussion in zenoss-users by email
[discussions-community-forums-zenoss--***@community.zenoss.org] -or- at Zenoss Community
[http://community.zenoss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2003]