[mythtv-users] Mythfrontend Client doesn't connect to Server

[Tom Lichti]

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-users
>
> Try 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
One other thing is to check the mysql config file on the backend 
(my.cnf) and make sure that skip-networking is not enabled, or it will 
not allow external connections.

Tom