Problems with Mapserver 5

[José Ramón López]

Hi list.

Im trying to configure mapserver with Oracle Spatial or OCI connection
This is my layer:

LAYER
    NAME CARRETERAS
    TYPE LINE
    STATUS ON
    CONNECTIONTYPE OGR
        CONNECTION "OCI:sde/password at SDE"
        DATA "SDE.RED_CARRETERAS"
        DUMP TRUE
        DEBUG ON
        PROCESSING "CLOSE_CONNECTION=DEFER"
        TRANSPARENCY 0
        PROJECTION
            "init=epsg:23030"
        END
        CLASS
            STYLE
                COLOR 0 0 0
            END
            NAME 'Carreteras'
        END
        METADATA
            "wms_title"           "Red Carreteras"
            "wms_keywordlist"     "WMS Carreteras"
            "wms_srs"             "epsg:23030"
            "wms_extent"         "164590 4062740 579080 4266350"
        END
END


Mapserver allways send to me a blank image.
I'd use shp2img , and allways send me a blank image, with this command:

C:\ms4w-v5\tools\mapserv>shp2img.exe -m c:\ms4w-v5\maps\map\wms.map -i png
-o C:\test.png -all_debug 9 -l CARRETERAS
msDrawMap(): Layer 1 (CARRETERAS), 0.000s
msDrawMap(): Drawing Label Cache, 0.000s
msDrawMap() total time: 0.000s
msFreeMap(): freeing map at 0144B390.

and made some test for testing oracle connection with og2info, and works
correctly, like:

C:\ms4w-v5\tools\mapserv>ogrinfo.exe OCI:sde/password at SDE:sde.RED_CARRETERAS-SO
INFO: Open of `OCI:sde/sde at SDE:sde.RED_CARRETERAS'
      using driver `OCI' successful.
1: sde.RED_CARRETERAS

if i use the command with -al option, it sends to me all information
allocated in this layer.

Is the problem related with system enviroment?

In httd.conf:

SetEnv PATH "C:/Oracle/oracle10g/BIN"
SetEnv TNS_ADMIN "C:/Oracle/oracle10g/NETWORK/ADMIN"
SetEnv ORACLE_SID SDE
SetEnv ORACLE_BASE "C:/Oracle/oracle10g"
SetEnv ORACLE_HOME "C:/Oracle/oracle10g"
SetEnv LD_LIBRARY_PATH "C:\Oracle\oracle10g\LIB"

and de tnsadmin.ora file

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

Windows 2003 System Enviroment:

Path=\ms4w\Apache\cgi-bin;\ms4w\tools\gdal-ogr;\ms4w\tools\mapserv;\ms4w\tools\shapelib;\ms4w\proj\bin;\ms4w\tools\shp2tile;\ms4w\tools\shpdiff;\ms4w\tools\avce00;C:\oracle\Oracle10g\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem
PROJ_LIB=\ms4w-v5\proj\nad
ORACLE_HOME=C:\oracle\Oracle10g

In ms_erro.txt file nothing is registered.

Thxs
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20071017/0565f98a/attachment.htm>