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: pictures not saving (Mike Wilson)
----------------------------------------------------------------------
Message: 1
Date: Tue, 19 Feb 2019 09:49:11 -0500
From: Mike Wilson <knobby2...@gmail.com>
To: Motion discussion list <motion-user@lists.sourceforge.net>
Subject: Re: [Motion-user] pictures not saving
Message-ID:
<caaveucodr0spfbrfqqzyw5ugp6u1czaoj8jh0ohxj4fneyp...@mail.gmail.com>
Content-Type: text/plain; charset="utf-8"
You do not need sql_query_start. You can use it to insert an event into
MySQL and use that event for photos and videos to take the guesswork out of
what files are tied to what event. The default config has an example of
usage.
On Mon, Feb 18, 2019 at 7:21 PM Tim Brown <gik...@gmail.com> wrote:
> OK, binary IS compiled with mysql support. I noticed sql_query_start,
> what is that used for and do I need it?
>
> Anyone have an example?
>
> Thanks, btw!
>
> On Mon, Feb 18, 2019 at 5:20 PM John D. Gwinner <j...@gwinner.org> wrote:
>
>> Exactly. If the binaries aren?t built right, the config could be perfect,
>> and nothing will go into the database. It?s what happened to me.
>>
>>
>>
>> == John ==
>>
>>
>>
>>
>>
>> *From:* Tim Brown <gik...@gmail.com>
>> *Sent:* Monday, February 18, 2019 10:04 AM
>> *To:* Motion discussion list <motion-user@lists.sourceforge.net>
>> *Subject:* Re: [Motion-user] pictures not saving
>>
>>
>>
>> I am just trying to cut to the chase about whether I am setting the
>> configs up correctly. The database is one I have used for years, was
>> working perfectly with the old motion. It still works fine, inserts etc.
>> User and pass is right.
>>
>>
>>
>> One thing I can check is if db support is in this package.
>>
>>
>>
>> On Mon, Feb 18, 2019 at 9:51 AM John D. Gwinner <j...@gwinner.org> wrote:
>>
>> I got that. I also explained why that might happen.
>>
>>
>>
>> Where did get Motion from, build it from source?
>>
>>
>>
>> It?s quite possible it was built without database support. Check your
>> config files from the build.
>>
>>
>>
>> If you?re running a newer MariaDB or MySQL, it?s also possible your
>> database is rejecting logon?s.
>>
>>
>>
>> Does that database accept mysql command line connections using the same
>> information in your motion configuration? In other words, open a Mysql
>> shell with the same connection info from the same PC, and try some SQL
>> insert statements. Doing that helped me debug mine.
>>
>>
>>
>> Also, check the log files of course.
>>
>>
>>
>> == John ==
>>
>>
>>
>>
>> <https://www.amazon.com/Getting-Started-React-VR-immersive-ebook/dp/B077VR6FMQ/>
>>
>> *John Gwinner* .
>>
>> cto4you.com
>>
>>
>> My book at Amazon
>> <https://www.amazon.com/Getting-Started-React-VR-immersive-ebook/dp/B077VR6FMQ/>
>>
>>
>>
>>
>>
>>
>>
>> *From:* Tim Brown <gik...@gmail.com>
>> *Sent:* Saturday, February 16, 2019 5:28 AM
>> *To:* Motion discussion list <motion-user@lists.sourceforge.net>
>> *Subject:* Re: [Motion-user] pictures not saving
>>
>>
>>
>> I am running the same mysql on the same host (nixos) that I ran the old
>> 3.* motion on. The new motion monitors the cams fine, and now is saving
>> images. Just not writing to the database.
>>
>>
>>
>>
>>
>> On Fri, Feb 15, 2019 at 11:52 PM John D. Gwinner <j...@gwinner.org>
>> wrote:
>>
>> Where did you get 4.2.1 from?
>>
>>
>>
>> What exact database are you using?
>>
>>
>>
>> I found (I think it?s listed as a bug on github) that if you download
>> source and build it, on an RPi you probably don?t have database support.
>> There?s no errors; SQL statements just do ... nothing.
>>
>>
>>
>> My workaround was to create a Ubunto VM, download MySQL from Oracle, and
>> run the configure stuff; then take the generated include and config files
>> and copy them over to the Pi, then build the pi app.
>>
>>
>>
>> Now I have the latest and greatest and MySQL support.
>>
>>
>>
>> The exact same sql statements that worked with ?apt-get motion? now work
>> with the newest motion.
>>
>>
>>
>> This may not be your issue, but I thought it might help if it were!
>>
>>
>>
>> == John ==
>>
>> *From:* Tim Brown <gik...@gmail.com>
>> *Sent:* Friday, February 15, 2019 2:59 AM
>> *To:* Motion discussion list <motion-user@lists.sourceforge.net>
>> *Subject:* Re: [Motion-user] pictures not saving
>>
>>
>>
>> The typo was it! I removed "value" and files are saving.
>>
>> Thank you!
>>
>>
>>
>> Not saving to the database yet though.
>>
>>
>>
>> Conf for mysql:
>>
>> 95 #setup_mode off
>>
>> 96 sql_log_snapshot on
>>
>> 97 sql_log_picture on
>>
>> 98 sql_log_movie off
>>
>> 99 database_type mysql
>>
>> 100 database_dbname security
>>
>> 101 database_host localhost
>>
>> 102 database_port 3306
>>
>> 103 database_user xxxx
>>
>> 104 database_password xxxx
>>
>> 105
>>
>> 106 sql_query insert into security(camera, filename, frame,
>> file_type, time_stamp, text_event) values('%t', '%f', '%q', '%n', '%
>> Y-%m-%d %T', '%C')
>>
>>
>>
>> sql_query is the same as before. No records appearing yet. I must have
>> missed a step?
>>
>>
>>
>>
>>
>> On Fri, Feb 15, 2019 at 1:29 AM tosiara <tosi...@gmail.com> wrote:
>>
>> You have a typo:
>> target_dir value /cams/nmotion
>>
>> Remove "value"
>>
>> On Fri, Feb 15, 2019 at 1:22 AM Tim Brown <gik...@gmail.com> wrote:
>> >
>> > target_dir is set, filename is set and these settings are there:
>> > camera_name FrontDoor
>> > threshold 50000
>> > target_dir value /cams/nmotion
>> > picture_output on
>> > picture_output_motion off
>> > picture_type jpeg
>> > picture_filename front/FrontDoor_%t-%v-%Y%m%d%H%M%S
>> >
>> > The output shows:
>> > [1:ml1:FrontDoor] [NTC] [EVT] event_newfile: File of type 1 saved to:
>> value /cams/nmotion/front/FrontDoor_101-01-20190214181340.jpg
>> > [1:ml1:FrontDoor] [NTC] [EVT] Above message repeats 28 times
>> >
>> > But, no files show up.
>> >
>> > I have used the 3x version for years with good success, just trying to
>> get this new one going.
>> > The version is 4.2.1.
>> >
>> > Any ideas?
>> > --
>> > ? Tim Brown
>> > _______________________________________________
>> > 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
>>
>>
>>
>>
>> --
>>
>> ? Tim Brown
>>
>> _______________________________________________
>> 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
>>
>>
>>
>>
>> --
>>
>> ? Tim Brown
>>
>> _______________________________________________
>> 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
>>
>>
>>
>>
>> --
>>
>> ? Tim Brown
>> _______________________________________________
>> 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
>
>
>
> --
> ? Tim Brown
> _______________________________________________
> 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...
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.jpg
Type: image/jpeg
Size: 2216 bytes
Desc: not available
------------------------------
------------------------------
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 152, Issue 16
********************************************
