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. difference in apt-get install and make install (Arrow22) 2. Re: Pixelation? (Harlan Daneker) 3. Re: difference in apt-get install and make install (tosiara) 4. Re: MySQL - access denied (tosiara) ---------------------------------------------------------------------- Message: 1 Date: Fri, 19 Mar 2021 10:01:08 -0700 From: "Arrow22" <arro...@siliconmagi.com> To: "'Motion discussion list'" <motion-user@lists.sourceforge.net> Subject: [Motion-user] difference in apt-get install and make install Message-ID: <000001d71ce1$76092890$621b79b0$@SiliconMagi.com> Content-Type: text/plain; charset="utf-8" There seems to be a difference in the package installations apt-get works great and all files are where they are supposed to be motion startup says version 4.1.1 git clone https://github.com/Motion-Project/motion.git works but compiling unaltered code even using ?prefix=/ will not start the service ->not found motion.conf is way different new to linux, but been programming for a long while. Old MS-DOS guy. What file in the project controls where files are placed/renamed on installation Is there a GUI for building these packages? Using Raspbian 10 buster thanks -------------- next part -------------- An HTML attachment was scrubbed... ------------------------------ Message: 2 Date: Fri, 19 Mar 2021 14:28:19 -0400 From: Harlan Daneker <hdane...@gmail.com> To: Motion discussion list <motion-user@lists.sourceforge.net> Subject: Re: [Motion-user] Pixelation? Message-ID: <cac1wkir6jawmpd+dopirmgkcttrzmbu5jy_pnrsbafxbgzb...@mail.gmail.com> Content-Type: text/plain; charset="utf-8" Just Informative: 15fps - key frame interval 60 = Every 4 seconds that the camera encoder does this. These cameras aren't bad for the price, but better cameras probably would not do this. On Wed, Mar 17, 2021 at 1:14 PM tosiara <tosi...@gmail.com> wrote: > I think those are (de)compression artifacts > > On Wed, Mar 17, 2021, 17:34 Harlan Daneker <hdane...@gmail.com> wrote: > >> I can use despeckle to stop motion from recording, but I don't understand >> what is making this happen. It almost seems to be pulsing every 4 seconds. >> >> http://www.htd.dns2go.com/cam3/092532.mp4 >> >> movie_output_motion >> http://www.htd.dns2go.com/cam3/092532m.mp4 >> _______________________________________________ >> 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 -------------- next part -------------- An HTML attachment was scrubbed... ------------------------------ Message: 3 Date: Fri, 19 Mar 2021 21:15:06 +0200 From: tosiara <tosi...@gmail.com> To: Motion discussion list <motion-user@lists.sourceforge.net> Subject: Re: [Motion-user] difference in apt-get install and make install Message-ID: <cachtdwqpvkz+k8txv9gq4nlw0c8dpqk8mkdp4orexf7v8rm...@mail.gmail.com> Content-Type: text/plain; charset="UTF-8" You can try pre-compiled debs: https://github.com/Motion-Project/motion/releases Or build your own deb: https://github.com/Motion-Project/motion-packaging On Fri, Mar 19, 2021 at 7:02 PM Arrow22 <arro...@siliconmagi.com> wrote: > > There seems to be a difference in the package installations > > apt-get works great and all files are where they are supposed to be > > motion startup says version 4.1.1 > > > > git clone https://github.com/Motion-Project/motion.git > > works but compiling unaltered code even using > > ?prefix=/ > will not start the service ->not found > > motion.conf is way different > > > > new to linux, but been programming for a long while. Old MS-DOS guy. > > What file in the project controls where files are placed/renamed on > installation > > > > Is there a GUI for building these packages? > > > > Using Raspbian 10 buster > > > > thanks > > > > _______________________________________________ > 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 ------------------------------ Message: 4 Date: Fri, 19 Mar 2021 22:11:53 +0200 From: tosiara <tosi...@gmail.com> To: Motion discussion list <motion-user@lists.sourceforge.net> Subject: Re: [Motion-user] MySQL - access denied Message-ID: <cachtdwqx0jhkfpyo3rqtiaexnxb+5z4hzrhwkkoqw_1zn__...@mail.gmail.com> Content-Type: text/plain; charset="UTF-8" If you are connecting from the same box to the same localhost address using the same credentials - it should work I could only suggest you to try to create a dedicated db user and make a network trace on the loopback adapter to see what is the difference in two connections On Fri, Mar 19, 2021 at 11:57 AM Bill Visick via Motion-user <motion-user@lists.sourceforge.net> wrote: > > Try adding also database name, like this: > > ./mysql -u root -p clips > > Does it work that way? > > Yes it does and I can list the contents of the tables without any problem. It > does appear as if motion is somehow not sending the right credentials: the > error reported in motion.log is > > > MySQL error was Access denied for user 'root'@'localhost' (using password: > YES) > > > I don't know where the single quotes are coming from, they are not in my > .conf file. If I try to log in from the command line and include the single > quotes: > > > ./mysql -u 'root'@'localhost' -p > > > then I get > > > ERROR 1045 (28000): Access denied for user 'root@localhost'@'localhost' > (using password: YES) > > > so mysql is somehow expanding the quoted userid to include localhost as well. > Does that suggest what might be going wrong? > > > > > Regards > Bill > > +44 7901 954568 > > > > > ------ Original Message ------ > From: "Bill Visick" <bvis...@btinternet.com> > To: "Motion discussion list" <motion-user@lists.sourceforge.net> > Sent: Thursday, 18 Mar, 21 At 12:19 > Subject: Re: [Motion-user] MySQL - access denied > > Thaanks to Tosaria for his comment, sorry I can't see how to respond directly > to it! > > > Anyway, I understand motion can't fix mysql problems but was hoping there was > maybe a config option that I'd set wrong somewhere. > > > On the command prompt I enter: > > ./mysql -u root -pxxxxxxxxxx > > > and get: > > Welcome to the MariaDB monitor. Commands end with ; or \g. > Your MariaDB connection id is 41 > Server version: 10.3.21-MariaDB Source distribution > > etc. > > > For info, the user table has: > > +-----------+------+ > | host | user | > +-----------+------+ > | 127.0.0.1 | root | > | ::1 | root | > | localhost | root | > +-----------+------+ > > > Could there be a path problem? At the command prompt I have to cd to the > relevant directory first (/usr/local/mariadb10/bin) but the fact that motion > says Access denied rather than being unable to find mysql suggests that's not > the problem. > > > Regards > Bill Visick > > > > > ------ Original Message ------ > From: "Bill Visick via Motion-user" <motion-user@lists.sourceforge.net> > To: motion-user@lists.sourceforge.net > Cc: "Bill Visick" <bvis...@btinternet.com> > Sent: Wednesday, 17 Mar, 21 At 17:31 > Subject: [Motion-user] MySQL - access denied > > I'm trying to insert records in a database but motion can't connect to it. I > have the following in motion.conf: > > > database_type mysql > database_dbname clips > daabase_host localhost > database_port 3306 > database_user root > database_password xxxxxxxxxxxxxxxx > sql_log_picture on > sql_log_snapshot on > sql_log_movie on > sql_query insert into motion(camera, filename, event, frame, file_type, > time_stamp, text_event) values('%$_%t', '%f', '%v', '%q', '%n', '%Y-%m-%d > %T', '%C') > > > In motion.log I get: > > > motion_init: Database backend mysql > motion_init: Cannot connect to MySQL database clips on host localhost with > user root > motion_init: MySQL error was Access denied for user 'root'@'localhost' (using > password: YES) > motion_loop: Thread exiting > > > I can log in to MySQL successfully using the same credentials from a command > prompt. > > > I'm sure I'm missing something simple, thanks very much for any suggestions. > > > Bill Visick > > ________________________________ > _______________________________________________ > 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 ------------------------------ ------------------------------ 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 177, Issue 10 ********************************************