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 (Tim Brown)
----------------------------------------------------------------------
Message: 1
Date: Mon, 18 Feb 2019 19:20:56 -0500
From: Tim Brown <gik...@gmail.com>
To: Motion discussion list <motion-user@lists.sourceforge.net>
Subject: Re: [Motion-user] pictures not saving
Message-ID:
<camr_f+4oc+cs79u1s9dcrjx5mbff0f9xfz5lkgpcfekpw+g...@mail.gmail.com>
Content-Type: text/plain; charset="utf-8"
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
-------------- 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 15
********************************************
