<HTML>
<HEAD>
<TITLE>Re: [mapserver-users] lighttpd, TNS:could not resolve...</TITLE>
</HEAD>
<BODY>
<FONT FACE="Calibri, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:11pt'>Sebastian,<BR>
<BR>
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<BR>
<BR>
CONNECTION “user/pass@hostname/service_name”<BR>
<BR>
Mike<BR>
<BR>
<BR>
-- <BR>
Michael Smith<BR>
US Army Corps of Engineers<BR>
Remote Sensing/GIS Center<BR>
Hanover, NH <BR>
<BR>
<BR>
<BR>
<BR>
On 10/5/10 7:26 AM, "Sebastian E. Ovide" <<a href="sebastian.ovide@gmail.com">sebastian.ovide@gmail.com</a>> wrote:<BR>
<BR>
</SPAN></FONT><BLOCKQUOTE><FONT FACE="Calibri, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:11pt'>I've also add a script that prints the variables and TNS_ADMIN is there...<BR>
<BR>
USERNAME=root<BR>
LANG=en_US.UTF-8<BR>
SUDO_GID=1001<BR>
SHELL=/bin/bash<BR>
SUDO_COMMAND=/etc/init.d/lighttpd restart<BR>
ORACLE_HOME=/home/gis/libs/instantclient_11_2/<BR>
SUDO_UID=1001<BR>
TERM=xterm<BR>
PHP_FCGI_CHILDREN=1<BR>
PATH=/sbin:/bin:/usr/sbin:/usr/bin<BR>
PWD=/home/gis/conf<BR>
LOGNAME=root<BR>
USER=root<BR>
HOME=/home/gis<BR>
MAIL=/var/mail/gis<BR>
SUDO_USER=gis<BR>
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:*.pcx=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:*.cgm=01;35:*.emf=01;35:*.axv=01;35:*.anx=01;35:*.ogv=01;35:*.ogx=01;35:*.aac=00;36:*.au=00;36:*.flac=00;36:*.mid=00;36:*.midi=00;36:*.mka=00;36:*.mp3=00;36:*.mpc=00;36:*.ogg=00;36:*.ra=00;36:*.wav=00;36:*.axa=00;36:*.oga=00;36:*.spx=00;36:*.xspf=00;36:<BR>
LD_LIBRARY_PATH=/home/gis/libs/instantclient_11_2/<BR>
TNS_ADMIN=/home/gis/conf/<BR>
<BR>
any other ideas ?<BR>
<BR>
On Thu, Sep 30, 2010 at 3:09 PM, Sebastian E. Ovide <<a href="sebastian.ovide@gmail.com">sebastian.ovide@gmail.com</a>> wrote:<BR>
</SPAN></FONT><BLOCKQUOTE><FONT FACE="Calibri, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:11pt'>done. (restarted server etc...)<BR>
<BR>
exactly the same problem...<BR>
<BR>
<BR>
<BR>
<BR>
<BR>
On Thu, Sep 30, 2010 at 2:51 PM, Dan Little <<a href="danlittle@yahoo.com">danlittle@yahoo.com</a>> wrote:<BR>
</SPAN></FONT><BLOCKQUOTE><FONT SIZE="2"><FONT FACE="Arial"><SPAN STYLE='font-size:10pt'>I was starting to suspect MapServer is just no seeing the environment variables...<BR>
<BR>
Try this... write a wrapper script "mapserv.sh"<BR>
<BR>
#!/bin/bash<BR>
<BR>
TNS_ADMIN=/home/gis/conf<BR>
<BR>
/home/gis/bin/mapserv<BR>
<BR>
Then update your script to point to "mapserv.sh".<BR>
<BR>
<BR>
<BR>
</SPAN></FONT></FONT><BLOCKQUOTE><FONT SIZE="2"><FONT FACE="Arial"><SPAN STYLE='font-size:10pt'><BR>
</SPAN></FONT></FONT><FONT FACE="Tahoma, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:11pt'><B>From:</B></SPAN><SPAN STYLE='font-size:12pt'> Sebastian E. Ovide <<a href="sebastian.ovide@gmail.com">sebastian.ovide@gmail.com</a>><BR>
<B>To:</B> Dan Little <<a href="danlittle@yahoo.com">danlittle@yahoo.com</a>><BR>
<B>Cc:</B> Rahkonen Jukka <<a href="Jukka.Rahkonen@mmmtike.fi">Jukka.Rahkonen@mmmtike.fi</a>>; <a href="mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a><BR>
<B>Sent:</B> Thu, September 30, 2010 8:01:22 AM<BR>
<BR>
<B>Subject:</B> Re: [mapserver-users] lighttpd, TNS:could not resolve...<BR>
</SPAN></FONT><SPAN STYLE='font-size:12pt'><FONT FACE="Times New Roman"><BR>
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 </FONT></SPAN><FONT SIZE="2"><FONT FACE="Arial"><SPAN STYLE='font-size:10pt'>"TNS_ADMIN" => "/home/gis/conf/" is ignored (in apache I've used SetEnv and PassEnv<BR>
</SPAN></FONT></FONT><FONT FACE="Arial"><SPAN STYLE='font-size:12pt'><BR>
???<BR>
</SPAN></FONT><SPAN STYLE='font-size:12pt'><FONT FACE="Times New Roman"><BR>
On Thu, Sep 30, 2010 at 12:22 PM, Dan Little <<a href="danlittle@yahoo.com">danlittle@yahoo.com</a>> wrote:<BR>
</FONT></SPAN><BLOCKQUOTE><FONT SIZE="2"><FONT FACE="Arial"><SPAN STYLE='font-size:10pt'>Does shp2img work with your Mapfile?<BR>
</SPAN></FONT></FONT><BLOCKQUOTE><FONT SIZE="2"><FONT FACE="Arial"><SPAN STYLE='font-size:10pt'><BR>
</SPAN></FONT></FONT><FONT FACE="Tahoma, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:11pt'><B>From:</B></SPAN><SPAN STYLE='font-size:12pt'> Sebastian E. Ovide <<a href="sebastian.ovide@gmail.com">sebastian.ovide@gmail.com</a>><BR>
<B>To:</B> Rahkonen Jukka <<a href="Jukka.Rahkonen@mmmtike.fi">Jukka.Rahkonen@mmmtike.fi</a>><BR>
<B>Cc:</B> <a href="mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a><BR>
<B>Sent:</B> Thu, September 30, 2010 4:47:30 AM<BR>
<B>Subject:</B> Re: [mapserver-users] lighttpd, TNS:could not resolve...<BR>
</SPAN></FONT><SPAN STYLE='font-size:12pt'><FONT FACE="Times New Roman"><BR>
the message says: <BR>
<BR>
ORA-12154: TNS:could not resolve the connect identifier specified in <unnamed><BR>
<BR>
so... does <unnamed> mean that gdal didn't get any name for the connection ?<BR>
<BR>
<BR>
<BR>
On Thu, Sep 30, 2010 at 9:54 AM, Sebastian E. Ovide <<a href="sebastian.ovide@gmail.com">sebastian.ovide@gmail.com</a>> wrote:<BR>
</FONT></SPAN><BLOCKQUOTE><SPAN STYLE='font-size:12pt'><FONT FACE="Times New Roman">no luck...<BR>
<BR>
renamed servicename to capital.. so now connection name==service name...<BR>
<BR>
same problem... ogrinfo works, mapserver doesn't....<BR>
<BR>
<BR>
On Thu, Sep 30, 2010 at 9:37 AM, Rahkonen Jukka <<a href="Jukka.Rahkonen@mmmtike.fi">Jukka.Rahkonen@mmmtike.fi</a>> wrote:<BR>
</FONT></SPAN></BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE><FONT COLOR="#0000FF"><FONT FACE="Arial"><SPAN STYLE='font-size:11pt'>Hi,<BR>
</SPAN></FONT></FONT><FONT FACE="Times New Roman"><SPAN STYLE='font-size:12pt'> <BR>
</SPAN></FONT><FONT COLOR="#0000FF"><FONT FACE="Arial"><SPAN STYLE='font-size:11pt'>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 </SPAN></FONT></FONT><FONT SIZE="4"><FONT FACE="Times New Roman"><SPAN STYLE='font-size:14pt'>MFUATDB for you. <BR>
</SPAN></FONT></FONT><FONT FACE="Times New Roman"><SPAN STYLE='font-size:12pt'> <BR>
</SPAN></FONT><FONT COLOR="#0000FF"><FONT FACE="Arial"><SPAN STYLE='font-size:11pt'>Actually, the error message </SPAN></FONT></FONT><FONT SIZE="4"><FONT FACE="Times New Roman"><SPAN STYLE='font-size:14pt'>"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.<BR>
</SPAN></FONT></FONT><FONT FACE="Times New Roman"><SPAN STYLE='font-size:12pt'> <BR>
<BR>
</SPAN><FONT SIZE="4"><SPAN STYLE='font-size:14pt'>-Jukka Rahkonen-</SPAN></FONT></FONT><FONT COLOR="#0000FF"><FONT FACE="Arial"><SPAN STYLE='font-size:12pt'> <BR>
</SPAN></FONT></FONT><SPAN STYLE='font-size:12pt'><FONT FACE="Times New Roman"><BR>
<BR>
<BR>
<BR>
<HR ALIGN=CENTER SIZE="3" WIDTH="100%"> </FONT></SPAN><FONT FACE="Tahoma, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:11pt'><B>Lähettäjä:</B></SPAN><SPAN STYLE='font-size:12pt'> <a href="mapserver-users-bounces@lists.osgeo.org">mapserver-users-bounces@lists.osgeo.org</a> [<a href="mailto:mapserver-users-bounces@lists.osgeo.org">mailto:mapserver-users-bounces@lists.osgeo.org</a>] <B>Puolesta </B>Sebastian E. Ovide<BR>
<B>Lähetetty:</B> 30. syyskuuta 2010 11:15<BR>
<B>Vastaanottaja:</B> Dan Little<BR>
<B>Kopio:</B> <a href="mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a><BR>
<B>Aihe:</B> Re: [mapserver-users] lighttpd, TNS:could not resolve...<BR>
</SPAN></FONT><SPAN STYLE='font-size:12pt'><FONT FACE="Times New Roman"><BR>
<BR>
yes. <BR>
<BR>
<BR>
<BR>
<BR>
<BR>
gis@mapserver:~$ ls -la /home/gis/conf/tnsnames.ora<BR>
<BR>
-rw-r--r-- 1 gis gis 184 2010-09-29 16:19 /home/gis/conf/tnsnames.ora<BR>
<BR>
gis@mapserver:~$ sudo su www-data -c 'cat /home/gis/conf/tnsnames.ora'<BR>
<BR>
MFUATDB =<BR>
<BR>
(DESCRIPTION =<BR>
<BR>
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.60.70)(PORT = 1521))<BR>
<BR>
(CONNECT_DATA =<BR>
<BR>
(SERVER = DEDICATED)<BR>
<BR>
(SERVICE_NAME = mfuatdb)<BR>
<BR>
)<BR>
<BR>
)<BR>
<BR>
<BR>
<BR>
<BR>
On Wed, Sep 29, 2010 at 7:58 PM, Dan Little <<a href="danlittle@yahoo.com">danlittle@yahoo.com</a>> wrote:<BR>
<BR>
<BR>
<BR>
</FONT></SPAN><FONT SIZE="2"><FONT FACE="Arial"><SPAN STYLE='font-size:10pt'> <BR>
Is tnsnames.ora accessible by the web-server user? (Check the permissions.)<BR>
<BR>
<BR>
<BR>
<BR>
Is t<BR>
<BR>
</SPAN></FONT></FONT><FONT FACE="Tahoma, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:11pt'><B>From:</B></SPAN><SPAN STYLE='font-size:12pt'> Sebastian E. Ovide <<a href="sebastian.ovide@gmail.com">sebastian.ovide@gmail.com</a>><BR>
<B>To:</B> <a href="mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a><BR>
<B>Sent:</B> Wed, September 29, 2010 11:10:09 AM<BR>
<B>Subject:</B> [mapserver-users] lighttpd, TNS:could not resolve...<BR>
</SPAN></FONT><SPAN STYLE='font-size:12pt'><FONT FACE="Times New Roman"> <BR>
<BR>
<BR>
<BR>
Hi All, <BR>
<BR>
<BR>
I have installed MapServer on lighttpd + fastcgi.<BR>
<BR>
<BR>
<BR>
<BR>
fastcgi.server = (<BR>
<BR>
"/mapserver" =><BR>
<BR>
( "localhost" =><BR>
<BR>
(<BR>
<BR>
"socket" => "/tmp/mapserver-fastcgi.socket",<BR>
<BR>
"bin-path" => "/home/gis/bin/mapserv",<BR>
<BR>
"bin-environment" =><BR>
<BR>
(<BR>
<BR>
"TNS_ADMIN" => "/home/gis/conf/"<BR>
<BR>
),<BR>
<BR>
"max-procs" => 2,<BR>
<BR>
"check-local" => "disable"<BR>
<BR>
)<BR>
<BR>
)<BR>
<BR>
)<BR>
<BR>
<BR>
<BR>
<BR>
<BR>
<BR>
gis@mapserver:~$ cat /home/gis/conf/tnsnames.ora<BR>
<BR>
MFUATDB =<BR>
<BR>
(DESCRIPTION =<BR>
<BR>
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.60.70)(PORT = 1521))<BR>
<BR>
(CONNECT_DATA =<BR>
<BR>
(SERVER = DEDICATED)<BR>
<BR>
(SERVICE_NAME = mfuatdb)<BR>
<BR>
)<BR>
<BR>
)<BR>
<BR>
<BR>
<BR>
and I'm getting: <BR>
<BR>
<BR>
<BR>
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><BR>
<BR>
<BR>
<BR>
from the logs:<BR>
<BR>
<BR>
<BR>
<BR>
[Wed Sep 29 17:00:13 2010].649965 CGI Request 1 on process 1513<BR>
<BR>
[Wed Sep 29 17:00:13 2010].717290 msOGRFileOpen(): OGR error. Open failed for OGR connection in layer `TESTII'.<BR>
<BR>
ORA-12154: TNS:could not resolve the connect identifier specified<BR>
<BR>
in <unnamed><BR>
<BR>
<BR>
<BR>
[Wed Sep 29 17:00:13 2010].717319 msDrawMap(): Image handling error. Failed to draw layer named 'TESTII'.<BR>
<BR>
[Wed Sep 29 17:00:13 2010].717454 msFreeMap(): freeing map at 0xa00f298.<BR>
<BR>
[Wed Sep 29 17:00:13 2010].717579 freeLayer(): freeing layer at 0xa0237a0.<BR>
<BR>
[Wed Sep 29 17:00:13 2010].717591 freeLayer(): freeing layer at 0xa024718.<BR>
<BR>
<BR>
<BR>
<BR>
<BR>
in mapserver:<BR>
<BR>
<BR>
<BR>
<BR>
LAYER<BR>
<BR>
NAME TESTII<BR>
<BR>
TYPE POLYGON<BR>
<BR>
STATUS ON<BR>
<BR>
CONNECTION "OCI:GEO_US_DATA/GEO_US_DATA@mfuatdb"<BR>
<BR>
CONNECTIONTYPE OGR<BR>
<BR>
DATA "CA_WILDFIRE"<BR>
<BR>
PROJECTION<BR>
<BR>
"init=epsg:3857"<BR>
<BR>
END<BR>
<BR>
CLASS<BR>
<BR>
# NAME "local_shape"<BR>
<BR>
COLOR 0 0 255<BR>
<BR>
OUTLINECOLOR 0 0 255<BR>
<BR>
END<BR>
<BR>
END<BR>
<BR>
<BR>
<BR>
<BR>
<BR>
<BR>
<BR>
The connection string is right as I'm using it from gdal:<BR>
<BR>
<BR>
<BR>
<BR>
<BR>
gis@mapserver:~$ ogrinfo OCI:GEO_US_DATA/GEO_US_DATA@mfuatdb:CA_WILDFIRE<BR>
<BR>
INFO: Open of `OCI:GEO_US_DATA/GEO_US_DATA@mfuatdb:CA_WILDFIRE'<BR>
<BR>
using driver `OCI' successful.<BR>
<BR>
1: CA_WILDFIRE<BR>
<BR>
<BR>
<BR>
<BR>
<BR>
any ideas ?<BR>
<BR>
<BR>
<BR>
<BR>
<BR>
</FONT></SPAN>
</BODY>
</HTML>