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