Thank you, DJ
My Apache is installed in Windows XP( run on NTFS file system). I think the
user setting in the way as you said would be only available in Windows
2000/2003. I did try to create a new user in the XP , but have nothing to
set the account right except andministrator or normal user.
Jack
----- Original Message -----
From: "DJ Anubis" <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Sent: Saturday, June 03, 2006 5:00 PM
Subject: Re: [sqlite] question about php_pdo_sqlite
Did you fully read Apache documentation ? Maybe some RTFM can help with
this.
From Apache doc, section Running Apache as a service on Windows:
"By default, all Apache services are registered to run as the system
user (the LocalSystem account). The LocalSystem account has no
privileges to your network via any Windows-secured mechanism, including
the file system, named pipes, DCOM, or secure RPC. It has, however, wide
privileges locally."
This explains the problem you face. Apache is more secured than most
Windows services. There is a simple solution which will give you write
access to your remote file system:
Create a separate account for running Apache services. This is mandatory
to access network resources. Simple steps:
1. Create a normal domain user account, and memorize (write doiwn)
its password.
2. Grant the newly created account a Logon privilege as a service and
Act as part of the OS. You'll have to use Group Policy to
propagate those settings.
3. Confirm the new account as a member of the Users Group
4. Grant this account Read and Execute rights to all documents and
folders (including subfolders) in your Apache Root Directory
(htdocs and cgi-bin)
5. Grant this account Change (RWXD) rights to Apache logs folder.
6. Grant the account Read and Execute (RX) rights to Apache binary.
Then stop and restart Apache Services. You should have access to your
network mounts, providing your scripts use the standard:
\\<NetworkShareName>\<Directory>\<SubDirectory>\<Filename_or_SQlite_Db>
instead of the classic
<Drive>:\<Directory>\<SubDirectory>\<Filename_or_SQlite_Db>
This should solve all of your access rights assignations between your
PHP script, Apache and the network mount.
If this can help, let us know :)
JCR
