Author |
Message |
goonzo
|
Posted: Thu Mar 17, 2011 2:53 pm |
|
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 |
|
|
mihanson
|
Posted: Thu Mar 17, 2011 5:17 pm |
|
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 |
|
|
goonzo
|
Posted: Fri Mar 18, 2011 2:22 am |
|
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 |
|
|
christ
|
Posted: Fri Mar 18, 2011 9:14 am |
|
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 |
|
|
slowtolearn
|
Posted: Fri Mar 18, 2011 1:30 pm |
|
Joined: Wed Nov 16, 2005 8:55 pm
Posts: 1381
Location:
Farmington, MI USA
|
|
Top |
|
|
goonzo
|
Posted: Tue Mar 22, 2011 2:42 am |
|
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 |
|
|
tjc
|
Posted: Tue Mar 22, 2011 7:14 am |
|
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 |
|
|
goonzo
|
Posted: Tue Mar 22, 2011 7:39 am |
|
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 |
|
|
goonzo
|
Posted: Tue Mar 22, 2011 10:19 am |
|
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 |
|
|
mihanson
|
Posted: Tue Mar 22, 2011 11:30 am |
|
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 |
|
|
goonzo
|
Posted: Tue Mar 22, 2011 11:40 am |
|
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 |
|
|
goonzo
|
Posted: Tue Mar 22, 2011 12:18 pm |
|
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 |
|
|
christ
|
Posted: Tue Mar 22, 2011 8:11 pm |
|
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 |
|
|
tjc
|
Posted: Tue Mar 22, 2011 8:13 pm |
|
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 |
|
|
goonzo
|
Posted: Wed Mar 23, 2011 6:11 am |
|
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 |
|
|