LinHES Forums http://forums.linhes.org/ |
|
knoppmyth frontend /backend ? http://forums.linhes.org/viewtopic.php?f=14&t=18658 |
Page 1 of 1 |
Author: | sudeep [ Mon Jul 28, 2008 7:38 am ] |
Post subject: | knoppmyth frontend /backend ? |
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 |
Author: | mihanson [ Mon Jul 28, 2008 1:56 pm ] |
Post subject: | |
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. |
Author: | slowtolearn [ Mon Jul 28, 2008 4:42 pm ] |
Post subject: | Re: knoppmyth frontend /backend ? |
In addition to Mike's suggestions, sudeep wrote: Data base error was: 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.
can't connect to mysql server on 'ip'(111) Also, be sure you've named the FE and BE differently. hostname will show you their names... |
Author: | sudeep [ Mon Jul 28, 2008 11:21 pm ] |
Post subject: | |
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 ? |
Author: | tjc [ Mon Jul 28, 2008 11:58 pm ] |
Post subject: | |
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 |
Page 1 of 1 | All times are UTC - 6 hours |
Powered by phpBB® Forum Software © phpBB Group http://www.phpbb.com/ |