--- Zbigniew Baniewski <[EMAIL PROTECTED]> wrote:
>
> While using SQLite as FastCGI module from within PHP-scripts, sometimes I'm
> getting error messages, like:
>
> (mod_fastcgi.c.2551) FastCGI-stderr: PHP Warning:
> sqlite_open() [<a href='function.sqlite-open'>function.sqlite-open</a>
> malformed database schema - unable to open a temporary database file
> for storing temporary tables in /usr/local/www/index.php on line 25
>
> Yes, I've found several "recipes", how to fix it, like:
>
> http://hostprogressive.com/support/php_5_docs/ref.sqlite.html
>
> "On Windows operating systems, unprivileged accounts don't have the TMP
> environment variable set by default. This will make sqlite create temporary
> files in the windows directory, which is not desirable. So, you should set
> the TMP environment variable for the web server"
>
> or f.e.:
>
> http://www.bacula.org/dev-manual/Installin_Configuri_SQLite.html
>
> "this is most likely caused by the fact that some versions of SQLite attempt
> to create a temporary file in the current directory"
>
>
> ...but the problem is, that:
>
> 1. This isn't any Windows-based installation - it's NetBSD.
>
> 2. The error message didn't tell, WHERE exactly it's trying to "open a
> temporary database file" - but under NetBSD, lighttpd is working with
> root privileges (the privileges seem not to be dropped, because I can
> see, that the files sent via http form are saved with root.wheel owner).
> So, even if it's trying to create any temporary file, it's able to create
> it anywhere. In /tmp or anywhere else.
>
> 3. The problem isn't occuring in regular manner - f.e. once in two weeks
> (while the PHP scripts, which are calling SQLite are used each day).
> So, currently no idea, what is causing that.
>
> Any clues?
Try
PRAGMA temp_store_directory = 'directory-name';
Otherwise, the temp file location order for UNIX is:
"/var/tmp",
"/usr/tmp",
"/tmp",
".",
If NetBSD has some equivalent to truss or strace you
could determine the temp file location using that.
____________________________________________________________________________________
Take the Internet to Go: Yahoo!Go puts the Internet in your pocket: mail, news,
photos & more.
http://mobile.yahoo.com/go?refer=1GNXIC
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
