[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