Fire ComcastTV - configure MythTV

Did a bit of research to prepare a bit better for the MythTV configuration.  Found several potentially useful sites:

• http://www.mythtv.org/wiki/Main_Page - The main page with links to other more useful pages.
• http://www.mythtv.org/docs/ - The official docs.  Oriented to building from source but starting around chapter 6 useful for configuration.  Only a loose connection to the software as installed but reasonable clues.  At chapter 9 there is rather detailed though not always adequate documentation for configuration of the back end system.
• http://www.mythtv.org/docs/mythtv-HOWTO.pdf - As above but a PDF that might be easier to use.
• http://www.mythtv.org/wiki/Mythtv-setup - Just a place holder but with some useful links.
• http://www.mythtv.org/wiki/User_Manual:MythTV_structure - Useful background and some configuration information.
• http://www.mythtv.org/wiki/User_Manual:Detailed_configuration_Backend - Detailed walk through of backend setup.  Probably a good place to start.

Setup a VNC link to Amazon so I can work while downstairs.  LOVE VNC.

OK working from http://www.mythtv.org/docs/mythtv-HOWTO.pdf I discovered that the database is at 

ls /usr/share/mythtv/mythweb/modules/database/.   However, during the initial install there were questions concerning the database so I'm going to skip the directions in 6.2.

Skip section 7 on sound since I know from earlier experiments with HDHomeRun that it captures sound.

Since I don't have a remote yet I also skipped section 8 on remotes.

Start with section 9.1, configure master backend system.

• Need a place to store the video so 

rbell01824@Amazon:~$ sudo -i
[sudo] password for rbell01824:
root@Amazon:~# mkdir /var/video
root@Amazon:~# chmod a+rwx /var/video
root@Amazon:~# exit

Much useful information about how to mount to minimize risk with video storage.  I'll ignore for the moment and return later. 

• Now run mythtv-setup to configure some more
• First run get notice that you must be a member of the mythtv group.  Say yes and get added to the group.  Must logout.  Since I'm working via VNC had to manually go upstairs and login again.  Need to find a better system.
• Reality and the directions part company here.  
• I get a screen to select language.  English is OK.
• Warning No UPnp.  Not sure what it is so I'm OK.
• Database Configuration 1/2 screen with warning Myth could not connect to the database.  This is somewhat alarming as during installation I answered questions that should have sorted this out.  
• Set host IP address since I know that the front end will be elsewhere and localhost is a nonstarter.
• Leave Ping set.
• Leave Port blank.
• Database name left at mythconverg.
• Leave User set to mythtv.
• Leave Password set to mythtv.
• Go to Database Configuration 2/2
• Leave everything along
• Get message that can not login to database
• Taken back to Database Configuration 1/2
• Try a couple of different passwords.  No joy.
• Cancel.  Get message Would you like to run mythfilldatabase.  Answer yes.  Text scrolls by but it looks like database access fails.
• Go back to database setup, section 6.

More DB work.

• Section 6 gives some commands.  They don't work as mysql is password protected per the earlier installation.

root@Amazon:~# mysql -u root --password=... mythconverg
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 89
Server version: 5.1.41-3ubuntu12.10 (Ubuntu)
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> grant all on mythconverg.* to mythtv@"192.168.1.%" identified by "mythtv";
Query OK, 0 rows affected (0.00 sec)
mysql> flush privileges;;
Query OK, 0 rows affected (0.00 sec)
mysql> quit;
Bye

• This should fix the issue.  But still no joy.
• Edit /etc/mysql/my.cnf and force the IP.  Restart mysql with 
rbell01824@Amazon:~$ sudo service mysql restart mysql start/running, process 12472 rbell01824@Amazon:~$
• Success as user mythtv pw mythtv!!!!
• Get Host Address Backend Setup screen.  Looks like the install configuration is badly broken.
• Get a series of configuration screens.  Look at http://www.mythtv.org/wiki/User_Manual:Detailed_configuration_Backend for help in dealing with these.  It seems they can be left alone for the moment.
• Get to the "mythtv-setup" screen. 

To DO

• Mount 2nd 160 GB drive and fix up place for video storage per section 9 guidelines.
• Configure VNC so that I can always get to the machine.
• Finish mythtv-setup now that DB is connected.