[mythtv-users] mysql issue when accessing backend from a remotefrontend

[Brad DerManouelian]

On Aug 20, 2006, at 8:22 PM, Andy Barr wrote:

> On 8/20/06, Andy Barr <ajbarr at gmail.com> wrote:
>> On 8/19/06, William Munson <wmunson at rochester.rr.com> wrote:
>>>>
>>>> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
>>>>
>>>> mysql> select host, user, password from user;
>>>> +--------------+------------------+------------------+
>>>> | host         | user             | password         |
>>>> +--------------+------------------+------------------+
>>>> | localhost    | root             | 121900c5120ed8d8 |
>>>> | mythtv       | root             |                  |
>>>> | localhost    | debian-sys-maint | 417a15742dd5e8e5 |
>>>> | localhost    | mythtv           | 0476fc026afffe24 |
>>>> | %            | mythtv           | 0476fc026afffe24 |
>>>> | 192.168.2.%% | mythtv           | 0476fc026afffe24 |
>>>> | 192.168.2.50 | mythtv           | 67457e226a1a15bd |
>>>> | 192.168.2.%  | mythtv           | 0476fc026afffe24 |
>>>> | xbox         | mythtv           | 0476fc026afffe24 |
>>>> +--------------+------------------+------------------+
>>>> 9 rows in set (0.00 sec)
>>>>
>>>> I suspect this is some mysql configuration issue but I searched and
>>>> tried every suggestion I saw.  Does anyone have any more ideas?
>>>> Thanks,
>>>> Andy
>>>>
>>>
>>> This may seem a bit obvious, is your network on 192.168.2.%?   
>>> Most are
>>> on .1.%
>>>
>>> Another option would be to install webmin and use it to configure  
>>> mysql
>>> in a nice gui. You should be able to verify if the server is  
>>> working. by
>>> telneting to your backend on the mysql port from your remote  
>>> machine and
>>> see what your login attempt does.
>>>
>>
>> Yes my network is 192.168.2.%.
>>
>> I installed webmin and as best I can tell permissions are correct.
>> Under user permissions it says,
>> mythtv 192.168.2.% permissions=All
>> Under database permissions it says the same thing with database of  
>> mythconverg.
>> Nothing is listed under Host permissions.  Is that correct?
>>
>> This is what I get from telnetting.
>>
>> xbox:~/.ssh# telnet 192.168.2.253 3306
>> Trying 192.168.2.253...
>> Connected to 192.168.2.253.
>> Escape character is '^]'.
>> G
>> 5.0.22-Debian_0ubuntu6.06'a6*j]p<wfvA"$/\bXt^
>> Connection closed by foreign host.
>>
>> Thanks for the help.
>> Andy
>>
> I just noticed that my xbox is running mysql client 4.0.22 but my
> backend is running mysql 5.0.  Could this be causing the issue?

Most certainly is. At some point mysql changed the way passwords were  
handled. Best thing would be to update the client, but if you poke  
around google for old password support, there's a command you can  
issue on the server side to use the old-style passwords. It might  
even be OLD_PASSWORD("password") instead of just "password". Can't  
remember off the top of my head what it is, though.