Hi there,
I've found the problem: permission in apache.
if I start the Apache using apache-install.bat or apache-restart.bat, the user name in the taskmanager for Apache process will be automatically set as SYSTEM, which is not my user name, my user name is ZWA.
If I change this user name manually, MapServer works perfect with the oracle spatial support.
if I start the apache again, I must set the user name manually again back to ZWA. Is there any solution to set this globally?
thanks for any ideas
zhonghai
On 6/21/06, Bart van den Eijnden (OSGIS) <[EMAIL PROTECTED]> wrote:
Are there any environment variables which are not passed on to the CGI but
are available in a DOS window? For instance how have you added the Oracle
client bin directory to the Windows PATH?
You also need to do this in Apache's httpd.conf using SetEnv and after
that restart apache.
Best regards,
Bart
> Hi guys,
>
> I've been working on this topic for almost two weeks, and I still can not
> get it work. In last two days, Fernando Simon has helped me a lot to solve
> this problem, Simon, thank you, I really appreciate it. With his help I
> stepped forward to solve this problem, but I still can not get it work.
>
> according to Fernando Simon's suggestion I made the test with the command:
>
> C:\ms4w>
> mapserv.exe"QUERY_STRING=localhost/cgi-bin/mapserv.exe?&mode=map&map=C:\ms4w\apps\Demo\OracleTest.map"
> ,
>
> and I get the map image successfully. In the OracleTest.map mapfile, two
> oracle layers are defined, one with native oracle suppport, one with OGR
> OCI
> interface.
>
> tests with the command mapserv -v and ogrinfo --formats indicate that
> oracle
> spatial and OCI are supported. with the "ogrinfo OCI:XX/[EMAIL PROTECTED]" command
> is
> also no problem to access the the oracle database, I can even use ogr2ogr
> command to convert the oracle spatial layer to ESRI Shapefile.
>
> but the problem is, if I am trying to access the oracle spatial database
> in
> web browse, an Internal Server Error is returned instead of the map image.
> i
> really can not figure out what the problem is.
>
> thanks for any ideas to solve this problem.
>
> zhonghai
>
