[mythtv-users] MariaDB 10.3.22 Database access with Master and Fedora 31

[John Pilkington]

On 04/07/2020 20:01, Bill Meek wrote:
> On 7/4/20 10:40 AM, John Pilkington wrote:
>> On 04/07/2020 15:26, Bill Meek wrote:
>>
>>> I <think> you're expecting the last two commands to work, but there are
>>> no such users.
>>>
>>> I'd check to see if the wildcard is working with:
>>>
>>>    mysql --user=mythtv --host=192.168.1.68 --password mythconverg
>>>
>>> For everything except MariaDB versions below v10.3, I expect this to
>>> work, including things other than localhost:
>>>
>>> CREATE USER IF NOT EXISTS 'mythtv'@'localhost' IDENTIFIED WITH 
>>> mysql_native_password;
>>> ALTER USER 'mythtv'@'localhost' IDENTIFIED BY 'mythtv';
>>> GRANT ALL ON mythconverg.* TO 'mythtv'@'localhost';
>>
>> That is a part of the current master mc.sql that I used after the
>> F30-to-F31 upgrade.
>>
>> I haven't made any later changes.  Before the upgrade the subnet 
>> number was 66.  Somehow that changed to 68.
>>
>> Your suggested test gives me
>>
>> Access denied for user 'mythtv'@'HPFed.home' (using password=YES)
> 
> I'd get the mysql... test working first, since if that fails, MythTV will.
> May need to go after config.xml issues if it's using IPs rather than
> hostnames.
> 
> I did omit the FLUSH PRIVILEGES; command from the above.
> 
> I've got IPv6 working (since MythTV 0.25) and had to add more than
> the IPv4 solution. I missed the HPFed.home reference before, but I'll
> guess that it's one of the  IP's that changed. So, I'll assume it
> was changed in /etc/hosts (or however you resolve things.)
> 
> You could reserve the old IPv4 address in your router etc., but that's
> another thread.
> 
> Here's mine (which works):
> 
> MariaDB [mysql]> SELECT User,Host FROM user WHERE User='mythtv' ORDER BY 
> User,Host;
> +--------+--------------------+
> | User   | Host               |
> +--------+--------------------+
> | mythtv | 192.168.1.%        |
> | mythtv | fdf9:db8:db8:1::%  |
> | mythtv | localhost          |
> +--------+--------------------+
> 

Hi Bill:  Thanks again.  I'm afraid these posts had gone off-list.  I'm 
puzzled.  The command above doesn't appear to be looking at mythconverg, 
and my users table contains only 'admin'

I don't know how the hostname HPFed gained the .home suffix, but none of 
  HPFed, HPFed.home or hp_fed1 can get DB access.  Only localhost seems 
to work, but isn't active on frontend start.

Stephen's suggestion last month of "select * from settings where data 
like '%192.168%' ; " brings up only 3 lines;  3 instances of 
192.168.1.68 of which one is NULL and the other 2 are the 'profile' 
hostname hp_fed1

/etc/hosts has only 127.0.0.1 as localhost and ::1 as localhost6

It's getting late...

               ... and I didn't hit 'send'