The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
0answers
4 views

Why/when does creating a mysql trigger require SUPER privileges? [migrated]

I'm attempting to parse and understand what the MySQL doc says about when SUPER privileges are required for creating triggers. They say: If binary logging is enabled, CREATE TRIGGER might require ...
1
vote
1answer
55 views

Zabbix - Create Trigger that parse the time in a file

I have a file that is written on each of my Zabbix clients with a time inside of it every hour. I need the Zabbix server(s) to check these files and alert if the time is at least 6 hours old. I ...
4
votes
1answer
495 views

Windows service trigger start - difference manual vs automatic?

Since Windows Server 2008 R2 (and Windows 7 I think for the client OS) Microsoft has introduced trigger start for services. I do understand difference between automatic, automatic (delayed) and manual ...
0
votes
1answer
352 views

How to check that a process is running on windows with zabbix

What would be the correct way to test that a specific process* is running on a host machine running Windows 7 that is connected to zabbix server? After reading a bit I understood using the proc_info ...
0
votes
1answer
205 views

Why are changing Zabbix's triggers status to unknown?

In zabbix I have an item which i create some triggers for that on below conditions: {Server Template:mysql.slowqueries.last(0,1800)}>{Server Template:mysql.slowqueries.last(0)} {Server ...
0
votes
1answer
606 views

how to get zabbix item values in two different time for trigger?

For monitoring some database servers parameters (NOT ZABBIX self), In zabbix I need to create a trigger for checking an item value at every 15 minute and run if the last retrieve value is increase or ...
1
vote
1answer
62 views

Trigger actions automatically when package is installed or user is added

When installing mysql-server on Debian Wheezy, the user "mysql" is created without a home directory. In my setup, directly after MySQL was installed, a new task is performed which relies on the mysql ...
1
vote
1answer
130 views

Asterisk - Trigger when an extension becomes reachable/unreachable

We have people in our office that use softphones to connect to our Asterisk system. The softphones are online when they are in the office, and offline when they are not. So the Reachable/UNREACHABLE ...
2
votes
0answers
21 views

How can I compare a stat in a trigger with a stat on a different host in Zabbix?

I am tracking servers which have users on through zabbix and I want to make a trigger go off when there are more than double the users on the most full server than the least full server (I basically ...
0
votes
1answer
256 views

Why do multiple time-based triggers on scheduled task not work as expected?

I have a problem with a task in Windows Task Scheduler on Windows Server 2008 R2 (German): A task has multiple (here: two) time based triggers. The first trigger is of the weekly type (a fixed time ...
1
vote
1answer
1k views

Zabbix monitor http service with simple check

How can I add trigger, or to be correct .. how should trigger look like, for net.tcp.service[http,80] so it would sound alarm if http is down longer than minute or two. I know that I can set ...
1
vote
2answers
1k views

How can I create a daily task that repeats every 15 mins EXCEPT between the hours of 12AM - 2AM?

Is it possible to create a scheduled task that runs every 15 min except for a few hours of the day. E.g. A task that runs every 15 minutes except between the hours of 2PM & 4PM. The reason I ...
0
votes
1answer
85 views

Do database triggers have performance impact on overall database functioning?

I have a trigger defined on a table, which for every insert, update or delete, will populate another table. Will this have any performance impact on the overall database functioning? Are there any ...
0
votes
4answers
158 views

Calling a specific URL daily

I need that every night at 2:00 am a call to a specific URl is made. For this reason, I inserted in the cronotab services the following: crontab -e 0 2 * * * wget -q -0 - "http://MYWEBSITE" But ...
1
vote
0answers
652 views

Where are task scheduler event files stored on Windows Server 2008?

I tried setting up triggers in Task Scheduler Windows Server 2008, but Microsoft needs to fix a bug that I documented on Stack Overflow. So I can't use triggers until they fix this bug. Basically ...
0
votes
1answer
80 views

Should i disable triggers when force reinstalling packages in ubuntu (to repair corrupted exectables)

I want to reinstall some selected packages on my ubuntu server (lucid). I'm planning on running cat packages.txt | xargs apt-get --reinstall install to restore some executables I think may have become ...
0
votes
1answer
255 views

How to trigger a SQL Agent Job from a client PC

I have SQL Agent job that is automated that a non SQL Admin user may need to occasionaly run. I know I can trigger a SQL Agent Job via sp_execute_job. Can anyone tell me where to find what I need ...
0
votes
1answer
571 views

postgresql trigger for updating multiple columns

i have a column in a certain table that i want to match to a column in a different table in a postgresql database, so i tried creating a trigger that could accomplish that: CREATE OR REPLACE FUNCTION ...
2
votes
2answers
2k views

Understanding Zabbix Triggers

I have zabbix set with an item to monitor a log file on a zabbix client: log["/var/log/program_name/client.log","ERROR:","UTF-8",100] And a trigger to determine when that log file get's more ...
0
votes
3answers
215 views

Trigger linux command using external web service

I am looking at different options of triggering linux command on NATed box that has internet access. I know that I could use combination of IMAP box in DMZ, send email to that box and then use como of ...
1
vote
1answer
1k views

trigger and dblink

im working on a trigger in PL/TCL that inserts data into tableB on databaseB upon insertion on tableA from databaseA. both databases are on the same server. i came up with this: CREATE OR REPLACE ...
2
votes
2answers
414 views

MSSQL 2005 Trigger Behavior

I'm wondering how a trigger on a table behaves in SQL Server in response to an uncommitted transaction affecting that table if the trigger is specified to fire AFTER UPDATE. If the transaction hasn't ...
0
votes
1answer
79 views

SQL Server 2005 inserting null when value hard coded

I have a stored proc that creates an entery in a table. INSERT INTO tbl_CaseDetails ( Case_Id , Client_Id , Client_HO_Id , Client_Case_Ref ...
1
vote
1answer
281 views

trigger port forwarding from terminal

I've set up a port triggering rule to listen for activity on port 5016 (arbitrary choice) and forward port 80 to port 80. As far as I'm aware, this has been set up correctly. How can I activate the ...
3
votes
1answer
3k views

Is a MySQL stored procedure able to insert/update to a remote backup MySQL server?

Is it possible to create a MySQL stored procedure that can execute a given insert or update and then also have it connect to a 2nd server and run the same commands? I want to basically call one server ...
0
votes
1answer
63 views

Hudson intermittently doesn't trigger jobs

I have a hudson 1.370 setup running on Windows 2003 R2 under a VMware VM, with ~30 jobs, some of them triggered on a cron job, and some triggered on a URL change. Most of the time, everything works ...
2
votes
2answers
181 views

How can records be deleted without activating the delete trigger?

Since about a month we are experiencing records that are disappearing from our database without any reason. (part of) Our database structure is at http://i.stack.imgur.com/i15nG.png Now users and ...
1
vote
1answer
714 views

importing a mysqldump file does not import triggers due to some permission problems

Whenever I try to import a mysqldump export on another server, the triggers are never created, and if I remember correctly, I get an error messages that super user permission is required. IF I remove ...
0
votes
4answers
557 views

is there some sort of catchable trigger when one writes/deletes a new file in linux?

I would like a simple tool for syncing two folders on remote servers... Utopically, I only need an OS catchable trigger (or something like that) that could be used to fire rsync automatically ? Is ...
1
vote
1answer
428 views

SQL Server 2005 - Deny DROP TRIGGER permissions

We have a custom trigger on a 3rd party app table to help us audit changes. Occasionally that trigger is removed. Looking thru the traces it shows that the 3rd party app is dropping it (for no good ...
0
votes
1answer
943 views

How do I disable trigger that killed SQL access?

http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/f9236131-cfcc-48ed-b431-57884842e874/ I needed to limit access to Sql Mgt Studio for certain users. I found the article above ...
1
vote
2answers
9k views

Disconnecting an Oracle Session from a Logon Trigger

I'm trying to construct an Oracle 11g logon trigger that restricts access for a specific user to a known list of applications. For example, user SCOTT can only connect with MYAPP.EXE. I believe I ...