Mapserver 5 with Oracle10g or ArcSDE 9.2

[Nolte, Tim]

Jose,

When I was working trying to get Oracle 10g working with MapServer I turned to using SHP2IMG for testing against my mapfile. So on the server/machine you have MapServer installed on, call shp2img...specifying your mapfile and make sure to tell it to return debugging information. This has helped to clue me in on issue with my mapfile/mapserver.

----
Timothy J Nolte - tnolte at ilpcs.com
Associate Network Planning Engineer

iPCS Wireless, Inc.
4717 Broadmoor Ave, Suite G
Kentwood, MI 49512

Office: 616-656-5163
PCS:    616-706-2438
Fax:    616-554-6484
Web: www.ipcswirelessinc.com


-----Original Message-----
From: UMN MapServer Users List [mailto:MAPSERVER-USERS at LISTS.UMN.EDU] On Behalf Of José Ramón López
Sent: Thursday, October 11, 2007 6:12 AM
To: MAPSERVER-USERS at LISTS.UMN.EDU
Subject: [UMN_MAPSERVER-USERS] Mapserver 5 with Oracle10g or ArcSDE 9.2

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 <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