Mapserver 5 with Oracle10g or ArcSDE 9.2

[José Ramón López]

Hi list again.

Im trying to configure a new server with mapserver 5.0 connect it with
Oracle 10g or ArcSDE 9.2 , ussing the ms4w package (MS4W PHP5 Base Installer
v2.2.6 )
I have done all that i have read in the instructions.
The problems is that mapserver sends to me a blank image, and with some
clients it send me a error.
I have installed in that machine Oracle 10g client.

This is the configuration of the layer.

LAYER
    NAME AFOROS
    GROUP "Redes.Ctrl"
    TYPE POINT
    CONNECTIONTYPE oraclespatial
    CONNECTION 'user/pass at SDE'
    DATA 'SHAPE FROM AFOROS USING UNIQUE OBJECTID'
        DUMP TRUE
        DEBUG ON
        PROCESSING "CLOSE_CONNECTION=DEFER"
        TRANSPARENCY 0
        PROJECTION
            "init=EPSG:23030"
        END
        CLASS
            STYLE
                SYMBOL "circle"
                SIZE 10
                COLOR 255 85 0
            END
            NAME 'Aforos'
        END
        METADATA
            "wms_title"         "Aforos"
            "wms_group_title"    "Redes de Control"
            "wms_keywordlist"     "WMS Aforos"
            "wms_srs"             "EPSG:23030"
            "wms_extent"         "154590 4062740 579080 4300000"
        END
END


In httpd.conf i have declared the system varibles:

#Oracle Spatial
SetEnv PATH "C:/oracle10gclient/bin"
SetEnv TNS_ADMIN "C:/oracle10gclient/network/admin"
SetEnv ORACLE_SID "SDE91 SDE92 GLOBAL"
SetEnv ORACLE_BASE "C:/oracle10gclient"
SetEnv LD_LIBRARY_PATH "C:/oracle10gclient/lib"

And the file C:/oracle10gclient/network/admin/tns_admin.ora

SDE =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 172.19.132.93)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = SDE)
    )
  )

In the access.log  nothing appears about the getmap and layer request , only
the getcapabilites, the same happens in the ms_error.txt

In access.log

[11/Oct/2007:11:58:58 +0200] "GET
/cgi-bin/wms?REQUEST=GetCapabilities&SERVICE=WMS&&EXCEPTIONS=XML HTTP/1.1"
200 5789
127.0.0.1 - - [11/Oct/2007:11:58:59 +0200] "GET
/cgi-bin/wms?REQUEST=GetCapabilities&SERVICE=WMS&VERSION=
1.1.1&EXCEPTIONS=XML HTTP/1.1" 200 5789

and in the ms_error file:

[Thu Oct 11 12:04:26 2007].828000 loadParams() QUERY_STRING:
REQUEST=GetCapabilities&SERVICE=WMS&&EXCEPTIONS=XML
[Thu Oct 11 12:04:26 2007].875000 msLoadMap(): 0.047s
[Thu Oct 11 12:04:26 2007].875000 CGI Request 1 on process 2288
[Thu Oct 11 12:04:27 2007].62000 loadParams() QUERY_STRING:
REQUEST=GetCapabilities&SERVICE=WMS&VERSION=1.1.1&EXCEPTIONS=XML
[Thu Oct 11 12:04:27 2007].93000 msLoadMap(): 0.031s
[Thu Oct 11 12:04:27 2007].93000 CGI Request 1 on process 532

I tried to make the request through explorer like

http://localhost/cgi-bin/wms?SERVICE=WMS&VERSION=1.1.1&REQUEST=GETMAP&LAYERS=AFOROS&SRS=EPSG:23030&BBOX=154590.0,4062740.0,579080.0,4300000.0&WIDTH=861&HEIGHT=482&FORMAT=image/png&STYLES=default&TRANSPARENT=TRUE

but sends to me a blank image.

Thats anybody knows what is happening?

Thxs and sorry for my english
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapserver-users/attachments/20071011/df8cf925/attachment.html