[MAPSERVER-USERS] mapserver does not show oracle layer
Hi,
i´m having troubles shwoing a oracle layer in mapserver.
in open layers i´ve:
map = new OpenLayers.Map( 'map' ,
{
scales: [ 400,300,200,100, 50,20,
10, 5,2,1 ],
maxExtent: new OpenLayers.Bounds(-18,34,4,45),
numZoomLevels: 10
}
);
var basemap = new OpenLayers.Layer.WMS.Untiled( MS 4.10,
http://172.18.210.67:8080/cgi-bin/mapserv.exe?;,
{
map: '/ms4w/apps/wmssrvrefer/config.map',
layers: 'border', format: 'png', 'transparent': 'on'},
{ projection:EPSG:4326 } );
map.addLayers([basemap]);
map.setCenter(new OpenLayers.LonLat(-8, 39.5), 0);
In mapfile:
EXTENT -9 36 -6 42
projection
init=epsg:4326
end
web
IMAGEPATH /ms4w/tmp/ms_tmp/
IMAGEURL /ms_tmp/
metadata
wms_title test
wms_srs EPSG:4326
end
end
## this show the layer !
layer
name major_roads_small_4
group border
type line
projection
init=epsg:4326
end
status on
data railways.shp
class
style
color 0 0 0
width 1
antialias true
end
end
end
##
this layer does not show !!
#
layer
name road_a
group border
type line
projection
init=epsg:4326
end
connectiontype oraclespatial
connection uui/pwdmydb
data geom_73 from caop_regiao using srid 4326
class
style
color 185 175 155
width 3
antialias true
end
end
end
I test with shp2img and it shows the shapelayer, but not the oracle layer.
http://www.nabble.com/file/p18847632/test.png
What´s wrong ?
--
View this message in context:
http://www.nabble.com/mapserver-does-not-show-oracle-layer-tp18847632p18847632.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 does not show oracle layer
What do you get if you use shp2img with debug info?
shp2img -all_debug 10
Best regards,
Bart
Hi,
i´m having troubles shwoing a oracle layer in mapserver.
in open layers i´ve:
map = new OpenLayers.Map( 'map' ,
{
scales: [ 400,300,200,100, 50,20,
10, 5,2,1 ],
maxExtent: new OpenLayers.Bounds(-18,34,4,45),
numZoomLevels: 10
}
);
var basemap = new OpenLayers.Layer.WMS.Untiled( MS 4.10,
http://172.18.210.67:8080/cgi-bin/mapserv.exe?;,
{
map: '/ms4w/apps/wmssrvrefer/config.map',
layers: 'border', format: 'png', 'transparent': 'on'},
{ projection:EPSG:4326 } );
map.addLayers([basemap]);
map.setCenter(new OpenLayers.LonLat(-8, 39.5), 0);
In mapfile:
EXTENT -9 36 -6 42
projection
init=epsg:4326
end
web
IMAGEPATH /ms4w/tmp/ms_tmp/
IMAGEURL /ms_tmp/
metadata
wms_title test
wms_srs EPSG:4326
end
end
## this show the layer !
layer
name major_roads_small_4
group border
type line
projection
init=epsg:4326
end
status on
data railways.shp
class
style
color 0 0 0
width 1
antialias true
end
end
end
##
this layer does not show !!
#
layer
name road_a
group border
type line
projection
init=epsg:4326
end
connectiontype oraclespatial
connection uui/pwdmydb
data geom_73 from caop_regiao using srid 4326
class
style
color 185 175 155
width 3
antialias true
end
end
end
I test with shp2img and it shows the shapelayer, but not the oracle layer.
http://www.nabble.com/file/p18847632/test.png
What´s wrong ?
--
View this message in context:
http://www.nabble.com/mapserver-does-not-show-oracle-layer-tp18847632p18847632.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
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
RE: [MAPSERVER-USERS] mapserver does not show oracle layer
Are you certain that you have Oracle client installed and MapServer compile against it? Timothy J Nolte - [EMAIL PROTECTED] Network Planning Engineer iPCS Wireless, Inc. 4717 Broadmoor Ave, Suite G Kentwood, MI 49512 Office: 616-656-5163 PCS:616-706-2438 Fax:616-554-6484 Web: www.ipcswirelessinc.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of FCampos Sent: Wednesday, August 06, 2008 5:58 AM To: mapserver-users@lists.osgeo.org Subject: Re: [MAPSERVER-USERS] mapserver does not show oracle layer That´s strange because does not appear nothing about oracle layer. C:\ms4w\apps\wmssrvrefershp2img -m config.map -o test.png -all_debug 10 msLoadMap(): 0.031s msDrawMap(): Layer 0 (major_roads_small_4), 0.000s msDrawMap(): Drawing Label Cache, 0.000s msDrawMap() total time: 0.015s msSaveImage() total time: 0.047s msFreeMap(): freeing map at 0148B288. shp2img total time: 0.109s but the connection is good because i see in the log apache, when i make a wms request. it does not give any oracle error [Wed Aug 06 10:57:18 2008] [error] [client 172.18.202.178] msDrawMap(): Layer 1 (road_a), 0.938s\r, referer: http://127.0.0.1/justtests/maps/openlayes/ -- View this message in context: http://www.nabble.com/mapserver-does-not-show-oracle-layer-tp1 8847632p18847865.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 ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
RE: [MAPSERVER-USERS] mapserver does not show oracle layer
Yes. Mapserver, I´ve got: MapServer version 5.2.0 OUTPUT=GIF OUTPUT=PNG OUTPUT=JPEG OUTPUT=WBMP OUTPUT=PDF OUTPUT=SWF OUTPUT=SVG SUPPORTS=PROJ SUPPORTS=AGG SUPPORTS=FREETYPE SUPPORTS=ICO NV SUPPORTS=WMS_SERVER SUPPORTS=WMS_CLIENT SUPPORTS=WFS_SERVER SUPPORTS=WFS_CLIE NT SUPPORTS=WCS_SERVER SUPPORTS=SOS_SERVER SUPPORTS=FASTCGI SUPPORTS=THREADS SUP PORTS=GEOS SUPPORTS=RGBA_PNG INPUT=JPEG INPUT=POSTGIS INPUT=ORACLESPATIAL INPUT= OGR INPUT=GDAL INPUT=SHAPEFILE Oracle: instantclient 11.1 with a tnsnames.ora definition. If i put a bad sql, it gives a oci error, so it´s compiled. msOracleSpatialLayerWhichShapes(): OracleSpatial error. Error parsing OracleSpatial DATA variable. Must be:'geometry_column FROM table_name [USING UNIQUE column SRID srid# FUNCTION]' or ... -- View this message in context: http://www.nabble.com/mapserver-does-not-show-oracle-layer-tp18847632p18849791.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 does not show oracle layer
Well, I have no problems. I'm running the same version of MapServer 5.2, however I think I'm only running IC 10.2. What I have in my map file is; LAYER GROUP Switch Boundaries NAME Kentwood TYPE POLYGON STATUS OFF CONNECTIONTYPE oraclespatial CONNECTION username/[EMAIL PROTECTED] PROCESSING CLOSE_CONNECTION=DEFER DATA geom FROM (SELECT swt.switch_descr, sgt.geom FROM ms_switch_vw swt, switch_geom_tab sgt WHERE swt.switch_id = sgt.switch_id AND swt.switch_id = 5) USING SRID 8307 LABELITEM switch_descr METADATA static_legend 1 END DUMP true TRANSPARENCY 100 CLASS MINSCALE 520 MAXSCALE 4100 STYLE SYMBOL circle OUTLINECOLOR 80 80 80 SIZE 1 END END CLASS MINSCALE 0 MAXSCALE 520 STYLE SYMBOL circle OUTLINECOLOR 80 80 80 SIZE 2 END END END I have many layers like this that work without a problem. Timothy J Nolte - [EMAIL PROTECTED] Network Planning Engineer iPCS Wireless, Inc. 4717 Broadmoor Ave, Suite G Kentwood, MI 49512 Office: 616-656-5163 PCS:616-706-2438 Fax:616-554-6484 Web: www.ipcswirelessinc.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of FCampos Sent: Wednesday, August 06, 2008 8:10 AM To: mapserver-users@lists.osgeo.org Subject: RE: [MAPSERVER-USERS] mapserver does not show oracle layer Yes. Mapserver, I´ve got: MapServer version 5.2.0 OUTPUT=GIF OUTPUT=PNG OUTPUT=JPEG OUTPUT=WBMP OUTPUT=PDF OUTPUT=SWF OUTPUT=SVG SUPPORTS=PROJ SUPPORTS=AGG SUPPORTS=FREETYPE SUPPORTS=ICO NV SUPPORTS=WMS_SERVER SUPPORTS=WMS_CLIENT SUPPORTS=WFS_SERVER SUPPORTS=WFS_CLIE NT SUPPORTS=WCS_SERVER SUPPORTS=SOS_SERVER SUPPORTS=FASTCGI SUPPORTS=THREADS SUP PORTS=GEOS SUPPORTS=RGBA_PNG INPUT=JPEG INPUT=POSTGIS INPUT=ORACLESPATIAL INPUT= OGR INPUT=GDAL INPUT=SHAPEFILE Oracle: instantclient 11.1 with a tnsnames.ora definition. If i put a bad sql, it gives a oci error, so it´s compiled. msOracleSpatialLayerWhichShapes(): OracleSpatial error. Error parsing OracleSpatial DATA variable. Must be:'geometry_column FROM table_name [USING UNIQUE column SRID srid# FUNCTION]' or ... -- View this message in context: http://www.nabble.com/mapserver-does-not-show-oracle-layer-tp1 8847632p18849791.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 ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
re: [MAPSERVER-USERS] mapserver does not show oracle layer
Hi there, With my oracle spatial layers I use connection uui/[EMAIL PROTECTED], where the dbname is setup on your server using the oracle clients 'Net Manager'. Hope this helps, Josh Hevenor ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
RE: [MAPSERVER-USERS] mapserver does not show oracle layer
hi, how do you check the rigth srid in the oracle ? -- View this message in context: http://www.nabble.com/mapserver-does-not-show-oracle-layer-tp18847632p18850449.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: re: [MAPSERVER-USERS] mapserver does not show oracle layer
yes, that what i do ! Josh Hevenor-2 wrote: Hi there, With my oracle spatial layers I use connection uui/[EMAIL PROTECTED], where the dbname is setup on your server using the oracle clients 'Net Manager'. Hope this helps, Josh Hevenor ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users -- View this message in context: http://www.nabble.com/mapserver-does-not-show-oracle-layer-tp18847632p18850640.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 does not show oracle layer
i export the layer to shape and , and made ogrinfo and i´ve got: Geometry: Line String Feature Count: 5801 Extent: (-113613.582981, -286361.190557) - (108654.660386, 258019.490810) Layer SRS WKT: (unknown) What´s the Layer SRS WKT: (unknown) -- View this message in context: http://www.nabble.com/mapserver-does-not-show-oracle-layer-tp18847632p18853796.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
