[mapserver-users] lighttpd, TNS:could not resolve...
Dan Little
danlittle at yahoo.com
Thu Sep 30 04:22:16 PDT 2010
Does shp2img work with your Mapfile?
>
>From: Sebastian E. Ovide <sebastian.ovide at gmail.com>
>To: Rahkonen Jukka <Jukka.Rahkonen at mmmtike.fi>
>Cc: mapserver-users at lists.osgeo.org
>Sent: Thu, September 30, 2010 4:47:30 AM
>Subject: Re: [mapserver-users] lighttpd, TNS:could not resolve...
>
>the message says:
>
>
>ORA-12154: TNS:could not resolve the connect identifier specified in <unnamed>
>
>
>so... does <unnamed> mean that gdal didn't get any name for the connection ?
>
>
>
>
>
>On Thu, Sep 30, 2010 at 9:54 AM, Sebastian E. Ovide <sebastian.ovide at gmail.com>
>wrote:
>
>no luck...
>>
>>
>>renamed servicename to capital.. so now connection name==service name...
>>
>>
>>same problem... ogrinfo works, mapserver doesn't....
>>
>>
>>
>>On Thu, Sep 30, 2010 at 9:37 AM, Rahkonen Jukka <Jukka.Rahkonen at mmmtike.fi>
>>wrote:
>>
>>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
>>>>
>>>>
>>>>
>>>>
>>>>
>>
>>
>>--
>>Sebastian E. Ovide
>>
>>
>>
>>
>>
>
>
>--
>Sebastian E. Ovide
>
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20100930/564d9715/attachment.htm>
More information about the MapServer-users
mailing list