[mythtv-users] Frontend setup

H P Ladds householdwords at gmail.com
Tue Jul 11 19:58:40 UTC 2006


Nick,

Thanks so much.

Did I mention my newbie status? I need to ask a few follow-up questions.

How do I accertain the address of my local network? You correctly noticed
that error messages report failed attempts to connect to 192.168.2.102. (The
192.168.0.112 adresses were hypothetical). ifconfig of my Front/Backend is
192.168.2.102.  I was trying to isolate on the "%" in the address; Is
that the correct usuage? Is "%" some tyope of wild card to indicate that all
addresses on the network may have access?

Thanks Again!

On 7/11/06, Nick <knowledgejunkie at gmail.com> wrote:
>
> 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 > > 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
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-users/attachments/20060711/9351a7f9/attachment.htm 


More information about the mythtv-users mailing list