Hi,
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 MFUATDB for you.
Actually, the error message "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.
-Jukka Rahkonen-
________________________________
Lähettäjä: [email protected]
[mailto:[email protected]] Puolesta Sebastian E. Ovide
Lähetetty: 30. syyskuuta 2010 11:15
Vastaanottaja: Dan Little
Kopio: [email protected]
Aihe: Re: [mapserver-users] lighttpd, TNS:could not resolve...
yes.
g...@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
g...@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 <[email protected]> wrote:
Is tnsnames.ora accessible by the web-server user? (Check the
permissions.)
Is t
From: Sebastian E. Ovide <[email protected]>
To: [email protected]
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"
)
)
)
g...@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_d...@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:
g...@mapserver:~$ ogrinfo
OCI:GEO_US_DATA/geo_us_d...@mfuatdb:CA_WILDFIRE
INFO: Open of
`OCI:GEO_US_DATA/geo_us_d...@mfuatdb:CA_WILDFIRE'
using driver `OCI' successful.
1: CA_WILDFIRE
any ideas ?
--
Sebastian E. Ovide
--
Sebastian E. Ovide
_______________________________________________
mapserver-users mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/mapserver-users
