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

[Paul Harrison]

On 26/04/2021 18:52, A. F. Cano wrote:

> 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

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.

Can you try adding -v or --verbose to the command line flags and start 
mythzmserver like that. Maybe the extra debugging will give a clue.

I think having NULL for the host is OK for a Local camera only remote 
cameras like IP cameras will have a Host set.


Paul H.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20210426/5ea65ed4/attachment.htm>