# sqlite temp directory

- Thread: https://externals.io/message/12578
- Original archive: https://news-web.php.net/php.internals/12578
- Started by Michael Spector on 2004-09-05T15:29:06+00:00
- Messages: 3
- Reply by email to internals@lists.php.net
- More for agents: search with https://externals.io/search.md?q={query} · JSON API at https://externals.io/api · documentation at https://externals.io/llms.txt

---

## #12578 — Michael Spector — 2004-09-05T15:29:06+00:00

URL: https://externals.io/message/12578#12578

Hi,

It looks like libsqlite uses global variable 'sqlite_temp_directory'
for storing the path to temporary directory. It would be very useful,
if there was a PHP.ini entry named like: "sqlite.temp_directory" setting this
variable, since there are cases where user environment doesn't allow to
every user writting to /tmp, /usr/tmp, /var/tmp or to current directory,
or another temporary directory is used. In such cases, these users
usually get this warning:

<b>Warning</b>: sqlite_open(): unable to open a temporary database file
for storing temporary tables in <b>....

Thanks.

-- 
Best regards,

Michael

---

## #12603 — Derick Rethans — 2004-09-06T06:32:10+00:00

URL: https://externals.io/message/12578#12603 · In reply to: #12578

> It looks like libsqlite uses global variable 'sqlite_temp_directory'
> for storing the path to temporary directory. It would be very useful,
> if there was a PHP.ini entry named like: "sqlite.temp_directory" setting this
> variable, since there are cases where user environment doesn't allow to
> every user writting to /tmp, /usr/tmp, /var/tmp or to current directory,
> or another temporary directory is used. In such cases, these users
> usually get this warning:
>
> <b>Warning</b>: sqlite_open(): unable to open a temporary database file
> for storing temporary tables in <b>....

Please file this as a feature request in our bug system.

regards,
Derick

-- 
Derick Rethans
http://derickrethans.nl | http://ez.no | http://xdebug.org

---

## #12606 — Andi Gutmans — 2004-09-06T07:24:07+00:00

URL: https://externals.io/message/12578#12606 · In reply to: #12578

Yeah I think that's a good idea. The only thing I'm not sure about is if we 
should unify tmp configuration for all extensions. My first instinct would 
be yes but from looking at php.ini
;upload_tmp_dir =
;session.save_path = "/tmp"
soap.wsdl_cache_dir="/tmp"

People might want to put these things into different directories so maybe 
the answer is no :)

Do you have a patch which implements this?

Andi

At 06:29 PM 9/5/2004 +0300, Michael Spector wrote:
>Hi,
>
>It looks like libsqlite uses global variable 'sqlite_temp_directory'
>for storing the path to temporary directory. It would be very useful,
>if there was a PHP.ini entry named like: "sqlite.temp_directory" setting this
>variable, since there are cases where user environment doesn't allow to
>every user writting to /tmp, /usr/tmp, /var/tmp or to current directory,
>or another temporary directory is used. In such cases, these users
>usually get this warning:
>
><b>Warning</b>: sqlite_open(): unable to open a temporary database file
>for storing temporary tables in <b>....
>
>Thanks.
>
>--
>Best regards,
>
>Michael