Problems with Mapserver 5
Rahkonen Jukka
Jukka.Rahkonen at MMMTIKE.FI
Wed Oct 17 08:26:53 PDT 2007
Hi,
I have never used SDE with Mapserver, but I suspect that you may be mixing Oracle spatial and ArcSDE in some way. You have Oracle database as I have understood, but are you data stored there through Oracle spatial or ArcSDE? If you are using SDE try to follow the advice from here:
http://mapserver.gis.umn.edu/docs/reference/vector_data/arcsde
If your data is in native Oracle spatial format, try to follow this:
http://mapserver.gis.umn.edu/docs/howto/oracle_spatial_howto
Perhaps you get empty map simply because your connectiontype/connection/data combination just do not find any data from the database.
-Jukka Rahkonen-
-----Original Message-----
From: UMN MapServer Users List on behalf of José Ramón López
Sent: Wed 17.10.2007 18:04
To: MAPSERVER-USERS at LISTS.UMN.EDU
Subject: [UMN_MAPSERVER-USERS] Problems with Mapserver 5
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
More information about the MapServer-users
mailing list