Graham Dunn wrote:
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
You need to start the frontend as the user mythtv su mythtv -c mythfrontend
[EMAIL PROTECTED] 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
[EMAIL PROTECTED] 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
[EMAIL PROTECTED] 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. _______________________________________________ mythtv-users mailing list [email protected] http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
