IIS and Oracle Permission

[Francesco Sozzi]

Ok Fernando, thank you...
As you suggested, problem 4 has been related to permission on Oracle bin
folder.

In summary: if mapserver cant't connect to Oracle and gives errors on wrong
connect string (on correct connect strings!), may be you can fixing by
setting right permissions:
1) go to Explore, Tools->Folder options
2) uncheck "use simple file sharing" on Wiew tab
3) go to Oracle bin folder and open "Sharing and Security", Security tab
4) add Read&Execute, List folder and Read on "Everyone" and on Internet
Guest Account (should be IUSR_..., you can check from IIS into Properties of
web site, opening Directory Security and pressing Edit button)

Best regards

Francesco

----- Original Message -----
From: "Fernando S." <fsimon at univali.br>
To: "Francesco Sozzi" <fsozzi at intercad.ch>
Sent: Monday, January 31, 2005 3:13 PM
Subject: Re: some possible bugs on Mapserver/Oracle Spatial


> Hi Francesco,
>     Thanks for your help.
>     About the problem 1 I'll check this after I finish the new version.
> The problem with the lenght I didn't see this problem here, I tested
> with the same name and worked corectly, but for the next version I
> changed the core of the code where I create the items buffer. The
> problem with the size of layer data I didn't know, in the code (since
> 3.6 of Mapserver) the data string is defined with 6000 of size.
>    The problem 3 I already know, the problem is that the OCI return
> error with null values inside the columns, I fixed this problem with 4.4
> version but I'll check the how Oracle return this null values.
>     The problem 4 can be with the IIS permissions to access the oracle
> dll's. Another problem can be with the global variables, you can check
> the oracle global variables for the system.
>     In problem 1:
>
> - If I remove "ic_areeverdi" layer leaving "ic_manufatti" alone, the
script
> works...
>
>     It's can be a problem with maplexer and not with oracle, I don't
> check in the code the number of layers. Or thsi problem can be with
> connection pool support inside the code. I'll check the oracle part.
>     Thanks.
>
> Fernando Simon
>
>
> Francesco Sozzi wrote:
>
> >Hi Fernando,
> >
> >I'am stressing mapserver with a lot of Oracle Spatial data and I
discovered
> >some potential bugs.
> >They are not simple to isolate because the same action many times seems
to
> >work, but sometime make mapserver crashes.
> >
> >---------------------
> >---------------------
> >PROBLEM 1: crash on opening layer after selection
> >---------------------
> >---------------------
> >
> >I prepared a sample that I hope allow you to replicate this problem.
> >
> >In test.php I open a map file where I have a first layer OFF and a second
> >Oracle Spatial layer ON.
> >I try to make a spatial selection and then I try to open layer; when I
open
> >layer, mapserver crashes (as you can see in the image); please note that
I'm
> >testing on one PC with both mapserver and Internet Explorer.
> >
> >The presence of a layer "ic_areeverdi" with status OFF seems to be
relevant
> >to generate the error. This layer can read from anywhere, it is not
> >important; you can also set DATA "".
> >
> >Some notes:
> >- If I remove "ic_areeverdi" layer leaving "ic_manufatti" alone, the
script
> >works...
> >- if I make a spatail selection on other regions, many time it works
> >properly, but in this region not (and also on many other).
> >- I have to rename fields, because there are many words token that make
> >mapserver crashes (for instance ANNO). This makes difficult to choose
> >meaningful aliases for fields (about this problem we already talked in
the
> >previous mails)
> >- if I remove some fields from selection, it works
> >
> >
> >---------------------
> >---------------------
> >PROBLEM 3: wrong result on null numeric fields
> >---------------------
> >---------------------
> >
> >A second problem is on NULLs on numeric fields (this problem is not
> >generated on string fields).
> >
> >In test2.php I write a result (string lenght and value) on a query where
I
> >expect to see for each
> >
> >LEN: =
> >VALUE:
> >
> >But what I see is something like:
> >
> >LEN: 4
> >VALUE: ÿÿÿÿ
> >LEN: 0
> >VALUE:
> >LEN: 0
> >VALUE:
> >LEN: 4
> >VALUE: ÿÿÿÿ
> >LEN: 0
> >VALUE:
> >LEN: 2
> >VALUE: w
> >LEN: 4
> >VALUE: ÿÿÿÿ
> >LEN: 0
> >VALUE:
> >LEN: 2
> >VALUE: û
> >LEN: 4
> >VALUE: ÿÿÿÿ
> >LEN: 0
> >VALUE:
> >LEN: 0
> >...
> >
> >
> >Before testing, you should add a field TESTNUM:
> >
> >ALTER TABLE "TI_MANUFATTI"."IC_KUBA_MANUFATTI"
> >    ADD ("TESTNUM" NUMBER(10) NOT NULL)
> >
> >
> >---------------------
> >---------------------
> >PROBLEM 4 : in some cases mapserver seems not able to connect to Oracle
> >---------------------
> >---------------------
> >
> >I tried to install with success mapserver on 4 PC with Oracle Spatial
option
> >and for all I used IIS on XP Professional.
> >
> >I then tried to install on another PC, but on this I can't connect to
> >Oracle.
> >Everithing seems to work properly (I can open shp layers, make pan, zoom
> >etc...), but If I try to issue Draw() on an Oracle layer I get:
> >
> >Warning: [MapServer Error]: msDrawMap(): Failed to draw layer named
'Fondi
> >(oracle)'. in C:\App\QueryMapWEB\runtime\qm\scripts\ic_php_map.inc on
line
> >438
> >
> >Warning: [MapServer Error]: msOracleSpatialLayerOpen(): Cannot create OCI
> >Handlers. Connection failure. Check the connection string. Error: . in
> >C:\App\QueryMapWEB\runtime\qm\scripts\ic_php_map.inc on line 438
> >
> >I am sure on connection string, because I can use on SQL*Worksheet and in
> >some other application.
> >
> >Can you suggest me something more to check?
> >
> >
> >Best regards
> >
> >Francesco
> >
> >
>
>
>