[mythtv-users] Frontend setup

[Nick]

On 11/07/06, H P Ladds <householdwords at gmail.com> wrote:
>
> 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 = /usr
> 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"
> 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.)

If your local network is 192.168.0.0/24 and you want remote machines
to be able to connect to the SQL server with username 'mythtv', then
you need to grant access to either each machine explicitly, or more
commonly the local network as a whole, which is what the GRANT command
above will do.

Note however, that the errors you posted above are trying to connect
to a SQL server on 192.168.2.102, so you need to make sure you use the
correct network address in the GRANT command.

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

Note that the GRANT command above gives access to clients on the local
10.0.1.0/24 network logging into the database with username 'mythtv'.
If you want to alter this at any time, you will need to update the
privileges.

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

Note that the mysql.txt file contains details of the SQL server,
database, username and password that MythTV will connect to, but if
you haven't granted access permissions to remote machines on the SQL
server, you will not be abe to connect.

Nick

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