Author |
Message |
ThisPageIntentionallyLeft
|
Posted: Tue Dec 27, 2005 9:46 pm |
|
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 |
|
 |
ThisPageIntentionallyLeft
|
Posted: Tue Dec 27, 2005 9:49 pm |
|
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 |
|
 |
tjc
|
Posted: Tue Dec 27, 2005 9:55 pm |
|
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 |
|
 |
ThisPageIntentionallyLeft
|
Posted: Tue Dec 27, 2005 10:47 pm |
|
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 |
|
 |
tjc
|
Posted: Wed Dec 28, 2005 6:55 pm |
|
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. 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 |
|
 |
ThisPageIntentionallyLeft
|
Posted: Wed Dec 28, 2005 8:29 pm |
|
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 |
|
 |
tjc
|
Posted: Wed Dec 28, 2005 8:42 pm |
|
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 |
|
 |
ThisPageIntentionallyLeft
|
Posted: Thu Dec 29, 2005 6:32 pm |
|
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 |
|
 |
ThisPageIntentionallyLeft
|
Posted: Thu Dec 29, 2005 10:22 pm |
|
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 |
|
 |
ThisPageIntentionallyLeft
|
Posted: Fri Dec 30, 2005 10:40 pm |
|
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 |
|
 |
ThisPageIntentionallyLeft
|
Posted: Fri Dec 30, 2005 10:58 pm |
|
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 |
|
 |
ThisPageIntentionallyLeft
|
Posted: Mon Jan 02, 2006 8:54 pm |
|
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 |
|
 |
ThisPageIntentionallyLeft
|
Posted: Mon Jan 02, 2006 10:14 pm |
|
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 |
|
 |