[Gllug] Re: How to setup mysql for mythtv

[Emon]

Ben Fitzgerald wrote:
> On Mon, Apr 10, 2006 at 12:19:49AM +0600, Emon wrote:
> 
> 
>>>>I am a newbie running Slackware10.2 with KDE
> 
> 
> nothing like learning on slackware! :-)
> 
> <snip>
> 
>>So can anyone please guide me on how to get mysql up & running???
>>Any pointer will also be appreciated..
> 
> 
> Emon,
> 
> a couple of quick googles and you have these:
> 
> generic mysql install howto:
> http://dev.mysql.com/doc/refman/4.1/en/installing.html
> 
> mythtv specific mysql installation/setup:
> http://www.mythtv.org/docs/mythtv-HOWTO-6.html
> 
> mysql is pretty easy from a simple setup. all you should need is mysql
> started from the init script (pgrep it to check it's started) then
> create the database for mythtv by reading in the supplied config file,
> as here:
> http://www.mythtv.org/docs/mythtv-HOWTO-6.html#ss6.2
> 
> HTH,
> 
> Ben.
> 

Thanks everyone

This is where I stand now...

I don't know anything about databases so I am kind of trying to 
(blindly) follow the instructions in the docs & the file 
/etc/rc.d/rc.mysqld to get mysql up & running...

My runlevel in /etc/inttab is 4 & this is what I see during startup

*********************
Starting mysqld daemon with databases from /var/lib/mysql
                  /usr/sbin/nmbd -D
Starting gpm:  /usr/sbin/gpm -m /dev/mouse -t imps2
Starting lirc daemon: lircd & lircmd... Done
Starting Guarddog...
STOPPING server from pid file /var/run/mysql/mysql.pid
060410 18:04:02  mysqld ended
Done
Starting LISa daemon...
Done
Starting up X11 session manager...
This is the LAN Information Server LISa 0.2.3
It is free software according the GNU General Public License
Copyright (c) 2000-2003 by Alexander Neundorf
email: neundorf at kde.org
running on port 7741
Have fun !  :-)
*********************

I am still getting the following error while trying to run mythtv

**********************
QSqlQuery::exec: database not open
QSqlQuery::exec: database not open
2006-04-10 18:18:34.505 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError?  Strange...
2006-04-10 18:18:34.556 Database not open while trying to save setting: 
Language
2006-04-10 18:18:34.574 Unable to connect to database!
2006-04-10 18:18:34.574 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 what is it that I am doing wrong??

Thanks
Emon

BTW I also encountered the following errors while running

mysql at magic-box:~$ mysql_install_db

********************
ERROR: 1017  Can't find file: './mysql/help_keyword.frm' (errno: 13)
060410 18:43:31 [ERROR] /usr/libexec/mysqld: Can't find file: 
'./mysql/help_keyword.frm' (errno: 13)
060410 18:43:31 [ERROR] /usr/libexec/mysqld: Can't find file: 
'./mysql/help_keyword.frm' (errno: 13)
ERROR: 1017  Can't find file: './mysql/help_keyword.frm' (errno: 13)
060410 18:43:31 [ERROR] /usr/libexec/mysqld: Can't find file: 
'./mysql/help_relation.frm' (errno: 13)
060410 18:43:31 [ERROR] /usr/libexec/mysqld: Can't find file: 
'./mysql/help_relation.frm' (errno: 13)
********************



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