[mythtv-users] ./mythconverg/callsignnetworkmap.frm

[Graham Dunn]

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