Awesome, email was sent before I finished...Seems like mythtv decided to override some settings. How nice...Deleted the line and now it works. I understand why they did it, but they should have probably just used 0.0.0.0 instead.<div>
<br></div><div><div>me@ubuntu:/etc/mysql/conf.d# cat mythtv.cnf</div><div>[mysqld]</div><div>bind-address=192.168.1.x</div><div>max_connections=100</div></div><div><br></div><div class="gmail_extra"><br><br><div class="gmail_quote">
On Tue, Dec 4, 2012 at 10:45 PM, Steve Malenfant <span dir="ltr"><<a href="mailto:smalenfant@gmail.com" target="_blank">smalenfant@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
I found the problem...<div class="HOEnZb"><div class="h5"><div><br></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Tue, Dec 4, 2012 at 9:08 PM, Steve Malenfant <span dir="ltr"><<a href="mailto:smalenfant@gmail.com" target="_blank">smalenfant@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">My bind-address in my.cnf is 127.0.0.1. But if I look at netstat it is bound to my 192.168.1.x address.<div><br></div>
<div>
<div>me@ubuntu:~$ grep bind /etc/mysql/my.cnf</div><div>bind-address = 127.0.0.1</div></div>
<div><br></div><div><div>me@ubuntu:~$ netstat -an | grep 3306</div><div>tcp 0 0 192.168.1.x:3306 0.0.0.0:* LISTEN</div></div><div><div><div><br></div><div class="gmail_extra">
<br><br><div class="gmail_quote">
On Tue, Dec 4, 2012 at 9:14 AM, Mike Perkins <span dir="ltr"><<a href="mailto:mikep@randomtraveller.org.uk" target="_blank">mikep@randomtraveller.org.uk</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div><div>On 04/12/12 13:46, Steve Malenfant wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
I upgraded my packages last night and lost mythweb in the process. Looks<br>
like my credentials are OK when I use "localhost" to connect to Mysql, but<br>
not when specifying 127.0.0.1. I changed my settings in<br>
/etc/mythtv/config.xml from 127.0.0.1 to localhost but didn't seem to have<br>
any effect on it. Anybody having the same problem? I can't seem to be able<br>
to override the "127.0.0.1" with all the location I tried.<br>
<br>
root@ubuntu:~/.mythtv# mysql -h 127.0.0.1 -umythtv -p mythconverg<br>
Enter password:<br>
ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (111)<br>
<br>
root@ubuntu:~/.mythtv# mysql -h localhost -umythtv -p mythconverg<br>
Enter password:<br>
Reading table information for completion of table and column names<br>
You can turn off this feature to get a quicker startup with -A<br>
<br>
Welcome to the MySQL monitor. Commands end with ; or \g.<br>
Your MySQL connection id is 185<br>
Server version: 5.5.28-0ubuntu0.12.04.2 (Ubuntu)<br>
<br>
Copyright (c) 2000, 2012, Oracle and/or its affiliates. All rights reserved.<br>
<br>
Oracle is a registered trademark of Oracle Corporation and/or its<br>
affiliates. Other names may be trademarks of their respective<br>
owners.<br>
<br>
Type 'help;' or '\h' for help. Type '\c' to clear the current input<br>
statement.<br>
<br>
mysql> quit<br>
<br>
</blockquote></div></div>
See if your mysql configuration has overwritten "bind-address".<span><font color="#888888"><br>
<br>
-- <br>
<br>
Mike Perkins<br>
<br>
______________________________<u></u>_________________<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/<u></u>listinfo/mythtv-users</a><br>
</font></span></blockquote></div><br></div>
</div></div></blockquote></div><br></div>
</div></div></blockquote></div><br></div>