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

[Sebastian E. Ovide]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapserver-users/attachments/20100930/6249ea54/attachment-0001.html