View unanswered posts    View active topics

All times are UTC - 6 hours





Post new topic Reply to topic  [ 27 posts ] 
Go to page Previous  1, 2

Print view Previous topic   Next topic  
Author Message
Search for:
 Post subject:
PostPosted: Tue Aug 05, 2008 3:01 pm 
Offline
Joined: Mon Apr 10, 2006 3:48 pm
Posts: 997
Location: Lexington, Ky
Backups were taken before the upgrade. I now have R5.5 installed but need to change the value in /home/mythtv/.mythtv/mysql.txt

Any suggestions on how I can do that?

Thanks.

Tim


Top
 Profile  
 
 Post subject:
PostPosted: Tue Aug 05, 2008 4:19 pm 
Offline
Joined: Thu Mar 25, 2004 11:00 am
Posts: 9551
Location: Arlington, MA
Stop the servers.

Edit the three files shown in the script in my previous post.

Restart the servers.

Better still if your /etc/mythtv/mysql.txt has the right host name, just run the script and it will make the appropriate changes.


Top
 Profile  
 
 Post subject:
PostPosted: Wed Aug 06, 2008 7:02 pm 
Offline
Joined: Mon Apr 10, 2006 3:48 pm
Posts: 997
Location: Lexington, Ky
Using the hostname didn't fix it for me. The ip address was in the database so I had to use localhost and the address to get everything running.

File were set as follows
/etc/mythtv/mythweb-htaccess - 192.168.2.50
/etc/mysql/my.cnf - 192.168.2.50
/etc/mythtv/mysql.txt - localhost


Thanks.

Tim


Last edited by tscholl on Thu Aug 07, 2008 7:21 am, edited 1 time in total.


Top
 Profile  
 
 Post subject:
PostPosted: Wed Aug 06, 2008 9:34 pm 
Offline
Joined: Thu Mar 25, 2004 11:00 am
Posts: 9551
Location: Arlington, MA
Which IP address? 127.0.0.1 is the same as "localhost" (associated with the "loopback" pseudo interface "lo0"). If you mean the IP address associated with eth0 all you should have needed was to correct /etc/mythtv/mysql.txt to match. This is necessary if you are running separate FE or SBE systems To do it you also need a stable IP address either via a DHCP mapping tied to the NIC's MAC address or a static IP configuration.


Top
 Profile  
 
 Post subject:
PostPosted: Wed Aug 06, 2008 11:36 pm 
Offline
Joined: Wed Mar 03, 2004 7:43 pm
Posts: 748
Location: Sydney, Australia
I suspect he means mythconverg.settings.BackendServerIP and MasterServerIP, although I have no idea why they would be wrong

_________________
| Nigel Pearson, nigel.pearson.au@gmail.com
| "Things you own end up owning you" - Tyler, Fight Club


Top
 Profile  
 
 Post subject:
PostPosted: Thu Aug 07, 2008 7:26 am 
Offline
Joined: Mon Apr 10, 2006 3:48 pm
Posts: 997
Location: Lexington, Ky
tjc,

Sorry for being ambiguous. I update the previous post with the IP Address used. I had to specify the hosts real address.

I tired using the hostname (mythtv) in all three but still got the repeating message:

Code:
Cannot login to database?

Would you like to configure the database connection now? [yes]
[console is not interactive, using default 'yes']
Database host name: [192.168.2.50]
[console is not interactive, using default '192.168.2.50']


This is a single FE/BE machine. But was also using it as a BE at times.

The question I have now is what should be the recommended settings to avoid the problem in the future? Should I use the hostname in all the settings?


Top
 Profile  
 
 Post subject:
PostPosted: Thu Aug 07, 2008 10:22 pm 
Offline
Joined: Thu Mar 25, 2004 11:00 am
Posts: 9551
Location: Arlington, MA
If the IP address works stick with that. I'd need to do serious spelunking to figure out if the various config files accept hostnames or if not why. Possibly because your hostname is actually an alias for localhost. e.g.:
Code:
root@black2:~# grep black2 /etc/hosts
127.0.0.1       black2 localhost

In this case I'd need to fix /etc/hosts or use a different alias associated with the IP of eth0:
Code:
root@black2:~# grep 103 /etc/hosts
192.168.1.103           media epox


Top
 Profile  
 
 Post subject:
PostPosted: Fri Aug 08, 2008 6:09 pm 
Offline
Joined: Mon Apr 10, 2006 3:48 pm
Posts: 997
Location: Lexington, Ky
tjc,

By default the /etc/hosts file gets configured like this.

Code:
127.0.0.1       mythtv localhost


At least that is the way mine looked when I checked it. Mine was created
by a R5F27 new install and upgrads since then.

I have since changed mine to read.
Code:
127.0.0.1       localhost
192.168.2.50    mythtv


Which I believe is the way it should read.


Top
 Profile  
 
 Post subject:
PostPosted: Fri Aug 08, 2008 6:50 pm 
Offline
Joined: Thu Mar 25, 2004 11:00 am
Posts: 9551
Location: Arlington, MA
Yes and no. Making your hostname an alias for localhost can simplify certain common cases and works fine for most non MBE/SBE/FE setups.

As a matter of fact Fedora does the exact same thing. It only matters when you want to listen at that name for remote (and possibly local) connections.


Top
 Profile  
 
 Post subject:
PostPosted: Fri Aug 08, 2008 7:19 pm 
Offline
Joined: Mon Apr 10, 2006 3:48 pm
Posts: 997
Location: Lexington, Ky
tjc,

tjc wrote:
I'd need to do serious spelunking to figure out if the various config files accept hostnames or if not why.


Looks like we need a definitive answer as to what is required for each type of environment MBE/SBE/FE, or a standard that will work in all cases.

Happy spelunking!!


Top
 Profile  
 
 Post subject:
PostPosted: Fri Aug 08, 2008 10:44 pm 
Offline
Joined: Thu Mar 25, 2004 11:00 am
Posts: 9551
Location: Arlington, MA
I'm a firm believer in the power of enlightened laziness. I'd use the IP addresses and not worry too much about which apps were to lame to look up the name. ;-)


Top
 Profile  
 
 Post subject:
PostPosted: Fri Sep 12, 2008 1:20 pm 
Offline
Joined: Thu Sep 30, 2004 11:29 am
Posts: 2419
Location: Mechanicsburg, PA
tjc's backup/restore fixes are now in R5.5's patcher: http://knoppmyth.net/phpBB2/viewtopic.p ... 084#116084

_________________
KnoppMyth R5.5
MythiC Dragon v2.0
Join the KnoppMyth Frappr!


Top
 Profile  
 

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



All times are UTC - 6 hours




Who is online

Users browsing this forum: No registered users and 6 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