[mapserver-users] lighttpd, TNS:could not resolve...

[Rahkonen Jukka]

Hi,
 
For me, sometimes with some Oracle user name from some computers SQL*Plus does not understand if I am using the SERVICE_NAME.  It you happen to have the same situation you should be able to connect with the connection name, which seems to be MFUATDB for you. 
 
Actually, the error message "TNS:could not resolve the connect identifier specified" may mean that you should not use service name but the connect identifier.  Have a try and tell how it went.
 
 
-Jukka Rahkonen- 



________________________________

	Lähettäjä: mapserver-users-bounces at lists.osgeo.org [mailto:mapserver-users-bounces at lists.osgeo.org] Puolesta Sebastian E. Ovide
	Lähetetty: 30. syyskuuta 2010 11:15
	Vastaanottaja: Dan Little
	Kopio: mapserver-users at lists.osgeo.org
	Aihe: Re: [mapserver-users] lighttpd, TNS:could not resolve...
	
	
	yes. 


	gis at mapserver:~$ ls -la /home/gis/conf/tnsnames.ora
	-rw-r--r-- 1 gis gis 184 2010-09-29 16:19 /home/gis/conf/tnsnames.ora
	gis at mapserver:~$ sudo su www-data -c 'cat /home/gis/conf/tnsnames.ora'
	MFUATDB =
	  (DESCRIPTION =
	    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.60.70)(PORT = 1521))
	    (CONNECT_DATA =
	      (SERVER = DEDICATED)
	      (SERVICE_NAME = mfuatdb)
	    )
	  )


	On Wed, Sep 29, 2010 at 7:58 PM, Dan Little <danlittle at yahoo.com> wrote:
	

		Is tnsnames.ora accessible by the web-server user? (Check the permissions.)


			Is t
			
			From: Sebastian E. Ovide <sebastian.ovide at gmail.com>
			To: mapserver-users at lists.osgeo.org
			Sent: Wed, September 29, 2010 11:10:09 AM
			Subject: [mapserver-users] lighttpd, TNS:could not resolve...
			

			Hi All, 

			I have installed MapServer on lighttpd + fastcgi.

			fastcgi.server = (
			        "/mapserver" =>
			        ( "localhost" =>
			                (
			                        "socket" => "/tmp/mapserver-fastcgi.socket",
			                        "bin-path" => "/home/gis/bin/mapserv",
			                        "bin-environment" =>
			                        (
			                                "TNS_ADMIN" => "/home/gis/conf/"
			                        ),
			                        "max-procs" => 2,
			                        "check-local" => "disable"
			                )
			        )
			)


			gis at mapserver:~$ cat /home/gis/conf/tnsnames.ora
			MFUATDB =
			  (DESCRIPTION =
			    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.60.70)(PORT = 1521))
			    (CONNECT_DATA =
			      (SERVER = DEDICATED)
			      (SERVICE_NAME = mfuatdb)
			    )
			  )

			and I'm getting: 

			msDrawMap(): Image handling error. Failed to draw layer named 'TESTII'. msOGRFileOpen(): OGR error. Open failed for OGR connection in layer `TESTII'. ORA-12154: TNS:could not resolve the connect identifier specified in <unnamed>

			from the logs:

			[Wed Sep 29 17:00:13 2010].649965 CGI Request 1 on process 1513
			[Wed Sep 29 17:00:13 2010].717290 msOGRFileOpen(): OGR error. Open failed for OGR connection in layer `TESTII'.
			ORA-12154: TNS:could not resolve the connect identifier specified
			 in <unnamed>

			[Wed Sep 29 17:00:13 2010].717319 msDrawMap(): Image handling error. Failed to draw layer named 'TESTII'.
			[Wed Sep 29 17:00:13 2010].717454 msFreeMap(): freeing map at 0xa00f298.
			[Wed Sep 29 17:00:13 2010].717579 freeLayer(): freeing layer at 0xa0237a0.
			[Wed Sep 29 17:00:13 2010].717591 freeLayer(): freeing layer at 0xa024718.


			in mapserver:

			  LAYER
			    NAME TESTII
			    TYPE POLYGON
			    STATUS ON
			    CONNECTION "OCI:GEO_US_DATA/GEO_US_DATA at mfuatdb"
			    CONNECTIONTYPE OGR
			    DATA "CA_WILDFIRE"
			    PROJECTION
			      "init=epsg:3857"
			    END
			    CLASS
			#      NAME "local_shape"
			      COLOR 0 0 255
			      OUTLINECOLOR 0 0 255
			    END
			  END



			The connection string is right as I'm using it from gdal:

			gis at mapserver:~$ ogrinfo OCI:GEO_US_DATA/GEO_US_DATA at mfuatdb:CA_WILDFIRE
			INFO: Open of `OCI:GEO_US_DATA/GEO_US_DATA at mfuatdb:CA_WILDFIRE'
			      using driver `OCI' successful.
			1: CA_WILDFIRE


			any ideas ?


			-- 
			Sebastian E. Ovide
			
			
			
			
			





	-- 
	Sebastian E. Ovide
	
	
	
	
	

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20100930/2099df7c/attachment.htm>