remote frontend
I have my backend running Mythdora 2.32 and have been using it successfully for sometime now. Now I have my laptop that runs FC 5 and I installed mythfrontend on it. However, it seems as if the the two machines do not want to talk. I have given access to the mysql database to all on my lan. My laptop connects wirelessly to a Netgear WGR614 router, and the backend is plugged into the router. I can ping the machines successfully. However I cannot really do anything else. When I attempt to use mythfrontend on the laptop it just give errors about not being able to connect the database. Also I changed host name in mysql.txt file on the laptop to:
DBHostName=192.168.1.6
DBUserName=mythtv
DBPassword=mythtv
DBName=mythconverg
DBType=QMYSQL3
Any ideas? I dont know what else to do.
Just trying to figure out
Just trying to figure out what is going on with this here. I remembered that I installed iptables during setup so that the machine had a firewall, do I need to open up ports / allow connections?
If you just want things to
If you just want things to work with no problems, I would disable the firewall.
"Please ignore the man behind the curtain"
Dennis
"Please ignore the man behind the curtain"
Dennis
output when trying to start
output when trying to start frontend:
QSqlQuery::exec: database not open
QSqlQuery::exec: database not open
2006-09-15 17:19:32.809 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError? Strange...
2006-09-15 17:19:32.861 Database not open while trying to load setting: TVVidModeWidth
2006-09-15 17:19:32.862 Unable to connect to database!
2006-09-15 17:19:32.862 Driver error was [1/2003]:
QMYSQL3: Unable to connect
Database error was:
Can't connect to MySQL server on '192.168.1.6' (113)
QSqlQuery::exec: database not open
continues for a while
I get very similar output
I get very similar output when trying to connect one of my PC's, eventually it gives a setup page to put in a database details and then errors out.
I can connect to the backend using the live CD from my laptop (but have been unable to get the live CD working on any of my other PCs) so I know that my backend setup and mysql setup is working.
You need to make sure that
You need to make sure that you have the IP address of your backend stated in mythtvsetup under General. These HAVE to be a static IP and not the 127.0.0.1 address. Also be sure to read the FAQ section under USAGE for a remote frontend connection.
"Please ignore the man behind the curtain"
Dennis
"Please ignore the man behind the curtain"
Dennis
I have done all of that
I have done all of that stuff. My ip is not "Static" but since it stays connected, it never changes, is that a problem? I have it set to 192.168.1.6 and it has been that for over a month now without changing. One thing I did notice however, was that when I start mythbackend in a terminal, it says "connected to database 'mythconverg' at host: localhost even though I had specified the address 192.168.1.6 in mythtvsetup, problem?
Well when I say "static", I
Well when I say "static", I meant a static IP designated on your backend computer. You have to have an IP different from any other computer. I have my setup as the master backend using 192.168.0.55 and a frontend(s) using 192.168.0.40 , 0.75 , 0.45 . The master backend has it's IP entered in mythtvsetup under General and not the loopback address of 127.0.0.1. If you leave it at that it will not work. Then you said you have given your master backend the proper MySQL permissions to allow other frontend connections?
"Please ignore the man behind the curtain"
Dennis
"Please ignore the man behind the curtain"
Dennis
Ok yea then I do have that
Ok yea then I do have that set up. I have ran the MySQL commands on the FAQ page and these are also in the mythtv.org documentation. Is there like a way to give access to everything to the MySQL database, just to test if that is the problem?
I'll take a guess.
I'll take a guess.
Check your hosts.allow, hosts.deny
??
I have a very good feeling
I have a very good feeling that this had to do with iptables. I have since tried to set up samba and had problems, disabled the firewall and it worked. So I think I just need to do some research and find what ports are needed by for a mythtv frontend.
What's in the FAQ is the
What's in the FAQ is the wide open command to MySQL. No security at all. It's open to anything. Are you still getting that same error? If you have added the master backend IP into your frontends mysql.txt file and issued the MySQL statement, then this should be working.
"Please ignore the man behind the curtain"
Dennis
"Please ignore the man behind the curtain"
Dennis
I have been very busy lately
I have been very busy lately and have not had much time to play around with this. However, it still does the same thing.
One thing I did notice is that when starting httpd: says something like cannot xxx full xxx domiain xxxx using 127.0.0.1 instead. I could not see all of it. I tried looking in the httpd logs but did not see it anywhere either.
The httpd stuff you see is
The httpd stuff you see is perfectly normal.
"Please ignore the man behind the curtain"
Dennis
"Please ignore the man behind the curtain"
Dennis