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

[Bill Meek]

On 5/22/19 11:53 AM, Barry Martin wrote:
> 
> 
> Hi Bill!
> 
> 
>      MariaDB [(none)]> SHOW GRANTS FOR 'mythtv'@'127.0.0.1';
> 
>      ERROR 1141 (42000): There is no such grant defined for user 'mythtv' on host '127.0.0.1'
> 
> If you'd like permissions for 127.0.0.1, just add it the same way others we added.
> 
> 
>     I think what I am going to do is leave the permissions for 127.0.0.1 as is as that’s to loopback which only would allow the Backend to work
>     with itself, not the network and so remote Frontends.
> 
>     SHOW GRANTS FOR 'mythtv'@'192.168.0.3’ (the static IP for BE-3) seems to the proper display.
> 
> 
> I think I was more concerned trying to get the (none) to display (mythconverg) and playing a little to see various outcomes and posting to give 
> you and Stephan information before requested.

Very good.

Leaving 'mythtv'@'127.0.0.1' out is fine, as you tested localhost and that works.  On any master or combined
master/frontend, the Database portion of config.xml should look like this:

   <Database>
     <PingHost>0</PingHost>
     <Host>localhost</Host>
     <UserName>mythtv</UserName>
     <Password>yourPassword</Password>
     <DatabaseName>mythconverg</DatabaseName>
     <Port>3306</Port>
   </Database>

MythTV will then use a socket, rather than TCP. The 'mythtv'@'192.168.0.%' entry
would be for remote frontends, which connects via TCP.

Try this to prove everything's OK:

$ sudo netstat --all | egrep '3306|mysql'
[sudo] password for bill:
tcp6       0      0 [::]:mysql              [::]:*                  LISTEN     <-- for remotes (IPV4 is fine too)
unix  2      [ ACC ]     STREAM     LISTENING     33345    /var/run/mysqld/mysqld.sock   <-- master uses a socket
unix  3      [ ]         STREAM     CONNECTED     84855    /var/run/mysqld/mysqld.sock
unix  3      [ ]         STREAM     CONNECTED     86098    /var/run/mysqld/mysqld.sock
<and many more similar to the above 2 lines>

On the remote frontends, the config.xml would look the same, but with an IP in it's <Host> line.

-- 
Bill