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

Harry Devine lifter89 at comcast.net
Fri Mar 4 13:45:41 UTC 2011


On 3/4/2011 2:16 AM, Anthony Giggins wrote:
>
>
> On 4 March 2011 10:24, Frank Phillips <frankalso at gmail.com 
> <mailto:frankalso at gmail.com>> wrote:
>
>
>
>     On Thu, Mar 3, 2011 at 5:29 PM, Harry Devine <lifter89 at comcast.net
>     <mailto: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 <mailto: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 list
> mythtv-users at mythtv.org
> http://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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.mythtv.org/pipermail/mythtv-users/attachments/20110304/e509765c/attachment.html 


More information about the mythtv-users mailing list