[mythtv-users] Mythfrontend Client doesn't connect to Server
R. G. Newbury
newbury at mandamus.org
Sun Feb 25 21:16:47 UTC 2007
Mitchell Gore wrote:
>> From: zlatko0612 at hotmail.com> To: mythtv-users at mythtv.org> Date: Sun, 25 Feb 2007 19:15:52 +0100> Subject: [mythtv-users] Mythfrontend Client doesn't connect to Server> > Hello List,> > I am a newbie to mythtv and it is my 100th try to install and use mythtv, > till now without success :-(> I didn't find the solution for the problem in google although some other > people have had the similar problem ...> > I can startand use mythbackend and mythfrontend on the myth server > (192.168.0.2) but not from client (192.168.0.12).> > After I start mythfrontend on the client I get:> "Myth could not connect to the database. Please verify your database ..."> > It is the same if I start it as mythtv user or as root.> > if I start on the client (192.168.0.12)> mysql -h 192.168.0.2 -u mythtv -p mythconverg> I can use the database !> mysql >> > cat ~/.mythtv/mysql.txt> DBHostName=192.168.0.2> DBUserName=mythtv> DBPassword=mythtv> DBName=mythconverg> DBType=QMYSQL3> > cat /home/mythtv/
.mythtv/mysql.txt> DBHostName=192.168.0.2> DBUserName=mythtv> DBPassword=mythtv> DBName=mythconverg> DBType=QMYSQL3> > > I use Mythtv 0.20 and FedoraCore 6 on both PCs.> > > Can anyone help me to start the mythtv on the client ?> > Thank you very much> > Zlatko> > _________________________________________________________________> Express yourself instantly with MSN Messenger! Download today it's FREE! > http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/> > _______________________________________________> mythtv-users mailing list> mythtv-users at mythtv.org> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-usersTry this..Remote front-ends-
>
>
> 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 grabbed this off Jarod's Fedora Mythtv site.Mitchell
You can check to see if a user at a particular remote client can access
the mysql server by running, ON THE MYSQL SERVER, AS ROOT
mysql -u root -p<password>
mysql> use mysql;
mysql> select host,user,password from user;
+-------------------+--------+------------------+
| host | user | password |
+-------------------+--------+------------------+
| localhost | root | 0683ce2d76eaa257 |
| tor2.mandamus.org | root | 0683ce2d76eaa257 |
| localhost | mythtv | 0476fc026afffe24 |
+-------------------+--------+------------------+
3 rows in set (0.00 sec)
This is my desktop machine, not my mythbox. If the mythtv user is to be
able to access the server, then the server cannot be 'localhost'nor can
the client. Both must be a named machine. and user mythtv must have
access. In the above I have NO outside acces enabled.
Look at the mc.sql text, it reads, approximately
GRANT ALL ON mythconverg.* to mythtv at localhost IDENTIFIED BY "mythtv";
________________
You need something like to mythtv@"%.myhomenetwork.org".....
Name all you machines using the 'name.whatever.org' scheme. The '%' is
the mysql wildcard so the above grants access to any 'mythtv' from any
host on the network, with password 'mythtv'.
Geoff
If
--
R. Geoffrey Newbury
Barrister and Solicitor
Suite 106, 150 Lakeshore Road West
Mississauga, Ontario, L5H 3R2
o905-271-9600 f905-271-1638
newbury at mandamus.org
Helping with the HTTP issue
<a href="http://www.w3.org/Protocols/">HTTP</a>
More information about the mythtv-users
mailing list