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

[Steven Adeff]

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.

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