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.ov...@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.rahko...@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-boun...@lists.osgeo.org [mailto: >> mapserver-users-boun...@lists.osgeo.org] *Puolesta *Sebastian E. Ovide >> *Lähetetty:* 30. syyskuuta 2010 11:15 >> *Vastaanottaja:* Dan Little >> *Kopio:* mapserver-users@lists.osgeo.org >> *Aihe:* Re: [mapserver-users] lighttpd, TNS:could not resolve... >> >> yes. >> >> >> g...@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 >> g...@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 <danlit...@yahoo.com> wrote: >> >>> Is tnsnames.ora accessible by the web-server user? (Check the >>> permissions.) >>> >>> Is t >>> *From:* Sebastian E. Ovide <sebastian.ov...@gmail.com> >>> *To:* mapserver-users@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" >>> ) >>> ) >>> ) >>> >>> >>> g...@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_d...@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: >>> >>> g...@mapserver:~$ ogrinfo OCI:GEO_US_DATA/geo_us_d...@mfuatdb >>> :CA_WILDFIRE >>> INFO: Open of `OCI:GEO_US_DATA/geo_us_d...@mfuatdb:CA_WILDFIRE' >>> using driver `OCI' successful. >>> 1: CA_WILDFIRE >>> >>> >>> any ideas ? >>> >>> >>> -- >>> Sebastian E. Ovide >>> >>> >>> >>> >>> >>> >> >> >> -- >> Sebastian E. Ovide >> >> >> >> >> > > > -- > Sebastian E. Ovide > > > > > -- Sebastian E. Ovide
_______________________________________________ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users