Mailing List Archive: MythTV: Users

Help! New Frontend box cannot connect to master backend in setup.

Index | Next | Previous | View Threaded

allen.edwards at oldpaloalto

Aug 7, 2008, 4:19 PM

Post #1 of 9 (450 views)
Permalink

Help! New Frontend box cannot connect to master backend in setup.

My Mythbuntu 8.04 machine works great. I decided to add a frontend so
my wife can watch from the bedroom. I am trying to use Mythbuntu 8.04.1
for that.

I googled the two error messages I have gotten in the three install
attempts I have made. Installing as a frontend only, I get "Connection
Results: Failure" at the MySQL screen when I test the connection. I
then tried a simple combined install and then deleted the backend and
got a message "Cannot login to database" even after entering the IP and
password of the backend.

In the mySQL screen, I entered 192.168.1.111, the IP address of the backend.
For password, I entered the password from the /etc/mythtv/mysql.txt file
of cdRN8CXD.
I can both ping and connect to mythweb from this would-be frontend so I
know the connection is good.

I checked the Host Address Backend Setup on the main myth box. I tried
both 127.0.0.1 and 192.168.1.111 as the IP addresses in both spots. The
security pin is set to 0000 which should allow anyone to connect.
Everything else looks like it does in the installation manual.

I am stuck, out of ideas. This can't be this hard as I know lots of
people do this.

Allen

_______________________________________________
mythtv-users mailing list
mythtv-users[at]mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

gravityhammer at gmail

Aug 7, 2008, 6:24 PM

Post #2 of 9 (429 views)
Permalink

Re: Help! New Frontend box cannot connect to master backend in setup. [In reply to]

On Thu, Aug 7, 2008 at 7:19 PM, Allen Edwards
<allen.edwards[at]oldpaloalto.com> wrote:
> My Mythbuntu 8.04 machine works great. I decided to add a frontend so
> my wife can watch from the bedroom. I am trying to use Mythbuntu 8.04.1
> for that.
>
> I googled the two error messages I have gotten in the three install
> attempts I have made. Installing as a frontend only, I get "Connection
> Results: Failure" at the MySQL screen when I test the connection. I
> then tried a simple combined install and then deleted the backend and
> got a message "Cannot login to database" even after entering the IP and
> password of the backend.
>
> In the mySQL screen, I entered 192.168.1.111, the IP address of the backend.
> For password, I entered the password from the /etc/mythtv/mysql.txt file
> of cdRN8CXD.
> I can both ping and connect to mythweb from this would-be frontend so I
> know the connection is good.
>
> I checked the Host Address Backend Setup on the main myth box. I tried
> both 127.0.0.1 and 192.168.1.111 as the IP addresses in both spots. The
> security pin is set to 0000 which should allow anyone to connect.
> Everything else looks like it does in the installation manual.
>
> I am stuck, out of ideas. This can't be this hard as I know lots of
> people do this.
>

Do you have any other mysql.txt files?

On the new frontend, can you connect to the master backend MySQL server?
_______________________________________________
mythtv-users mailing list
mythtv-users[at]mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

allen.edwards at oldpaloalto

Aug 7, 2008, 8:31 PM

Post #3 of 9 (428 views)
Permalink

Re: Help! New Frontend box cannot connect to master backend in setup. [In reply to]

Phil Bridges wrote:
> On Thu, Aug 7, 2008 at 7:19 PM, Allen Edwards
> <allen.edwards[at]oldpaloalto.com> wrote:
>> My Mythbuntu 8.04 machine works great. I decided to add a frontend so
>> my wife can watch from the bedroom. I am trying to use Mythbuntu 8.04.1
>> for that.
>>
>> I googled the two error messages I have gotten in the three install
>> attempts I have made. Installing as a frontend only, I get "Connection
>> Results: Failure" at the MySQL screen when I test the connection. I
>> then tried a simple combined install and then deleted the backend and
>> got a message "Cannot login to database" even after entering the IP and
>> password of the backend.
>>
>> In the mySQL screen, I entered 192.168.1.111, the IP address of the backend.
>> For password, I entered the password from the /etc/mythtv/mysql.txt file
>> of cdRN8CXD.
>> I can both ping and connect to mythweb from this would-be frontend so I
>> know the connection is good.
>>
>> I checked the Host Address Backend Setup on the main myth box. I tried
>> both 127.0.0.1 and 192.168.1.111 as the IP addresses in both spots. The
>> security pin is set to 0000 which should allow anyone to connect.
>> Everything else looks like it does in the installation manual.
>>
>> I am stuck, out of ideas. This can't be this hard as I know lots of
>> people do this.
>>
>
> Do you have any other mysql.txt files?
>
> On the new frontend, can you connect to the master backend MySQL server?
>
Thanks for the reply.

I have 4 mysql.txt files on the machine but they all have the same
password on them.

I reinstalled mythbuntu a 4th time far enough that I could get a command
prompt and had mysql installed.
I issued this command:
mysql -h 192.168.1.111 -u root -p
I entered my password and cannot connect.

I guess that points to the backend, but what? I have checked all the
settings in myth three times.

Allen
_______________________________________________
mythtv-users mailing list
mythtv-users[at]mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

knowledgejunkie at gmail

Aug 7, 2008, 8:42 PM

Post #4 of 9 (428 views)
Permalink

Re: Help! New Frontend box cannot connect to master backend in setup. [In reply to]

On 08/08/2008, Allen Edwards <allen.edwards[at]oldpaloalto.com> wrote:

> I reinstalled mythbuntu a 4th time far enough that I could get a command
> prompt and had mysql installed.
> I issued this command:
> mysql -h 192.168.1.111 -u root -p
> I entered my password and cannot connect.
>
>
> I guess that points to the backend, but what? I have checked all the
> settings in myth three times.

More likely an access issue with your MySQL installation, which is
denying access to remote hosts. Check your /etc/my.cnf on the DB host
in case it is binding to localhost, and if that is not the case, you
may have to grant access for your remote machines to the MythTV
database directly - instructions can be found in the MythTV docs and
on the wiki.

--
Nick Morrott

MythTV Official wiki:
http://mythtv.org/wiki/
MythTV users list archive:
http://www.gossamer-threads.com/lists/mythtv/users

"An investment in knowledge always pays the best interest." - Benjamin Franklin
_______________________________________________
mythtv-users mailing list
mythtv-users[at]mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

allen.edwards at oldpaloalto

Aug 7, 2008, 9:55 PM

Post #5 of 9 (427 views)
Permalink

Re: Help! New Frontend box cannot connect to master backend in setup. [In reply to]

Nick Morrott wrote:
> On 08/08/2008, Allen Edwards <allen.edwards[at]oldpaloalto.com> wrote:
>
>> I reinstalled mythbuntu a 4th time far enough that I could get a command
>> prompt and had mysql installed.
>> I issued this command:
>> mysql -h 192.168.1.111 -u root -p
>> I entered my password and cannot connect.
>>
>>
>> I guess that points to the backend, but what? I have checked all the
>> settings in myth three times.
>
> More likely an access issue with your MySQL installation, which is
> denying access to remote hosts. Check your /etc/my.cnf on the DB host
> in case it is binding to localhost, and if that is not the case, you
> may have to grant access for your remote machines to the MythTV
> database directly - instructions can be found in the MythTV docs and
> on the wiki.
>
Thank you. I think that must be it.

That file has:
bind-address = 127.0.0.1

which, according to the wiki I need to comment out. Can't try it until
"So You Think You Can Dance" is over -- my family would kill me if I
messed up their watching of the show by locking up some database...

I think you have put me on the right track and I thank you again.

Allen

_______________________________________________
mythtv-users mailing list
mythtv-users[at]mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

finlay at moeraki

Aug 7, 2008, 10:13 PM

Post #6 of 9 (428 views)
Permalink

Re: Help! New Frontend box cannot connect to master backend in setup. [In reply to]

Allen Edwards wrote:
> My Mythbuntu 8.04 machine works great. I decided to add a frontend so
> my wife can watch from the bedroom. I am trying to use Mythbuntu 8.04.1
> for that.
>
> I googled the two error messages I have gotten in the three install
> attempts I have made. Installing as a frontend only, I get "Connection
> Results: Failure" at the MySQL screen when I test the connection. I
> then tried a simple combined install and then deleted the backend and
> got a message "Cannot login to database" even after entering the IP and
> password of the backend.
>
> In the mySQL screen, I entered 192.168.1.111, the IP address of the backend.
> For password, I entered the password from the /etc/mythtv/mysql.txt file
> of cdRN8CXD.
> I can both ping and connect to mythweb from this would-be frontend so I
> know the connection is good.
>
> I checked the Host Address Backend Setup on the main myth box. I tried
> both 127.0.0.1 and 192.168.1.111 as the IP addresses in both spots. The
> security pin is set to 0000 which should allow anyone to connect.
> Everything else looks like it does in the installation manual.
>
> I am stuck, out of ideas. This can't be this hard as I know lots of
> people do this.
>
>
Have you tried on the backend using the Applications->System->Mythbuntu
Control Center. Look on the System Services page to see if the MySQL
Service is Enabled which allows the DB to accept connections remotely.
If it's Disabled try Enabling it and then clicking the Apply button. I
don't remember if you have to restart MySQL after doing this.

John
_______________________________________________
mythtv-users mailing list
mythtv-users[at]mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

allen.edwards at oldpaloalto

Aug 8, 2008, 9:07 AM

Post #7 of 9 (392 views)
Permalink

Re: Help! New Frontend box cannot connect to master backend in setup. [In reply to]

On Thu, Aug 7, 2008 at 10:13 PM, John Finlay <finlay[at]moeraki.com> wrote:
> Allen Edwards wrote:
>>
>> My Mythbuntu 8.04 machine works great. I decided to add a frontend so my
>> wife can watch from the bedroom. I am trying to use Mythbuntu 8.04.1 for
>> that.
>>
>> I googled the two error messages I have gotten in the three install
>> attempts I have made. Installing as a frontend only, I get "Connection
>> Results: Failure" at the MySQL screen when I test the connection. I then
>> tried a simple combined install and then deleted the backend and got a
>> message "Cannot login to database" even after entering the IP and password
>> of the backend.
>>
>> In the mySQL screen, I entered 192.168.1.111, the IP address of the
>> backend.
>> For password, I entered the password from the /etc/mythtv/mysql.txt file
>> of cdRN8CXD.
>> I can both ping and connect to mythweb from this would-be frontend so I
>> know the connection is good.
>>
>> I checked the Host Address Backend Setup on the main myth box. I tried
>> both 127.0.0.1 and 192.168.1.111 as the IP addresses in both spots. The
>> security pin is set to 0000 which should allow anyone to connect.
>> Everything else looks like it does in the installation manual.
>>
>> I am stuck, out of ideas. This can't be this hard as I know lots of
>> people do this.
>>
>>
>
> Have you tried on the backend using the Applications->System->Mythbuntu
> Control Center. Look on the System Services page to see if the MySQL Service
> is Enabled which allows the DB to accept connections remotely. If it's
> Disabled try Enabling it and then clicking the Apply button. I don't
> remember if you have to restart MySQL after doing this.
>
> John
>

This was a huge help, Thanks!!!

I can now access the mysql database from the new frontend. I can also
watch recordings and play live TV. That is great.

However, I cannot play music or videos. I can see the titles, but
when I try and play I get a message about failure to open. I think I
need to enable NTFS on the backend and will try that later today.

The other problem is that XvMC locks up X. I can play recordings on
SLIM but not on CPU--, for example. Don't know what is going on
there.

I am thinking of going back to Mythbuntu 8.04 for the new frontend.
8.04.1 is doing some other strange things so perhaps it has problems.

Allen
_______________________________________________
mythtv-users mailing list
mythtv-users[at]mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

gravityhammer at gmail

Aug 8, 2008, 9:40 AM

Post #8 of 9 (391 views)
Permalink

Re: Help! New Frontend box cannot connect to master backend in setup. [In reply to]

On Fri, Aug 8, 2008 at 12:07 PM, Allen Edwards
<allen.edwards[at]oldpaloalto.com> wrote:

>
> However, I cannot play music or videos. I can see the titles, but
> when I try and play I get a message about failure to open. I think I
> need to enable NTFS on the backend and will try that later today.

I think you're looking for NFS, not NTFS. Yes, your music / video
directories will need to be mounted on your frontend; preferably, at
the same mountpoint as they exist on your other machine.
_______________________________________________
mythtv-users mailing list
mythtv-users[at]mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

allen.edwards at oldpaloalto

Aug 8, 2008, 8:49 PM

Post #9 of 9 (372 views)
Permalink

Re: Help! New Frontend box cannot connect to master backend in setup. [In reply to]

Phil Bridges wrote:
> On Fri, Aug 8, 2008 at 12:07 PM, Allen Edwards
> <allen.edwards[at]oldpaloalto.com> wrote:
>
>> However, I cannot play music or videos. I can see the titles, but
>> when I try and play I get a message about failure to open. I think I
>> need to enable NTFS on the backend and will try that later today.
>
> I think you're looking for NFS, not NTFS. Yes, your music / video
> directories will need to be mounted on your frontend; preferably, at
> the same mountpoint as they exist on your other machine.
> _______________________________________________
> mythtv-users mailing list
> mythtv-users[at]mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>
Thanks for the help.

I enabled NFS but that didn't help. I gave up and installed the DVR
interface which removes these options and simplifies the interface.
Good enough for what I want to do.

BTW, I could not get XvMC to work either in spite of having made it work
on an almost identical computer and another more powerful one. SLIM
seems to be working well so I will try and stick with that.

Allen

_______________________________________________
mythtv-users mailing list
mythtv-users[at]mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

Index | Next | Previous | View Threaded

Interested in having your list archived? Contact lists@gossamer-threads.com