[mythtv-users] Frontend setup

[H P Ladds]

Hey all,

I can't connect to the Backend of my Frontend/Backend machine from a remote
Frontend machine.

Using Knoppmyth. Frontend/Backend is a AMD 3500+ 64 machine. (Works Fine)
The Frontend only machine is a Celeron 3.05. (Has worked as a dedicated
Front/Backend machine.)
But using the Celeron as Frontend only....

Below are the error messages I receive:

2006-07-11 09:43:26.513 Using runtime prefix 2006-07-11 09:43:26.540 New DB connection, total: 1
2006-07-11 09:43:26.542 Unable to connect to database!
2006-07-11 09:43:26.542 Driver error was [1/2003]:
QMYSQL3: Unable to connect
Database error was:
Can't connect to MySQL server on '192.168.2.102' (111)

2006-07-11 09:43:26.600 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError? Strange...
2006-07-11 09:43:26.653 Unable to connect to database!
2006-07-11 09:43:26.653 Driver error was [1/2003]:
QMYSQL3: Unable to connect
Database error was:Can't connect to MySQL server on '192.168.2.102' (111)
....

(note: many more instances of the above error message edited out ... )

2006-07-11 09:43:36.003 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError? Strange...
2006-07-11 09:43:36.056 Failed to init MythContext, exiting.

I've tried a multitude of setup option provided by that Knoppmyth's API --
no luck, always the same error messages as above.

I have also tried is solution from the web -- "Fedora Myth
Tips-n-tTricks<http://wilsonet.com/mythtv/tips.php>"
However, I can't tell if there is a typo in the instructions. If my backend
is 192.168.0.112 and the frontend is 192.168.0.115. Are the instructions
suggesting that I grant permission to mythtv@"192.168.0.%" ? (Please see
text below.)

          " Configuring a remote front-end is relatively easy. There are
only a few steps you need to take on your back-end machine.

1. On the machine you're running mysql (typically the same machine as your
MythTV master backend server), you need to allow mysql connections from
other hosts on your network. This example assumes your local area network is
10.0.1.0/255.255.255.0, adjust accordingly for your network:
$ mysql -u root -p mythconverg
mysql> grant all on mythconverg.* to mythtv@"10.0.1.%" identified by
"mythtv";
mysql> flush privileges;
mysql> quit

2. In the mythtvsetup application on your back-end, you'll need to make sure
you set the variables for "IP address for <host>" and "Master Server IP
address" to the IP address of the back-end's network card, rather than the
loopback address (127.0.0.1).

3. On your remote systems, you'll need to edit one or more files. If your
remote system is a remote frontend only, open up ~/.mythtv/mysql.txt, and
change the DBHostName variable from localhost to the IP or host name of your
back-end server (the one you just set in the previous step). If your remote
system is a slave backend (i.e., it has a tuner card you want to use with
MythTV), you'll need to make the same changes to /.mythtv/mysql.txt and
/root/.mythtv/mysql.txt.

4. In the mythtvsetup application on your front-end, you'll need to make
sure you set the variable for "Master Server IP address" to the IP address
of the machine you just set in your mysql.txt file.
These are the primary changes that differentiate a setup with a remote
front-end, but you'll also have to go through the bulk of the rest of the
steps detailed here to get things working. A few of the packages installed
throughout this guide aren't necessary for a front-end only system, but it
won't hurt anything to install them anyway, so I'm not going to go into what
they are."

I have read that problems similar to mine are caused by running
differing versions of MySQL. I installed from the same installation disk, so
I'm assuming that the same version has been installed. But perhaps not;
might KnoppmythTV install two differing version of MySQL -- depending upon
the machine's hardware?

Thanks All
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-users/attachments/20060711/99fc6ba6/attachment.htm