Mapserver 5 with Oracle10g or ArcSDE 9.2

Thu Oct 11 07:42:17 PDT 2007

You might try to set your debug level higher. I'm not seeing any output from the debug you ran regarding Oracle connections. When run with debugging I set it pretty high to get more output.

----
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: José Ramón López [mailto:joseramonlopez at gmail.com] 
Sent: Thursday, October 11, 2007 10:33 AM
To: Nolte, Tim
Cc: MAPSERVER-USERS at lists.umn.edu
Subject: Re: [UMN_MAPSERVER-USERS] Mapserver 5 with Oracle10g or ArcSDE 9.2

Hi Tim

I used it before too, but its send to me a blank image.

This is the output command:

C:\ms4w\tools\mapserv>shp2img.exe -m ..\..\maps\map\wms.map -i png -o prueba.png -all_debug 4
msDrawMap(): Drawing Label Cache, 0.000s
msDrawMap() total time: 0.000s
msFreeMap(): freeing map at 0145B630.

No errors?

Thxs

2007/10/11, Nolte, Tim <Tim.Nolte at ipcswirelessinc.com >:

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