Re: setting up mythtv

Eve Kotyk wrote:
> I thought I might try to setup mythtv, but I'm already stuck. I'm on a
> Mandriva Free 2007 setup and I've installed all the rpm required. Mysqld
> is running. The instruction at
> http://www.mythtv.org/docs/mythtv-HOWTO.pdf tell you run the following
> command: msyql -u root < mc.sql . I get an error response. ' no mc.sql'.

That command is supposed to get MySQL to execute the mc.sql file's
commands (initializing the values of the mythconverg database). It
looks like you didn't have the mc.sql in that directory; locate it and
execute the command in that directory (or type the full path in).

> I did however create a mythconverg database.
>
> When I run /usr/bin/mythtv-setup I get a huge string of errors,
> beginning with
> Database error was:
> Can't connect to MySQL server on '127.0.0.1' (111)
>
> QSqlQuery::exec: database not open
> QSqlQuery::exec: database not open
> 2007-03-13 19:30:06.775 DB Error (KickDatabase):
> Query was:
> SELECT NULL;
> No error type from QSqlError? Strange...
>
> Does anyone have any idea why I mythtv can't connect to the database?

Sounds like you're not running the mysqld. You'll need to run something
like '/etc/rc.d/init.d/rc.mysql start' before the SQL server will be
running. This should be done before you try to enter the mc.sql data above.

So:
  - Start the server
  - Import the mc.sql file, once you have the correct path.
  - Run mythtv-setup

You might have to flush the permissions table if you've just setup the
MythTV sql user, too.
Received on Wed Mar 14 00:03:35 2007