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

[R. G. Newbury]

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


And AFTER you have checked all of those things, and you STILL get a 
'cannot connect to database. Database not open' error, do

yum -y install qt-MySQL

The normal Fedora Core 6 installation does not seem to add this, even if 
you have selected it in the customization portion of the install.

Worse yet, that particular package is capitalized, in part. and linux, 
as we know is character sensitive. Been there, done that, chastised 
myself for my stupidity....

Finally make sure that you have *properly* entered the enviroment 
variables in your path. Again, an underscore "-" instead of a hyphen "_" 
  -;) is a tremendous timewaster.

Geoff