> + On Windows operating systems, unprivilged accounts doesn't have the
> + <varname>TMP</varname> environment variable set by default. This will
> + make sqlite create temporary files in the windows directory, which isn't
> + good. So, you should set the <varname>TMP</varname> environment variable
> + for the web server or the user account the web server is running under.
3 things about that, first of all "unprivilged accounts" has a typo ;) secondly, that sentence isn't correct, I'd change "doesn't" to "don't"
Then there's also the third and final comment on this from me; I think the wording of that piece of info sounds... well... wrong... it's mainly the "which isn't good" part that ticks me off...
hope others agree, - tul
Nuno Lopes wrote:
nlopess Tue Feb 15 13:29:05 2005 EDT
Modified files: /phpdoc/en/reference/sqlite reference.xml Log:
fix #30955: TMP windows envar. based on patch by danielc at analysisandsolutions dot com
http://cvs.php.net/diff.php/phpdoc/en/reference/sqlite/reference.xml?r1=1.14&r2=1.15&ty=u
Index: phpdoc/en/reference/sqlite/reference.xml
diff -u phpdoc/en/reference/sqlite/reference.xml:1.14 phpdoc/en/reference/sqlite/reference.xml:1.15
--- phpdoc/en/reference/sqlite/reference.xml:1.14 Sun Feb 13 23:13:16 2005
+++ phpdoc/en/reference/sqlite/reference.xml Tue Feb 15 13:29:02 2005
@@ -1,5 +1,5 @@
<?xml version="1.0" encoding="iso-8859-1"?>
-<!-- $Revision: 1.14 $ -->
+<!-- $Revision: 1.15 $ -->
<reference id="ref.sqlite">
<title>SQLite Functions</title>
<titleabbrev>SQLite</titleabbrev>
@@ -42,6 +42,43 @@
In PHP 5, the SQLite extension and the engine itself are bundled and
compiled by default.
</para>
+ <note>
+ <title>Windows installation for unprivilged accounts</title>
+ <para>
+ On Windows operating systems, unprivilged accounts doesn't have the
+ <varname>TMP</varname> environment variable set by default. This will
+ make sqlite create temporary files in the windows directory, which isn't
+ good. So, you should set the <varname>TMP</varname> environment variable
+ for the web server or the user account the web server is running under.
+ If Apache is your web server, you can accomplish this via a
+ <command>SetEnv</command> directive in your &httpd.conf; file. For
+ example:
+ <informalexample>
+ <programlisting role="apache-conf">
+<![CDATA[
+SetEnv TMP c:/temp
+]]>
+ </programlisting>
+ </informalexample>
+ If you are unable to establish this setting at the server
+ level, you can implement the setting in your script:
+ <informalexample>
+ <programlisting role="php">
+<![CDATA[
+putenv('TMP=C:/temp');
+]]>
+ </programlisting>
+ </informalexample>
+ The setting must refer to a directory that the web server
+ has permission to create files in and subsequently write
+ to and delete the files it created.
+ Otherwise, you may receive the following error message:
+ <computeroutput>
+ malformed database schema -
+ unable to open a temporary database file for storing temporary tables
+ </computeroutput>
+ </para>
+ </note>
</section>
<section id="sqlite.requirements">
&reftitle.required;
