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 > > > > >
_______________________________________________ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users