[mythtv-users] BE3 - Issues with installation and database

[Stephen Worthington]

On Wed, 22 May 2019 16:01:28 -0500, you wrote:

[snip]
>As soon as you do that, mythbackend will start up too
>soon, before that IP address is available on the Ethernet port.  So it
>will not work after boot, but will if you restart it after the network
>is up:
>
>sudo restart mythtv-backend
>
>    Found another potential error, or could be just a shortcut command I
>    don’t have installed:
>
>
>    barry at Backend-3:~$ sudo restart mythtv-backend
>
>    sudo: restart: command not found

Sorry, that was a typo on my part.  It should be:

sudo systemctl restart mythtv-backend

>    barry at Backend-3:~$
>
>    barry at Backend-3:~$
>
>    barry at Backend-3:~$ sudo systemctl stop mythtv-backend
>
>    barry at Backend-3:~$ sudo systemctl start mythtv-backend
>
>    barry at Backend-3:~$
>
>
>    Both of these went to prompt immediately. Seems like should be a bit
>    of a delay. (BE3 is fast but not that fast!)
>
>
>    Then thought I’d try:
>
>
>    barry at Backend-3:~$ mythtv-setup
>
>    ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.0.3'
>    (111 "Connection refused")
>
>    Gtk-Message: 14:23:58.949: GtkDialog mapped without a transient
>    parent. This is discouraged.
>
>
>    Figure error 2003 due to the mysql/mythcoverg/etc., errors; the
>    second (discouraged) is just an advisory.

OK, that all looks good except for not being able to connect to
MariaDB on 192.168.0.3.  That is likely only that you have not yet
changed the bind-address= line in the MariaDB config files, so it is
only allowing connections on localhost.  So you need to fix that now.
Do this to find all the bind-address lines:

sudo su
cd /etc/mysql
grep -ar "bind-address" *

There may be more than one bind-address line.  If so, choose one of
them and change it to:

bind-address=::

and change all the others by adding a # character as the first
character on the line (comment them out).  Use your favourite editor,
or nano.

Then restart MariaDB:

systemctl restart mariadb

and exit from the root command prompt:

exit

Now check that you can connect using 192.168.0.3:

mysql -u mythtv -p mythconverg

and give it the password from /etc/mythtv/config.xml.

>Tomorrow I may not be able to respond as have a few appointments scattered throughout the day, and as I am uncomfortable have Backend-3 and Backend-2 connected to the network at the same time until the problem is resolved might miss my window of experimentation.  Plus gives you a chance to get get over the headache I’ve been given you. <joke>
>
>Thanks again for the assistance!  Right now it seems like something simple we’re overlooking.
>Barry

I have a script I use to login to the database that reads the
credentials from /etc/mythtv/config.xml.  If you want a copy, I have
it on my web server:

http://www.jsw.gen.nz/mythtv/do_mythconverg.sh

Download that file and put it in /usr/local/bin, fix its ownership and
permissions, and install the package it needs:

sudo su
cd /usr/local/bin
wget -c http://www.jsw.gen.nz/mythtv/do_mythconverg.sh
chown root:root do_mythconverg.sh
chmod u=rwx,g=rwx,o=r do_mythconverg.sh
apt install xmlstarlet
exit

Now you can get normal access to the mythconverg database by:

do_m<hit the tab key><hit Enter>