View unanswered posts    View active topics

All times are UTC - 6 hours





Post new topic Reply to topic  [ 29 posts ] 
Go to page 1, 2  Next

Print view Previous topic   Next topic  
Author Message
Search for:
PostPosted: Thu Mar 17, 2011 2:53 pm 
Offline
Joined: Sun Jan 08, 2006 5:13 pm
Posts: 67
Location: Göteborg - Sweden
Ive done a fresh linhes 6.04.00 standalone install on my server(ip 192.168.0.102) and it works fine watching TV after setting up the channels.

I then tried to install a remote frontend only on my Nano ITX(192.168.0.101) that is placed in my living room but when finished the remote frontend cannot connect to the backend(standalone system that holds the backend)

I then read this:
"If you will be deploying multiple backends, or if your backend is on one system and you're running the frontend on another machine then do not use the "127.0.0.1" IP address."
@
http://www.mythtv.org/docs/mythtv-HOWTO-9.html
-so I have to change the IP in the "mythtv-setup->General Settings" to the actual IP assigned to the standalone system.
I changed:
"IP address for mythtv" to 192.168.0.102
"Master Server IP address" to 192.168.0.102

after that the frontend on the standalone system couldnt connect to the local backend anymore. the remote frontend could not connect either.
Even if i changed the IP back to 127.0.0.1 the backend was unreachable by both frontends(local and remote).

Ive done this complete procedure twice with the same result.
Do I currupt the sql database somehow by doing this?
What is the correct way to make the remote frontend being able to connect to the backend?


Last edited by goonzo on Thu Mar 24, 2011 2:51 am, edited 3 times in total.


Top
 Profile  
 
 Post subject:
PostPosted: Thu Mar 17, 2011 5:17 pm 
Offline
Joined: Sun Sep 25, 2005 3:50 pm
Posts: 1013
Location: Los Angeles
Check /etc/hosts on your standalone system. Make sure your IP address is defined there.

Code:
127.0.0.1     localhost     <standalone_hostname>
192.168.0.102     <standalone_hostname>

_________________
Mike
My Hardware Profile


Top
 Profile  
 
 Post subject:
PostPosted: Fri Mar 18, 2011 2:22 am 
Offline
Joined: Sun Jan 08, 2006 5:13 pm
Posts: 67
Location: Göteborg - Sweden
it already does:

Code:
[root@linhesserver /]# cat /etc/hosts
127.0.0.1 localhost
192.168.0.102 linhesserver
#
# /etc/hosts: static lookup table for host names
#

#<ip-address>   <hostname.domain.org>   <hostname>

# End of file
[root@linhesserver /]#


i searched through the settings at the frontedn. In "MythTV Settings" there are some database settings and the IP there is set to "127.0.0.1". Is this the IP that is distributed to the remote frontends as well? in that case i have to change that too..

Im afraid of changing some IP:s relating to sql/backend now since the last two times it broke something and no frontends were able to connect to the backend anymore.

Ive searched for a guide or something how to set up a remote frontend. Does such guide exist for R6?


Top
 Profile  
 
 Post subject:
PostPosted: Fri Mar 18, 2011 9:14 am 
Offline
Joined: Mon Dec 24, 2007 9:47 am
Posts: 535
Location: Ottawa, Canada
You haven't specified the error that you are getting and where it occurs.

But the other place you may have an issue is with mysql. Are you simply getting the language choice screen at start up?

If so then verify that mysql.txt has the correct values and specifically that "DBHostName=<your backend mysql ip address>".

I believe in LinHes the path is /home/mythtv/.mythtv/mysql.txt.

of course verify that the database username and password are correct.


Top
 Profile  
 
 Post subject:
PostPosted: Fri Mar 18, 2011 1:30 pm 
Offline
Joined: Wed Nov 16, 2005 8:55 pm
Posts: 1381
Location: Farmington, MI USA
This seems quite a bit more up-to-date than the URL you were referencing: http://www.mythtv.org/wiki/User_Manual: ... n_Frontend

(edit) The backend settings: http://www.mythtv.org/wiki/User_Manual: ... on_Backend (/edit)


Top
 Profile  
 
 Post subject:
PostPosted: Tue Mar 22, 2011 2:42 am 
Offline
Joined: Sun Jan 08, 2006 5:13 pm
Posts: 67
Location: Göteborg - Sweden
Quote:
Are you simply getting the language choice screen at start up?


yes, the language screen is coming up.

when starting the frontend(on remote frontend) from a console this is the output:

Code:
[mythtv@nanoitx ~]$ more /home/mythtv/frontendlog.txt
2011-03-22 08:11:26.290 mythfrontend version: 0.24-fixes [g316718a] www.mythtv.o
rg
2011-03-22 08:11:26.292 Using runtime prefix = /usr
2011-03-22 08:11:26.292 Using configuration directory = /home/mythtv/.mythtv
2011-03-22 08:11:26.295 ThreadPool:HTTP: Initial 1, Max 25, Timeout 60000
2011-03-22 08:11:27.037 Empty LocalHostName.
2011-03-22 08:11:27.037 Using localhost value of nanoitx
2011-03-22 08:11:27.038 Testing network connectivity to '192.168.0.102'
2011-03-22 08:11:27.199 New DB connection, total: 1
2011-03-22 08:11:27.200 Unable to connect to database!
2011-03-22 08:11:27.201 Driver error was [1/2003]:
QMYSQL: Unable to connect
Database error was:
Can't connect to MySQL server on '192.168.0.102' (111)
...


I have followed the guides:
http://www.mythtv.org/wiki/User_Manual: ... on_Backend

and there lies my problem. when changing(on the backend) "IP address for mythtv" and "Master Server IP address" to 192.168.0.102 the frontend on my standalone box looses connection with the (local)backend and it doesnt help if I change the IP:s back to localhost.

But Ill try again and change the IP settings on the backend and look at the output when trying to start the fronted(on the standalone box). ill post it here.


Top
 Profile  
 
 Post subject:
PostPosted: Tue Mar 22, 2011 7:14 am 
Offline
Joined: Thu Mar 25, 2004 11:00 am
Posts: 9551
Location: Arlington, MA
Oh yeah, this sounds familiar... What was it....

- Check all the settings data and look for occurrences of the loopback address 127.0.0.1
Code:
[root@black2 ~]# settings.sh -d | grep 127.0.0.1
MasterServerIP  127.0.0.1       NULL
BackendServerIP 127.0.0.1       black2
DefaultVxmlUrl  http://127.0.0.1/vxml/index.vxml        black2
[

- Also check for localhost
Code:
[root@black2 ~]# settings.sh -d | grep -i localhost
HostMysqlserver localhost       black2

- Finally check the entries your /etc/hosts file and if your hostname is associated with the loopback address rather than external address make sure that you don't use that name as the address in any of the settings.


Top
 Profile  
 
 Post subject:
PostPosted: Tue Mar 22, 2011 7:39 am 
Offline
Joined: Sun Jan 08, 2006 5:13 pm
Posts: 67
Location: Göteborg - Sweden
thx, ill do a complete check for all possible localhost settings tonight.

but i cant find the "settings.sh" script? where should it be located?

Code:
[root@linhesserver /]# find / settings.sh | grep settings.sh
/usr/MythVantage/bin/restore_default_settings.sh
find: `settings.sh': No such file or directory
[root@linhesserver /]#


Top
 Profile  
 
 Post subject:
PostPosted: Tue Mar 22, 2011 10:19 am 
Offline
Joined: Sun Jan 08, 2006 5:13 pm
Posts: 67
Location: Göteborg - Sweden
christ wrote:
If so then verify that mysql.txt has the correct values and specifically that "DBHostName=<your backend mysql ip address>".

I believe in LinHes the path is /home/mythtv/.mythtv/mysql.txt.


the only mysql.txt i found was
/usr/share/mythtv/mysql.txt

On my standalone box I did the following:

* i changed mysql.txt to hold:
DBHostName=192.168.0.102

* in mythtv-setup -> General: "IP address for mythtv" and "Master Server IP address" to 192.168.0.102

I exit mythtv-setup. exit the frontend. reboot the system and the frontend(on the standalone box still) complains(by starting lang selection screen) it cannot connect to the backend.

when starting mythfrontend from xterm it says:

Code:
2011-03-22 17:05:13.936 mythfrontend version: 0.24-fixes [g316718a] www.mythtv.
rg
2011-03-22 17:05:13.937 Using runtime prefix = /usr
2011-03-22 17:05:13.937 Using configuration directory = /home/mythtv/.mythtv
2011-03-22 17:05:13.938 ThreadPool:HTTP: Initial 1, Max 25, Timeout 60000
2011-03-22 17:05:14.699 Empty LocalHostName.
2011-03-22 17:05:14.699 Using localhost value of linhesserver
2011-03-22 17:05:14.699 Testing network connectivity to '192.168.0.102'
2011-03-22 17:05:14.824 New DB connection, total: 1
2011-03-22 17:05:14.824 Unable to connect to database!
2011-03-22 17:05:14.824 Driver error was [1/2003]:
QMYSQL: Unable to connect
Database error was:
Can't connect to MySQL server on '192.168.0.102' (111)

...............................................................................
2011-03-22 17:05:17.035 UPnPautoconf() - No UPnP backends found
2011-03-22 17:05:17.035 No UPnP backends found
...


HAve I missed something?
(this is a fresh install with 6.04)

If I try to run mythtv-setup to restore the settings i only get to the language selection screen in the same way...

I even tried restarting the backend without any luck


Top
 Profile  
 
 Post subject:
PostPosted: Tue Mar 22, 2011 11:30 am 
Offline
Joined: Sun Sep 25, 2005 3:50 pm
Posts: 1013
Location: Los Angeles
Is mysql running? What does
Code:
$ sudo sv status mysql
show? Does the directory /var/service/mysql exist?

_________________
Mike
My Hardware Profile


Top
 Profile  
 
 Post subject:
PostPosted: Tue Mar 22, 2011 11:40 am 
Offline
Joined: Sun Jan 08, 2006 5:13 pm
Posts: 67
Location: Göteborg - Sweden
seems to be alright:

Code:
[root@linhesserver /]# sv status mysql
run: mysql: (pid 4367) 4181s
[root@linhesserver /]# ls -la /var/service/mysql
lrwxrwxrwx 1 root root 13 2011-03-17 21:37 /var/service/mysql -> /etc/sv/mysql
[root@linhesserver /]# ls -la /etc/sv/mysql/
total 16
drwxr-xr-x  3 root root 4096 2011-03-17 21:56 .
drwxr-xr-x 46 root root 4096 2011-02-17 01:38 ..
-rwxr-xr-x  1 root root  899 2009-09-08 18:50 run
drwx------  2 root root 4096 2011-03-22 17:28 supervise
[root@linhesserver /]#


Top
 Profile  
 
 Post subject:
PostPosted: Tue Mar 22, 2011 12:18 pm 
Offline
Joined: Sun Jan 08, 2006 5:13 pm
Posts: 67
Location: Göteborg - Sweden
it seems mythweb isnt functioning properly either.

the web server works but when clicking on "mythweb" all I see is the top menu(logo, icons etc) with the message:

"Error
Unable to connect to the master backend at 192.168.0.102:6543.
Is it running?"

the backend IS running:
Code:
[root@linhesserver /]# ps ax |grep backend
 4324 ?        Ss     0:04 runsv mythbackend
 4416 ?        S      0:00 /usr/bin/logger -p local7.info -t mythbackend
14648 ?        Sl     0:00 /usr/bin/mythbackend --logfile /var/log/mythtv/mythbackend.log
14688 pts/2    S+     0:00 grep backend
[root@linhesserver /]#


Im thinking that the actual address 192.168.0.102 isn't resolved properly on the local machine... somehow it doesn't understand that the IP is the local machine?
any ideas howto troubleshoot that, please?


Top
 Profile  
 
 Post subject:
PostPosted: Tue Mar 22, 2011 8:11 pm 
Offline
Joined: Mon Dec 24, 2007 9:47 am
Posts: 535
Location: Ottawa, Canada
goonzo wrote:
the only mysql.txt i found was
/usr/share/mythtv/mysql.txt

This doesn't look right to me. I'm almost certain you need one either in the /home/mythtv or /etc paths. I don't have my system handy at the moment as I'm on the road and I have a very limited broadband connection.

Try copying or linking the mysql.txt to /home/mythtv/.mythtv directory and see if that helps. Ensure the changes I suggest above are done. Don't forget to ensure user mythtv can read the file.

The other possibility is that your mysql database on your master backend does not have permissions set for non-localhost. Are you using a standard LinHES as a master backend?


Top
 Profile  
 
 Post subject:
PostPosted: Tue Mar 22, 2011 8:13 pm 
Offline
Joined: Thu Mar 25, 2004 11:00 am
Posts: 9551
Location: Arlington, MA
goonzo wrote:
but i cant find the "settings.sh" script? where should it be located?

http://knoppmyth.net/phpBB2/viewtopic.p ... t=settings

Having been through the process of setting things up to use the public address before, I remember it being quite painful to track down all the places that assumed the back end was listening on the loopback interface rather than on eth0. The good news is that is the only "trick" to it.


Top
 Profile  
 
 Post subject:
PostPosted: Wed Mar 23, 2011 6:11 am 
Offline
Joined: Sun Jan 08, 2006 5:13 pm
Posts: 67
Location: Göteborg - Sweden
christ wrote:
goonzo wrote:
the only mysql.txt i found was
/usr/share/mythtv/mysql.txt

This doesn't look right to me. I'm almost certain you need one either in the /home/mythtv or /etc paths. I don't have my system handy at the moment as I'm on the road and I have a very limited broadband connection.

Try copying or linking the mysql.txt to /home/mythtv/.mythtv directory and see if that helps. Ensure the changes I suggest above are done. Don't forget to ensure user mythtv can read the file.


I actually did find the file and it has the correct permissions
Code:
[mythtv@linhesserver ~]$ ls -la /home/mythtv/.mythtv/
total 40
drwxr-xr-x 5 mythtv mythtv 4096 2011-03-22 17:23 .
drwxr-xr-x 8 mythtv mythtv 4096 2011-03-23 00:02 ..
-rw-r--r-- 1 mythtv mythtv   85 2011-03-17 22:07 .xmltv
-rw-r--r-- 1 mythtv mythtv 2475 2011-03-17 22:06 DVB1.xmltv
drwxr-xr-x 2 mythtv mythtv 4096 2011-03-17 22:10 MythSmolt
drwxr-xr-x 2 mythtv mythtv 4096 2011-03-17 22:10 channels
-rw-r--r-- 1 mythtv mythtv  420 2011-03-17 22:14 config.xml
lrwxrwxrwx 1 mythtv mythtv   11 2011-03-17 21:37 lircrc -> /etc/lircrc
-rw-r--r-- 1 mythtv mythtv 1103 2011-03-22 20:58 mysql.txt
-rw-r--r-- 1 mythtv mythtv   37 2011-03-17 21:39 smolt.info
drwxr-xr-x 4 mythtv mythtv 4096 2011-03-22 17:03 themecache
[mythtv@linhesserver ~]$


and it contains the correct DB settings:
DBHostName=192.168.0.102

christ wrote:
The other possibility is that your mysql database on your master backend does not have permissions set for non-localhost. Are you using a standard LinHES as a master backend?


If you by "Standard LinHES" mean a fresh install with 6.04, then yes.
its a standalone installation and i've installed samba and VNC. Also altered the ssh permissions so that i can log in from a remote system.
but thats it.

is there a setting for "non-localhost permissions" accessing the database somewhere?


Top
 Profile  
 

Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 29 posts ] 
Go to page 1, 2  Next



All times are UTC - 6 hours




Who is online

Users browsing this forum: No registered users and 73 guests


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:  
cron
Powered by phpBB® Forum Software © phpBB Group

Theme Created By ceyhansuyu