RE: [MAPSERVER-USERS] mapserver does not show oracle layer

2008-08-06 Thread FCampos 

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

Re: re: [MAPSERVER-USERS] mapserver does not show oracle layer

2008-08-06 Thread FCampos 

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

2008-08-06 Thread FCampos 

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: [MAPSERVER-USERS] mapserver does not show oracle layer

2008-08-06 Thread Josh Hevenor 
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

2008-08-06 Thread Nolte, Tim 
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  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

2008-08-06 Thread FCampos 

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

2008-08-06 Thread Nolte, Tim 
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\wmssrvrefer>shp2img -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

2008-08-06 Thread FCampos 

That´s strange because does not appear nothing about oracle layer.

C:\ms4w\apps\wmssrvrefer>shp2img -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-tp18847632p18847865.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

2008-08-06 Thread bartvde 
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