[mythtvnz] New install - mythbackend password not accepted

[Stephen Worthington]

On Mon, 5 Apr 2021 09:09:30 +1200, you wrote:

>
>On 4/04/21 7:54 pm, Stephen Worthington wrote:
>> On Sun, 4 Apr 2021 10:55:34 +1200, you wrote:
>>
>>> Ok ,I tried your scripts which don't appear to work correctly in this system
>>>
>>> While running htop in another workspace ,I can issue sudo
>>> /home/mythtv/bin/mythtv-systemctl-helper.sh stop and sudo
>>> /home/mythtv/bin/mythtv-systemctl-helper.sh start commands and observe
>>> that the processes related to /usr/bin/mythtv disappear and reappear.
>>>
>>> If I start mythtv backend setup ,first I get a window asking to stop
>>> myth backend ,I click yes, I get another window asking for the password
>>> and I close it.
>> If my scripts are installed correctly, you should not get a popup
>> window asking for the password.  So you need to check that the scripts
>> are installed.  Try doing this:
>>
>> sudo mysql
>> use mythconverg;
>> select * from settings where data like '%helper%' order by hostname;
>> quit
>>
>> This is what I get:
>>
>> MariaDB [mythconverg]> select * from settings where data like
>> '%helper%' order by hostname;
>> +---------------------+---------------------------------------------------------+----------+
>> | value               | data                                                    | hostname |
>> +---------------------+---------------------------------------------------------+----------+
>> | ServerHaltCommand   | sudo /usr/local/bin/mythtv-systemctl-helper.sh halt     | NULL     |
>> | BackendStartCommand | sudo /usr/local/bin/mythtv-systemctl-helper.sh start    | NULL     |
>> | BackendStopCommand  | sudo /usr/local/bin/mythtv-systemctl-helper.sh stop     | NULL     |
>> | HaltCommand         | sudo /usr/local/bin/mythtv-systemctl-helper.sh poweroff | mypvr    |
>> | RebootCommand       | sudo /usr/local/bin/mythtv-systemctl-helper.sh reboot   | mypvr    |
>> | HaltCommand         | sudo /usr/local/bin/mythtv-systemctl-helper.sh poweroff | savaidh  |
>> | RebootCommand       | sudo /usr/local/bin/mythtv-systemctl-helper.sh reboot   | savaidh  |
>> +---------------------+---------------------------------------------------------+----------+
>> 7 rows in set (0.001 sec)
>>
>> That shows the hostname=NULL commands, and the commands for two
>> different frontends (mypvr which is also the backend, and savaidh).
>> The BackendSartCommand and BackendStopCommand ones are the vital ones
>> for running mythtv-setup.  If you are having trouble installing them,
>> it can be done from the mysql command line.  Be aware that the update
>> command is dangerous - typos can destroy your database so it is best
>> to just cut and paste if you are not confident with the mysql command
>> line:
>>
>> sudo mysql
>> use mythconverg;
>> update settings set data='sudo
>> /usr/local/bin/mythtv-systemctl-helper.sh start' where hostname is
>> NULL and value='BackendStartCommand';
>> update settings set data='sudo
>> /usr/local/bin/mythtv-systemctl-helper.sh stop' where hostname is NULL
>> and value='BackendStopCommand';
>> select * from settings where data like '%helper%' order by hostname;
>> quit
>>
>> Note that my email client wraps lines - cut and paste the above into
>> an editor and unwrap the 'update' lines so that they are all on one
>> line before pasting them to a terminal.  It will not work if the
>> command string between the single quotes is wrapped.

>It looks like they installed correctly:
>
>+---------------------+-----------------------------------------------------------+----------+
>| value                 | 
>data                                                            | hostname |
>+---------------------+-----------------------------------------------------------+----------+
>| ServerHaltCommand   | sudo /home/mythtv/bin.systemctl-helper-sh 
>halt            | NULL     |
>| BackendStopCommand  | sudo /home/mythtv/bin.mythtv-systemctl-helper.sh 
>stop     | NULL     |
>| BackendStartCommand | sudo /home/mythtv/bin.mythtv-systemctl-helper.sh 
>start    | NULL     |
>| HaltCommand         | sudo /home/mythtv/bin.mythtv-systemctl-helper.sh 
>poweroff | myth     |
>| RebootCommand       | sudo /home/mythtv/bin.mythtv-systemctl-helper.sh 
>reboot   | myth     |
>+---------------------+-----------------------------------------------------------+----------+
>5 rows in set (0.01 sec)

No, there is a typo in all of them.  Between "bin" and
"mythtv-systemctl-helper.sh" it should be a "/" not a ".".

And "ServerHaltCommand" also has "systemctl-helper-sh" instead of
"mythtv-systemctl-helper.sh" (missing "mythtv-" at the front and has
"-sh" instead of ".sh").