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

Steven Adeff adeffs.mythtv at gmail.com
Sun Oct 3 16:52:18 UTC 2010


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)


-- 
Steve
http://www.mythtv.org/wiki/User:Steveadeff
Before you ask, read the FAQ!
http://www.mythtv.org/wiki/index.php/Frequently_Asked_Questions
then search the Wiki, and this list,
http://www.gossamer-threads.com/lists/mythtv/
Mailinglist etiquette -
http://www.mythtv.org/wiki/index.php/Mailing_List_etiquette


More information about the mythtv-users mailing list