<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=ISO-8859-1">
</head>
<body bgcolor="#ffffff" text="#000000">
<big><tt>I am a complete mythtv newbie and need a lot of help. Here
are my<br>
experiences so far.<br>
<br>
System = Mandriva 2009.1, 2.6.29.1-desktop-4mnb<br>
<br>
Devices such as the Hauppage WinTV DVB-T Nova USB stick have been<br>
widely reported as compatible with kernels later that 2.6.27 so I<br>
installed one and the operating system appeared to recognize it once<br>
the firmware file was copied to /lib/firmware. This created the<br>
/dev/dvb tree and switched on the green LED on the USB device. There<br>
are two LEDs - presumably for the two tuners (?).<br>
<br>
A listing from lsmod contains these entries:<br>
<br>
dvb_usb 18764 1 dvb_usb_dib0700<br>
dvb_core 103468 1 dvb_usb<br>
dib3000mc 14056 1 dvb_usb_dib0700<br>
dibx000_common 4068 3 dib7000p,dib7000m,dib3000mc<br>
dib0070 8356 3 dvb_usb_dib0700<br>
<br>
I had already installed MythTV earlier and simply ran the setup<br>
program and the mythfilldatabase --manual command to connect the video<br>
source (antenna) to the tuner card. Subsequently I was able to scan<br>
for Freeview channels, about half of which came in at 50% to 80%<br>
signal strength. However when I tried "Watch TV" the screen flashed<br>
and reverted to the menu. Can't remember the errors - might have been<br>
something to do with the mySQL database. mysqld was running and so<br>
was the mythtv backend. What I expected was something to allow me to<br>
choose a channel to watch and optionally record and in addition load<br>
an EPG via xmltv.<br>
<br>
After several hours of tinkering I decided to delete all the mythtv<br>
components; urpme -a myth and then delete mythconverg. Reinstalled<br>
mythtv but the database went missing. As far as I can remember it<br>
appeared automagically at some point in the first run. I certainly<br>
did nothing to create it.<br>
<br>
The /usr/share/mythtv/initialdb directory contains the script mc.sql<br>
which certainly looks as if it is meant to be run by something;<br>
ownership is root,root and permissions 644. The text is:<br>
<br>
<a class="moz-txt-link-rfc2396E" href="mailto:[lcl@altair~/.mythtv]$cat/usr/share/mythtv/initialdb/mc.sql"><[lcl@altair ~/.mythtv]$ cat /usr/share/mythtv/initialdb/mc.sql></a><br>
CREATE DATABASE if not exists mythconverg;<br>
GRANT ALL ON mythconverg.* TO mythtv@localhost IDENTIFIED BY "mythtv";<br>
FLUSH PRIVILEGES;<br>
GRANT CREATE TEMPORARY TABLES ON mythconverg.* TO mythtv@localhost
IDENTIFIED BY "mythtv";<br>
FLUSH PRIVILEGES;<br>
ALTER DATABASE mythconverg DEFAULT CHARACTER SET latin1;<br>
<br>
Knowing nothing about mysql I tried running the individual commands as<br>
above at the mysql prompt. The response to each was:<br>
<br>
"Query OK, 0 rows affected (0.00 sec)"<br>
<br>
No idea where the database is supposed to go and since no record<br>
structure is defined I assume it would be an empty shell to start<br>
with, hence the need for mythfilldatabase --manual later on.<br>
<br>
So can anybody give me a clear idea of what I need to do to set up<br>
MythTV again? How do you create the initial database for instance?<br>
The online manual only tells me to do what I am doing anyway. No<br>
troubleshooting tips.<br>
<br>
Apologies for the length of this query.<br>
<br>
Len<br>
</tt></big><br>
</body>
</html>