[mythtv-users] Frontend setup

[Melunko]

"%" is the mysql wildcard, like "*" in other systems.

Did you see this page?  http://www.mythtv.org/docs/mythtv-HOWTO-6.html

On 7/11/06, H P Ladds <householdwords at gmail.com> 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.
> (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
> >
>
>
> _______________________________________________
> 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/33c0c3f7/attachment.htm