On Thu, Mar 24, 2005 at 03:17:46AM -0800, Don wrote: > [EMAIL PROTECTED] 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. > [EMAIL PROTECTED] 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 [email protected] http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
