<br><br><div class="gmail_quote">On 4 March 2011 23:45, Harry Devine <span dir="ltr"><<a href="mailto:lifter89@comcast.net">lifter89@comcast.net</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<div text="#000000" bgcolor="#ffffff"><div><div></div><div class="h5">
On 3/4/2011 2:16 AM, Anthony Giggins wrote:
<blockquote type="cite"><br>
<br>
<div class="gmail_quote">On 4 March 2011 10:24, Frank Phillips <span dir="ltr"><<a href="mailto:frankalso@gmail.com" target="_blank">frankalso@gmail.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<br>
<br>
<div class="gmail_quote">
<div>On Thu, Mar 3, 2011 at 5:29 PM, Harry Devine <span dir="ltr"><<a href="mailto:lifter89@comcast.net" target="_blank">lifter89@comcast.net</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
hdevine@hdevine-faa:~$ mysql -u mythtv -p -h
192.168.1.200<br>
Enter password:<br>
ERROR 1045 (28000): Access denied for user
'mythtv'@'192.168.1.105'<br>
(using password: YES)<br>
<br>
Using the mysql client on the master be, I printed out
the values in the<br>
user table of the mysql database:<br>
<br>
mysql> select Host,User,Password from user where
user='mythtv'\g<br>
+---------------+--------+-------------------------------------------+<br>
| Host | User | Password
|<br>
+---------------+--------+-------------------------------------------+<br>
| localhost | mythtv |
*A56FCCF24B1776335AA9DC7ACDE28E92A20FC921 |<br>
| % | mythtv |
*A56FCCF24B1776335AA9DC7ACDE28E92A20FC921 |<br>
| 192.168.1.105 | mythtv |
9b9890430520b16e39afb3698ded2eb0 |<br>
+---------------+--------+-------------------------------------------+<br>
3 rows in set (0.00 sec)<br>
</blockquote>
</div>
<div><br>
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.<br>
Try getting in from 192.169.1.200 (localhost) as the
mythtv user.<br>
<br>
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.<br>
</div>
</div>
<br>
_______________________________________________<br>
mythtv-users mailing list<br>
<a href="mailto:mythtv-users@mythtv.org" target="_blank">mythtv-users@mythtv.org</a><br>
<a href="http://www.mythtv.org/mailman/listinfo/mythtv-users" target="_blank">http://www.mythtv.org/mailman/listinfo/mythtv-users</a><br>
<br>
</blockquote>
</div>
<br>
Sounds like mysqld is not listening on the network interface or
there are firewall rules blocking it<br>
<br>
Check what interfaces its listening on by running the command
below<br>
<br>
$ netstat -l | grep mysql<br>
tcp 0 0 *:mysql
*:* LISTEN<br>
unix 2 [ ACC ] STREAM LISTENING 12192
/var/lib/mysql/mysql.sock<br>
<br>
then check the firewall by running<br>
<br>
iptables -L | grep mysql<br>
<br>
Cheers,<br>
<br>
Anthony<br>
<br>
<pre><fieldset></fieldset>
_______________________________________________
mythtv-users mailing list
<a href="mailto:mythtv-users@mythtv.org" target="_blank">mythtv-users@mythtv.org</a>
<a href="http://www.mythtv.org/mailman/listinfo/mythtv-users" target="_blank">http://www.mythtv.org/mailman/listinfo/mythtv-users</a>
</pre>
</blockquote></div></div>
OK, when I run netstat -l |grep mysql, I get:<br>
<br>
getnameinfo failed<div class="im"><br>
tcp 0 0 *:mysql *:* LISTEN<br></div>
unix 2 [ ACC ] STREAM LISTENING 5631
/var/run/mysqld/mysqld.sock<br>
<br>
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.<br>
<br>
Any ideas?<br>
Harry<br>
<br>
</div>
<br>_______________________________________________<br>
mythtv-users mailing list<br>
<a href="mailto:mythtv-users@mythtv.org">mythtv-users@mythtv.org</a><br>
<a href="http://www.mythtv.org/mailman/listinfo/mythtv-users" target="_blank">http://www.mythtv.org/mailman/listinfo/mythtv-users</a><br>
<br></blockquote></div><br>The other thing to check is that mythbackend is running on the LAN IP and not localhost in Mythtv Setup<br><br>Cheers,<br><br>Anthony<br>