|
From: Muzaffar M. <muz...@gm...> - 2019-09-20 06:41:51
|
Hi, I am to ask about on_event_start on_event_end on_movie_start on_movie_end configurations. Can we execute sql query on these like sql_query_start etc? On these we can give path of some script file it can be any script like php, python, perl or bash right? I want to save motion start time and motion end time in DB so what should be the best option or configuration for this? sql_query_stop(end of event) runs at-least one minute after sql_query_start(starting event) even though motion ends early. See in following logs. [1:ml1] [WRN] [DBL] [Sep 19 23:07:58] do_sql_query: Ignoring empty sql query [1:ml1] [NTC] [EVT] [Sep 19 23:07:58] event_newfile: File of type 8 saved to: value/0-01-20190919230758.mkv [1:ml1] [NTC] [ALL] [Sep 19 23:07:58] motion_detected: Motion detected - starting event 1 [1:ml1] [NTC] [ALL] [Sep 19 23:08:58] mlp_actions: End of event 1 [1:ml1] [WRN] [DBL] [Sep 19 23:10:11] do_sql_query: Ignoring empty sql query [1:ml1] [NTC] [EVT] [Sep 19 23:10:11] event_newfile: File of type 8 saved to: value/0-02-20190919231011.mkv [1:ml1] [NTC] [ALL] [Sep 19 23:10:11] motion_detected: Motion detected - starting event 2 [1:ml1] [NTC] [ALL] [Sep 19 23:11:11] mlp_actions: End of event 2 [1:ml1] [WRN] [DBL] [Sep 19 23:13:56] do_sql_query: Ignoring empty sql query [1:ml1] [NTC] [EVT] [Sep 19 23:13:56] event_newfile: File of type 8 saved to: value/0-03-20190919231356.mkv [1:ml1] [NTC] [ALL] [Sep 19 23:13:56] motion_detected: Motion detected - starting event 3 [1:ml1] [NTC] [ALL] [Sep 19 23:14:56] mlp_actions: End of event 3 [1:ml1] [WRN] [DBL] [Sep 19 23:15:23] do_sql_query: Ignoring empty sql query [1:ml1] [NTC] [EVT] [Sep 19 23:15:23] event_newfile: File of type 8 saved to: value/0-04-20190919231522.mkv [1:ml1] [NTC] [ALL] [Sep 19 23:15:23] motion_detected: Motion detected - starting event 4 [1:ml1] [NTC] [ALL] [Sep 19 23:16:23] mlp_actions: End of event 4 [1:ml1] [WRN] [DBL] [Sep 19 23:17:19] do_sql_query: Ignoring empty sql query [1:ml1] [NTC] [EVT] [Sep 19 23:17:19] event_newfile: File of type 8 saved to: value/0-05-20190919231719.mkv [1:ml1] [NTC] [ALL] [Sep 19 23:17:19] motion_detected: Motion detected - starting event 5 [1:ml1] [NTC] [ALL] [Sep 19 23:18:19] mlp_actions: End of event 5 [1:ml1] [WRN] [DBL] [Sep 19 23:18:26] do_sql_query: Ignoring empty sql query [1:ml1] [NTC] [EVT] [Sep 19 23:18:26] event_newfile: File of type 8 saved to: value/0-06-20190919231826.mkv [1:ml1] [NTC] [ALL] [Sep 19 23:18:26] motion_detected: Motion detected - starting event 6 [1:ml1] [NTC] [ALL] [Sep 19 23:19:26] mlp_actions: End of event 6 [1:ml1] [WRN] [DBL] [Sep 19 23:24:24] do_sql_query: Ignoring empty sql query [1:ml1] [NTC] [EVT] [Sep 19 23:24:24] event_newfile: File of type 8 saved to: value/0-07-20190919232424.mkv [1:ml1] [NTC] [ALL] [Sep 19 23:24:24] motion_detected: Motion detected - starting event 7 [1:ml1] [NTC] [ALL] [Sep 19 23:25:24] mlp_actions: End of event 7 [1:ml1] [WRN] [DBL] [Sep 19 23:27:12] do_sql_query: Ignoring empty sql query [1:ml1] [NTC] [EVT] [Sep 19 23:27:12] event_newfile: File of type 8 saved to: value/0-08-20190919232711.mkv [1:ml1] [NTC] [ALL] [Sep 19 23:27:12] motion_detected: Motion detected - starting event 8 [1:ml1] [NTC] [ALL] [Sep 19 23:28:12] mlp_actions: End of event 8 [1:ml1] [WRN] [DBL] [Sep 19 23:32:37] do_sql_query: Ignoring empty sql query [1:ml1] [NTC] [EVT] [Sep 19 23:32:37] event_newfile: File of type 8 saved to: value/0-09-20190919233236.mkv [1:ml1] [NTC] [ALL] [Sep 19 23:32:37] motion_detected: Motion detected - starting event 9 [1:ml1] [NTC] [ALL] [Sep 19 23:33:37] mlp_actions: End of event 9 [1:ml1] [WRN] [DBL] [Sep 19 23:33:39] do_sql_query: Ignoring empty sql query [1:ml1] [NTC] [EVT] [Sep 19 23:33:39] event_newfile: File of type 8 saved to: value/0-10-20190919233339.mkv [1:ml1] [NTC] [ALL] [Sep 19 23:33:39] motion_detected: Motion detected - starting event 10 [1:ml1] [NTC] [ALL] [Sep 19 23:34:39] mlp_actions: End of event 10 [1:ml1] [WRN] [DBL] [Sep 19 23:34:41] do_sql_query: Ignoring empty sql query [1:ml1] [NTC] [EVT] [Sep 19 23:34:41] event_newfile: File of type 8 saved to: value/0-11-20190919233441.mkv [1:ml1] [NTC] [ALL] [Sep 19 23:34:41] motion_detected: Motion detected - starting event 11 [1:ml1] [NTC] [ALL] [Sep 19 23:35:41] mlp_actions: End of event 11 [1:ml1] [WRN] [DBL] [Sep 19 23:35:41] do_sql_query: Ignoring empty sql query [1:ml1] [NTC] [EVT] [Sep 19 23:35:41] event_newfile: File of type 8 saved to: value/0-12-20190919233540.mkv [1:ml1] [NTC] [ALL] [Sep 19 23:35:41] motion_detected: Motion detected - starting event 12 [1:ml1] [NTC] [ALL] [Sep 19 23:36:41] mlp_actions: End of event 12 Thanks |