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: mysqldb/mariadb libs (Mike Wilson)
2. Re: firefox does not load >6 "img src' from motion default
page (folkert)
----------------------------------------------------------------------
Message: 1
Date: Thu, 18 Jun 2020 00:10:20 -0400
From: Mike Wilson <knobby2...@gmail.com>
To: Motion discussion list <motion-user@lists.sourceforge.net>
Subject: Re: [Motion-user] mysqldb/mariadb libs
Message-ID:
<caaveucrt0x27fvo5dwc5wt-anpjygq4fdqox7f4zykv9itm...@mail.gmail.com>
Content-Type: text/plain; charset="utf-8"
If motion doesn't have a docker container yet, this is a perfect reason for
one.
On Wed, Jun 17, 2020 at 5:57 PM Henry B. Tindall, Jr. <
he...@linux-meister.com> wrote:
> Installed the latest MariaDB after creating repos on my Foreman server,
> updating Content Views, and all that mess:
>
> MariaDB-cassandra-engine-10.4.13-1.el7.centos.x86_64
> MariaDB-common-10.4.13-1.el7.centos.x86_64
> MariaDB-connect-engine-10.4.13-1.el7.centos.x86_64
> MariaDB-client-10.4.13-1.el7.centos.x86_64
> MariaDB-backup-10.4.13-1.el7.centos.x86_64
> MariaDB-compat-10.4.13-1.el7.centos.x86_64
> MariaDB-devel-10.4.13-1.el7.centos.x86_64
> MariaDB-server-10.4.13-1.el7.centos.x86_64
> MariaDB-shared-10.4.13-1.el7.centos.x86_64
> MariaDB-test-10.4.13-1.el7.centos.x86_64
> MariaDB-cracklib-password-check-10.4.13-1.el7.centos.x86_64
>
>
> Then, after a reboot, asterisk blows up on the odbc connector... :(
> [abrt] : asterisk killed by SIGABRT
>
> fixed that by installing binaries from
> mariadb-connector-odbc-3.0.6-ga-rhel7-x86_64.tar.gz,
> editing the /etc/odbcinst.ini....
> , back to motion:
>
>
> configure finds mariadb !!
> compile, install, then:
>
>
> Jun 17 15:31:30 pbx motion: [0:motion] [INF] [ALL] database_type
> mysql
> Jun 17 15:31:30 pbx motion: [0:motion] [INF] [ALL] database_dbname
> motion
> Jun 17 15:31:30 pbx motion: [0:motion] [INF] [ALL] database_host
> localhost
> Jun 17 15:31:30 pbx motion: [0:motion] [INF] [ALL] database_port
> 3306
> Jun 17 15:31:30 pbx motion: [0:motion] [INF] [ALL] database_user
> <redacted>
> Jun 17 15:31:30 pbx motion: [0:motion] [INF] [ALL] database_password
> <redacted>
> Jun 17 15:31:30 pbx motion: [0:motion] [INF] [ALL] database_busy_timeout
> 0
> Jun 17 15:31:30 pbx motion: [0:motion] [INF] [ALL] sql_log_picture
> off
> Jun 17 15:31:30 pbx motion: [0:motion] [INF] [ALL] sql_log_snapshot
> on
> Jun 17 15:31:30 pbx motion: [0:motion] [INF] [ALL] sql_log_movie
> on
> Jun 17 15:31:30 pbx motion: [0:motion] [INF] [ALL] sql_log_timelapse
> off
> Jun 17 15:31:30 pbx motion: [0:motion] [INF] [ALL] sql_query_start
> Jun 17 15:31:30 pbx motion: [0:motion] [INF] [ALL] sql_query_stop
> Jun 17 15:31:30 pbx motion: [0:motion] [INF] [ALL] sql_query
> insert into security(camera, filename, frame, file_type, time_stamp,
> event_time_stamp) values('%t', '%f', '%q', '%n', '%Y-%m-%d %T', '%C')
>
> But no insertions. :(
>
> MariaDB [motion]> select * from security order by time_stamp desc limit 10;
>
> +--------+--------+----------------------------------------------------------------+-------+-----------+--------------------------------+---------------------+
> | serial | camera | filename
> | frame | file_type | event_time_stamp | time_stamp
> |
>
> +--------+--------+----------------------------------------------------------------+-------+-----------+--------------------------------+---------------------+
> | 218548 | 3 |
> /home/tindallh/public_html/motion/cam3/3935-20200616222027.mp4 | 17 | 8
> | Linux-Meister.com - 2020061622 | 2020-06-16 22:20:27 |
> | 218398 | 3 |
> /home/tindallh/public_html/motion/cam3/3912-20200616195215.mp4 | 2 | 8
> | Linux-Meister.com - 2020061619 | 2020-06-16 19:52:15 |
> | 218397 | 3 |
> /home/tindallh/public_html/motion/cam3/3911-20200616195140.mp4 | 25 | 8
> | Linux-Meister.com - 2020061619 | 2020-06-16 19:51:40 |
> | 218396 | 1 |
> /home/tindallh/public_html/motion/cam1/1319-20200616195137.mp4 | 11 | 8
> | Linux-Meister.com - 2020061619 | 2020-06-16 19:51:37 |
> | 218395 | 3 |
> /home/tindallh/public_html/motion/cam3/3910-20200616195050.mp4 | 9 | 8
> | Linux-Meister.com - 2020061619 | 2020-06-16 19:50:50 |
> | 218394 | 1 |
> /home/tindallh/public_html/motion/cam1/1318-20200616195041.mp4 | 6 | 8
> | Linux-Meister.com - 2020061619 | 2020-06-16 19:50:41 |
> | 218393 | 3 |
> /home/tindallh/public_html/motion/cam3/3909-20200616194938.mp4 | 16 | 8
> | Linux-Meister.com - 2020061619 | 2020-06-16 19:49:38 |
> | 218392 | 1 |
> /home/tindallh/public_html/motion/cam1/1317-20200616194936.mp4 | 20 | 8
> | Linux-Meister.com - 2020061619 | 2020-06-16 19:49:36 |
> | 218391 | 1 |
> /home/tindallh/public_html/motion/cam1/1316-20200616194625.mp4 | 16 | 8
> | Linux-Meister.com - 2020061619 | 2020-06-16 19:46:25 |
> | 218390 | 1 |
> /home/tindallh/public_html/motion/cam1/1315-20200616194525.mp4 | 8 | 8
> | Linux-Meister.com - 2020061619 | 2020-06-16 19:45:25 |
>
> +--------+--------+----------------------------------------------------------------+-------+-----------+--------------------------------+---------------------+
> 10 rows in set (0.016 sec)
>
> Even after falling back to 4.2.2, which previously worked:
>
> Jun 17 15:48:02 pbx motion: [3:ml3:SouthPorchC] [WRN] [DBL] do_sql_query:
> Ignoring empty sql query
> Jun 17 15:48:02 pbx motion: [3:ml3:SouthPorchC] [ERR] [DBL] do_sql_query:
> Mysql query failed Data too long for column 'event_time_stamp' at row 1
> error code 1406: No such file or directory
> Jun 17 15:48:09 pbx motion: [1:ml1:DrivewayCam] [WRN] [DBL] do_sql_query:
> Ignoring empty sql query
> Jun 17 15:48:09 pbx motion: [1:ml1:DrivewayCam] [ERR] [DBL] do_sql_query:
> Mysql query failed Data too long for column 'event_time_stamp' at row 1
> error code 1406: No such file or directory
>
> REMOVED the mariadb-connector-odbc files, all the 10.4 version MariaDB,
> re-installed the 5.5.65 version and the 5.2.5-8 version of
> mysql-connector-odbc, and both motion 4.2.2 and asterisk work... :O Of
> course, now the 4.3.1 fails to find either mysql or MariaDB support
> again... So I guess I'll stick with 4.2.2 for the time being. I'll have
> to create/sync the MariaDB 5.5 repos on my Foreman server; right now I'm
> using the CentOS7 Base repo for MariaDB and it doesn't have the
> MariaDB-client packages, for some reason. I spent the better part of my
> free time yesterday adding a MariaDB product and all the repos and content
> views for 10.x so now I'm behind on other projects...
>
> --
> Henry B. Tindall, Jr.
> CISSP, SSCP, Security+, Linux+, RHCSA
>
> On Wed, June 17, 2020 1:47 am, Hans Fernhout wrote:
> > Maybe installing a new version of MariaDB is a good idea. Often when you
> > start upgrading one bit you may need to upgrade other bits as well. I
> have
> > MariaDB-10.4.12 installed.
> >
> >
> > In Gentoo, Motion's autoconfigure checks for file
> > /usr/lib64/pkgconfig/mariadb.pc. Do you have that file? In CentOS the
> > path may be different.
> >
> > For the client software you should have
> > /usr/lib64/pkgconfig/libmariadb.pc. Not sure if a binary install will
> > install that. CentOs should have a package for the client software too, I
> > would say.
> >
> > On 6/17/20 5:47 AM, Henry B. Tindall, Jr. wrote:
> >
> >> Binaries installed from
> >> https://downloads.mariadb.com/Connectors/c/connector-c-3.1.8/; still no
> >> joy. Thinking about updating to the 10.4 version of mariadb to see if
> >> that makes a difference...
> >>
> >
> >
> >
>
>
>
>
> _______________________________________________
> 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: 2
Date: Thu, 18 Jun 2020 09:21:20 +0200
From: folkert <folk...@vanheusden.com>
To: Motion discussion list <motion-user@lists.sourceforge.net>
Subject: Re: [Motion-user] firefox does not load >6 "img src' from
motion default page
Message-ID: <20200618072119.go22...@belle.intranet.vanheusden.com>
Content-Type: text/plain; charset=iso-8859-1
What I do in my own program ( https://vanheusden.com/constatus/ ) is
merging multiple streams into 1 mjpeg stream. At a cpu-cost but then you
won't have trouble with browsers.
e.g.
https://keetweej.vanheusden.com/constatus-demo/stream.mjpeg?int=view-3&view-proxy
are 4 webcams in one view. So 1 socket. This is a simple raspberry pi by
the way.
Maybe implement this in motion? It is not very difficult.
On Mon, Jun 15, 2020 at 12:16:43AM -0700, rmbusy wrote:
> That is really not an acceptable solution.? Not everyone uses a browser that
> can be modified in that way.? I use several different browsers, on multiple
> different devices, and not all have the option to make changes like
> adjusting the max persistent connections.
>
> I've ended up regressing to version 4.1.1 to get around the issue, and now
> I'm looking into Zoneminder (it seems to use more CPU, and I'm pushing the
> limits of the current machine now with Motion).
>
> Is there some reason this limitation was added starting with Motion 4.2?
>
>
> --
> Rob.
>
>
>
> On 6/14/20 11:07 AM, tosiara wrote:
> > Adjust your Firefox setting in about:config
> >
> > network.http.max-persistent-connections-per-server
> >
> > On Sun, Jun 14, 2020 at 8:10 PM csspcmotion
> > <mot...@curtissystemssoftware.com> wrote:
> > > i adding a few more cameras ... now firefox (ver 77.0) when browsing
> > > default
> > >
> > > page at localhost:/8080 does not load more than 6 camera streams
> > >
> > > in motion ... what adjustments can be made to overcome this issue
> > >
> > >
> > >
> > > _______________________________________________
> > > 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
>
>
>
> _______________________________________________
> 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
Folkert van Heusden
--
MultiTail is een flexibele tool voor het volgen van logfiles en
uitvoer van commando's. Filteren, van kleur voorzien, mergen,
'diff-view', etc. http://www.vanheusden.com/multitail/
----------------------------------------------------------------------
Phone: +31-6-41278122, PGP-key: 1F28D8AE, www.vanheusden.com
------------------------------
------------------------------
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 168, Issue 48
********************************************
