[mapserver-users] lighttpd, TNS:could not resolve...

[Sebastian E. Ovide]

yes.


gis at 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
gis at 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 <danlittle at yahoo.com> wrote:

> Is tnsnames.ora accessible by the web-server user? (Check the permissions.)
>
> Is t
> *From:* Sebastian E. Ovide <sebastian.ovide at gmail.com>
> *To:* mapserver-users at 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"
>                 )
>         )
> )
>
>
> gis at 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_DATA at 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:
>
> gis at mapserver:~$ ogrinfo OCI:GEO_US_DATA/GEO_US_DATA at mfuatdb:CA_WILDFIRE
> INFO: Open of `OCI:GEO_US_DATA/GEO_US_DATA at mfuatdb:CA_WILDFIRE'
>       using driver `OCI' successful.
> 1: CA_WILDFIRE
>
>
> any ideas ?
>
>
> --
> Sebastian E. Ovide
>
>
>
>
>
>


-- 
Sebastian E. Ovide
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20100930/22528c35/attachment.htm>