<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p>On 26/04/2021 18:52, A. F. Cano wrote:<br>
</p>
<blockquote type="cite"
cite="mid:20210426175237.GA7655@hp-i3.shibaya.lonestar.org">
<pre class="moz-quote-pre" wrap="">On Mon, Apr 26, 2021 at 06:19:22PM +0100, Paul Harrison wrote:
</pre>
<blockquote type="cite">
<pre class="moz-quote-pre" wrap="">On 26/04/2021 03:52, A. F. Cano wrote:
</pre>
<blockquote type="cite">
<pre class="moz-quote-pre" wrap="">Failed to get mysql row
Failed to shmget for monitor: 2
ENOENT - no segment exists for the given key
new connection from 192.168.200.9 on socket 5
socket 5 hung up
Augustine
</pre>
</blockquote>
<pre class="moz-quote-pre" wrap="">
I suspect this is the problem where ZoneMinder uses the reserved word
'Function' as a field name in the database.
I forget if it's MySQL or MariaDB that has the problem and exactly which
versions but I do know older versions of both worked OK.
If you know MySQL you can test this by running the following query and if it
fails retry by adding quote marks (") around Function and it should then
work.
SELECT Id, Name, Type, Device, Host, Channel, Function, Enabled FROM
Monitors;
</pre>
</blockquote>
<pre class="moz-quote-pre" wrap="">
$ sudo mysql -u root
[sudo] password for afc:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 55845
Server version: 10.3.27-MariaDB-0+deb10u1 Debian 10
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]> use zm;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
MariaDB [zm]> select Id, Name, Type, Device, Host, Channel, Function, Enabled from Monitors;
+----+-----------+-------+-------------+------+---------+----------+---------+
| Id | Name | Type | Device | Host | Channel | Function | Enabled |
+----+-----------+-------+-------------+------+---------+----------+---------+
| 2 | Desk-C600 | Local | /dev/video0 | NULL | 0 | Monitor | 1 |
+----+-----------+-------+-------------+------+---------+----------+---------+
1 row in set (0.001 sec)
MariaDB [zm]>
It seems to work. Not sure why the Host is NULL. It doesn't seem to
affect operation from the web browser.
</pre>
<blockquote type="cite">
<pre class="moz-quote-pre" wrap="">If that is the problem then we can look at ways to fix this. Master already
has a fix but fixes/31 and fixes/30 don't.
</pre>
</blockquote>
<pre class="moz-quote-pre" wrap="">
Anything else I should try?
Thanks.
Augustine
</pre>
</blockquote>
<p>OK so it's not that then. It does look like a query is failing
for some reason and that is cascading to other errors.<br>
</p>
<p>Can you try adding <span class="pl-s">-v or --verbose to the
command line flags and start mythzmserver like that. Maybe the
extra debugging will give a clue.</span></p>
<p>I think having NULL for the host is OK for a Local camera only
remote cameras like IP cameras will have a Host set.</p>
<p><br>
</p>
<p><span class="pl-s"></span></p>
<p><span class="pl-s">Paul H.<br>
</span></p>
</body>
</html>