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

[Sebastian E. Ovide]

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/80df105d/attachment.htm>