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 class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<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:2px solid rgb(16, 16, 255);margin-left:5px;padding-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>