<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=iso-8859-1" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.6001.18702"></HEAD>
<BODY>
<DIV dir=ltr align=left>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=766222908-30092010>Hi,</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=766222908-30092010></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=766222908-30092010>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 <FONT color=#000000 size=3
face="Times New Roman">MFUATDB for you. </FONT></SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=766222908-30092010></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=766222908-30092010>Actually, the error message <FONT
face="Times New Roman"><FONT color=#000000 size=3>"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.</FONT></FONT></SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=766222908-30092010><FONT color=#0000ff size=2
face=Arial></FONT></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=766222908-30092010></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT color=#0000ff size=2 face=Arial><SPAN
class=766222908-30092010><FONT color=#000000 size=3
face="Times New Roman">-Jukka
Rahkonen-</FONT> </SPAN></FONT></DIV><BR></DIV><BR>
<BLOCKQUOTE
style="BORDER-LEFT: #0000ff 2px solid; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px"
dir=ltr>
<DIV dir=ltr lang=fi class=OutlookMessageHeader align=left>
<HR tabIndex=-1>
<FONT size=2 face=Tahoma><B>Lähettäjä:</B>
mapserver-users-bounces@lists.osgeo.org
[mailto:mapserver-users-bounces@lists.osgeo.org] <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> mapserver-users@lists.osgeo.org<BR><B>Aihe:</B>
Re: [mapserver-users] lighttpd, TNS:could not resolve...<BR></FONT><BR></DIV>
<DIV></DIV>yes.
<DIV><BR></DIV>
<DIV><BR></DIV>
<DIV>
<DIV>gis@mapserver:~$ ls -la /home/gis/conf/tnsnames.ora</DIV>
<DIV>-rw-r--r-- 1 gis gis 184 2010-09-29 16:19
/home/gis/conf/tnsnames.ora</DIV>
<DIV>gis@mapserver:~$ sudo su www-data -c 'cat
/home/gis/conf/tnsnames.ora'</DIV>
<DIV>MFUATDB =</DIV>
<DIV> (DESCRIPTION =</DIV>
<DIV> (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.60.70)(PORT
= 1521))</DIV>
<DIV> (CONNECT_DATA =</DIV>
<DIV> (SERVER = DEDICATED)</DIV>
<DIV> (SERVICE_NAME = mfuatdb)</DIV>
<DIV> )</DIV>
<DIV> )</DIV>
<DIV><BR></DIV><BR>
<DIV class=gmail_quote>On Wed, Sep 29, 2010 at 7:58 PM, Dan Little <SPAN
dir=ltr><<A
href="mailto:danlittle@yahoo.com">danlittle@yahoo.com</A>></SPAN>
wrote:<BR>
<BLOCKQUOTE
style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex"
class=gmail_quote>
<DIV>
<DIV style="FONT-FAMILY: arial, helvetica, sans-serif; FONT-SIZE: 10pt">
<DIV>Is tnsnames.ora accessible by the web-server user? (Check the
permissions.)</DIV>
<DIV><BR></DIV>
<BLOCKQUOTE
style="BORDER-LEFT: rgb(16,16,255) 2px solid; PADDING-LEFT: 5px; MARGIN-LEFT: 5px">
<DIV style="FONT-FAMILY: arial, helvetica, sans-serif; FONT-SIZE: 10pt">Is
t<BR>
<DIV
style="FONT-FAMILY: times new roman, new york, times, serif; FONT-SIZE: 12pt"><FONT
size=2 face=Tahoma><B><SPAN style="FONT-WEIGHT: bold">From:</SPAN></B>
Sebastian E. Ovide <<A href="mailto:sebastian.ovide@gmail.com"
target=_blank>sebastian.ovide@gmail.com</A>><BR><B><SPAN
style="FONT-WEIGHT: bold">To:</SPAN></B> <A
href="mailto:mapserver-users@lists.osgeo.org"
target=_blank>mapserver-users@lists.osgeo.org</A><BR><B><SPAN
style="FONT-WEIGHT: bold">Sent:</SPAN></B> Wed, September 29, 2010
11:10:09 AM<BR><B><SPAN style="FONT-WEIGHT: bold">Subject:</SPAN></B>
[mapserver-users] lighttpd, TNS:could not resolve...<BR></FONT>
<DIV>
<DIV></DIV>
<DIV class=h5><BR>Hi All,
<DIV><BR></DIV>
<DIV>I have installed MapServer on lighttpd + fastcgi.</DIV>
<DIV><BR></DIV>
<DIV>
<DIV>fastcgi.server = (</DIV>
<DIV> "/mapserver" =></DIV>
<DIV> ( "localhost" =></DIV>
<DIV> (</DIV>
<DIV>
"socket" => "/tmp/mapserver-fastcgi.socket",</DIV>
<DIV>
"bin-path" => "/home/gis/bin/mapserv",</DIV>
<DIV>
"bin-environment" =></DIV>
<DIV>
(</DIV>
<DIV>
"TNS_ADMIN" =>
"/home/gis/conf/"</DIV>
<DIV>
),</DIV>
<DIV>
"max-procs" => 2,</DIV>
<DIV>
"check-local" => "disable"</DIV>
<DIV> )</DIV>
<DIV> )</DIV>
<DIV>)</DIV></DIV>
<DIV><BR></DIV>
<DIV><BR></DIV>
<DIV>
<DIV>gis@mapserver:~$ cat /home/gis/conf/tnsnames.ora</DIV>
<DIV>MFUATDB =</DIV>
<DIV> (DESCRIPTION =</DIV>
<DIV> (ADDRESS = (PROTOCOL = TCP)(HOST =
192.168.60.70)(PORT = 1521))</DIV>
<DIV> (CONNECT_DATA =</DIV>
<DIV> (SERVER = DEDICATED)</DIV>
<DIV> (SERVICE_NAME = mfuatdb)</DIV>
<DIV> )</DIV>
<DIV> )</DIV></DIV>
<DIV><BR></DIV>
<DIV>and I'm getting: </DIV>
<DIV><BR></DIV>
<DIV>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></DIV>
<DIV><BR></DIV>
<DIV>from the logs:</DIV>
<DIV><BR></DIV>
<DIV>
<DIV>[Wed Sep 29 17:00:13 2010].649965 CGI Request 1 on process 1513</DIV>
<DIV>[Wed Sep 29 17:00:13 2010].717290 msOGRFileOpen(): OGR error. Open
failed for OGR connection in layer `TESTII'.</DIV>
<DIV>ORA-12154: TNS:could not resolve the connect identifier
specified</DIV>
<DIV> in <unnamed></DIV>
<DIV><BR></DIV>
<DIV>[Wed Sep 29 17:00:13 2010].717319 msDrawMap(): Image handling error.
Failed to draw layer named 'TESTII'.</DIV>
<DIV>[Wed Sep 29 17:00:13 2010].717454 msFreeMap(): freeing map at
0xa00f298.</DIV>
<DIV>[Wed Sep 29 17:00:13 2010].717579 freeLayer(): freeing layer at
0xa0237a0.</DIV>
<DIV>[Wed Sep 29 17:00:13 2010].717591 freeLayer(): freeing layer at
0xa024718.</DIV></DIV>
<DIV><BR></DIV>
<DIV><BR></DIV>
<DIV>in mapserver:</DIV>
<DIV><BR></DIV>
<DIV>
<DIV> LAYER</DIV>
<DIV> NAME TESTII</DIV>
<DIV> TYPE POLYGON</DIV>
<DIV> STATUS ON</DIV>
<DIV> CONNECTION
"OCI:GEO_US_DATA/GEO_US_DATA@mfuatdb"</DIV>
<DIV> CONNECTIONTYPE OGR</DIV>
<DIV> DATA "CA_WILDFIRE"</DIV>
<DIV> PROJECTION</DIV>
<DIV> "init=epsg:3857"</DIV>
<DIV> END</DIV>
<DIV> CLASS</DIV>
<DIV># NAME "local_shape"</DIV>
<DIV> COLOR 0 0 255</DIV>
<DIV> OUTLINECOLOR 0 0 255</DIV>
<DIV> END</DIV>
<DIV> END</DIV></DIV>
<DIV><BR></DIV>
<DIV><BR></DIV>
<DIV><BR></DIV>
<DIV>The connection string is right as I'm using it from gdal:</DIV>
<DIV><BR></DIV>
<DIV>
<DIV>
<DIV>gis@mapserver:~$ ogrinfo
OCI:GEO_US_DATA/GEO_US_DATA@mfuatdb:CA_WILDFIRE</DIV>
<DIV>INFO: Open of `OCI:GEO_US_DATA/GEO_US_DATA@mfuatdb:CA_WILDFIRE'</DIV>
<DIV> using driver `OCI' successful.</DIV>
<DIV>1: CA_WILDFIRE</DIV></DIV></DIV>
<DIV><BR></DIV>
<DIV><BR></DIV>
<DIV>any ideas ?</DIV>
<DIV><BR></DIV>
<DIV><BR></DIV>
<DIV>-- <BR>Sebastian E.
Ovide<BR><BR><BR><BR><BR></DIV></DIV></DIV></DIV></DIV></BLOCKQUOTE>
<DIV></DIV></DIV><BR></DIV></BLOCKQUOTE></DIV><BR><BR clear=all><BR>--
<BR>Sebastian E. Ovide<BR><BR><BR><BR><BR></DIV></BLOCKQUOTE></BODY></HTML>