[mythtvnz] New install - mythbackend password not accepted

[Paul]

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.
>
> _______________________________________________
> mythtvnz mailing list
> mythtvnz at lists.ourshack.com
> https://lists.ourshack.com/mailman/listinfo/mythtvnz
> Archives http://www.gossamer-threads.com/lists/mythtv/mythtvnz/

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)