Send Motion-user mailing list submissions to
[email protected]
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
[email protected]
You can reach the person managing the list at
[email protected]
When replying, please edit your Subject line so it is more specific
than "Re: Contents of Motion-user digest..."
Today's Topics:
1. Re: outdoor camera UK (Harlan Daneker)
2. Re: Duplicate SQL entries for every event (Shawn Ashe)
----------------------------------------------------------------------
Message: 1
Date: Thu, 29 Jul 2021 13:03:55 -0400
From: Harlan Daneker <[email protected]>
To: Motion discussion list <[email protected]>
Subject: Re: [Motion-user] outdoor camera UK
Message-ID:
<cac1wkiq-gvsty8t4cgwgdvrooldz9jtjnunquehjrmzzd6-...@mail.gmail.com>
Content-Type: text/plain; charset="utf-8"
I wanted to add using h265 encoder causes issues (gray screens) so I'm
using h264 baseline. Also setting video format to 50hz instead of 60hz
solved some time issues and I don't know why. The internal motion detection
must be turned off.
On Thu, Jul 29, 2021 at 12:50 PM Harlan Daneker <[email protected]> wrote:
> 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 <[email protected]> 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
>> [email protected]
>> 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 13:44:38 -0400
From: Shawn Ashe <[email protected]>
To: Motion discussion list <[email protected]>
Subject: Re: [Motion-user] Duplicate SQL entries for every event
Message-ID:
<caahwyfqqidhp-rnerryme3mulodrfyhgmsyvva2qv9mukj7...@mail.gmail.com>
Content-Type: text/plain; charset="utf-8"
I would find a way to log it, at least it's a symptom you can give to the
motion team, and maybe something will become obvious to you
On Thu, Jul 29, 2021, 1:05 PM David Powell <[email protected]> wrote:
> It's the %v replaceable parameter in the insert statement. Motion
> generates it internally.
> dp
>
> On July 29, 2021 11:26:25 AM Shawn Ashe <[email protected]> wrote:
>
>> 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 <[email protected]> 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 <[email protected]> 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 [email protected] 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
>>>>> [email protected]
>>>>> 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
>>>>> [email protected]https://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
>>>>> [email protected]https://lists.sourceforge.net/lists/listinfo/motion-userhttps://motion-project.github.io/
>>>>>
>>>>> Unsubscribe: https://lists.sourceforge.net/lists/options/motion-user
>>>>>
>>>>> _______________________________________________
>>>>> Motion-user mailing list
>>>>> [email protected]
>>>>> 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
>>> [email protected]
>>> 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
>> [email protected]
>> 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
> [email protected]
> 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
[email protected]
https://lists.sourceforge.net/lists/listinfo/motion-user
------------------------------
End of Motion-user Digest, Vol 181, Issue 16
********************************************
