[mythtv-users] MariaDB 10.3.22 Database access with Master and Fedora 31
John Pilkington
johnpilk222 at gmail.com
Sun Jul 5 07:34:31 UTC 2020
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'
More information about the mythtv-users
mailing list