The picture just froze yesterday while watching OTA HDTV. I rebooted Mythbuntu and selected 'Watch TV'. The screen goes blank for a second, then returns to the main menu. At this point I tried a DVD which worked except no sound. alsamixer had muted the digital output. I un-muted that and got sound.

I did a channel scan from setup, and Mythbuntun found all my OTA local DTV stations. Still nothing when I select "Watch TV". I'm using the Hauppauge 1250 tuner card.

Any logs I can look at? Something I could run/look at from the command line?

Can you play recorded shows?

What does this show:
lsof -i -n -P |grep 3306
lsof -i -n -P |grep 654

matt@mythbuntu:~$ lsof -i -n -P |grep 3306
matt@mythbuntu:~$ lsof -i -n -P |grep 654
mythfront 6519 matt 7r IPv4 18991 TCP *:6547 (LISTEN)
mythfront 6519 matt 8r IPv4 18993 UDP *:6549
mythfront 6519 matt 24w IPv4 19218 TCP 127.0.0.1:41051->127.0.0.1:6543 (ESTABLISHED)
mythfront 6519 matt 30u IPv4 19219 TCP 127.0.0.1:41050->127.0.0.1:6543 (ESTABLISHED)
matt@mythbuntu:~$


grep didn't catch any lines with 3306

And now I can't log into the mysql DB. I screwed something up trying to do a DB
mysqlcheck --auto-repair -A -u mythtv -pmysqlpass

OK, so mysql has quit.
$ sudo /etc/init.d/mysql start
$ sudo /etc/init.d/mythtv-backend restart
... then it should work.

BTW, that lsof command is VERY useful, to see what daemons are listening on what interfaces. I set it up as a 'listen' command by adding the following line to my /etc/profile
alias listen='lsof -i -n -P |more'
...then run it:
/etc/profile
... and you now have the listen command, and will have it from now on.

Using it, you can see what daemons are listening to tcp on -all- interfaces. For security reasons you want as few daemons listening to outside interfaces as possible. To set this is often the corresponding file in /etc/default, or sometimes requires a modification to the init.d file.

Whups, mysql may be running as its own user. Try:
sudo lsof -i -n -P |grep 3306

mysqld 5678 mysql 10u IPv4 16005 TCP *:3306 (LISTEN)

Its up. I think the DB is screwed up now. I cannot log in from the cmd line.
matt@mythbuntu:/$ mysql -u mythtv -p
Enter password:
ERROR 1045 (28000): Access denied for user 'mythtv'@'localhost' (using password: YES)

And I have two mythtv accounts now somehow?

As root:
mysql> select user from user where user like 'mythtv';
+--------+
| user |
+--------+
| mythtv |
| mythtv |
+--------+
2 rows in set (0.00 sec)


I did this and got it fixed. Its working again
matt@mythbuntu:/$ mysqlcheck --auto-repair -A -u mythtv -pxxxxxxx

.
.
.

mythconverg.record OK
mythconverg.recorded
warning : Table is marked as crashed and last repair failed
warning : Size of indexfile is: 9216 Should be: 2048
error : Found 36 keys of 38
error : Corrupt
mythconverg.recordedcredits OK
mythconverg.recordedfile OK
.
.
.

What do you think caused this?

I'd prolly give the hard drives a good advanced scan with DFT just to make sure they're ok --> http://www.hitachigst.com/hdd/support/download.htm#DFT (works w/ all brands)