You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@httpd.apache.org by Siegfried Heintze <in...@signitek.com> on 2006/04/14 16:08:12 UTC
[users@httpd] How to populate MSAccess Database while Apache HTTPD Queries it?
Sorry if this appears twice. When I did not see it echo I sent it again
-----Original Message-----
From: siegfried [mailto:siegfried@heintze.com]
Sent: Thursday, April 13, 2006 6:16 PM
To: 'users@httpd.apache.org'
Subject: Populating Microsoft MDB file and simultaneously querying it
I have some cygwin cron jobs populating a Microsoft Access database while
users are trying to simultaneouly query the database via C#/httpd.
I think my problem is that the cygwin cron jobs are running in the
Administrator account and they create a .mdl file (the lock) under the
administrator account and then, while httpd can open the .mdb file (because
I put an access control list on it), httpd cannot open the mdl file (because
the cron job just created it with the Administrator account).
What account should my cron jobs be running in to be compatible with with
httpd? I think they could all access the database fine if they were all
running in the same account?
Thanks,
Siegfried
RE: [users@httpd] How to populate MSAccess Database while Apache HTTPD Queries it?
Posted by Siegfried Heintze <in...@signitek.com>.
Yikes! I'm running as the SYSTEM account according to a little program I
wrote that prints out
System.Security.Principal.WindowsIdentity.GetCurrent().Name using the cli.
This looks like a security threat. Can I change this so the web server is
running in a less privledged account?
Sieg
_____
From: Siegfried Heintze [mailto:info@signitek.com]
Sent: Friday, April 14, 2006 12:49 PM
To: users@httpd.apache.org
Subject: RE: [users@httpd] How to populate MSAccess Database while Apache
HTTPD Queries it?
Gary,
Why cannot I not just run the cygwin cron jobs under the same account as
Apache httpd is using? That ought to fix the problem. Can someone tell me
where in the httpd.conf file I specify the account that Apache httpd uses? I
thought I saw it in there once.
If it is not specified there, what is the account that the web server is
running under?
Sieg
_____
From: Garry Taylor
Sent: Friday, April 14, 2006 8:15 AM
To: users@httpd.apache.org
Subject: RE: [users@httpd] How to populate MSAccess Database while Apache
HTTPD Queries it?
-----Original Message-----
From: Siegfried Heintze [mailto:info@signitek.com]
Sent: 14 April 2006 15:08
To: users@httpd.apache.org
Subject: [users@httpd] How to populate MSAccess Database while Apache HTTPD
Queries it?
Sorry if this appears twice. When I did not see it echo I sent it again
-----Original Message-----
From: siegfried [mailto:siegfried@heintze.com]
Sent: Thursday, April 13, 2006 6:16 PM
To: 'users@httpd.apache.org'
Subject: Populating Microsoft MDB file and simultaneously querying it
I have some cygwin cron jobs populating a Microsoft Access database while
users are trying to simultaneouly query the database via C#/httpd.
I think my problem is that the cygwin cron jobs are running in the
Administrator account and they create a .mdl file (the lock) under the
administrator account and then, while httpd can open the .mdb file (because
I put an access control list on it), httpd cannot open the mdl file (because
the cron job just created it with the Administrator account).
What account should my cron jobs be running in to be compatible with with
httpd? I think they could all access the database fine if they were all
running in the same account?
Thanks,
Siegfried
I think your stuffed. You could get the script to make a copy of the
database and put all the new record into that one. Then copy the file over
replacing the old one. You may have you restart Apache with graceful after
this, if it changes anything. Adding records should be ok.
Giz
RE: [users@httpd] How to populate MSAccess Database while Apache HTTPD Queries it?
Posted by Siegfried Heintze <in...@signitek.com>.
Gary,
Why cannot I not just run the cygwin cron jobs under the same account as
Apache httpd is using? That ought to fix the problem. Can someone tell me
where in the httpd.conf file I specify the account that Apache httpd uses? I
thought I saw it in there once.
If it is not specified there, what is the account that the web server is
running under?
Sieg
_____
From: Garry Taylor
Sent: Friday, April 14, 2006 8:15 AM
To: users@httpd.apache.org
Subject: RE: [users@httpd] How to populate MSAccess Database while Apache
HTTPD Queries it?
-----Original Message-----
From: Siegfried Heintze [mailto:info@signitek.com]
Sent: 14 April 2006 15:08
To: users@httpd.apache.org
Subject: [users@httpd] How to populate MSAccess Database while Apache HTTPD
Queries it?
Sorry if this appears twice. When I did not see it echo I sent it again
-----Original Message-----
From: siegfried [mailto:siegfried@heintze.com]
Sent: Thursday, April 13, 2006 6:16 PM
To: 'users@httpd.apache.org'
Subject: Populating Microsoft MDB file and simultaneously querying it
I have some cygwin cron jobs populating a Microsoft Access database while
users are trying to simultaneouly query the database via C#/httpd.
I think my problem is that the cygwin cron jobs are running in the
Administrator account and they create a .mdl file (the lock) under the
administrator account and then, while httpd can open the .mdb file (because
I put an access control list on it), httpd cannot open the mdl file (because
the cron job just created it with the Administrator account).
What account should my cron jobs be running in to be compatible with with
httpd? I think they could all access the database fine if they were all
running in the same account?
Thanks,
Siegfried
I think your stuffed. You could get the script to make a copy of the
database and put all the new record into that one. Then copy the file over
replacing the old one. You may have you restart Apache with graceful after
this, if it changes anything. Adding records should be ok.
Giz
RE: [users@httpd] How to populate MSAccess Database while Apache HTTPD Queries it?
Posted by Garry Taylor <gi...@gbdesign.net>.
-----Original Message-----
From: Siegfried Heintze [mailto:info@signitek.com]
Sent: 14 April 2006 15:08
To: users@httpd.apache.org
Subject: [users@httpd] How to populate MSAccess Database while Apache
HTTPD Queries it?
Sorry if this appears twice. When I did not see it echo I sent it again
-----Original Message-----
From: siegfried [mailto:siegfried@heintze.com]
Sent: Thursday, April 13, 2006 6:16 PM
To: 'users@httpd.apache.org'
Subject: Populating Microsoft MDB file and simultaneously querying it
I have some cygwin cron jobs populating a Microsoft Access database
while users are trying to simultaneouly query the database via C#/httpd.
I think my problem is that the cygwin cron jobs are running in the
Administrator account and they create a .mdl file (the lock) under the
administrator account and then, while httpd can open the .mdb file
(because I put an access control list on it), httpd cannot open the mdl
file (because the cron job just created it with the Administrator
account).
What account should my cron jobs be running in to be compatible with
with httpd? I think they could all access the database fine if they were
all running in the same account?
Thanks,
Siegfried
I think your stuffed. You could get the script to make a copy of the
database and put all the new record into that one. Then copy the file
over replacing the old one. You may have you restart Apache with
graceful after this, if it changes anything. Adding records should be
ok.
Giz