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 <[email protected]>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ä:* [email protected] [mailto: > [email protected]] *Puolesta *Sebastian E. Ovide > *Lähetetty:* 30. syyskuuta 2010 11:15 > *Vastaanottaja:* Dan Little > *Kopio:* [email protected] > *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 <[email protected]> wrote: > >> Is tnsnames.ora accessible by the web-server user? (Check the >> permissions.) >> >> Is t >> *From:* Sebastian E. Ovide <[email protected]> >> *To:* [email protected] >> *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
_______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
