[mythtv-users] HELP: No temp tables permissions: SOLVED, not understood

R. G. Newbury newbury at mandamus.org
Sat Nov 17 05:28:01 UTC 2007

William Munson wrote:
> R. G. Newbury wrote:


>> 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?


Mysqld is passed --tmpdir=/tmp/mysql which has 775 permissions.
It does not use that directory however. Mythfilldatabase writes to /tmp 
and creates a mythtv-ddp-xxxxxx directory with cache files in it...So 
that part *seems* to be working, although not as I expect.

BUT ...
2007-11-16 22:18:57.913 Upgrading to schema version 1190
2007-11-16 22:18:57.913 DB Error (Performing database upgrade):
Query was: CREATE TEMPORARY TABLE tmpcodecparams AS SELECT * FROM 
codecparams WHERE name = 'mpeg4scalebitrate';
Error was: Driver error was [2/1005]:
QMYSQL3: Unable to execute query
Database error was:
Can't create table 'tmpcodecparams' (errno: 13)

new version: 1190
2007-11-16 22:18:57.913 Database Schema upgrade FAILED, unlocking.

Been banging my head against the wall on this one for 4 days now....and 
completely stumped on simple answers..so brute force and ignorance to 
the fore...

I gave the /tmp directory to mysql:mysql from root and set permissions 
to 777...(yup, brute force!)


Why it would not work as root:root with 777 I have no idea. Why it 
changed and stopped working from the prior state I have no idea.
And the temp directories which are created in /tmp *are owned by root!*.

No idea....
But it's working again

More information about the mythtv-users mailing list