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