[mythtv-users] HELP: No temp tables permissions: (WAS: dd_v_ tables missing from mythconverg)
william_munson at bellsouth.net
Fri Nov 16 22:48:26 UTC 2007
R. G. Newbury wrote:
> Michael T. Dean wrote:
>> I will try it again, running mythtv-setup first.
>>> Anyone else have any good ideas? (I don't mind hearing *bad* ideas, but
>>> I make no promises about using them!)
>> the MythTV "Spring Cleaning" (TM):
> REALLY REALLY STUMPED HERE.
> The problem is more basic than a mythconverg database error.
> The error is actually 'errno 13'...that is, a *system permissions error*.
> Mysql is not capable of creating the temporary tables!!!
> What I am running: SVN 14794 on Fedora 8rc2. Lots of disk space on the
> OS disk (Video on separate disks)
> When this first surfaced...sometime around upgrade to 14794 from 14726?
> or so. 14830 failed to run with segfaults.. Cleaned up and recompiled
> 14794, Making current SVN at present but not tested yet.
> What I did:
> 1) I did the spring cleaning backup by dumping the tables to be saved.
> 2) I dropped the mythconverg database and ran <mc.sql to create the
> database again, and 'grant create temporary'...etc.
> 3) I started mythtv-setup and it started with the language prompt, as
> for a new database
> 4) Mythtv-setup promptly failed at attempting to upgrade.,,segfault
> 5) I could get mythtv-setup into its setup pages, but it always
> seg-faulted on exit..although the data was saved
> THE ERROR IS 'errno 13'.
> What I checked:
> 6) Mysql is the user and group for /var/lib/mysql. Permissions are 775
> 7) I created a /tmp/mysql directory, owned by mysql and perms are 775
> and added a 'temp=/tmp/mysql' to the mysql stanza of my.cnf, and
> restarted mysqld.
> 8) The mysql user is mythtv and mythtv is listed, with password in the
> mysql.user table ..However, I note that that table shows that the users
> mythtv does *NOT* have 'create_tmp_table_priv' (or
> create_tmp_priv..can't remember the exact column), nor Lock_tables_priv.
> Poking those to 'Y' does not seem to help.
> SYMPTOM ANALYSIS. It *appears* that the 'upgrade schema' and
> 'mythfilldatabase' programs, *change the user* while running, so that
> the system refuses the process the right to create the temp tables needed.
> And yes, this makes no sense to me too!
> But otherwise why is the error returned by qtmysql an 'errno 13'...a
> systems error, NOT a driver error or a mysql error.
> HELP...NOW I do not even have a running system!
Did you perhaps change a path to a non existant file or permissions on
the existing one?
More information about the mythtv-users