I was starting to suspect MapServer is just no seeing the environment variables...
Try this... write a wrapper script "mapserv.sh" #!/bin/bash TNS_ADMIN=/home/gis/conf /home/gis/bin/mapserv Then update your script to point to "mapserv.sh". > >From: Sebastian E. Ovide <sebastian.ov...@gmail.com> >To: Dan Little <danlit...@yahoo.com> >Cc: Rahkonen Jukka <jukka.rahko...@mmmtike.fi>; mapserver-users@lists.osgeo.org >Sent: Thu, September 30, 2010 8:01:22 AM >Subject: Re: [mapserver-users] lighttpd, TNS:could not resolve... > >on the same machine, with the same data and same tns file it works fine with >APACHE.... the problems is only with LIGHTTPD... it looks like "TNS_ADMIN" => >"/home/gis/conf/" is ignored (in apache I've used SetEnv and PassEnv > > >??? > > >On Thu, Sep 30, 2010 at 12:22 PM, Dan Little <danlit...@yahoo.com> wrote: > >Does shp2img work with your Mapfile? >> >>> >>>From: Sebastian E. Ovide <sebastian.ov...@gmail.com> >>>To: Rahkonen Jukka <jukka.rahko...@mmmtike.fi> >>>Cc: mapserver-users@lists.osgeo.org >>>Sent: Thu, September 30, 2010 4:47:30 AM >>>Subject: Re: [mapserver-users] lighttpd, TNS:could not resolve... >>> >>> >>>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 >>> >>> >>> >>> >> > > >-- >Sebastian E. Ovide > > > > >
_______________________________________________ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users