updates. even if it works with APACHE + CGI, it does NOT work with APACHE+FASTCGI (AppClass /home/gis/bin/mapserv -initial-env TNS_ADMIN=/home/gis/conf/)
On Thu, Sep 30, 2010 at 2:01 PM, Sebastian E. Ovide < [email protected]> wrote: > 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 <[email protected]> wrote: > >> Does shp2img work with your Mapfile? >> >> >> *From:* Sebastian E. Ovide <[email protected]> >> *To:* Rahkonen Jukka <[email protected]> >> *Cc:* [email protected] >> *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 < >> [email protected]> 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 < >>> [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 >>> >>> >>> >>> >>> >> >> >> -- >> Sebastian E. Ovide >> >> >> >> >> > > > -- > Sebastian E. Ovide > > > > > -- Sebastian E. Ovide
_______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
