[mapserver-users] Mapserver error
Hi Dear's, I'm getting these erros when i test my mapserver build: can someone give some hint to a possible fix.. thanks error 1: Failed to draw layer named #39;waterways6#39;.\nmsPostGISLayerWhichShapes(): Query error. Error executing query: ERROR: relation quot;osm_new_waterways_gen0quot; does not exist\nLINE 1: ...(select geometry, osm_id, type, name as name from osm_new_wa...\n ^\n \n/ServiceException\n/ServiceExceptionReport\n, referer: http://localhost/mapcache/demo/wm error 2: mod_fcgid: stderr: msPostGISLayerWhichShapes(): Query error. Error executing query: ERROR: relation osm_new_waterways_gen0 does not exist thanks Mac ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] Mapserver error: Web application error. Missing magic string, ...
I have an html template that worked fine with an earlier version of Mapserver, but not with v5.4.1 The error mesage is: Content-type: text/html isValidTemplate(): Web application error. Missing magic string, /srv/www/htdocs/mapdata/linz_topo/linz_250_template.html doesn't look like a MapServer template. I can't find any docs to help identify what the error is how to fix it. Any advice appreciated Brent Wood The (short) html template I was using is: HTML HEAD TITLE Mapserver LINZ250 prototype/TITLE HEAD CENTER H2 Mapserver demonstration of LINZ250 data/H2 FORM method=get action=/cgi-bin/mapserv TABLE border=0 cellspacing=0 cellpadding=4 TR TD BU INPUT name=img type=image SRC=[img] width=600 height=480 border=0 ALT=Map ImageBR INPUT type=hidden name=map value=/srv/www/htdocs/linz_topo/linz250.map INPUT type=hidden name=imgxy value=[center_x] [center_y] INPUT type=hidden name=imgextvalue=[mapext] INPUT type=hidden name=map value=[map] INPUT type=hidden name=savequery value=true INPUT type=hidden name=mapextvalue=shapes INPUT type=submit value=Redraw/Update Zoom In INPUT type=radio name=zoomdir value=1 [zoomdir_1_check] nbsp;nbsp;nbsp;nbsp; Re-center INPUT type=radio name=zoomdir value=0 [zoomdir_0_check] nbsp;nbsp;nbsp;nbsp; Zoom Out INPUT type=radio name=zoomdir value=-1 [zoomdir_-1_check] nbsp;nbsp;nbsp;nbsp; Zoom size INPUT type=text name=zoomsize size=3 value=[zoomsize] /TD /TR /TABLE /FORM /CENTER /BODY /HTML ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] Mapserver error: Web application error. Missing magic string, ...
On Tue, Oct 27, 2009 at 6:24 PM, pcr...@pcreso.com wrote: I have an html template that worked fine with an earlier version of Mapserver, but not with v5.4.1 The error mesage is: Content-type: text/html isValidTemplate(): Web application error. Missing magic string, /srv/www/htdocs/mapdata/linz_topo/linz_250_template.html doesn't look like a MapServer template. I can't find any docs to help identify what the error is how to fix it. Any advice appreciated http://www.mapserver.org/development/rfc/ms-rfc-56.html?highlight=magic Brent Wood The (short) html template I was using is: HTML HEAD TITLE Mapserver LINZ250 prototype/TITLE HEAD CENTER H2 Mapserver demonstration of LINZ250 data/H2 FORM method=get action=/cgi-bin/mapserv TABLE border=0 cellspacing=0 cellpadding=4 TR TD BU INPUT name=img type=image SRC=[img] width=600 height=480 border=0 ALT=Map ImageBR INPUT type=hidden name=map value=/srv/www/htdocs/linz_topo/linz250.map INPUT type=hidden name=imgxy value=[center_x] [center_y] INPUT type=hidden name=imgext value=[mapext] INPUT type=hidden name=map value=[map] INPUT type=hidden name=savequery value=true INPUT type=hidden name=mapext value=shapes INPUT type=submit value=Redraw/Update Zoom In INPUT type=radio name=zoomdir value=1 [zoomdir_1_check] nbsp;nbsp;nbsp;nbsp; Re-center INPUT type=radio name=zoomdir value=0 [zoomdir_0_check] nbsp;nbsp;nbsp;nbsp; Zoom Out INPUT type=radio name=zoomdir value=-1 [zoomdir_-1_check] nbsp;nbsp;nbsp;nbsp; Zoom size INPUT type=text name=zoomsize size=3 value=[zoomsize] /TD /TR /TABLE /FORM /CENTER /BODY /HTML ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users -- Puneet Kishor http://www.punkish.org Carbon Model http://carbonmodel.org Charter Member, Open Source Geospatial Foundation http://www.osgeo.org Science Commons Fellow, http://sciencecommons.org/about/whoweare/kishor Nelson Institute, UW-Madison http://www.nelson.wisc.edu --- Assertions are politics; backing up assertions with evidence is science === Sent from Madison, WI, United States ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] Mapserver error: Web application error. Missingmagic string, ...
Thanks guys... That was most certainly it :-) Cheers, Brent --- On Wed, 10/28/09, Bob Basques bob.basq...@ci.stpaul.mn.us wrote: From: Bob Basques bob.basq...@ci.stpaul.mn.us Subject: Re: [mapserver-users] Mapserver error: Web application error. Missingmagic string, ... To: pcr...@pcreso.com Date: Wednesday, October 28, 2009, 12:39 PM Brent, This should help: http://mapserver.org/development/rfc/ms-rfc-56.html?highlight=magic%20string bobb pcr...@pcreso.com 10/27/09 6:25 PM I have an html template that worked fine with an earlier version of Mapserver, but not with v5.4.1 The error mesage is: Content-type: text/html isValidTemplate(): Web application error. Missing magic string, /srv/www/htdocs/mapdata/linz_topo/linz_250_template.html doesn't look like a MapServer template. I can't find any docs to help identify what the error is how to fix it. Any advice appreciated Brent Wood The (short) html template I was using is: HTML HEAD TITLE Mapserver LINZ250 prototype/TITLE HEAD CENTER H2 Mapserver demonstration of LINZ250 data/H2 FORM method=get action=/cgi-bin/mapserv TABLE border=0 cellspacing=0 cellpadding=4 TR TD BU INPUT name=img type=image SRC=[img] width=600 height=480 border=0 ALT=Map ImageBR INPUT type=hidden name=map value=/srv/www/htdocs/linz_topo/linz250.map INPUT type=hidden name=imgxy value=[center_x] [center_y] INPUT type=hidden name=imgext value=[mapext] INPUT type=hidden name=map value=[map] INPUT type=hidden name=savequery value=true INPUT type=hidden name=mapext value=shapes INPUT type=submit value=Redraw/Update Zoom In INPUT type=radio name=zoomdir value=1 [zoomdir_1_check] Re-center INPUT type=radio name=zoomdir value=0 [zoomdir_0_check] Zoom Out INPUT type=radio name=zoomdir value=-1 [zoomdir_-1_check] Zoom size INPUT type=text name=zoomsize size=3 value=[zoomsize] /TD /TR /TABLE /FORM /CENTER /BODY /HTML ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
RE: [mapserver-users] Mapserver error debugging
Bob, A couple of years ago, I had FWTools, including MapServer running on a USB stick. You might want to take a look at Jo Cook's Portable GIS: http://www.archaeogeek.com/blog/portable-gis/ David. From: mapserver-users-boun...@lists.osgeo.org [mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of Bob Basques Sent: Wednesday, September 23, 2009 4:22 PM To: mapserver-users@lists.osgeo.org Subject: [mapserver-users] Mapserver error debugging All, So I'm trying to run MapServer from a thumb Drive, first off, is this possible? I'm on Windows XP, and get what looks like a Browser error: The image Mapserver URL here cannot be displayed, because it contains errors. I'm using the MS4W Mapserv Binary ( should I try another, if so which?), are there things I should look for related to MS4W? How do I go about trying to debug the problem? Thanks bobb ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] MapServer Error]: msLoadMap()
I am new to map servers… I have written my first program …..and I am having problem ……I have written a simple hello world programon windows and it is showing problems…… Error is -- *Warning*: [MapServer Error]: msLoadMap(): First token must be MAP, this doesn't look like a mapfile. in *C:\OSGeo4W\apache\htdocs\hello.php* on line *6* *Warning*: Failed to open map file C:\OSGeo4W\apache\htdocs/hello.map in * C:\OSGeo4W\apache\htdocs\hello.php* on line *6* *Fatal error*: Call to a member function draw() on a non-object in * C:\OSGeo4W\apache\htdocs\hello.php* on line *8* I have tried so much but it is not sorted out ….. plz help me in doing so …….. thanx in advance … The code is ?php dl(php_mapscript.dll); $map_path=C:\OSGeo4W\apache\htdocs/; $map = ms_newMapObj($map_path.hello.map); $image=$map-draw(); $image_url=$image-saveWebImage(); ? HTML HEAD TITLEMAPSERVER HELLO WORLD/TITLE /HEAD BODY IMG SRC=?php echo $image_url;? /BODY /HTML The hello.map file is in the C:\OSGeo4W\apache\htdocs directory ……. And the hello.php file is also in the same directory. Plz help me I will be greatful to u ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] MapServer Error]: msLoadMap()
Hi Seems you are using mapserver 5.4 In your MAP-file the first word (except for comments) must be MAP (see the error message) also, can you post here contents of the map-file... Regards, michael 2009/9/15 harpal singh harpalh...@gmail.com I am new to map servers… I have written my first program …..and I am having problem ……I have written a simple hello world programon windows and it is showing problems…… Error is -- *Warning*: [MapServer Error]: msLoadMap(): First token must be MAP, this doesn't look like a mapfile. in *C:\OSGeo4W\apache\htdocs\hello.php* on line *6* *Warning*: Failed to open map file C:\OSGeo4W\apache\htdocs/hello.map in * C:\OSGeo4W\apache\htdocs\hello.php* on line *6* *Fatal error*: Call to a member function draw() on a non-object in * C:\OSGeo4W\apache\htdocs\hello.php* on line *8* I have tried so much but it is not sorted out ….. plz help me in doing so …….. thanx in advance … The code is ?php dl(php_mapscript.dll); $map_path=C:\OSGeo4W\apache\htdocs/; $map = ms_newMapObj($map_path.hello.map); $image=$map-draw(); $image_url=$image-saveWebImage(); ? HTML HEAD TITLEMAPSERVER HELLO WORLD/TITLE /HEAD BODY IMG SRC=?php echo $image_url;? /BODY /HTML The hello.map file is in the C:\OSGeo4W\apache\htdocs directory ……. And the hello.php file is also in the same directory. Plz help me I will be greatful to u ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] MapServer Error
Hi everyone, I have installed mapserver and pmapper and when custimize my maps have this error: Warning: [MapServer Error]: msLoadMap(): Undefined symbol Hidro.shp-0-0 in class 0, style 0 of layer Hidrografia. in /home/orsep/public_html/gis2/incphp/globals.php on line 60 Warning: [MapServer Error]: msAddImageSymbol(): Error opening image file /home/orsep/public_html/gis2/mapoteca/presas_gis/Hidro.shp-0-0. in /home/orsep/public_html/gis2/incphp/globals.php on line 60 Warning: Failed to open map file /home/orsep/public_html/gis2/mapoteca/presas_gis/presas_gis.map in /home/orsep/public_html/gis2/incphp/globals.php on line 60 Fatal error: Call to a member function getAllGroupNames() on a non-object in /home/orsep/public_html/gis2/incphp/init/initmap.php on line 129 Any ideas? Kind regards and sorry my bad english. ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] MapServer Error
Hey Gonzalo. Still wrestling with that puppy, huh? We'll get it hammered into place. :) Warning: [MapServer Error]: msLoadMap(): Undefined symbol Hidro.shp-0-0 in class 0, style 0 of layer Hidrografia. in /home/orsep/public_html/gis2/incphp/globals.php on line 60 Undefined symbol means that you have a keyword in the mapfile that MapServer doesn't understand. It is always advised that you quote all words and stuff, such as the name of your shapefile: Bad: DATA filenames.shp Good: DATA filenames.shp Where I would start debugging: I'd open up the mapfile and look for Hidro.shp-0-0 which seems to be in a class somewhere, and post the layer definition. Then we can check for any obvious mistakes. All the rest of your errors, probably stem from that one. If your mapfile is broken, then $m = ms_newMapObj() will return a null, then later on your're caling $m-draw() and that's a non-object, and so on. Usually (but not always) the first error is the real one. -- HostGIS, Open Source solutions for the global GIS community Greg Allensworth - SysAdmin, Programmer, GIS Person, Security Network+ Server+ A+ Security+ ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] MapServer Error
And the new error: Warning: [MapServer Error]: msLoadSymbolSet(): First token must be SYMBOLSET, this doesn't look like a symbol file. in /home/orsep/public_html/gis2/incphp/globals.php on line 60 That means exactly what it says: symbol files must now start with SYMBOLSET and end with END. This is a security feature introduced in 5.2.1 and 5.4.0. -- HostGIS, Open Source solutions for the global GIS community Greg Allensworth - SysAdmin, Programmer, GIS Person, Security Network+ Server+ A+ Security+ ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] mapserver error
On Friday 24 April 2009 12:42:46 Pano wrote: Hi Iratxe, Unfortunately I know very little about CentOS. Just a windows guy me :-) But let me try: Is it possible that you have multiple Oracle Homes setup? And sqlplus is using the home where oracle server is installed whereas mapserver is using another (oracle client?) home which does not have the tnsnames setup correctly? In a windows setup i would first check the PATH environment variable. If the oracle client install is the first on the list then this is what mapserver would use. You mention a path /usr/lib/oracle/10.2.0.3/client- does this folder also contains a network\admin\tnsnames.ora file? Maybe this is the one you need to change (again maybe talking complete rubish here as on idea abt this OS) Finally- another idea just to make sure its not a WFS problem. Are you able to get an image by simply using cgi-bin e.g. http://localhost/cgi-bin/mapserve?map=...,mode=map etc?? Pano Iratxe Lejarreta wrote: On Wednesday 22 April 2009 08:54:57 Pano wrote: Hi Iratxe, Looks like mapserver doesnt know the TNS name 'orcl' that you have defined. I assume that the machine where mapserver runs has an oracle client installed? Can you log into sql plus i..e sqlplus mddata/passwd@orcl from a command prompt on this box? I assume you will get the same TNS error. Which will mean that your tnsnames.ora file is not set correctly. The file should be located under $ORACLE_HOME\network\admin\tnsnames.ora. There should be an entry in there like: ORCL = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = server_name_or_IP) (PORT = usually_1521) ) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = oracle_service_name) ) ) Hope this helps, Pano Iratxe Lejarreta wrote: Hi, I installed MapServer-5.2.0 on CentOS 5.2 with Oracle 10g, but when I run the WFS service... http://localhost/cgi- bin/mywfs?SERVICE=WFSVERSION=1.0.0REQUEST=getfeatureTYPENAME=cities ...the result is: − ServiceExceptionReport version=1.2.0 xsi:schemaLocation=http://www.opengis.net/ogc http://schemas.opengis.net/wfs/1.0.0/OGC-exception.xsd; − ServiceException code=NoApplicableCode locator=mapserv msWFSGetFeature(): WFS server error. ms_error-code not found msOracleSpatialLayerOpen(): OracleSpatial error. Cannot create OCI Handlers. Connection failure. Check the connection string. Error: ORA-12154: TNS:could not resolve the connect identifier specified . msOracleSpatialLayerOpen(): OracleSpatial error. Cannot create OCI Handlers. Connection failure. Check the connection string. Error: ORA-12154: TNS:could not resolve the connect identifier specified . /ServiceException /ServiceExceptionReport Mapfile: MAP NAME WFS_TEST STATUS ON SIZE 400 300 EXTENT -180 -90 180 90 UNITS METERS IMAGECOLOR 255 255 255 WEB METADATA wfs_title WFS TEST wfs_onlineresourcehttp://localhost/cgi-bin/mywfs?; wfs_srs EPSG:4326 END END PROJECTION init=epsg:4326 END LAYER NAME cities TYPE POINT CONNECTIONTYPE oraclespatial CONNECTION MDDATA/**...@orcl DATA GEOM FROM CITIES USING UNIQUE FID SRID 4326 VERSION 10g METADATA wfs_title cities gml_featureid FID gml_include_items all END STATUS ON DUMP TRUE CLASS STYLE OUTLINECOLOR 0 0 0 COLOR 0 128 128 END END END # Cities END # Map File Somebody can help me? Thanks in advance. -- Iratxe Lejarreta www.axios.es ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users Hi Pano, Firstly, thanks for your answer! I have checked all configuration but I continue with the same error: 1.- I haven't got any error in logs. 2.- I installed Oracle Instat Client: # rpm -Uvh oracle-instantclient-basic-10.2.0.4-1.i386.rpm I have set the library loading path: # export LD_LIBRARY_PATH=/usr/lib/oracle/10.2.0.3/client/lib 3.- I can access with sqlplus and sqldeveloper without any problem: [oracle]$ sqlplus mddata/passwd@orcl 4.- $ORACLE_HOME\network\admin\tnsnames.ora file: ORCL = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.2.215) (PORT = 1521) ) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl) ) ) 5.- I try to access with the following URL: http://192.168.2.215/cgi-
Re: [mapserver-users] mapserver error
On Friday 24 April 2009 12:42:46 Pano wrote: Hi Iratxe, Unfortunately I know very little about CentOS. Just a windows guy me :-) But let me try: Is it possible that you have multiple Oracle Homes setup? And sqlplus is using the home where oracle server is installed whereas mapserver is using another (oracle client?) home which does not have the tnsnames setup correctly? In a windows setup i would first check the PATH environment variable. If the oracle client install is the first on the list then this is what mapserver would use. You mention a path /usr/lib/oracle/10.2.0.3/client- does this folder also contains a network\admin\tnsnames.ora file? Maybe this is the one you need to change (again maybe talking complete rubish here as on idea abt this OS) Finally- another idea just to make sure its not a WFS problem. Are you able to get an image by simply using cgi-bin e.g. http://localhost/cgi-bin/mapserve?map=...,mode=map etc?? Pano Iratxe Lejarreta wrote: On Wednesday 22 April 2009 08:54:57 Pano wrote: Hi Iratxe, Looks like mapserver doesnt know the TNS name 'orcl' that you have defined. I assume that the machine where mapserver runs has an oracle client installed? Can you log into sql plus i..e sqlplus mddata/passwd@orcl from a command prompt on this box? I assume you will get the same TNS error. Which will mean that your tnsnames.ora file is not set correctly. The file should be located under $ORACLE_HOME\network\admin\tnsnames.ora. There should be an entry in there like: ORCL = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = server_name_or_IP) (PORT = usually_1521) ) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = oracle_service_name) ) ) Hope this helps, Pano Iratxe Lejarreta wrote: Hi, I installed MapServer-5.2.0 on CentOS 5.2 with Oracle 10g, but when I run the WFS service... http://localhost/cgi- bin/mywfs?SERVICE=WFSVERSION=1.0.0REQUEST=getfeatureTYPENAME=cities ...the result is: − ServiceExceptionReport version=1.2.0 xsi:schemaLocation=http://www.opengis.net/ogc http://schemas.opengis.net/wfs/1.0.0/OGC-exception.xsd; − ServiceException code=NoApplicableCode locator=mapserv msWFSGetFeature(): WFS server error. ms_error-code not found msOracleSpatialLayerOpen(): OracleSpatial error. Cannot create OCI Handlers. Connection failure. Check the connection string. Error: ORA-12154: TNS:could not resolve the connect identifier specified . msOracleSpatialLayerOpen(): OracleSpatial error. Cannot create OCI Handlers. Connection failure. Check the connection string. Error: ORA-12154: TNS:could not resolve the connect identifier specified . /ServiceException /ServiceExceptionReport Mapfile: MAP NAME WFS_TEST STATUS ON SIZE 400 300 EXTENT -180 -90 180 90 UNITS METERS IMAGECOLOR 255 255 255 WEB METADATA wfs_title WFS TEST wfs_onlineresourcehttp://localhost/cgi-bin/mywfs?; wfs_srs EPSG:4326 END END PROJECTION init=epsg:4326 END LAYER NAME cities TYPE POINT CONNECTIONTYPE oraclespatial CONNECTION MDDATA/**...@orcl DATA GEOM FROM CITIES USING UNIQUE FID SRID 4326 VERSION 10g METADATA wfs_title cities gml_featureid FID gml_include_items all END STATUS ON DUMP TRUE CLASS STYLE OUTLINECOLOR 0 0 0 COLOR 0 128 128 END END END # Cities END # Map File Somebody can help me? Thanks in advance. -- Iratxe Lejarreta www.axios.es ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users Hi Pano, Firstly, thanks for your answer! I have checked all configuration but I continue with the same error: 1.- I haven't got any error in logs. 2.- I installed Oracle Instat Client: # rpm -Uvh oracle-instantclient-basic-10.2.0.4-1.i386.rpm I have set the library loading path: # export LD_LIBRARY_PATH=/usr/lib/oracle/10.2.0.3/client/lib 3.- I can access with sqlplus and sqldeveloper without any problem: [oracle]$ sqlplus mddata/passwd@orcl 4.- $ORACLE_HOME\network\admin\tnsnames.ora file: ORCL = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.2.215) (PORT = 1521) ) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl) ) ) 5.- I try to access with the following URL: http://192.168.2.215/cgi-
Re: [mapserver-users] mapserver error
Hi Iratxe, Unfortunately I know very little about CentOS. Just a windows guy me :-) But let me try: Is it possible that you have multiple Oracle Homes setup? And sqlplus is using the home where oracle server is installed whereas mapserver is using another (oracle client?) home which does not have the tnsnames setup correctly? In a windows setup i would first check the PATH environment variable. If the oracle client install is the first on the list then this is what mapserver would use. You mention a path /usr/lib/oracle/10.2.0.3/client- does this folder also contains a network\admin\tnsnames.ora file? Maybe this is the one you need to change (again maybe talking complete rubish here as on idea abt this OS) Finally- another idea just to make sure its not a WFS problem. Are you able to get an image by simply using cgi-bin e.g. http://localhost/cgi-bin/mapserve?map=...,mode=map etc?? Pano Iratxe Lejarreta wrote: On Wednesday 22 April 2009 08:54:57 Pano wrote: Hi Iratxe, Looks like mapserver doesnt know the TNS name 'orcl' that you have defined. I assume that the machine where mapserver runs has an oracle client installed? Can you log into sql plus i..e sqlplus mddata/passwd@orcl from a command prompt on this box? I assume you will get the same TNS error. Which will mean that your tnsnames.ora file is not set correctly. The file should be located under $ORACLE_HOME\network\admin\tnsnames.ora. There should be an entry in there like: ORCL = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = server_name_or_IP) (PORT = usually_1521) ) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = oracle_service_name) ) ) Hope this helps, Pano Iratxe Lejarreta wrote: Hi, I installed MapServer-5.2.0 on CentOS 5.2 with Oracle 10g, but when I run the WFS service... http://localhost/cgi- bin/mywfs?SERVICE=WFSVERSION=1.0.0REQUEST=getfeatureTYPENAME=cities ...the result is: − ServiceExceptionReport version=1.2.0 xsi:schemaLocation=http://www.opengis.net/ogc http://schemas.opengis.net/wfs/1.0.0/OGC-exception.xsd; − ServiceException code=NoApplicableCode locator=mapserv msWFSGetFeature(): WFS server error. ms_error-code not found msOracleSpatialLayerOpen(): OracleSpatial error. Cannot create OCI Handlers. Connection failure. Check the connection string. Error: ORA-12154: TNS:could not resolve the connect identifier specified . msOracleSpatialLayerOpen(): OracleSpatial error. Cannot create OCI Handlers. Connection failure. Check the connection string. Error: ORA-12154: TNS:could not resolve the connect identifier specified . /ServiceException /ServiceExceptionReport Mapfile: MAP NAME WFS_TEST STATUS ON SIZE 400 300 EXTENT -180 -90 180 90 UNITS METERS IMAGECOLOR 255 255 255 WEB METADATA wfs_title WFS TEST wfs_onlineresourcehttp://localhost/cgi-bin/mywfs?; wfs_srs EPSG:4326 END END PROJECTION init=epsg:4326 END LAYER NAME cities TYPE POINT CONNECTIONTYPE oraclespatial CONNECTION MDDATA/**...@orcl DATA GEOM FROM CITIES USING UNIQUE FID SRID 4326 VERSION 10g METADATA wfs_title cities gml_featureid FID gml_include_items all END STATUS ON DUMP TRUE CLASS STYLE OUTLINECOLOR 0 0 0 COLOR 0 128 128 END END END # Cities END # Map File Somebody can help me? Thanks in advance. -- Iratxe Lejarreta www.axios.es ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users Hi Pano, Firstly, thanks for your answer! I have checked all configuration but I continue with the same error: 1.- I haven't got any error in logs. 2.- I installed Oracle Instat Client: # rpm -Uvh oracle-instantclient-basic-10.2.0.4-1.i386.rpm I have set the library loading path: # export LD_LIBRARY_PATH=/usr/lib/oracle/10.2.0.3/client/lib 3.- I can access with sqlplus and sqldeveloper without any problem: [oracle]$ sqlplus mddata/passwd@orcl 4.- $ORACLE_HOME\network\admin\tnsnames.ora file: ORCL = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.2.215) (PORT = 1521) ) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl) ) ) 5.- I try to access with the following URL: http://192.168.2.215/cgi- bin/mywfs?SERVICE=WFSVERSION=1.0.0REQUEST=getfeatureTYPENAME=cities 6.- ...but the result it's the same: ServiceExceptionReport version=1.2.0 xsi:schemaLocation=http://www.opengis.net/ogc
Re: [mapserver-users] mapserver error
Hi Iratxe, Looks like mapserver doesnt know the TNS name 'orcl' that you have defined. I assume that the machine where mapserver runs has an oracle client installed? Can you log into sql plus i..e sqlplus mddata/passwd@orcl from a command prompt on this box? I assume you will get the same TNS error. Which will mean that your tnsnames.ora file is not set correctly. The file should be located under $ORACLE_HOME\network\admin\tnsnames.ora. There should be an entry in there like: ORCL = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = server_name_or_IP) (PORT = usually_1521) ) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = oracle_service_name) ) ) Hope this helps, Pano Iratxe Lejarreta wrote: Hi, I installed MapServer-5.2.0 on CentOS 5.2 with Oracle 10g, but when I run the WFS service... http://localhost/cgi- bin/mywfs?SERVICE=WFSVERSION=1.0.0REQUEST=getfeatureTYPENAME=cities ...the result is: − ServiceExceptionReport version=1.2.0 xsi:schemaLocation=http://www.opengis.net/ogc http://schemas.opengis.net/wfs/1.0.0/OGC-exception.xsd; − ServiceException code=NoApplicableCode locator=mapserv msWFSGetFeature(): WFS server error. ms_error-code not found msOracleSpatialLayerOpen(): OracleSpatial error. Cannot create OCI Handlers. Connection failure. Check the connection string. Error: ORA-12154: TNS:could not resolve the connect identifier specified . msOracleSpatialLayerOpen(): OracleSpatial error. Cannot create OCI Handlers. Connection failure. Check the connection string. Error: ORA-12154: TNS:could not resolve the connect identifier specified . /ServiceException /ServiceExceptionReport Mapfile: MAP NAME WFS_TEST STATUS ON SIZE 400 300 EXTENT -180 -90 180 90 UNITS METERS IMAGECOLOR 255 255 255 WEB METADATA wfs_title WFS TEST wfs_onlineresourcehttp://localhost/cgi-bin/mywfs?; wfs_srs EPSG:4326 END END PROJECTION init=epsg:4326 END LAYER NAME cities TYPE POINT CONNECTIONTYPE oraclespatial CONNECTION MDDATA/**...@orcl DATA GEOM FROM CITIES USING UNIQUE FID SRID 4326 VERSION 10g METADATA wfs_title cities gml_featureid FID gml_include_items all END STATUS ON DUMP TRUE CLASS STYLE OUTLINECOLOR 0 0 0 COLOR 0 128 128 END END END # Cities END # Map File Somebody can help me? Thanks in advance. -- Iratxe Lejarreta www.axios.es ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users -- View this message in context: http://n2.nabble.com/mapserver-error-tp2671622p2674567.html Sent from the Mapserver - User mailing list archive at Nabble.com. ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] mapserver error
On Wednesday 22 April 2009 08:54:57 Pano wrote: Hi Iratxe, Looks like mapserver doesnt know the TNS name 'orcl' that you have defined. I assume that the machine where mapserver runs has an oracle client installed? Can you log into sql plus i..e sqlplus mddata/passwd@orcl from a command prompt on this box? I assume you will get the same TNS error. Which will mean that your tnsnames.ora file is not set correctly. The file should be located under $ORACLE_HOME\network\admin\tnsnames.ora. There should be an entry in there like: ORCL = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = server_name_or_IP) (PORT = usually_1521) ) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = oracle_service_name) ) ) Hope this helps, Pano Iratxe Lejarreta wrote: Hi, I installed MapServer-5.2.0 on CentOS 5.2 with Oracle 10g, but when I run the WFS service... http://localhost/cgi- bin/mywfs?SERVICE=WFSVERSION=1.0.0REQUEST=getfeatureTYPENAME=cities ...the result is: − ServiceExceptionReport version=1.2.0 xsi:schemaLocation=http://www.opengis.net/ogc http://schemas.opengis.net/wfs/1.0.0/OGC-exception.xsd; − ServiceException code=NoApplicableCode locator=mapserv msWFSGetFeature(): WFS server error. ms_error-code not found msOracleSpatialLayerOpen(): OracleSpatial error. Cannot create OCI Handlers. Connection failure. Check the connection string. Error: ORA-12154: TNS:could not resolve the connect identifier specified . msOracleSpatialLayerOpen(): OracleSpatial error. Cannot create OCI Handlers. Connection failure. Check the connection string. Error: ORA-12154: TNS:could not resolve the connect identifier specified . /ServiceException /ServiceExceptionReport Mapfile: MAP NAME WFS_TEST STATUS ON SIZE 400 300 EXTENT -180 -90 180 90 UNITS METERS IMAGECOLOR 255 255 255 WEB METADATA wfs_title WFS TEST wfs_onlineresourcehttp://localhost/cgi-bin/mywfs?; wfs_srs EPSG:4326 END END PROJECTION init=epsg:4326 END LAYER NAME cities TYPE POINT CONNECTIONTYPE oraclespatial CONNECTION MDDATA/**...@orcl DATA GEOM FROM CITIES USING UNIQUE FID SRID 4326 VERSION 10g METADATA wfs_title cities gml_featureid FID gml_include_items all END STATUS ON DUMP TRUE CLASS STYLE OUTLINECOLOR 0 0 0 COLOR 0 128 128 END END END # Cities END # Map File Somebody can help me? Thanks in advance. -- Iratxe Lejarreta www.axios.es ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users Hi Pano, Firstly, thanks for your answer! I have checked all configuration but I continue with the same error: 1.- I haven't got any error in logs. 2.- I installed Oracle Instat Client: # rpm -Uvh oracle-instantclient-basic-10.2.0.4-1.i386.rpm I have set the library loading path: # export LD_LIBRARY_PATH=/usr/lib/oracle/10.2.0.3/client/lib 3.- I can access with sqlplus and sqldeveloper without any problem: [oracle]$ sqlplus mddata/passwd@orcl 4.- $ORACLE_HOME\network\admin\tnsnames.ora file: ORCL = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.2.215) (PORT = 1521) ) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl) ) ) 5.- I try to access with the following URL: http://192.168.2.215/cgi- bin/mywfs?SERVICE=WFSVERSION=1.0.0REQUEST=getfeatureTYPENAME=cities 6.- ...but the result it's the same: ServiceExceptionReport version=1.2.0 xsi:schemaLocation=http://www.opengis.net/ogc http://schemas.opengis.net/wfs/1.0.0/OGC-exception.xsd; ServiceException code=NoApplicableCode locator=mapserv msWFSGetFeature(): WFS server error. ms_error-code not found msOracleSpatialLayerOpen(): OracleSpatial error. Cannot create OCI Handlers. Connection failure. Check the connection string. Error: ORA-12154: TNS:could not resolve the connect identifier specified. msOracleSpatialLayerOpen(): OracleSpatial error. Cannot create OCI Handlers. Connection failure. Check the connection string. Error: ORA-12154: TNS:could not resolve the connect identifier specified. /ServiceException /ServiceExceptionReport Do you know where could be wrong? Thanks for your help! Regards, -- Iratxe Lejarreta www.axios.es ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] mapserver error
Hi, I installed MapServer-5.2.0 on CentOS 5.2 with Oracle 10g, but when I run the WFS service... http://localhost/cgi- bin/mywfs?SERVICE=WFSVERSION=1.0.0REQUEST=getfeatureTYPENAME=cities ...the result is: − ServiceExceptionReport version=1.2.0 xsi:schemaLocation=http://www.opengis.net/ogc http://schemas.opengis.net/wfs/1.0.0/OGC-exception.xsd; − ServiceException code=NoApplicableCode locator=mapserv msWFSGetFeature(): WFS server error. ms_error-code not found msOracleSpatialLayerOpen(): OracleSpatial error. Cannot create OCI Handlers. Connection failure. Check the connection string. Error: ORA-12154: TNS:could not resolve the connect identifier specified . msOracleSpatialLayerOpen(): OracleSpatial error. Cannot create OCI Handlers. Connection failure. Check the connection string. Error: ORA-12154: TNS:could not resolve the connect identifier specified . /ServiceException /ServiceExceptionReport Mapfile: MAP NAME WFS_TEST STATUS ON SIZE 400 300 EXTENT -180 -90 180 90 UNITS METERS IMAGECOLOR 255 255 255 WEB METADATA wfs_title WFS TEST wfs_onlineresourcehttp://localhost/cgi-bin/mywfs?; wfs_srs EPSG:4326 END END PROJECTION init=epsg:4326 END LAYER NAME cities TYPE POINT CONNECTIONTYPE oraclespatial CONNECTION MDDATA/**...@orcl DATA GEOM FROM CITIES USING UNIQUE FID SRID 4326 VERSION 10g METADATA wfs_title cities gml_featureid FID gml_include_items all END STATUS ON DUMP TRUE CLASS STYLE OUTLINECOLOR 0 0 0 COLOR 0 128 128 END END END # Cities END # Map File Somebody can help me? Thanks in advance. -- Iratxe Lejarreta www.axios.es ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
