[mythtv-users] Can't get remote frontend to connect

[Anthony Giggins]

On 4 March 2011 23:45, Harry Devine <lifter89 at comcast.net> wrote:

>  On 3/4/2011 2:16 AM, Anthony Giggins wrote:
>
>
>
> On 4 March 2011 10:24, Frank Phillips <frankalso at gmail.com> wrote:
>
>>
>>
>>  On Thu, Mar 3, 2011 at 5:29 PM, Harry Devine <lifter89 at comcast.net>wrote:
>>
>>> hdevine at hdevine-faa:~$ mysql -u mythtv -p -h 192.168.1.200
>>> Enter password:
>>> ERROR 1045 (28000): Access denied for user 'mythtv'@'192.168.1.105'
>>> (using password: YES)
>>>
>>> Using the mysql client on the master be, I printed out the values in the
>>> user table of the mysql database:
>>>
>>> mysql> select Host,User,Password from user where user='mythtv'\g
>>> +---------------+--------+-------------------------------------------+
>>> | Host          | User   | Password                                  |
>>> +---------------+--------+-------------------------------------------+
>>> | localhost     | mythtv | *A56FCCF24B1776335AA9DC7ACDE28E92A20FC921 |
>>> | %             | mythtv | *A56FCCF24B1776335AA9DC7ACDE28E92A20FC921 |
>>> | 192.168.1.105 | mythtv | 9b9890430520b16e39afb3698ded2eb0          |
>>> +---------------+--------+-------------------------------------------+
>>> 3 rows in set (0.00 sec)
>>>
>>
>> A quick google suggests doing a select password('password'); to compare
>> the hashes. Note that there are different hashes for '%' and
>> '192.168.2.105'. You may be using the former and it is trying to
>> authenticate against the latter.
>> Try getting in from 192.169.1.200 (localhost) as the mythtv user.
>>
>> You are talking with the daemon, so its not a blocked port, and the grant
>> tables (grant/flush privileges) shouldn't affect your ability to login,
>> AFAIK.
>>
>> _______________________________________________
>> mythtv-users mailing list
>> mythtv-users at mythtv.org
>> http://www.mythtv.org/mailman/listinfo/mythtv-users
>>
>>
> Sounds like mysqld is not listening on the network interface or there are
> firewall rules blocking it
>
> Check what interfaces its listening on by running the command below
>
> $ netstat -l | grep mysql
> tcp        0      0 *:mysql                     *:*
> LISTEN
> unix  2      [ ACC ]     STREAM     LISTENING     12192
> /var/lib/mysql/mysql.sock
>
> then check the firewall by running
>
> iptables -L | grep mysql
>
> Cheers,
>
> Anthony
>
>
> _______________________________________________
> mythtv-users mailing listmythtv-users at mythtv.orghttp://www.mythtv.org/mailman/listinfo/mythtv-users
>
>  OK, when I run netstat -l |grep mysql, I get:
>
> getnameinfo failed
>
> tcp    0    0    *:mysql    *:*    LISTEN
> unix 2    [ ACC ]    STREAM    LISTENING    5631
> /var/run/mysqld/mysqld.sock
>
> Running iptables -L returns nothing.  Just goes back to the prompt.  I'm
> pretty sure that I have the software firewall on the backend turned off.
>
> Any ideas?
> Harry
>
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://www.mythtv.org/mailman/listinfo/mythtv-users
>
>
The other thing to check is that mythbackend is running on the LAN IP and
not localhost in Mythtv Setup

Cheers,

Anthony
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.mythtv.org/pipermail/mythtv-users/attachments/20110305/7b27def7/attachment.html