Send Motion-user mailing list submissions to
motion-user@lists.sourceforge.net
To subscribe or unsubscribe via the World Wide Web, visit
https://lists.sourceforge.net/lists/listinfo/motion-user
or, via email, send a message with subject or body 'help' to
motion-user-requ...@lists.sourceforge.net
You can reach the person managing the list at
motion-user-ow...@lists.sourceforge.net
When replying, please edit your Subject line so it is more specific
than "Re: Contents of Motion-user digest..."
Today's Topics:
1. Won't log to database (David Powell)
----------------------------------------------------------------------
Message: 1
Date: Wed, 7 Nov 2018 21:14:28 -0600
From: David Powell <da...@depowell.com>
To: Motion discussion list <Motion-user@lists.sourceforge.net>
Subject: [Motion-user] Won't log to database
Message-ID: <67110f08-667c-5c8d-ed49-105e1fd3c...@depowell.com>
Content-Type: text/plain; charset="utf-8"; Format="flowed"
I'm using the latest Motion (Motion 4.1.1+git20181002-062a328) and MySQL
on a Raspberry Pi running Ubuntu and I can't seem to get Motion to write
to the database.? Everything else seems to work ok - Motion captures
activity on the camera and I can manually insert and delete rows from
the database.? No errors are generated in the sysout nor the Motion log.
Can someone help me figure out what is keeping Motion from recording
events in the database?? Here is the relevant (database) part of the
config file:
*############################################################
# Database and SQL Configuration parameters
############################################################
# The type of database being used if any.
database_type mysql
# Database name to use. For sqlite3, the full path and name.
database_dbname cameras
# The host on which the database is located
database_host localhost
# Port used by the database.
database_port 3306
# User account name for database.
database_user root
# User password for database.
database_password <redacted>
# Database wait for unlock time
database_busy_timeout 0
# Log to the database when creating motion triggered image file
sql_log_picture off
# Log to the database when creating a snapshot image file
sql_log_snapshot off
# Log to the database when creating motion triggered movie file
sql_log_movie on
# Log to the database when creating timelapse movie file
sql_log_timelapse off
# SQL query at event start.? See motion_guide.html
; sql_query_start value
# SQL query at event stop.? See motion_guide.html
; sql_query_stop value
# SQL query string that is sent to the database.? See motion_guide.html
sql_query INSERT INTO cameras.events
(server_number,camera_number,event_number,event_date,video_length,filename)
VALUES (2,%t,%v,{ts '%C'},null,'%v-%Y%m%d%H%M%S');*
-------------- next part --------------
An HTML attachment was scrubbed...
------------------------------
------------------------------
Subject: Digest Footer
_______________________________________________
Motion-user mailing list
Motion-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/motion-user
------------------------------
End of Motion-user Digest, Vol 149, Issue 8
*******************************************
