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: pictures not saving (John D. Gwinner)
----------------------------------------------------------------------
Message: 1
Date: Mon, 18 Feb 2019 19:45:50 +0000
From: "John D. Gwinner" <[email protected]>
To: Motion discussion list <[email protected]>
Subject: Re: [Motion-user] pictures not saving
Message-ID:
<byapr01mb4213612c5ec843c0862df577c3...@byapr01mb4213.prod.exchangelabs.com>
Content-Type: text/plain; charset="utf-8"
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 <[email protected]>
Sent: Monday, February 18, 2019 10:04 AM
To: Motion discussion list <[email protected]>
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
<[email protected]<mailto:[email protected]>> 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 ==
[cid:[email protected]]<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 <[email protected]<mailto:[email protected]>>
Sent: Saturday, February 16, 2019 5:28 AM
To: Motion discussion list
<[email protected]<mailto:[email protected]>>
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
<[email protected]<mailto:[email protected]>> 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 <[email protected]<mailto:[email protected]>>
Sent: Friday, February 15, 2019 2:59 AM
To: Motion discussion list
<[email protected]<mailto:[email protected]>>
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
<[email protected]<mailto:[email protected]>> wrote:
You have a typo:
target_dir value /cams/nmotion
Remove "value"
On Fri, Feb 15, 2019 at 1:22 AM Tim Brown
<[email protected]<mailto:[email protected]>> 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
> [email protected]<mailto:[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]<mailto:[email protected]>
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
[email protected]<mailto:[email protected]>
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
[email protected]<mailto:[email protected]>
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: image001.jpg
Type: image/jpeg
Size: 2216 bytes
Desc: image001.jpg
------------------------------
------------------------------
Subject: Digest Footer
_______________________________________________
Motion-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/motion-user
------------------------------
End of Motion-user Digest, Vol 152, Issue 14
********************************************
