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

[Dan Little]

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
>
>
>
>
>


      
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapserver-users/attachments/20100929/d60d27b2/attachment.html