search

Motion-Project / motion

Motion, a software motion detector. Home page: https://motion-project.github.io/
GNU General Public License v2.0
3.67k stars 549 forks source link

mysql (mariadb) filename conversion specifier '%f' not available in sql_query_start #884

Closed ipyakuza closed 2 years ago

ipyakuza commented 5 years ago

Version: 4.2.1+git20181209-7bd179c (built from scratch) Video Stream: rtsp (Lorex IP Camera) Hardware: X86 OS: ArchLinux x86_64 latest updates

Running MariaDB (mysql fork) and attempting to insert/update a recording table:

CREATE TABLE recordings (id BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY, camera_id VARCHAR(6), camera_name VARCHAR(32), filename VARCHAR(256), width INT, height INT, fps INT, start_time DATETIME, end_time DATETIME, event VARCHAR(16));

Query for 'sql_query_start': sql_query_start INSERT INTO recordings (camera_id, camera_name, filename, width, height, fps, start_time, event) VALUES ('%t', '%$', "%f", '%w', '%h', '%{fps}', '%Y-%m-%d %H:%M:%S', '%v')

Query for 'sql_query_stop': sql_query_stop UPDATE recordings SET end_time = '%Y-%m-%d %H:%M:%S' WHERE filename = "%f"

SQL RESULTS:

MariaDB [sec]> SELECT * FROM recordings LIMIT 10;
+----+-----------+-------------+----------+-------+--------+------+---------------------+----------+-------+
| id | camera_id | camera_name | filename | width | height | fps  | start_time          | end_time | event |
+----+-----------+-------------+----------+-------+--------+------+---------------------+----------+-------+
|  1 | 1         | Front Door  | NULL     |  1920 |   1080 |    0 | 2019-01-09 20:08:01 | NULL     | 01    |
|  2 | 1         | Front Door  | NULL     |  1920 |   1080 |    2 | 2019-01-09 20:12:12 | NULL     | 02    |
|  3 | 1         | Front Door  | NULL     |  1920 |   1080 |    2 | 2019-01-09 20:14:17 | NULL     | 03    |
|  4 | 1         | Front Door  | NULL     |  1920 |   1080 |    2 | 2019-01-09 20:14:40 | NULL     | 04    |
|  5 | 1         | Front Door  | NULL     |  1920 |   1080 |    2 | 2019-01-09 20:17:34 | NULL     | 05    |
|  6 | 1         | Front Door  | NULL     |  1920 |   1080 |    2 | 2019-01-09 20:19:39 | NULL     | 06    |
|  7 | 1         | Front Door  |          |  1920 |   1080 |    0 | 2019-01-09 20:21:06 | NULL     | 01    |
|  8 | 1         | Front Door  |          |  1920 |   1080 |    2 | 2019-01-09 20:21:54 | NULL     | 02    |
|  9 | 1         | Front Door  |          |  1920 |   1080 |    0 | 2019-01-09 20:27:45 | NULL     | 01    |
| 10 | 1         | Front Door  |          |  1920 |   1080 |    2 | 2019-01-09 20:28:52 | NULL     | 02    |
+----+-----------+-------------+----------+-------+--------+------+---------------------+----------+-------+
10 rows in set (0.00 sec)

ISSUE: The results show the first 6 entries were NULL only because I wasn't inserting the filename at the time. From rows 7 onward the conversion specifier '%f' doesn't seem to be outputting a value (or if it is its just a blank since it's not coming through as NULL). I read the docs and it was noted could use '' or "" around values both yield the same results. Expected result is the absolute path to the recording filename. My target as defined by my configuration is: target_dir /sec/media/cameras/frontdoor which works as recordings work just fine. As for the path itself it's a an external USB hard drive (formatted as ext4) mounted to /sec/media.

tosiara commented 5 years ago

Do you have a corresponding motion log?

ipyakuza commented 5 years ago

I do sorry forgot to post it this morning. This was run at log level 7:

Jan 10 06:12:13 scout audit[1]: SERVICE_START pid=1 uid=0 auid=4294967295 ses=4294967295 msg='unit=motion comm="systemd" exe="/usr/lib/systemd/systemd" hostname=? addr=? terminal=? res=success'
Jan 10 06:12:13 scout kernel: audit: type=1130 audit(1547129533.343:98): pid=1 uid=0 auid=4294967295 ses=4294967295 msg='unit=motion comm="systemd" exe="/usr/lib/systemd/systemd" hostname=? addr=? terminal=? res=success'
Jan 10 06:12:13 scout motion[12268]: [0:motion] [NTC] [ALL] conf_load: Processing thread 0 - config file /sec/etc/motion/motion.conf
Jan 10 06:12:13 scout motion[12268]: [0:motion] [NTC] [ALL] conf_load: Processing thread 0 - config file /sec/etc/motion/motion.conf
Jan 10 06:12:13 scout motion[12268]: [0:motion] [NTC] [ALL] config_camera: Processing camera config file /sec/etc/motion/frontdoor.conf
Jan 10 06:12:13 scout motion[12268]: [0:motion] [NTC] [ALL] motion_startup: Logging to syslog
Jan 10 06:12:13 scout motion[12268]: [0:motion] [NTC] [ALL] motion_startup: Motion 4.2.1+git20181209-7bd179c Started
Jan 10 06:12:13 scout motion[12268]: [0:motion] [NTC] [ALL] motion_startup: Using default log type (ALL)
Jan 10 06:12:13 scout motion[12268]: [0:motion] [NTC] [ALL] motion_startup: Using log type (ALL) log level (INF)
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] conf_output_parms: Writing configuration parameters from all files (2):
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] Thread 0 - Config file: /sec/etc/motion/motion.conf
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] daemon                    off
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] setup_mode                off
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] pid_file
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] log_file
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] log_level                 7
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] log_type                  ALL
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] quiet                     on
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] native_language           on
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] camera_name
Jan 10 06:12:13 scout motion[12268]: [0:motion] [NTC] [ALL] config_camera: Processing camera config file /sec/etc/motion/frontdoor.conf
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] camera_id                 0
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] target_dir                /sec/media
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] videodevice               /dev/video0
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] vid_control_params
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] v4l2_palette              17
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] input                     -1
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] norm                      0
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] frequency                 0
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] auto_brightness           0
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] tunerdevice
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] roundrobin_frames         1
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] roundrobin_skip           1
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] roundrobin_switchfilter   off
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] netcam_url
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] netcam_highres
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] netcam_userpass
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] netcam_keepalive          off
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] netcam_proxy
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] netcam_tolerant_check     off
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] netcam_use_tcp            on
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] mmalcam_name
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] mmalcam_control_params
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] width                     640
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] height                    480
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] framerate                 15
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] minimum_frame_time        0
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] rotate                    0
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] flip_axis                 none
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] locate_motion_mode        off
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] locate_motion_style       box
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] text_left
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] text_right                %Y-%m-%d\n%T
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] text_changes              off
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] text_scale                1
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] text_event                %Y%m%d%H%M%S
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] emulate_motion            off
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] threshold                 1500
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] threshold_maximum         0
Jan 10 06:12:13 scout motion[12268]: [0:motion] [NTC] [ALL] motion_startup: Logging to syslog
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] threshold_tune            off
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] noise_level               32
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] noise_tune                on
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] despeckle_filter
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] area_detect
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] mask_file
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] mask_privacy
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] smart_mask_speed          0
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] lightswitch_percent       0
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] lightswitch_frames        5
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] minimum_motion_frames     1
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] event_gap                 60
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] pre_capture               0
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] post_capture              0
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] on_event_start
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] on_event_end
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] on_picture_save
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] on_area_detected
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] on_motion_detected
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] on_movie_start
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] on_movie_end
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] on_camera_lost
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] on_camera_found
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] picture_output            off
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] picture_output_motion     off
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] picture_type              jpeg
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] picture_quality           75
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] picture_exif
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] picture_filename          %v-%Y%m%d%H%M%S-%q
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] snapshot_interval         0
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] snapshot_filename         %v-%Y%m%d%H%M%S-snapshot
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] movie_output              on
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] movie_output_motion       off
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] movie_max_time            120
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] movie_bps                 400000
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] movie_quality             60
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] movie_codec               mkv
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] movie_duplicate_frames    off
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] movie_passthrough         off
Jan 10 06:12:13 scout motion[12268]: [0:motion] [NTC] [ALL] motion_startup: Motion 4.2.1+git20181209-7bd179c Started
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] movie_filename            %v-%Y%m%d%H%M%S
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] movie_extpipe_use         off
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] movie_extpipe
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] timelapse_interval        0
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] timelapse_mode            daily
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] timelapse_fps             30
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] timelapse_codec           mpg
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] timelapse_filename        %Y%m%d-timelapse
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] video_pipe
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] video_pipe_motion
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] webcontrol_port           81
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] webcontrol_ipv6           off
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] webcontrol_localhost      off
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] webcontrol_parms          0
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] webcontrol_interface      0
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] webcontrol_auth_method    0
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] webcontrol_authentication
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] webcontrol_tls            off
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] webcontrol_cert
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] webcontrol_key
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] webcontrol_cors_header
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] stream_port               8081
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] stream_localhost          off
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] stream_auth_method        0
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] stream_authentication
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] stream_tls                off
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] stream_cors_header
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] stream_preview_scale      25
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] stream_preview_newline    off
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] stream_preview_method     0
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] stream_quality            50
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] stream_grey               off
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] stream_motion             off
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] stream_maxrate            1
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] stream_limit              0
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] database_type             mysql
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] database_dbname           sec
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] database_host             localhost
Jan 10 06:12:13 scout motion[12268]: [0:motion] [NTC] [ALL] motion_startup: Using default log type (ALL)
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] database_port             3306
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] database_user             <redacted>
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] database_password         <redacted>
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] database_busy_timeout     0
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] sql_log_picture           off
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] sql_log_snapshot          off
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] sql_log_movie             off
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] sql_log_timelapse         off
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] sql_query_start
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] sql_query_stop
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] sql_query
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] track_type                0
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] track_auto                off
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] track_port
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] track_motorx              0
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] track_motorx_reverse      off
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] track_motory              0
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] track_motory_reverse      off
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] track_maxx                0
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] track_minx                0
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] track_maxy                0
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] track_miny                0
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] track_homex               128
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] track_homey               128
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] track_iomojo_id           0
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] track_step_angle_x        10
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] track_step_angle_y        10
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] track_move_wait           10
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] track_speed               255
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] track_stepsize            40
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] track_generic_move
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] camera
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] camera_dir
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] Thread 1 - Config file: /sec/etc/motion/frontdoor.conf
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] camera_name               Front Door
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] camera_id                 1
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] target_dir                /sec/media/cameras/frontdoor
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] netcam_url                <redacted>
Jan 10 06:12:13 scout motion[12268]: [0:motion] [NTC] [ALL] motion_startup: Using log type (ALL) log level (INF)
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] width                     1920
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] height                    1080
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] framerate                 2
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] threshold                 3000
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] despeckle_filter          EedDl
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] event_gap                 3
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] pre_capture               3
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] post_capture              10
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] picture_quality           100
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] picture_filename          %Y%m%d_%H%M%S-%t-%v
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] movie_max_time            0
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] movie_bps                 7680000
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] movie_quality             100
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] movie_passthrough         on
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] movie_filename            %Y%m%d_%H%M%S-%t-%v
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] sql_log_movie             on
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] sql_query_start           INSERT INTO recordings (camera_id, camera_name, filename, width, height, fps, start_time, event) VALUES ('%t', '%$', "%f", '%w', '%h', '%{fps}', '%Y-%m-%d %H:%M:%S', '%v')
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] sql_query_stop            UPDATE recordings SET end_time = '%Y-%m-%d %H:%M:%S' WHERE filename = "%f"
Jan 10 06:12:13 scout motion[12268]: [0:motion] [NTC] [STR] webu_start_strm: Starting all camera streams on port 8081
Jan 10 06:12:13 scout motion[12268]: [0:motion] [NTC] [STR] webu_strm_ntc: Started camera 1 stream on port/camera_id 8081/1
Jan 10 06:12:13 scout motion[12268]: [0:motion] [NTC] [STR] webu_start_ctrl: Starting webcontrol on port 81
Jan 10 06:12:13 scout motion[12268]: [0:motion] [NTC] [STR] webu_start_ctrl: Started webcontrol on port 81
Jan 10 06:12:13 scout motion[12268]: [0:motion] [NTC] [ENC] ffmpeg_global_init: ffmpeg libavcodec version 58.35.100 libavformat version 58.20.100
Jan 10 06:12:13 scout motion[12268]: [0:motion] [NTC] [ALL] translate_init: Language: English
Jan 10 06:12:13 scout motion[12268]: [0:motion] [NTC] [ALL] motion_start_thread: Camera ID: 1 is from /sec/etc/motion/frontdoor.conf
Jan 10 06:12:13 scout motion[12268]: [0:motion] [NTC] [ALL] motion_start_thread: Camera ID: 1 Camera Name: Front Door Service: rtsp:
Jan 10 06:12:13 scout motion[12268]: [0:motion] [NTC] [ALL] main: Waiting for threads to finish, pid: 12268
Jan 10 06:12:13 scout motion[12268]: [1:ml1:Front Door] [NTC] [ALL] motion_init: Camera 1 started: motion detection Enabled
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] conf_output_parms: Writing configuration parameters from all files (2):
Jan 10 06:12:13 scout motion[12268]: [1:ml1:Front Door] [NTC] [VID] vid_start: Opening Netcam RTSP
Jan 10 06:12:13 scout motion[12268]: [1:ml1:Front Door] [INF] [NET] netcam_rtsp_set_parms: Setting up Normal resolution stream.
Jan 10 06:12:13 scout motion[12268]: [1:ml1:Front Door] [INF] [NET] util_check_passthrough: pass-through is enabled but is still experimental.
Jan 10 06:12:13 scout motion[12268]: [1:ml1:Front Door] [INF] [NET] Above message repeats 1 times
Jan 10 06:12:13 scout motion[12268]: [1:ml1:Front Door] [INF] [NET] netcam_rtsp_set_path: Setting up rtsp via ffmpeg netcam
Jan 10 06:12:13 scout motion[12268]: [1:ml1:Front Door] [INF] [NET] netcam_rtsp_set_rtsp: Normal resolution: Setting rtsp transport to tcp
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] Thread 0 - Config file: /sec/etc/motion/motion.conf
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] daemon                    off
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] setup_mode                off
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] pid_file
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] log_file
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] log_level                 7
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] log_type                  ALL
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] quiet                     on
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] native_language           on
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] camera_name
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] camera_id                 0
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] target_dir                /sec/media
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] videodevice               /dev/video0
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] vid_control_params
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] v4l2_palette              17
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] input                     -1
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] norm                      0
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] frequency                 0
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] auto_brightness           0
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] tunerdevice
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] roundrobin_frames         1
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] roundrobin_skip           1
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] roundrobin_switchfilter   off
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] netcam_url
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] netcam_highres
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] netcam_userpass
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] netcam_keepalive          off
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] netcam_proxy
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] netcam_tolerant_check     off
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] netcam_use_tcp            on
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] mmalcam_name
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] mmalcam_control_params
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] width                     640
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] height                    480
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] framerate                 15
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] minimum_frame_time        0
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] rotate                    0
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] flip_axis                 none
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] locate_motion_mode        off
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] locate_motion_style       box
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] text_left
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] text_right                %Y-%m-%d\n%T
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] text_changes              off
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] text_scale                1
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] text_event                %Y%m%d%H%M%S
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] emulate_motion            off
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] threshold                 1500
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] threshold_maximum         0
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] threshold_tune            off
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] noise_level               32
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] noise_tune                on
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] despeckle_filter
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] area_detect
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] mask_file
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] mask_privacy
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] smart_mask_speed          0
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] lightswitch_percent       0
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] lightswitch_frames        5
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] minimum_motion_frames     1
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] event_gap                 60
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] pre_capture               0
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] post_capture              0
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] on_event_start
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] on_event_end
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] on_picture_save
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] on_area_detected
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] on_motion_detected
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] on_movie_start
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] on_movie_end
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] on_camera_lost
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] on_camera_found
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] picture_output            off
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] picture_output_motion     off
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] picture_type              jpeg
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] picture_quality           75
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] picture_exif
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] picture_filename          %v-%Y%m%d%H%M%S-%q
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] snapshot_interval         0
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] snapshot_filename         %v-%Y%m%d%H%M%S-snapshot
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] movie_output              on
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] movie_output_motion       off
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] movie_max_time            120
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] movie_bps                 400000
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] movie_quality             60
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] movie_codec               mkv
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] movie_duplicate_frames    off
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] movie_passthrough         off
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] movie_filename            %v-%Y%m%d%H%M%S
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] movie_extpipe_use         off
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] movie_extpipe
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] timelapse_interval        0
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] timelapse_mode            daily
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] timelapse_fps             30
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] timelapse_codec           mpg
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] timelapse_filename        %Y%m%d-timelapse
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] video_pipe
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] video_pipe_motion
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] webcontrol_port           81
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] webcontrol_ipv6           off
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] webcontrol_localhost      off
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] webcontrol_parms          0
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] webcontrol_interface      0
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] webcontrol_auth_method    0
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] webcontrol_authentication
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] webcontrol_tls            off
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] webcontrol_cert
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] webcontrol_key
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] webcontrol_cors_header
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] stream_port               8081
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] stream_localhost          off
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] stream_auth_method        0
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] stream_authentication
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] stream_tls                off
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] stream_cors_header
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] stream_preview_scale      25
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] stream_preview_newline    off
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] stream_preview_method     0
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] stream_quality            50
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] stream_grey               off
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] stream_motion             off
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] stream_maxrate            1
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] stream_limit              0
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] database_type             mysql
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] database_dbname           sec
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] database_host             localhost
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] database_port             3306
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] database_user             <redacted>
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] database_password         <redacted>
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] database_busy_timeout     0
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] sql_log_picture           off
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] sql_log_snapshot          off
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] sql_log_movie             off
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] sql_log_timelapse         off
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] sql_query_start
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] sql_query_stop
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] sql_query
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] track_type                0
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] track_auto                off
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] track_port
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] track_motorx              0
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] track_motorx_reverse      off
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] track_motory              0
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] track_motory_reverse      off
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] track_maxx                0
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] track_minx                0
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] track_maxy                0
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] track_miny                0
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] track_homex               128
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] track_homey               128
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] track_iomojo_id           0
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] track_step_angle_x        10
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] track_step_angle_y        10
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] track_move_wait           10
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] track_speed               255
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] track_stepsize            40
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] track_generic_move
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] camera
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] camera_dir
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] Thread 1 - Config file: /sec/etc/motion/frontdoor.conf
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] camera_name               Front Door
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] camera_id                 1
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] target_dir                /sec/media/cameras/frontdoor
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] netcam_url                <redacted>
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] width                     1920
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] height                    1080
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] framerate                 2
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] threshold                 3000
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] despeckle_filter          EedDl
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] event_gap                 3
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] pre_capture               3
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] post_capture              10
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] picture_quality           100
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] picture_filename          %Y%m%d_%H%M%S-%t-%v
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] movie_max_time            0
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] movie_bps                 7680000
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] movie_quality             100
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] movie_passthrough         on
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] movie_filename            %Y%m%d_%H%M%S-%t-%v
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] sql_log_movie             on
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] sql_query_start           INSERT INTO recordings (camera_id, camera_name, filename, width, height, fps, start_time, event) VALUES ('%t', '%$', "%f", '%w', '%h', '%{fps}', '%Y-%m-%d %H:%M:%S', '%v')
Jan 10 06:12:13 scout motion[12268]: [0:motion] [INF] [ALL] sql_query_stop            UPDATE recordings SET end_time = '%Y-%m-%d %H:%M:%S' WHERE filename = "%f"
Jan 10 06:12:13 scout motion[12268]: [0:motion] [NTC] [STR] webu_start_strm: Starting all camera streams on port 8081
Jan 10 06:12:13 scout motion[12268]: [0:motion] [NTC] [STR] webu_strm_ntc: Started camera 1 stream on port/camera_id 8081/1
Jan 10 06:12:13 scout motion[12268]: [0:motion] [NTC] [STR] webu_start_ctrl: Starting webcontrol on port 81
Jan 10 06:12:13 scout motion[12268]: [0:motion] [NTC] [STR] webu_start_ctrl: Started webcontrol on port 81
Jan 10 06:12:13 scout motion[12268]: [0:motion] [NTC] [ENC] ffmpeg_global_init: ffmpeg libavcodec version 58.35.100 libavformat version 58.20.100
Jan 10 06:12:13 scout motion[12268]: [0:motion] [NTC] [ALL] translate_init: Language: English
Jan 10 06:12:13 scout motion[12268]: [0:motion] [NTC] [ALL] motion_start_thread: Camera ID: 1 is from /sec/etc/motion/frontdoor.conf
Jan 10 06:12:13 scout motion[12268]: [0:motion] [NTC] [ALL] motion_start_thread: Camera ID: 1 Camera Name: Front Door Service: rtsp:
Jan 10 06:12:13 scout motion[12268]: [0:motion] [NTC] [ALL] main: Waiting for threads to finish, pid: 12268
Jan 10 06:12:13 scout motion[12268]: [1:ml1:Front Door] [NTC] [ALL] motion_init: Camera 1 started: motion detection Enabled
Jan 10 06:12:13 scout motion[12268]: [1:ml1:Front Door] [NTC] [VID] vid_start: Opening Netcam RTSP
Jan 10 06:12:13 scout motion[12268]: [1:ml1:Front Door] [INF] [NET] netcam_rtsp_set_parms: Setting up Normal resolution stream.
Jan 10 06:12:13 scout motion[12268]: [1:ml1:Front Door] [INF] [NET] util_check_passthrough: pass-through is enabled but is still experimental.
Jan 10 06:12:13 scout motion[12268]: [1:ml1:Front Door] [INF] [NET] Above message repeats 1 times
Jan 10 06:12:13 scout motion[12268]: [1:ml1:Front Door] [INF] [NET] netcam_rtsp_set_path: Setting up rtsp via ffmpeg netcam
Jan 10 06:12:13 scout motion[12268]: [1:ml1:Front Door] [INF] [NET] netcam_rtsp_set_rtsp: Normal resolution: Setting rtsp transport to tcp
Jan 10 06:12:13 scout motion[12268]: [1:ml1:Front Door] [INF] [NET] netcam_rtsp_open_context: Normal resolution: Opened camera(Front Door)
Jan 10 06:12:13 scout motion[12268]: [1:ml1:Front Door] [INF] [NET] netcam_rtsp_open_context: Normal resolution: Opened camera(Front Door)
Jan 10 06:12:15 scout motion[12268]: [1:ml1:Front Door] [INF] [ENC] ffmpeg_avcodec_log: deprecated pixel format used, make sure you did set range correctly
Jan 10 06:12:15 scout motion[12268]: [1:ml1:Front Door] [INF] [ENC] ffmpeg_avcodec_log: deprecated pixel format used, make sure you did set range correctly
Jan 10 06:12:15 scout motion[12268]: [1:ml1:Front Door] [INF] [NET] netcam_rtsp_copy_stream: Stream copied for pass-through
Jan 10 06:12:15 scout motion[12268]: [1:ml1:Front Door] [INF] [NET] netcam_rtsp_copy_stream: Stream copied for pass-through
Jan 10 06:12:15 scout motion[12268]: [1:ml1:Front Door] [NTC] [NET] netcam_rtsp_connect: Normal resolution: Camera (Front Door) connected
Jan 10 06:12:15 scout motion[12268]: [1:ml1:Front Door] [NTC] [NET] netcam_rtsp_connect: Normal resolution: Camera (Front Door) connected
Jan 10 06:12:15 scout motion[12268]: [1:ml1:Front Door] [NTC] [ALL] image_ring_resize: Resizing pre_capture buffer to 1 items
Jan 10 06:12:15 scout motion[12268]: [1:ml1:Front Door] [NTC] [ALL] image_ring_resize: Resizing pre_capture buffer to 1 items
Jan 10 06:12:15 scout motion[12268]: [2:nc2:Front Door] [NTC] [NET] netcam_rtsp_handler: Normal resolution: Camera handler thread [2] started
Jan 10 06:12:15 scout motion[12268]: [2:nc2:Front Door] [NTC] [NET] netcam_rtsp_handler: Normal resolution: Camera handler thread [2] started
Jan 10 06:12:15 scout motion[12268]: [2:nc2:Front Door] [INF] [NET] netcam_rtsp_open_context: Normal resolution: Opened camera(Front Door)
Jan 10 06:12:15 scout motion[12268]: [2:nc2:Front Door] [INF] [NET] netcam_rtsp_open_context: Normal resolution: Opened camera(Front Door)
Jan 10 06:12:16 scout motion[12268]: [2:nc2:Front Door] [INF] [ENC] ffmpeg_avcodec_log: deprecated pixel format used, make sure you did set range correctly
Jan 10 06:12:16 scout motion[12268]: [2:nc2:Front Door] [INF] [ENC] ffmpeg_avcodec_log: deprecated pixel format used, make sure you did set range correctly
Jan 10 06:12:16 scout motion[12268]: [2:nc2:Front Door] [INF] [NET] netcam_rtsp_copy_stream: Stream copied for pass-through
Jan 10 06:12:16 scout motion[12268]: [2:nc2:Front Door] [INF] [NET] netcam_rtsp_copy_stream: Stream copied for pass-through
Jan 10 06:12:16 scout motion[12268]: [2:nc2:Front Door] [NTC] [NET] netcam_rtsp_connect: Normal resolution: Camera (Front Door) connected
Jan 10 06:12:16 scout motion[12268]: [2:nc2:Front Door] [NTC] [NET] netcam_rtsp_connect: Normal resolution: Camera (Front Door) connected
Jan 10 06:12:17 scout motion[12268]: [1:ml1:Front Door] [INF] [NET] netcam_rtsp_pktarray_resize: Normal resolution: Resized packet array to 30
Jan 10 06:12:17 scout motion[12268]: [1:ml1:Front Door] [INF] [NET] netcam_rtsp_pktarray_resize: Normal resolution: Resized packet array to 30
Jan 10 06:12:17 scout motion[12268]: [1:ml1:Front Door] [NTC] [DBL] dbse_init: Database backend mysql
Jan 10 06:12:17 scout motion[12268]: [1:ml1:Front Door] [NTC] [DBL] dbse_init: Database backend mysql
Jan 10 06:12:17 scout motion[12268]: [1:ml1:Front Door] [NTC] [ALL] image_ring_resize: Resizing pre_capture buffer to 4 items
Jan 10 06:12:17 scout motion[12268]: [1:ml1:Front Door] [NTC] [ALL] image_ring_resize: Resizing pre_capture buffer to 4 items
Jan 10 06:12:17 scout motion[12268]: [1:ml1:Front Door] [INF] [NET] netcam_rtsp_pktarray_resize: Normal resolution: Resized packet array to 52
Jan 10 06:12:17 scout motion[12268]: [1:ml1:Front Door] [INF] [NET] netcam_rtsp_pktarray_resize: Normal resolution: Resized packet array to 52
Jan 10 06:12:18 scout motion[12268]: [1:ml1:Front Door] [INF] [NET] netcam_rtsp_pktarray_resize: Normal resolution: Resized packet array to 76
Jan 10 06:12:18 scout motion[12268]: [1:ml1:Front Door] [INF] [NET] netcam_rtsp_pktarray_resize: Normal resolution: Resized packet array to 76
Jan 10 06:12:42 scout systemd[1]: Stopping Motion Security IP Camera Service...
Jan 10 06:12:42 scout motion[12268]: [1:ml1:Front Door] [NTC] [ALL] mlp_actions: End of event 1
Jan 10 06:12:42 scout motion[12268]: [1:ml1:Front Door] [NTC] [ALL] mlp_actions: End of event 1
Jan 10 06:12:42 scout motion[12268]: [1:ml1:Front Door] [NTC] [ALL] motion_loop: Thread exiting
Jan 10 06:12:42 scout motion[12268]: [1:ml1:Front Door] [NTC] [ALL] motion_loop: Thread exiting
Jan 10 06:12:42 scout motion[12268]: [1:ml1:Front Door] [INF] [ALL] motion_cleanup: Calling vid_close() from motion_cleanup
Jan 10 06:12:42 scout motion[12268]: [1:ml1:Front Door] [INF] [VID] vid_close: calling netcam_rtsp_cleanup
Jan 10 06:12:42 scout motion[12268]: [1:ml1:Front Door] [INF] [NET] netcam_rtsp_cleanup: Normal resolution: Shutting down network camera.
Jan 10 06:12:42 scout motion[12268]: [1:ml1:Front Door] [INF] [ALL] motion_cleanup: Calling vid_close() from motion_cleanup
Jan 10 06:12:42 scout motion[12268]: [1:ml1:Front Door] [INF] [VID] vid_close: calling netcam_rtsp_cleanup
Jan 10 06:12:42 scout motion[12268]: [1:ml1:Front Door] [INF] [NET] netcam_rtsp_cleanup: Normal resolution: Shutting down network camera.
Jan 10 06:12:42 scout motion[12268]: [2:nc2:Front Door] [INF] [NET] netcam_rtsp_read_image: Normal resolution: av_read_frame: Success ,Interrupt: True
Jan 10 06:12:42 scout motion[12268]: [2:nc2:Front Door] [INF] [NET] netcam_rtsp_read_image: Normal resolution: av_read_frame: Success ,Interrupt: True
Jan 10 06:12:42 scout motion[12268]: [2:nc2:Front Door] [INF] [NET] netcam_rtsp_handler: Normal resolution: Handler loop finished.
Jan 10 06:12:42 scout motion[12268]: [2:nc2:Front Door] [INF] [NET] netcam_rtsp_handler: Normal resolution: Handler loop finished.
Jan 10 06:12:42 scout motion[12268]: [2:nc2:Front Door] [INF] [NET] netcam_rtsp_handler: netcam camera handler: finish set, exiting
Jan 10 06:12:42 scout motion[12268]: [2:nc2:Front Door] [INF] [NET] netcam_rtsp_handler: netcam camera handler: finish set, exiting
Jan 10 06:12:43 scout motion[12268]: [1:ml1:Front Door] [NTC] [NET] netcam_rtsp_cleanup: Normal resolution: Shut down complete.
Jan 10 06:12:43 scout motion[12268]: [1:ml1:Front Door] [NTC] [NET] netcam_rtsp_cleanup: Normal resolution: Shut down complete.
Jan 10 06:12:44 scout motion[12268]: [0:motion] [NTC] [ALL] main: Threads finished
Jan 10 06:12:44 scout motion[12268]: [0:motion] [NTC] [ALL] main: Threads finished
Jan 10 06:12:44 scout motion[12268]: [0:motion] [NTC] [ALL] main: Motion terminating
Jan 10 06:12:44 scout motion[12268]: [0:motion] [NTC] [ALL] main: Motion terminating
Jan 10 06:12:49 scout motion[12268]: Error in my_thread_global_end(): 1 threads didn't exit
Jan 10 06:12:49 scout systemd[1]: motion.service: Succeeded.
Jan 10 06:12:49 scout systemd[1]: Stopped Motion Security IP Camera Service.
Jan 10 06:12:49 scout audit[1]: SERVICE_STOP pid=1 uid=0 auid=4294967295 ses=4294967295 msg='unit=motion comm="systemd" exe="/usr/lib/systemd/systemd" hostname=? addr=? terminal=? res=success'
Jan 10 06:12:49 scout kernel: audit: type=1131 audit(1547129569.509:99): pid=1 uid=0 auid=4294967295 ses=4294967295 msg='unit=motion comm="systemd" exe="/usr/lib/systemd/systemd" hostname=? addr=? terminal=? res=success'
tosiara commented 5 years ago

Was your motion running just for few seconds? That's not what I wanted. I'd like to see your motion detecting events and saving files

ipyakuza commented 5 years ago

Apologies, here is a log from this morning with 3 captured events. One thing I noted in this log pull was this entry:

[1:ml1:Front Door] [WRN] [DBL] [Jan 11 07:33:11] do_sql_query: Ignoring empty sql query
[1:ml1:Front Door] [NTC] [EVT] [Jan 11 07:33:11] event_newfile: File of type 8 saved to: /sec/media/cameras/frontdoor/20190111_073310-1-01.mp4
[1:ml1:Front Door] [NTC] [ALL] [Jan 11 07:33:11] motion_detected: Motion detected - starting event 1
[1:ml1:Front Door] [NTC] [ALL] [Jan 11 07:34:23] mlp_actions: End of event 1

https://gist.github.com/ipyakuza/8f3620a299abdb1f4593b07799b2f011

ipyakuza commented 5 years ago

Did some additional testing today by testing externally using on_movie_start executing a python 3.7 script trying to pass '%f' and it still fails with a blank value. I was able to pass the python script the start time '%Y-%m-%d %H:%M:%S' and it passes through and inserts into the database just fine. So I am believing it looks like the %f filename conversion specifier is broken. The majority of the other values work as well (via sql or script) but I haven't tested them all.

tosiara commented 5 years ago

Ok, thanks, I will try to verify it

tosiara commented 5 years ago

I have tested on_movie_start and it is working fine:

[0:motion] [NTC] [ALL] motion_startup: Motion 4.2.1+git20181209-7bd179c Started
[0:motion] [INF] [ALL] on_movie_start            /home/motion/git/event.sh %f
[1:ml1] [INF] [EVT] event_new_video: Source FPS 8
[1:ml1] [INF] [ENC] ffmpeg_set_quality: libx264 codec vbr/crf/bit_rate: 28
[1:ml1] [NTC] [EVT] event_newfile: File of type 8 saved to: ./0-01-20190112165526.mkv
[1:ml1] [NTC] [ALL] motion_detected: Motion detected - starting event 1
^C[1:ml1] [NTC] [ALL] mlp_actions: End of event 1

Script I used was:

#!/bin/bash

echo $1 > log.txt

Result:

$ cat log.txt 
./0-01-20190112165526.mkv
ipyakuza commented 5 years ago

Strange. In my setup I have the target_dir setting defined in each of my camera config files (3 cameras each targeting different directories). For this frontdoor camera I am using target_dir /sec/media/cameras/frontdoor as the path. I will try to writing to local path and see what happens.

ipyakuza commented 5 years ago

Reproducing the test you have done it does seem to work via an external script using on_movie_start config to log to a file so technically that should work through my python script -> mysql. However it still seems to be broken when using sql_log_movie on and sql_query_start. The SQL logging with these params does work just fine for several other params just not %f. Using: sql_query_start INSERT INTO recordings (camera_id, camera_name, filename, width, height, fps, codec, start_time, event) VALUES ('%t', '%$', '%f', '%w', '%h', '%{fps}', '%n', '%Y-%m-%d %H:%M:%S', '%v') the only value not coming through is %f. That was the original bug filed. For now I can leverage the external script until its working via sql_query_start.

tosiara commented 5 years ago

Will check sql now

ipyakuza commented 5 years ago

Well looks like it works using sql_query param not sql_query_start. It was confusing because the documentation notes sql_query_start and sql_query_end are used for "event" logging. However when I use sql_query for my INSERT statement when the recording begins and then sql_query_stop UPDATE recordings SET end_time = '%Y-%m-%d %H:%M:%S' WHERE filename = '%f' for my UPDATE when the recording ends it works just fine. My confusion was the difference between sql_query_start and sql_query. So now it's working as expected. Documentation cleanup at some point in the future may be helpful. I appreciate you looking into this issue for me.

tosiara commented 5 years ago

Ok, so you have been affected by the same confusion as some other users: https://github.com/Motion-Project/motion/issues/879#issuecomment-450622324

Meanwhile I have tested which variables are available by running this query:

sql_query_start insert into a values ('%Y year %m month %d day %H hour %M minute %S second %T HH:MM:SS %v event %q frame number %t camera id number %D changed pixels %N noise level %w width of the image %h height of the image %i width of motion area %J height of motion area %K X coordinates of motion center %L Y coordinates of motion center %C value defined by text_event %f filename with full path %n number indicating filetype %o threshold %Q Number of labels from despeckle %{dbeventid} See sql_query_start %$ camera name %{fps} current frames per second %{host} name of computer running Motion %{ver} The version of Motion')

Got this result:

| 2019 year 01 month 12 day 18 hour 42 minute 47 second 18:42:47 HH:MM:SS 01 event 11 frame number 0 camera id number 1810 changed pixels 73 noise level 1280 width of the image 720 height of the image 64 width of motion area 100 height of motion area 926 X coordinates of motion center 636 Y coordinates of motion center 20190112184247 value defined by text_event filename with full path number indicating filetype 1500 threshold 9 Number of labels from despeckle 0 See sql_query_start camera name 0 current frames per second motion name of computer running Motion 4.2.1+git20181209-7bd179c The version of Motion |

Indeed, %f seems to be the only one missing. And I see no reason why the filename is not available for the event start sql query. Adding @Mr-Dave for comment whether this is a bug or a feature request

Mr-DaveDev commented 5 years ago

What it looks like is happening is that the sql_query_start is executed before any file from the event exists so it can not include a file name. (Null is passed into the function for the file name).

I don't run a database so do not know the ultimate root reason why users would want to use this query trigger instead of the usual 'sql_query'. My general thought is that the start/stop should be the on the edges of the event to allow for preparing and cleaning up any activity from sql_query.

(PR are welcome for the documentation.)

tosiara commented 5 years ago

We should probably rename those sql statements to avoid future confusion. Marking as "enhancement" for backlog

jgwinner commented 5 years ago

I just noticed the same thing!

I added an enhancement to the formatting, %F (capital) that stripped the path away, so that if you were dumping the filenames into a directory that was in a WWW path, you could give people a database listing, and have them click and download without any additional shenanigans :) However, it was null a lot!

I think all we have to do is update the docs. It would save a lot of hair pulling.

I have also noticed that %{dbeventid} seems to be the same, and 'one off' or zero. Still doing some testing.

I've also noticed that .jpg files get written to with sql_query. You can't do a sql insert for jpg without also doing one for a movie. Same statement.

== John ==