[mythtv-users] Mythzmserver DB problems. Was: doesn't start:...

[A. F. Cano]

On Mon, Apr 26, 2021 at 06:19:22PM +0100, Paul Harrison wrote:
> On 26/04/2021 03:52, A. F. Cano wrote:
> 
> > 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
> 
> 
> 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;

$ 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.


> 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.

Anything else I should try?

Thanks.

Augustine