[mythtv-users] Mythbuntu remote frontend can't connect to server

[Phil Bridges]

On Sun, Oct 3, 2010 at 12:52 PM, Steven Adeff <adeffs.mythtv at gmail.com> wrote:
> On Sun, Oct 3, 2010 at 12:34 PM, Steven Adeff <adeffs.mythtv at gmail.com> wrote:
>> On Sun, Oct 3, 2010 at 12:13 PM, Greg Oliver <oliver.greg at gmail.com> wrote:
>>> On Sun, Oct 3, 2010 at 11:04 AM, Steven Adeff <adeffs.mythtv at gmail.com> wrote:
>>>> ack, nevermind, that didn't solve it, still not connecting...
>>>>
>>>> On Sun, Oct 3, 2010 at 12:02 PM, Steven Adeff <adeffs.mythtv at gmail.com> wrote:
>>>>> GAH, nevermind, top posting because this was just IO error, apparently
>>>>> mythbuntu does not properly set the master backend IP's properly when
>>>>> you tell it you want to be able to connect remote frontends, so I had
>>>>> to change them from 127.0.0.1
>>>>>
>>>>>
>>>>> On Sun, Oct 3, 2010 at 11:47 AM, Steven Adeff <adeffs.mythtv at gmail.com> wrote:
>>>>>> Hello all, little issue I can't quite pin down.
>>>>>>
>>>>>> I've got a new mythtv system I'm building for my parents. I've got a
>>>>>> main system with a backend and frontend, and one remote frontend. I'm
>>>>>> running mythbuntu 10.04 on both. I set up the backend and with the
>>>>>> mythtv-database package told it I will have remote frontends, except I
>>>>>> can't get the remote frontend to connect, I've even tried one of my
>>>>>> frontends with the config.xml and mysql.txt to point to their backend.
>>>>>> they see the machine but it says it can't connect,
>>>>>>
>>>>>> 2010-10-03 11:36:53.341 Driver error was [1/2002]:
>>>>>> QMYSQL: Unable to connect
>>>>>> Database error was:
>>>>>> Can't connect to local MySQL server through socket
>>>>>> '/var/run/mysqld/mysqld.sock' (2)
>>>>>>
>>>>>>
>>>>>> it then looks for UPnP backends and finds my backend and connects,
>>>>>>
>>>>>> 2010-10-03 11:36:53.469 UPnPautoconf() - Found one UPnP backend
>>>>>> 2010-10-03 11:36:53.629 Testing network connectivity to '192.168.1.151'
>>>>>> 2010-10-03 11:36:53.637 Closing DB connection named 'DBManager0'
>>>>>> 2010-10-03 11:36:53.658 Connected to database 'mythconverg' at host:
>>>>>> 192.168.1.151
>>>>>> 2010-10-03 11:36:53.659 Closing DB connection named 'DBManager0'
>>>>>> 2010-10-03 11:36:53.668 ScreenSaverX11Private: Gnome screen saver
>>>>>> support enabled
>>>>>> 2010-10-03 11:36:53.710 DPMS is not supported.
>>>>>> Xlib:  extension "Generic Event Extension" missing on display "localhost:12.0".
>>>>>> Xlib:  extension "Generic Event Extension" missing on display "localhost:12.0".
>>>>>> 2010-10-03 11:36:53.766 Primary screen: 0.
>>>>>> 2010-10-03 11:36:53.767 Connected to database 'mythconverg' at host:
>>>>>> 192.168.1.151
>>>>>>
>>>>>>
>>>>>> I've tried manually telling mysql to allow remote connections, but to
>>>>>> no avail. I've compared the mysql config files between my backend and
>>>>>> this new one and can't see a difference.
>>>>>>
>>>>>> anyone have a similar experience and figure it out, or have an idea
>>>>>> for me to try? I used mythbuntu 10.04 to set up my backend and don't
>>>>>> remember having this issue so I'm a bit lost.
>>>>>>
>>>>>> thanks!
>>>>>>
>>>
>>> I always use these steps:
>>>
>>> $ mysql -u root mythconverg
>>> mysql> grant all on mythconverg.* to mythtv@"192.168.100.%" identified
>>> by "mythtv";
>>> mysql> flush privileges;
>>>
>>> I change the password something more user friendly as well..
>>>
>>> mysql> UPDATE user SET Password=PASSWORD('mythtv') WHERE user='mythtv';
>>> mysql> FLUSH PRIVILEGES;
>>> mysql> quit
>>>
>>> It's all from the manual or wiki, but I seem to have to reference it
>>> everytime anyway.
>>>
>>> I think you can also run 'dpkg-reconfigure mysql-server' in Ubuntu and
>>> it may ask you all of those questions.  Of course, the config.xml and
>>> mysql.txt files have to be updated after that, but at least the
>>> password is something you do not have to cut and paster or write down
>>> for posterity..
>>
>> mysql> UPDATE user SET Password=PASSWORD('mythtv') WHERE user='mythtv';
>> ERROR 1146 (42S02): Table 'mythconverg.user' doesn't exist
>>
>> my personal backend mythconverg does not contain mythconverg.user either.
>
> ok, I think I'm a step closer, from a remote system,
> $ mysql -h 192.168.1.142 -u mythtv -p mythconverg
> Enter password:
> ERROR 1045 (28000): Access denied for user 'mythtv'@'fileserver'
> (using password: YES)
>
> from the local machine,
> # mysql -u mythtv -p mythconverg
> works,
> # mysql -h 192.168.1.142 -u mythtv -p mythconverg
> doesn't.
>
> but if I use localhost or 127.0.0.1 from the local machine it does.
>
> so apparently mysql will accept connections from the loopback but not
> from the exact ip, even when originating locally.
>
> still don't know why or how to fix it, and I have run this, multiple
> times actually...
> $ mysql -u root mythconverg
> mysql> grant all on mythconverg.* to mythtv@"%" identified by "mythtv";
> Query OK, 0 rows affected (0.00 sec)
>
> mysql> flush privileges;
> Query OK, 0 rows affected (0.00 sec)
>
>
> --


IIRC, there's a setting in my.cnf (or one of the mysql config files)
that indicates where MySQL binds (if it is dedicated to a particular
port).  It defaults to loopback.  Comment out that line, and restart
MySQL.