[mythtv-users] ./mythconverg/callsignnetworkmap.frm
Don
dlw3 at tds.net
Thu Mar 24 11:55:50 UTC 2005
Graham Dunn wrote:
>On Thu, Mar 24, 2005 at 03:17:46AM -0800, Don wrote:
>
>
>>[don at localhost don]$ mythfrontend
>>2005-03-24 03:05:01.692 Inserting MythTV initial database information.
>>2005-03-24 03:05:01.693 Upgrading to schema version 1060
>>2005-03-24 03:05:01.694 DB Error (Performing database upgrade):
>>Query was: CREATE TABLE IF NOT EXISTS callsignnetworkmap ( id int(11)
>>NOT NULL auto_increment, callsign varchar(20) NOT NULL default '',
>>network varchar(20) NOT NULL default '', PRIMARY KEY (id), UNIQUE KEY
>>callsign (callsign));
>>Error was: Driver error was [2/1]:
>>QMYSQL3: Unable to execute query
>>Database error was:
>>Can't create/write to file './mythconverg/callsignnetworkmap.frm'
>>(Errcode: 13)
>>
>>new version: 1060
>>2005-03-24 03:05:01.696 Couldn't upgrade database to new schema, exiting.
>>[don at localhost don]$
>>
>>If I understand the above, there is no
>>/var/lib/mysql/mythconverg/callsignnetworkmap.frm
>>and it can not be created.
>>
>>Is this a permission problem?
>>Permissions for /var/lib/mysql/mythconverg are 'mythtv:mythtv'.
>>
>>Is trying to start 'mythfrontend' as a 'user' a problem since the
>>permissions are 'mythtv:mythtv'?
>>
>>
>
>You need to start the frontend as the user mythtv
>
>su mythtv -c mythfrontend
>
>What user is your database running as?
>
>The files in /var/lib/mysql/mythconverg are files for the database
>server, and should be owned by the user the database is running as.
>
>To find out what this user is:
>
>ps auxww | grep mysqld
>
>look for a line similar to
>
>mysql 9213 0.0 7.6 70476 19564 ? S<l Mar21 0:00
>/usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql
>--pid-file=/var/run/mysqld/mysqld.pid --skip-locking --port=3306
>--socket=/var/run/mysqld/mysqld.sock
>
>The first item on that line is the user the database is running as
>(mysql).
>
>All the files in /var/lib/mysql/mythconverg must be owned by that user:
>
>ls -l /var/lib/mysql/mythconverg/
>
>-rw-rw---- 1 mysql mysql 0 Mar 13 03:42 callsignnetworkmap.MYD
>-rw-rw---- 1 mysql mysql 1024 Mar 13 03:42 callsignnetworkmap.MYI
>-rw-rw---- 1 mysql mysql 8612 Mar 10 13:53 callsignnetworkmap.frm
>-rw-rw---- 1 mysql mysql 164 Mar 13 03:42 capturecard.MYD
>-rw-rw---- 1 mysql mysql 2048 Mar 13 03:42 capturecard.MYI
>[...]
>-rw-rw---- 1 mysql mysql 68 Mar 15 17:35 videosource.MYD
>-rw-rw---- 1 mysql mysql 3072 Mar 16 14:37 videosource.MYI
>-rw-rw---- 1 mysql mysql 8752 Mar 10 14:03 videosource.frm
>-rw-rw---- 1 mysql mysql 120 Mar 13 03:45 videotypes.MYD
>-rw-rw---- 1 mysql mysql 2048 Mar 13 03:45 videotypes.MYI
>-rw-rw---- 1 mysql mysql 8698 Mar 10 14:03 videotypes.frm
>
>
>
>
>>Can I create 'callsignnetworkmap.frm' to solve this?
>>
>>
>
>No. This file is strictly for the database's use only. You mess with it
>at your own peril.
>
>Graham
>
>
>------------------------------------------------------------------------
>
>_______________________________________________
>mythtv-users mailing list
>mythtv-users at mythtv.org
>http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>
>
You need to start the frontend as the user mythtv
su mythtv -c mythfrontend
[don at localhost don]$ su mythtv -c mythfrontend
Password:
Xlib: connection to ":0.0" refused by server
Xlib: No protocol specified
mythfrontend: cannot connect to X server :0.0
[don at localhost don]$ ps auxww | grep mysqld
root 3028 0.0 0.2 2016 1056 ? S 00:04 0:00 /bin/sh
/usr/bin/mysqld_safe --datadir=/var/lib/mysql
--pid-file=/var/lib/mysql/localhost.pid
mysql 3097 0.0 2.6 91292 13736 ? Sl 00:04 0:00
/usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql
--pid-file=/var/lib/mysql/localhost.pid --skip-locking
don 11550 0.0 0.1 1764 592 pts/3 R+ 03:45 0:00 grep mysqld
[don at localhost don]$ ls -l /var/lib/mysql/mythconverg/
total 0
I know I don't know much about this stuf but this looks really messed up.
More information about the mythtv-users
mailing list