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. Re: Duplicate SQL entries for every event (Shawn Ashe)
2. outdoor camera UK (George Savage)
3. Re: outdoor camera UK (Harlan Daneker)
----------------------------------------------------------------------
Message: 1
Date: Thu, 29 Jul 2021 12:25:04 -0400
From: Shawn Ashe <dracutfo...@gmail.com>
To: Motion discussion list <motion-user@lists.sourceforge.net>
Subject: Re: [Motion-user] Duplicate SQL entries for every event
Message-ID:
<CAAHwYfRerso=lcs0r5srrjg5rp-vb+d1x-abpm8vpuakbcp...@mail.gmail.com>
Content-Type: text/plain; charset="utf-8"
is the event_number a counter,or based on time/etc?
Could be the events are going off to fast and you are getting duplicate
event numbers.
On Thu, Jul 29, 2021 at 12:15 PM David Powell <da...@depowell.com> wrote:
> Oh, I understand your question better now. The event number is generated
> by Motion automatically.
>
> David
>
> On July 29, 2021 11:11:01 AM David Powell <da...@depowell.com> wrote:
>
>>
>> My understanding is that *event_number* is there for this very purpose -
>> to make each event unique. I can't imagine another reason to have it.
>>
>> David
>>
>> On July 29, 2021 10:46:33 AM motionl...@frontdesign.com wrote:
>>
>>> Hi.
>>>
>>>
>>> Also; "The primary key for the *events* table is
>>> *server_number,event_number,event_date*, and *camera_number*."
>>>
>>> So, can the server_number, event_number, event_date and camera_number be
>>> the same twice?
>>>
>>> I'm guessing server_number for sure, camera_number too. Event date? Yeah
>>> possible if it's two events in tight enough sequence and sloppy enough
>>> datetime datatype.
>>>
>>> event_number? ... doesn't sound likely but... what do i know - how does
>>> that get generated?
>>>
>>>
>>> Why not use an auto_intrement for primary key and have a composite index
>>> on those other columns instead?
>>>
>>>
>>> //Lars
>>>
>>>
>>>
>>> On 2021-07-29 16:59, John L. Poole wrote:
>>>
>>> The error message you shared, e.g. trigger of a primary key constraint,
>>> suggests an error in program design. If you have a table with unique
>>> constraints, e.g. every entry must be unique, you don't try to insert the
>>> same record twice.
>>>
>>> I recommend you file a bug so everything is documented well and then the
>>> developers can determine why they are attempting to insert something
>>> already present, or at least testing for presence before attempting to
>>> insert a record that may already exist.
>>> On 7/29/2021 7:27 AM, David Powell wrote:
>>>
>>> This is the whole SQL section of motion.conf:
>>> ############################################################
>>> # 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 *<redacted>*
>>>
>>> # User password for database.
>>> database_password *<redacted>*
>>>
>>> # Database wait for unlock time
>>> database_busy_timeout 5
>>>
>>> # 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 INSERT INTO events
>>> (server_number,camera_number,event_number,event_date,video_length,filename)
>>> VALUES (1,%t,%v,{ts '%C'},null,'%f');
>>>
>>> # SQL query string that is sent to the database. See motion_guide.html
>>> ; sql_query
>>>
>>> I had the query in *sql_query* but I moved it to *sql_query_stop*.
>>> That didn't help.
>>>
>>> David
>>>
>>>
>>> On 7/29/21 8:17 AM, Damian via Motion-user wrote:
>>>
>>> The SQL statement in motion.conf is
>>> INSERT INTO events
>>> (server_number,camera_number,event_number,event_date,video_length,filename)
>>> VALUES (1,%t,%v,{ts '%C'},null,'%f');
>>>
>>> The records /are/ there in the database, and I run a custom program to
>>> extract them for displaying the snapshots and movies in a web page
>>>
>>>
>>> Which sql_log_* statements are enabled?
>>>
>>>
>>> _______________________________________________
>>> Motion-user mailing list
>>> Motion-user@lists.sourceforge.net
>>> https://lists.sourceforge.net/lists/listinfo/motion-user
>>> https://motion-project.github.io/
>>>
>>> Unsubscribe: https://lists.sourceforge.net/lists/options/motion-user
>>>
>>>
>>>
>>> _______________________________________________
>>> Motion-user mailing
>>> listMotion-user@lists.sourceforge.nethttps://lists.sourceforge.net/lists/listinfo/motion-userhttps://motion-project.github.io/
>>>
>>> Unsubscribe: https://lists.sourceforge.net/lists/options/motion-user
>>>
>>> --
>>>
>>> John Laurence Poole
>>> 1566 Court ST NE
>>> Salem OR 97301-4241
>>> 707-812-1323 office
>>>
>>>
>>>
>>> _______________________________________________
>>> Motion-user mailing
>>> listMotion-user@lists.sourceforge.nethttps://lists.sourceforge.net/lists/listinfo/motion-userhttps://motion-project.github.io/
>>>
>>> Unsubscribe: https://lists.sourceforge.net/lists/options/motion-user
>>>
>>> _______________________________________________
>>> Motion-user mailing list
>>> Motion-user@lists.sourceforge.net
>>> https://lists.sourceforge.net/lists/listinfo/motion-user
>>> https://motion-project.github.io/
>>>
>>> Unsubscribe: https://lists.sourceforge.net/lists/options/motion-user
>>>
>>
>>
> _______________________________________________
> Motion-user mailing list
> Motion-user@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/motion-user
> https://motion-project.github.io/
>
> Unsubscribe: https://lists.sourceforge.net/lists/options/motion-user
-------------- next part --------------
An HTML attachment was scrubbed...
------------------------------
Message: 2
Date: Thu, 29 Jul 2021 17:40:22 +0100
From: George Savage <gtsav...@gmail.com>
To: motion-user@lists.sourceforge.net
Subject: [Motion-user] outdoor camera UK
Message-ID:
<cab0h6osjbbiqphzitz_etmrehcjhbf+e3ps1vaky6gwewpx...@mail.gmail.com>
Content-Type: text/plain; charset="utf-8"
Although I have one camera (Reolink) working with motion I would like
another camera to check the wildlife in the back garden. Is there a list of
cameras that work with motion - every one I can find appears to need a
mobile app.
-------------- next part --------------
An HTML attachment was scrubbed...
------------------------------
Message: 3
Date: Thu, 29 Jul 2021 12:50:22 -0400
From: Harlan Daneker <hdane...@gmail.com>
To: Motion discussion list <motion-user@lists.sourceforge.net>
Subject: Re: [Motion-user] outdoor camera UK
Message-ID:
<cac1wkireou0rg1c7bs3hdswqvoakaborgsrp6a89mxombj5...@mail.gmail.com>
Content-Type: text/plain; charset="utf-8"
This brand works, *not top of the line*. 15fps 5MP - iframe every 4
seconds. Some artifacts were triggering motion detection at certain times
of the day, but despeckle_filter el fixed that. I'm running 5 of these and
one old ip camera.
https://www.amazon.com/SV3C-Megapixels-Surveillance-Detection-Weatherproof/dp/B07T9K7N1G/ref=asc_df_B07T9K7N1G/?tag=hyprod-20&linkCode=df0&hvadid=343253277043&hvpos=&hvnetw=g&hvrand=9957291220939701323&hvpone=&hvptwo=&hvqmt=&hvdev=c&hvdvcmdl=&hvlocint=&hvlocphy=9007201&hvtargid=pla-782406280202&psc=1&tag=&ref=&adgrpid=69185921255&hvpone=&hvptwo=&hvadid=343253277043&hvpos=&hvnetw=g&hvrand=9957291220939701323&hvqmt=&hvdev=c&hvdvcmdl=&hvlocint=&hvlocphy=9007201&hvtargid=pla-782406280202
On Thu, Jul 29, 2021 at 12:41 PM George Savage <gtsav...@gmail.com> wrote:
> Although I have one camera (Reolink) working with motion I would like
> another camera to check the wildlife in the back garden. Is there a list of
> cameras that work with motion - every one I can find appears to need a
> mobile app.
> _______________________________________________
> Motion-user mailing list
> Motion-user@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/motion-user
> https://motion-project.github.io/
>
> Unsubscribe: https://lists.sourceforge.net/lists/options/motion-user
-------------- 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 181, Issue 14
********************************************
