[mythtv-users] Frontend setup
glen martin
lists at locutory.org
Tue Jul 11 20:17:40 UTC 2006
I think you've set up your local network as 192.168.2.*, based on your
ifconfig. So for you the GRANT command would be
grant all on mythconverg.* to mythtv@"192.168.2.%" identified by "mythtv";
However, in my case I found that this didn't work - that the remote
access to MySQL identified as coming from the frontend machine *name*
and not the ip address. So I additionally GRANTed access from the name,
which solved my access problem.
grant all on mythconverg.* to mythtv@"myfrontendmachinename"
identified by "mythtv";
or something like that. I never did figure out why this was necessary,
but it worked.
Don't neglect Hallyson's point either, that the MySQL config might not
open the port by default, so you have to change my.cnf (look for
'listen') and restart MySQL on the backend (or wherever your DB server is).
glen
H P Ladds wrote:
> 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 <http://192.168.2.102>. (The 192.168.0.112
> <http://192.168.0.112> adresses were hypothetical). ifconfig of my
> Front/Backend is 192.168.2.102 <http://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
> <mailto:knowledgejunkie at gmail.com>> wrote:
>
> On 11/07/06, H P Ladds <householdwords at gmail.com
> <mailto: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
> <http://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 <http://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 <http://192.168.0.112> and the frontend is
> 192.168.0.115 <http://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 <http://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 <http://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 <http://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 <http://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 <mailto:mythtv-users at mythtv.org>
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>
More information about the mythtv-users
mailing list