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

[Anthony Giggins]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.mythtv.org/pipermail/mythtv-users/attachments/20110304/58b13fe4/attachment.html