BUG: Unknown config option for Database options
I installed motion on banana pi and it works great. I use an IP camera via rtsp port and everything works good. I have installed mysql and created the table security with all the required field but when I enable the database options from motion.conf, I get the following errors:
[0] [ALR] [ALL] conf_cmdparse: Unknown config option "sql_log_picture"
[0] [ALR] [ALL] conf_cmdparse: Unknown config option "sql_log_movie"
[0] [ALR] [ALL] conf_cmdparse: Unknown config option "database_type"
[0] [ALR] [ALL] conf_cmdparse: Unknown config option "database_dbname"
[0] [ALR] [ALL] conf_cmdparse: Unknown config option "database_user"
[0] [ALR] [ALL] conf_cmdparse: Unknown config option "database_password"
[0] [ALR] [ALL] conf_cmdparse: Unknown config option "database_port"
[0] [ALR] [ALL] conf_cmdparse: Unknown config option "database_busy_timeout"
I have tried to write the values with " and with ; at the end, but it still won't work.
Below is a snapshot of the options I use in motion.conf
#####################################################################
# Common Options for database features.
# Options require database options to be active also.
#####################################################################
# Log to the database when creating motion triggered picture file (default: on)
sql_log_picture on
# Log to the database when creating a snapshot image file (default: on)
; sql_log_snapshot on
# Log to the database when creating motion triggered movie file (default: off)
sql_log_movie on
...
sql_query insert into security(camera, filename, frame, file_type) values('%t', '%f', '%q', '%n')
############################################################
# Database Options
############################################################
# database type : mysql, postgresql, sqlite3 (default : not defined)
database_type mysql
# database to log to (default: not defined)
# for sqlite3, the full path and name for the database.
database_dbname secure_login
# The host on which the database is located (default: localhost)
;database_host
# User account name for database (default: not defined)
database_user root
Environment
Motion version: |
3.2.12 |
ffmpeg version: |
|
Shared libraries: |
ffmpeg, mysql, |
Server OS: |
Linux on Banana pi |
--
VictorO - 18 May 2016
Follow up
Fix record