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: difference in apt-get install and make install (Roger Heflin)
2. Re: Pixelation? (Roger Heflin)
3. Re: MySQL - access denied (Bill Visick)
----------------------------------------------------------------------
Message: 1
Date: Fri, 19 Mar 2021 16:13:54 -0500
From: Roger Heflin <roger.hef...@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:
<CAAMCDeeo+dy6Ypib6YpvUhYPy3C=izq4tzb0dvnzxo1hcvx...@mail.gmail.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
>
>
>
Generally the startup scripts are not part of most make installs
because they are different for each different distribution.
Also it is pretty rare for make install to (even if it has a
proto-type startup script) to install it and enable it because of it
being different for each distribution, so if you do make install
typically you will have to setup a startup script or be lazy and just
put it in rc.local.
------------------------------
Message: 2
Date: Fri, 19 Mar 2021 16:22:19 -0500
From: Roger Heflin <roger.hef...@gmail.com>
To: Motion discussion list <motion-user@lists.sourceforge.net>
Subject: Re: [Motion-user] Pixelation?
Message-ID:
<CAAMCDee0Xg0u0zxwS80QZjXr-CNYn71ae8Z0vP=oekjcj0q...@mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"
On Fri, Mar 19, 2021 at 1:29 PM Harlan Daneker <hdane...@gmail.com> wrote:
>
> 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.
>
>
A higher bitrate might make it work better, or it may not. There may
simply not be enough bits for the key frame to contain the image with
the given bitrate and so to get the detail may need some of the data
after the key frame to get a detailed image. And it could be that the
hardware encoder sucks.
------------------------------
Message: 3
Date: Sat, 20 Mar 2021 11:59:41 +0000 (GMT)
From: Bill Visick <bvis...@btinternet.com>
To: Motion discussion list <motion-user@lists.sourceforge.net>
Subject: Re: [Motion-user] MySQL - access denied
Message-ID: <7775a40c.28b60.1784f815e52.webtop...@btinternet.com>
Content-Type: text/plain; charset="utf-8"; Format="flowed"
I could only suggest you to try to create a dedicated db user and makea
network trace on the loopback adapter to see what is the differencein
two connectionsThanks for this suggestion, it put me on the right track!
I was looking at how to set up the loopback adapter and noticed that
applications use a unix socket to communicate with mysql if localhost is
used and a tcpip one if 127.0.0.1 is given. So I tried 127.0.0.1 and it
works! I don't know why this should be the case when most
recommendations are to use localhost but for now I'm just happy it's
working, thanks very much for your help getting me to this point.
Regards
Bill
------ Original Message ------
From: "Bill Visick" <bvis...@btinternet.com>
To: "Bill Visick" <bvis...@btinternet.com>; "Motion discussion list"
<motion-user@lists.sourceforge.net>
Sent: Friday, 19 Mar, 21 At 09:55
Subject: Re: [Motion-user] MySQL - access denied
Try adding also database name, like this:./mysql -u root -p clipsDoes 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://lists.sourceforge.net/lists/listinfo/motion-user>
https://motion-project.github.io/ <https://motion-project.github.io/>
Unsubscribe: https://lists.sourceforge.net/lists/options/motion-user
<https://lists.sourceforge.net/lists/options/motion-user>
-------------- next part --------------
An HTML attachment was scrubbed...
------------------------------
------------------------------
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 11
********************************************
