View unanswered posts    View active topics

All times are UTC - 6 hours





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

Print view Previous topic   Next topic  
Author Message
Search for:
 Post subject:
PostPosted: Tue Dec 27, 2005 9:46 pm 
Offline
Joined: Fri Jun 24, 2005 3:22 pm
Posts: 124
I commented out the skip networking.

pinging:

5 packets transmitted, 5 received, 0% packet loss, time 4000ms
rtt min/avg/max/mdev = 0.015/0.020/0.041/0.011 ms


telnet:

5 packets transmitted, 5 received, 0% packet loss, time 4000ms
rtt min/avg/max/mdev = 0.015/0.020/0.041/0.011 ms
mythtv@overturetv:~$ telnet 192.168.0.80 3306
Trying 192.168.0.80...
Connected to 192.168.0.80.
Escape character is '^]'.
+
4.0.22-log?u_Y%Fr.),


Thanks for your help.

_________________
AMD Athlon XP 2800+
MSI K7N2 Delta2 ATX w/FX5200 AGP video
2X256MB PC3200 RAM
Maxtor 250GB drive (master on IDE 1)
Pioneer DVR-109 (master on IDE 2)
Antec Overture II ATX case with 330watts
Hauppauge 250 in PCI slot 2


Top
 Profile  
 
 Post subject:
PostPosted: Tue Dec 27, 2005 9:49 pm 
Offline
Joined: Fri Jun 24, 2005 3:22 pm
Posts: 124
Output from: netstat -an | grep 3306

Trying 192.168.0.80...
Connected to 192.168.0.80.
Escape character is '^]'.
+
4.0.22-log?u_Y%Fr.),exit
Bad handshakeConnection closed by foreign host.
mythtv@overturetv:~$ netstat -an | grep 3306
tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN

_________________
AMD Athlon XP 2800+
MSI K7N2 Delta2 ATX w/FX5200 AGP video
2X256MB PC3200 RAM
Maxtor 250GB drive (master on IDE 1)
Pioneer DVR-109 (master on IDE 2)
Antec Overture II ATX case with 330watts
Hauppauge 250 in PCI slot 2


Top
 Profile  
 
 Post subject:
PostPosted: Tue Dec 27, 2005 9:55 pm 
Offline
Joined: Thu Mar 25, 2004 11:00 am
Posts: 9551
Location: Arlington, MA
So you can get to that IP (ping), and there is a server listening on that port (telnet and netstat). Now the question becomes is it allowing connections, and is the front end connecting to the right place... Check out the mysql error logs (see this wiki page for details) http://www.knoppmythwiki.org/index.php?page=CheckingLogFiles for any errors related to the connection...


Top
 Profile  
 
 Post subject:
PostPosted: Tue Dec 27, 2005 10:47 pm 
Offline
Joined: Fri Jun 24, 2005 3:22 pm
Posts: 124
Thank you for your help. I checked both /var/log/mysql/mysql.err and /var/log/mysql.err and found both files to exist, but are empty.

That page you mentioned also recommends running 'more /var/log/daemon.log' and that returns the following info on mysql:

Dec 26 01:32:56 overturetv /etc/mysql/debian-start[3406]: Checking for crashed MySQL tables.
Dec 26 01:39:41 overturetv pumpd[5286]: starting at (uptime 0 days, 0:07:10) Sun Dec 25 17:39
:41 2005

--- snip ----

It goes on for quite a long time, but I see no mysql errors.

_________________
AMD Athlon XP 2800+
MSI K7N2 Delta2 ATX w/FX5200 AGP video
2X256MB PC3200 RAM
Maxtor 250GB drive (master on IDE 1)
Pioneer DVR-109 (master on IDE 2)
Antec Overture II ATX case with 330watts
Hauppauge 250 in PCI slot 2


Top
 Profile  
 
 Post subject:
PostPosted: Wed Dec 28, 2005 6:55 pm 
Offline
Joined: Thu Mar 25, 2004 11:00 am
Posts: 9551
Location: Arlington, MA
nigelpearson wrote:
Weird. Local mysql works.

Try this one:
Code:
mysql -h 192.168.0.80 -u mythtv -pmythtv

I just went back and tried this on my own system and it didn't work, so it's actually normal for a healthy single server FrontEnd/BackEnd setup. Basically this was a red herring and I apologize for not realizing it sooner. :oops:

I'm thinking that the key is your mysql.txt file. I show a couple on my system, with minor differences, I suspect that the one in /home/mythtv/.mythtv/mysql.txt is the critical one:
Code:
root@black2:~# find / -name mysql.txt -ls
173137    4 -rw-rw----   1 mythtv   mythtv        954 Nov 17 00:25 /etc/mythtv/mysql.txt
210941    4 -rw-r--r--   1 mythtv   mythtv        962 Feb 27  2005 /home/mythtv/.mythtv/mysql.txt
 79793    0 lrwxrwxrwx   1 root     root           21 Nov 17 00:25 /usr/share/mythtv/mysql.txt -> /etc/mythtv/mysql.txt
root@black2:~# diff -w /etc/mythtv/mysql.txt /home/mythtv/.mythtv/mysql.txt
2a3
> DBPassword=mythtv
3a5
> DBType=QMYSQL3
16c18
< # Set the time the frontend waits (in seconds) beetween reconnect tries.
---
> # Set the time the frontend waits (in seconds) between reconnect tries.
27,28c29
< #WOLsqlCommand=echo \'WOLsqlServerCommand not set\'
< DBPassword=mythtv
---
> #WOLsqlCommand=echo 'WOLsqlServerCommand not set'
root@black2:~# cat /home/mythtv/.mythtv/mysql.txt
DBHostName=localhost
DBUserName=mythtv
DBPassword=mythtv
DBName=mythconverg
DBType=QMYSQL3

# Set the following if you want to use something other than the
# machine's real hostname for identifying settings in the database.
# This is useful if your hostname changes often, as otherwise
# you'll need to reconfigure mythtv (or futz with the DB) every time.
# TWO HOSTS MUST NOT USE THE SAME VALUE
#
#LocalHostName=my-unique-identifier-goes-here

# If you want your frontend to be able to wake your MySQL server
# using WakeOnLan, have a look at the following settings:
#
# Set the time the frontend waits (in seconds) between reconnect tries.
# This should be the rough time your MySQL server needs for startup
#WOLsqlReconnectWaitTime=0
#
#
# This is the amount of retries to wake the MySQL server until the frontend
# gives up
#WOLsqlConnectRetry=5
#
#
# This is the command executed to wake your MySQL server.
#WOLsqlCommand=echo 'WOLsqlServerCommand not set'

OBTW - Have you found the sticky posting by Cecil on how to check/correct DB corruption?


Top
 Profile  
 
 Post subject:
PostPosted: Wed Dec 28, 2005 8:29 pm 
Offline
Joined: Fri Jun 24, 2005 3:22 pm
Posts: 124
Thanks for your response. A couple of months ago, I had some database corruption and fixed it using the posting you mention. In fact I ran the command that repairs everything, just in case. After that, no problems ever.

The complete conteents of that text file:

DBHostName=192.168.0.80
DBUserName=mythtv
DBPassword=<snip>
DBName=mythconverg
DBType=QMYSQL3

# Set the following if you want to use something other than the
# machine's real hostname for identifying settings in the database.
# This is useful if your hostname changes often, as otherwise
# you'll need to reconfigure mythtv (or futz with the DB) every time.
# TWO HOSTS MUST NOT USE THE SAME VALUE
#
#LocalHostName=my-unique-identifier-goes-here

# If you want your frontend to be able to wake your MySQL server
# using WakeOnLan, have a look at the following settings:
#
# Set the time the frontend waits (in seconds) between reconnect tries.
# This should be the rough time your MySQL server needs for startup
#WOLsqlReconnectWaitTime=0
#
#
# This is the amount of retries to wake the MySQL server until the frontend
# gives up
#WOLsqlConnectRetry=5
#
#
# This is the command executed to wake your MySQL server.
#WOLsqlCommand=echo 'WOLsqlServerCommand not set'


As i mentioned before, I was prompted to change the msql password, and I did. I've been told it isn't supposed to do this, but there you are.

Should I change the password back to mythtv and see if I can restart this whole process?

Should I redo the upgrade, re-wiping the partition?

Thanks again.

_________________
AMD Athlon XP 2800+
MSI K7N2 Delta2 ATX w/FX5200 AGP video
2X256MB PC3200 RAM
Maxtor 250GB drive (master on IDE 1)
Pioneer DVR-109 (master on IDE 2)
Antec Overture II ATX case with 330watts
Hauppauge 250 in PCI slot 2


Top
 Profile  
 
 Post subject:
PostPosted: Wed Dec 28, 2005 8:42 pm 
Offline
Joined: Thu Mar 25, 2004 11:00 am
Posts: 9551
Location: Arlington, MA
ThisPageIntentionallyLeft wrote:
DBHostName=192.168.0.80
DBUserName=mythtv
DBPassword=<snip>

Aha!!! Try changing 192.168.0.80 to localhost and rebooting.
ThisPageIntentionallyLeft wrote:
Should I redo the upgrade, re-wiping the partition?

Not just yet, we can hold that in reserve. If you decide it's the only way to go, and it prompts you to change the password again, make sure you set the password back to "mythtv" to avoid any lingering issues.


Top
 Profile  
 
 Post subject:
PostPosted: Thu Dec 29, 2005 6:32 pm 
Offline
Joined: Fri Jun 24, 2005 3:22 pm
Posts: 124
Thank you very much, this seems to be helping. i can now run mythtv-setup, and then mythfilldatabase. This is my master backend machine, and I also have one slave backend PC.

At the end, I get an error telling me to go into mythtv setup and change to the correct IP address. I've tried 127.0.0.1 and 192.168.0.80, which is it's IP address.

Going into the frontend, I can see all my transcoded videos, but no recorded shows or live TV. "Master Backend Not Running".

I'm not sure why this is happening. I know the machine has to be listed with it's IP (not 127.0.0.1) for it to function as an MBE.

Thanks for your help.

_________________
AMD Athlon XP 2800+
MSI K7N2 Delta2 ATX w/FX5200 AGP video
2X256MB PC3200 RAM
Maxtor 250GB drive (master on IDE 1)
Pioneer DVR-109 (master on IDE 2)
Antec Overture II ATX case with 330watts
Hauppauge 250 in PCI slot 2


Top
 Profile  
 
 Post subject:
PostPosted: Thu Dec 29, 2005 10:22 pm 
Offline
Joined: Fri Jun 24, 2005 3:22 pm
Posts: 124
OK, I managed to work out the mysql stuff and got the system running. I could watch live TV, watch recordings, watch my avi's.

So I went back to here:

http://mysettopbox.tv/phpBB2/viewtopic. ... t=frontend

to migrate this system to be a mbe and the other system to be slave.

While this worked with little problem for me with the last version, it isn't working with this one. After reboot, the master can no longer watch TV or recordings.

Is there something changed that will do this in the new version? I confused, as I didn't have these problems last time. Thanks.

_________________
AMD Athlon XP 2800+
MSI K7N2 Delta2 ATX w/FX5200 AGP video
2X256MB PC3200 RAM
Maxtor 250GB drive (master on IDE 1)
Pioneer DVR-109 (master on IDE 2)
Antec Overture II ATX case with 330watts
Hauppauge 250 in PCI slot 2


Top
 Profile  
 
 Post subject:
PostPosted: Fri Dec 30, 2005 10:40 pm 
Offline
Joined: Fri Jun 24, 2005 3:22 pm
Posts: 124
i've got the basic vieo playback running on the mbe and I've checked all my work. Before migrating from stand alone to mbe, I could watch TV and see my recorded shows. Now the machine is slow, and I can't watch TV or see my recordings.

What about the LinHES migration could have caused this? Thanks.

_________________
AMD Athlon XP 2800+
MSI K7N2 Delta2 ATX w/FX5200 AGP video
2X256MB PC3200 RAM
Maxtor 250GB drive (master on IDE 1)
Pioneer DVR-109 (master on IDE 2)
Antec Overture II ATX case with 330watts
Hauppauge 250 in PCI slot 2


Top
 Profile  
 
 Post subject:
PostPosted: Fri Dec 30, 2005 10:58 pm 
Offline
Joined: Fri Jun 24, 2005 3:22 pm
Posts: 124
I believe the backend is still not running properly, and that is precipetating these headaches. Should I just start over?

_________________
AMD Athlon XP 2800+
MSI K7N2 Delta2 ATX w/FX5200 AGP video
2X256MB PC3200 RAM
Maxtor 250GB drive (master on IDE 1)
Pioneer DVR-109 (master on IDE 2)
Antec Overture II ATX case with 330watts
Hauppauge 250 in PCI slot 2


Top
 Profile  
 
 Post subject:
PostPosted: Mon Jan 02, 2006 8:54 pm 
Offline
Joined: Fri Jun 24, 2005 3:22 pm
Posts: 124
OK, the good news is I figured out what is wrong. Although I couldn't find anything in the logs, I was finally able to get far enough into the Information Center (it runs slooooow) to see that the machine thinks its a slave back end.

The log says "Started as slave back end." So, I figured I had a sudden attack of dislexia, and checked here:

http://mysettopbox.tv/phpBB2/viewtopic. ... t=frontend

to see where I went wrong. Only I couldn't find anything I did wrong, and when I setup the last build I didn't have this problem.

Is there something in those instructions that is unclear and I might have misinterpreted? Thanks for your time.

_________________
AMD Athlon XP 2800+
MSI K7N2 Delta2 ATX w/FX5200 AGP video
2X256MB PC3200 RAM
Maxtor 250GB drive (master on IDE 1)
Pioneer DVR-109 (master on IDE 2)
Antec Overture II ATX case with 330watts
Hauppauge 250 in PCI slot 2


Top
 Profile  
 
 Post subject:
PostPosted: Mon Jan 02, 2006 10:14 pm 
Offline
Joined: Fri Jun 24, 2005 3:22 pm
Posts: 124
I'm very sorry, the last part was my dyslexia. Thanks for your help.

_________________
AMD Athlon XP 2800+
MSI K7N2 Delta2 ATX w/FX5200 AGP video
2X256MB PC3200 RAM
Maxtor 250GB drive (master on IDE 1)
Pioneer DVR-109 (master on IDE 2)
Antec Overture II ATX case with 330watts
Hauppauge 250 in PCI slot 2


Top
 Profile  
 

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



All times are UTC - 6 hours




Who is online

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