Hi,<br>
<br>
Running Fedora Core 3 in the following box<br>
<br>
Intel (Thrasher motherboard) with P-4 2.6 Ghz+ 1GB RAM<br>
Radeon 9250 Video Card (PCI) with OSS 'radeon' + 'dri' driver running<br>
Hauppauge wintv go video capture card running on 'bttv driver' (I'm
piping the audio thru my PC's intel sound card rather than
brooktree-audio, might be relevant to my problem, I dunno)<br>
<br>
installed <a href="http://mythtv-0.18.1-113.rhfc3.at">mythtv-0.18.1-113.rhfc3.at</a><br>
mysql-3.23.58-16.FC3.1<br>
<a href="http://xmltv-0.5.40-62.rhfc3.at">xmltv-0.5.40-62.rhfc3.at</a><br>
<br>
<br>
<br>
I followed the instruction according to the following site:<br>
<br>
<a href="http://wilsonet.com/mythtv/HOWTO-fc3.php">http://wilsonet.com/mythtv/HOWTO-fc3.php</a><br>
<br>
I made detailed logs (as detailed as I could) of what it is that I did exactly. They are presented below.<br>
I followed the instruction as religiously as I could. mythtv backend starts up ok, and frontend also starts up, but<br>
1. No channel info (even though I configged my login/passwd for zap2it labs<br>
2. I can only get 1 channel (can't change them with keystrokes) and NO sound<br>
<br>
My tv tunder card works fine in itself (I can use 'tvtime'
software and watch tv w/out probs, but mythtv is so much more versatile
that I just HAVE to have it)<br>
<br>
No problem with the xml file at my zap2it labs account (I use
tv_grab_na_dd to download the xml file from there so that 'tvtime' can
read it, and it reads it and renders the info just fine)<br>
<br>
I would appreciate any guidance or advice as to how I should try to fix these problems.<br>
<br>
The detailed logs of my installation are below:<br>
<br>
<br>
<br>
************************************************<br>
$apt-get install mythtv-suite<br>
<br>
<br>
The following extra packages will be installed:<br>
httpd httpd-suexec libmyth mysql mysql-server mythbrowser mythdvd mythgallery mythgame<br>
mythmkmovie mythmusic mythnews mythphone mythplugins myththemes mythtv mythtv-backend<br>
mythtv-frontend mythtv-setup mythtv-theme-MediaCenter mythtv-theme-MythCenter<br>
mythtv-theme-abstract mythtv-theme-isthmus mythtv-theme-photo<br>
mythtv-theme-purplegalaxy mythtv-theme-sleek mythtv-theme-visor mythtv-themes<br>
mythvideo mythweather mythweb perl-DBD-MySQL php php-mysql php-pear qt-MySQL<br>
The following NEW packages will be installed:<br>
httpd httpd-suexec libmyth mysql mysql-server mythbrowser mythdvd mythgallery mythgame<br>
mythmkmovie mythmusic mythnews mythphone mythplugins myththemes mythtv mythtv-backend<br>
mythtv-frontend mythtv-setup mythtv-suite mythtv-theme-MediaCenter<br>
mythtv-theme-MythCenter mythtv-theme-abstract mythtv-theme-isthmus mythtv-theme-photo<br>
mythtv-theme-purplegalaxy mythtv-theme-sleek mythtv-theme-visor mythtv-themes<br>
mythvideo mythweather mythweb perl-DBD-MySQL php php-mysql php-pear qt-MySQL<br>
0 upgraded, 37 newly installed, 0 removed and 11 not upgraded.<br>
Need to get 40.0MB of archives.<br>
After unpacking 68.8MB of additional disk space will be used.<br>
Do you want to continue? [Y/n] Y<br>
<br>
<br>
blahblah... all ok so far<br>
<br>
$/sbin/chkconfig mysqld on<br>
$service mysqld start<br>
Starting
MySQL:
[OK]<br>
<br>
<br>
<br>
$mysql -u root mysql<br>
ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)<br>
<br>
#restarted mysqld with 'skip-grant-tables' in /etc/my.cnf, set am ampty
root pwd. Rolled back to original config w/out 'skip-grant-tables'
& restarted mysqld<br>
<br>
$mysql -u root mysql<br>
Reading table information for completion of table and column names<br>
You can turn off this feature to get a quicker startup with -A<br>
<br>
Welcome to the MySQL monitor. Commands end with ; or \g.<br>
Your MySQL connection id is 2 to server version: 3.23.58<br>
<br>
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.<br>
<br>
mysql> UPDATE user SET Password=PASSWORD('frogbutton_NOT_MY_REAL_PWD') WHERE user='root';<br>
Query OK, 2 rows affected (0.00 sec)<br>
Rows matched: 2 Changed: 2 Warnings: 0<br>
<br>
mysql> FLUSH PRIVILEGES;<br>
Query OK, 0 rows affected (0.00 sec)<br>
mysql> quit<br>
Bye<br>
<br>
$mysql -u root -p < /usr/share/doc/mythtv-0.18.1/database/mc.sql<br>
Enter password: <br>
ERROR 1007 at line 1: Can't create database 'mythconverg'. Database exists<br>
<br>
<br>
<br>
#Downgraded to older version of urw-fonts at
<a href="ftp://rpmfind.net/linux/fedora/core/2/i386/os/Fedora/RPMS/urw-fonts-2.1-7.noarch.rpm">ftp://rpmfind.net/linux/fedora/core/2/i386/os/Fedora/RPMS/urw-fonts-2.1-7.noarch.rpm</a>
<br>
<br>
[Regular User]$mythtvsetup<br>
<br>
#Now following instructions on <a href="http://www.mythtv.org/docs/mythtv-HOWTO-9.html">http://www.mythtv.org/docs/mythtv-HOWTO-9.html</a><br>
#configged zap2it labs channel header downloader with my login & pwd<br>
<br>
[Regular User]$mythbackend &<br>
<br>
Seems to be running.<br>
<br>
[Regular User]$mythfilldatabase<br>
<br>
A whole bunch of errors like<br>
<br>
DB Error (Inserting into dd_genre):<br>
Query was:<br>
INSERT INTO dd_genre (programid, class, relevance) VALUES('SH5153420000','Special','0');<br>
Driver error was [2/1146]:<br>
QMYSQL3: Unable to execute query<br>
Database error was:<br>
Table 'mythconverg.dd_genre' doesn't exist<br>
<br>
DB Error (Inserting into dd_genre):<br>
Query was:<br>
INSERT INTO dd_genre (programid, class, relevance) VALUES('SH5153420000','Travel','1');<br>
Driver error was [2/1146]:<br>
QMYSQL3: Unable to execute query<br>
Database error was:<br>
Table 'mythconverg.dd_genre' doesn't exist<br>
<br>
<br>
Anyhou, ran mythtvfrontend.<br>
<br>
No sound, just 1 channel.<br>
<br>
<br>
<br>
<br>