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

[Greg Oliver]

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..