View unanswered posts    View active topics

All times are UTC - 6 hours





Post new topic Reply to topic  [ 5 posts ] 
Print view Previous topic   Next topic  
Author Message
Search for:
PostPosted: Mon Jul 28, 2008 7:38 am 
Offline
Joined: Tue Jun 24, 2008 9:31 am
Posts: 10
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


Top
 Profile  
 
 Post subject:
PostPosted: Mon Jul 28, 2008 1:56 pm 
Offline
Joined: Sun Sep 25, 2005 3:50 pm
Posts: 1013
Location: Los Angeles
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


Top
 Profile  
 
PostPosted: Mon Jul 28, 2008 4:42 pm 
Offline
Joined: Wed Nov 16, 2005 8:55 pm
Posts: 1381
Location: Farmington, MI USA
In addition to Mike's suggestions,
sudeep wrote:
Data base error was:
can't connect to mysql server on 'ip'(111)
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...


Top
 Profile  
 
 Post subject:
PostPosted: Mon Jul 28, 2008 11:21 pm 
Offline
Joined: Tue Jun 24, 2008 9:31 am
Posts: 10
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 ?


Top
 Profile  
 
 Post subject:
PostPosted: Mon Jul 28, 2008 11:58 pm 
Offline
Joined: Thu Mar 25, 2004 11:00 am
Posts: 9551
Location: Arlington, MA
First, what is your IP configuration on both machines? The following command will show the IP and other details.
Code:
ifconfig eth0

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:
Code:
root@black2:~# grep bind-address /etc/mysql/my.cnf
bind-address            = 127.0.0.1

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


Top
 Profile  
 

Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 5 posts ] 


All times are UTC - 6 hours




Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
Powered by phpBB® Forum Software © phpBB Group

Theme Created By ceyhansuyu