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

[Sebastian E. Ovide]

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/d9424de0/attachment.htm>