Re: [mapserver-users] lighttpd, TNS:could not resolve...
Sebastian, Instead of using TNS, you could try the EZConnect syntax of @host:port/service_name. That way you bypass even needing a TNS. Also if your port is 1521, you can just not include it and use CONNECTION ³user/p...@hostname/service_name² Mike -- Michael Smith US Army Corps of Engineers Remote Sensing/GIS Center Hanover, NH On 10/5/10 7:26 AM, Sebastian E. Ovide sebastian.ov...@gmail.com wrote: I've also add a script that prints the variables and TNS_ADMIN is there... USERNAME=root LANG=en_US.UTF-8 SUDO_GID=1001 SHELL=/bin/bash SUDO_COMMAND=/etc/init.d/lighttpd restart ORACLE_HOME=/home/gis/libs/instantclient_11_2/ SUDO_UID=1001 TERM=xterm PHP_FCGI_CHILDREN=1 PATH=/sbin:/bin:/usr/sbin:/usr/bin PWD=/home/gis/conf LOGNAME=root USER=root HOME=/home/gis MAIL=/var/mail/gis SUDO_USER=gis LS_COLORS=rs=0:di=01;34:ln=01;36:mh=00:pi=40;33:so=01;35:do=01;35:bd=40;33;01: cd=40;33;01:or=40;31;01:su=37;41:sg=30;43:ca=30;41:tw=30;42:ow=34;42:st=37;44: ex=01;32:*.tar=01;31:*.tgz=01;31:*.arj=01;31:*.taz=01;31:*.lzh=01;31:*.lzma=01 ;31:*.tlz=01;31:*.txz=01;31:*.zip=01;31:*.z=01;31:*.Z=01;31:*.dz=01;31:*.gz=01 ;31:*.lz=01;31:*.xz=01;31:*.bz2=01;31:*.bz=01;31:*.tbz=01;31:*.tbz2=01;31:*.tz =01;31:*.deb=01;31:*.rpm=01;31:*.jar=01;31:*.rar=01;31:*.ace=01;31:*.zoo=01;31 :*.cpio=01;31:*.7z=01;31:*.rz=01;31:*.jpg=01;35:*.jpeg=01;35:*.gif=01;35:*.bmp =01;35:*.pbm=01;35:*.pgm=01;35:*.ppm=01;35:*.tga=01;35:*.xbm=01;35:*.xpm=01;35 :*.tif=01;35:*.tiff=01;35:*.png=01;35:*.svg=01;35:*.svgz=01;35:*.mng=01;35:*.p cx=01;35:*.mov=01;35:*.mpg=01;35:*.mpeg=01;35:*.m2v=01;35:*.mkv=01;35:*.ogm=01 ;35:*.mp4=01;35:*.m4v=01;35:*.mp4v=01;35:*.vob=01;35:*.qt=01;35:*.nuv=01;35:*. wmv=01;35:*.asf=01;35:*.rm=01;35:*.rmvb=01;35:*.flc=01;35:*.avi=01;35:*.fli=01 ;35:*.flv=01;35:*.gl=01;35:*.dl=01;35:*.xcf=01;35:*.xwd=01;35:*.yuv=01;35:*.cg m=01;35:*.emf=01;35:*.axv=01;35:*.anx=01;35:*.ogv=01;35:*.ogx=01;35:*.aac=00;3 6:*.au=00;36:*.flac=00;36:*.mid=00;36:*.midi=00;36:*.mka=00;36:*.mp3=00;36:*.m pc=00;36:*.ogg=00;36:*.ra=00;36:*.wav=00;36:*.axa=00;36:*.oga=00;36:*.spx=00;3 6:*.xspf=00;36: LD_LIBRARY_PATH=/home/gis/libs/instantclient_11_2/ TNS_ADMIN=/home/gis/conf/ any other ideas ? On Thu, Sep 30, 2010 at 3:09 PM, Sebastian E. Ovide sebastian.ov...@gmail.com wrote: done. (restarted server etc...) exactly the same problem... On Thu, Sep 30, 2010 at 2:51 PM, Dan Little danlit...@yahoo.com wrote: 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
Re: [mapserver-users] lighttpd, TNS:could not resolve...
Bingo ! yes, that worked... resuming: replaced TNS connection string CONNECTION OCI:GEO_US_DATA/geo_us_d...@mfuatdb:CA_WILDFIRE with EZConnect syntax CONNECTION OCI:GEO_US_DATA/geo_us_d...@192.168.60.70/MFUATDB:CA_WILDFIRE where the tnsnames.ora is MFUATDB = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.60.70)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = MFUATDB) ) ) Thanks On Tue, Oct 5, 2010 at 12:48 PM, Michael Smith michael.sm...@usace.army.mil wrote: Sebastian, Instead of using TNS, you could try the EZConnect syntax of @host:port/service_name. That way you bypass even needing a TNS. Also if your port is 1521, you can just not include it and use CONNECTION “user/p...@hostname/service_name” Mike ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
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 ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] lighttpd, TNS:could not resolve...
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
Re: [mapserver-users] lighttpd, TNS:could not resolve...
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.fiwrote: 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 ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] lighttpd, TNS:could not resolve...
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.) Ist From: Sebastian E. Ovide sebastian.ov...@gmail.com To: mapserver-users@lists.osgeo.org Sent: Wed, September 29, 201011: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 identifierspecified 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 CONNECTIONOCI: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 ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http
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
Re: [mapserver-users] lighttpd, TNS:could not resolve...
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.) Ist From: Sebastian E. Ovide sebastian.ov...@gmail.com To: mapserver-users@lists.osgeo.org Sent: Wed, September 29, 201011: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 identifierspecified 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
Re: [mapserver-users] lighttpd, TNS:could not resolve...
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 sebastian.ov...@gmail.com 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 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.comwrote: 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
Re: [mapserver-users] lighttpd, TNS:could not resolve...
done. (restarted server etc...) exactly the same problem... On Thu, Sep 30, 2010 at 2:51 PM, Dan Little danlit...@yahoo.com wrote: 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.comwrote: 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
[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
Re: [mapserver-users] lighttpd, TNS:could not resolve...
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
