How to setup mysql for mythtv (was: Re: [Gllug] Mythtv queries)

[Emon]

John Winters wrote:
> On Sun, 2006-04-09 at 15:34 +0600, Emon wrote:
> 
>>Hi all
>>
>>I am a newbie running Slackware10.2 with KDE
>>
>>I use "TvTime" to watch tv on my PC via my TV card (PinnaclePCTV 
>>Stereo). It uses the following chip, "Phillips Semiconductors SAA7134" & 
>>has limited video capture capability.
>>
>>So now I want to be able to record video from my tv. Somebody once told 
>>me to look at "transcode.org" but I found that to be text oriented... & 
>>didn't dig too deep.
>>
>>BTW I am only interested in analogue tv *NOT* DBV because analogue 
>>(cable) tv is all that we get here in Bangladesh.
>>
>>I was wondering if Mythtv will do the trick?? I wasn't sure after 
>>looking at it's homepage whether it would record analogue tv or not!!
> 
> 
> Yes, MythTV will do analogue TV.  Indeed, it is more oriented towards
> analogue than digital.  AIUI, they don't use DVB much in the USA either,
> and since MythTV originates there DVB has had to be added in later.
> 

Thanks

I have installed mythtv-0.19-i486, but it keeps giving me the following 
error, something about database,.....


*****************

QSqlQuery::exec: database not open
QSqlQuery::exec: database not open
2006-04-07 12:00:40.097 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...
2006-04-07 12:00:40.149 Database not open while trying to save setting:
Language
2006-04-07 12:00:40.151 Unable to connect to database!
2006-04-07 12:00:40.151 Driver error was [1/2002]:
QMYSQL3: Unable to connect
Database error was:
Can't connect to local MySQL server through socket
'/var/run/mysql/mysql.sock' (2)
*****************

So I installed mysql-4.1.14-i486-1, & after going through the 
Mythtv/Mysql readme files, I realized that I have actually got to get 
mysql up & running with my own bare hands :(

Honestly speaking I don't know much about databases, but still tried to 
configure mysql using the docs (without much success...as I am still 
getting the same error).

So can anyone please guide me on how to get mysql up & running???
Any pointer will also be appreciated..

Thanks again
Emon

-- 
Gllug mailing list  -  Gllug at gllug.org.uk
http://lists.gllug.org.uk/mailman/listinfo/gllug