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 (John D. Gwinner)
----------------------------------------------------------------------
Message: 1
Date: Mon, 18 Feb 2019 14:35:03 +0000
From: "John D. Gwinner" <j...@gwinner.org>
To: Motion discussion list <motion-user@lists.sourceforge.net>
Subject: Re: [Motion-user] pictures not saving
Message-ID:
<byapr01mb42133146972ba166b2d336fec3...@byapr01mb4213.prod.exchangelabs.com>
Content-Type: text/plain; charset="utf-8"
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 ==
[cid:image002.jpg@01D4C753.88D0DF30]<https://www.amazon.com/Getting-Started-React-VR-immersive-ebook/dp/B077VR6FMQ/>
John Gwinner .
cto4you.com<http://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<mailto: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<mailto:gik...@gmail.com>>
Sent: Friday, February 15, 2019 2:59 AM
To: Motion discussion list
<motion-user@lists.sourceforge.net<mailto: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<mailto: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<mailto: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<mailto: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<mailto: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<mailto: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
-------------- next part --------------
An HTML attachment was scrubbed...
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.jpg
Type: image/jpeg
Size: 2216 bytes
Desc: image002.jpg
------------------------------
------------------------------
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 10
********************************************
