Hello All ,

I installed Knoppmyth r5f27 in two different system and i made a one machine as a backend where my capture card ( tv tunner card )in installed and I have a given a static ip to back end machine and i am able to watch all the channels from my local cable.

and another machine as front end and there is no capture card ( tvtunner card ) in this machine .
and i follow the steps as per this link

http://www.knoppmythwiki.org/index.php? ... nlyInstall


I am getting these errors in the front-end

Query was:
SELECT NULL;
No error type from Qsqlerror? strange....
2008-07-08 23:57:20.814 Data base not open while trying to load setting language.
2008-07-08 23:57:20.815 unable to connect data base
2008-07-08 23:57:20.816 Driver error was [1/2003]
QMYSQL3:UNABLE TO CONNECT
Data base error was:
can't connect to mysql server on 'ip'(111)
Qsqlquery::exec:database not open
Qsqlquery::exec:database not open
2008-07-08 23:57:20.868 database error DB error(kickdatabase)

any help? any idea?

thanku

My guess is that either (a) you did not disable mysql on the frontend or (b) you did not change the IP addresses on the backend ("Preparing the Backend") or edit the mysql.txt file on the frontend. BTW, there's a newer version of KnoppMyth available, R5.5.

_________________
Mike
My Hardware Profile

In addition to Mike's suggestions, doesn't look right. 'ip' should be your BE's hostname or it's actual IP address. If you have the BE's hostname in there, be sure you have defined it in the FE's /etc/hosts file.

Also, be sure you've named the FE and BE differently. hostname will show you their names...

Hello,

I am 100% sure i disabled mysql on the frontend and I changed on ip address on the backend.

In frontend /etc/mythtv/mysql.txt file is as below

DBHostname=192.168.0.92
DBUserName=mythtv
DBName=mythconverg
DBPassword=mythtv

In backend /etc/mythtv/mysql.txt file is as below

DBHostname=localhost or 192.168.0.92
DBUserName=mythtv
DBName=mythconverg
DBPassword=mythtv


is this configurati0on correct ? or any changes i have to made ?

hello slowtolearn,

actuall the error shown like this

Data base error was:
can't connect to mysql server on 192.168.0.92(111)

and my /etc/hosts file in the frontend as below

127.0.0.1 mythtv localhost

#the following lines are desirable for ipv6 capable host
#(added automatically by netbase upgrade)

::1 ip6-localhost ip6-loopback
fe00::0 ip6-localnet
ff00::0 ip6-mcastprefix
ff02:: ip6-allnodes
ff02:: ip6-allrouters
ff02:: ip6-allhosts

any changes i have to made in this hosts file ?

First, what is your IP configuration on both machines? The following command will show the IP and other details.

Remember that the two machines need to be using different address but compatible parameters. Indicate which is which when you post the results.

Second, have you enabled remote access in your /etc/mysql/my.cnf file? if you see this:

You didn't get it right. You either need to comment that out or make it use your LAN address. See this FAQ for more details: http://dev.mysql.com/doc/refman/5.0/en/can-not-connect-to-server.html