[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