[Motion-user] Database Tables?

[Muzaffar M. <muz...@gm...>]

Hi,

I added following configurations for database logging but there are not
tables created yet although motion movie files are being generated and
their events are being logged in log file.  Should i create tables itself
or i am to create tables myself? Some log content about db is this:
*Log:*

[1:ml1] [NTC] [DBL] [Sep 18 22:43:28] dbse_init: Database backend mysql
[1:ml1] [NTC] [ALL] [Sep 18 22:43:28] image_ring_resize: Resizing
pre_capture buffer to 4 items
[1:ml1] [WRN] [DBL] [Sep 18 22:43:57] do_sql_query: Ignoring empty sql query
[1:ml1] [NTC] [EVT] Above message repeats 1 times
[1:ml1] [NTC] [EVT] [Sep 18 22:43:57] event_newfile: File of type 8 saved
to: value/0-01-20190918224357.mkv
[1:ml1] [NTC] [ALL] [Sep 18 22:43:57] motion_detected: Motion detected -
starting event 1
[1:ml1] [WRN] [DBL] [Sep 18 22:44:57] do_sql_query: Ignoring empty sql query
[1:ml1] [NTC] [ALL] [Sep 18 22:44:57] mlp_actions: End of event 1
[1:ml1] [WRN] [DBL] [Sep 18 22:45:07] do_sql_query: Ignoring empty sql query
[1:ml1] [NTC] [EVT] Above message repeats 1 times
[1:ml1] [NTC] [EVT] [Sep 18 22:45:07] event_newfile: File of type 8 saved
to: value/0-02-20190918224507.mkv
[1:ml1] [NTC] [ALL] [Sep 18 22:45:07] motion_detected: Motion detected -
starting event 2
[1:ml1] [WRN] [DBL] [Sep 18 22:46:07] do_sql_query: Ignoring empty sql query
[1:ml1] [NTC] [ALL] [Sep 18 22:46:07] mlp_actions: End of event 2
[1:ml1] [WRN] [DBL] [Sep 18 22:46:39] do_sql_query: Ignoring empty sql query
[1:ml1] [NTC] [EVT] Above message repeats 1 times
[1:ml1] [NTC] [EVT] [Sep 18 22:46:39] event_newfile: File of type 8 saved
to: value/0-03-20190918224639.mkv
[1:ml1] [NTC] [ALL] [Sep 18 22:46:39] motion_detected: Motion detected -
starting event 3
[1:ml1] [WRN] [DBL] [Sep 18 22:47:39] do_sql_query: Ignoring empty sql query
[1:ml1] [NTC] [ALL] [Sep 18 22:47:39] mlp_actions: End of event 3
[1:ml1] [WRN] [DBL] [Sep 18 22:47:43] do_sql_query: Ignoring empty sql query
[1:ml1] [NTC] [EVT] Above message repeats 1 times
[1:ml1] [NTC] [EVT] [Sep 18 22:47:43] event_newfile: File of type 8 saved
to: value/0-04-20190918224743.mkv
*---------------------------------------------------------------------------------------------------------*

*Configurations:*
#####################################################################
# 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

# Log to the database when creating timelapse movies file (default: off)
 sql_log_timelapse on

# SQL query string that is sent to the database
# Use same conversion specifiers has for text features
# Additional special conversion specifiers are
# %n = the number representing the file_type
# %f = filename with full path
# Default value:
# Create tables :
##
# Mysql
# CREATE TABLE security (camera int, filename char(80) not null, frame int,
file_type int, time_stamp timestamp(14), event_time_stamp timestamp(14));
#
# Postgresql
# CREATE TABLE security (camera int, filename char(80) not null, frame int,
file_type int, time_stamp timestamp without time zone, event_time_stamp
timestamp without time zone);
#
# insert into security(camera, filename, frame, file_type, time_stamp,
text_event) values('%t', '%f', '%q', '%n', '%Y-%m-%d %T', '%C')
; sql_query insert into security(camera, filename, frame, file_type,
time_stamp, event_time_stamp) values('%t', '%f', '%q', '%n', '%Y-%m-%d %T',
'%C')


############################################################
# 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 motion_db

# The host on which the database is located (default: localhost)
 database_host localhost

# User account name for database (default: not defined)
 database_user root

# User password for database (default: not defined)
 database_password admin

# Port on which the database is located
#  mysql 3306 , postgresql 5432 (default: not defined)
 database_port 3306

# Database wait time in milliseconds for locked database to
# be unlocked before returning database locked error (default 0)
 database_busy_timeout 10000

Thanks & Regards
Muzaffar Mahmood