I have a question about os_unix.c On line 854 inside function sqlite3UnixTempFileName, you declare: static const char *azDirs[] = { 0, "/var/tmp", "/usr/tmp", "/tmp", ".", };
I'm guessing this is where sqlite attempts to create a temp copy of the database it's opening. I'm having difficulties with this because I'm running apache & trac ( http://trac.edgewall.org/ ) as a non-priviliged user (of course) and subsequently it does not have read access to either of these directories. Is there a chance it could, at runtime, eval the environment variable $TMP and use that as one of the options? It looks like creating the temp file fails if and only if all of the dirs listed in azDirs is accessible. So just adding the env var $TMP should solve this problem. Do you agree? if so, I'd be happy to write a patch for this. Respectfully, Christopher