Howard,<br><br>Is it possible we have a bad combination of libraries or something in our mapserv compile? it's like it doesn't understand the datastring coming out of mapserver. In the error message from gdal, it's prepending the filesystem path. So instead of it starting with SDE: it starts with /filepath/SDE:<br>
<br>Liz<br><br><br><br><div class="gmail_quote">On Tue, Nov 4, 2008 at 11:50 AM, Howard Butler <span dir="ltr"><<a href="mailto:hobu.inc@gmail.com">hobu.inc@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Liz,<br>
<br>
To use SDE raster data in MapServer, you must use GDAL compiled with SDE raster support. The "native" SDE raster support that was in MapServer was removed and no longer works.<br>
<br>
Ensure that your GDAL SDE raster is working with gdalinfo and then specify your layer as follows:<br>
<br>
<br>
LAYER<br>
<br>
TYPE RASTER<br>
DATA "SDE:<a href="http://sdemachine.iastate.edu" target="_blank">sdemachine.iastate.edu</a>,5151,database,username,password,fully.specified.tablename,RASTER"<br>
...<br>
<br>
END<div><div></div><div class="Wj3C7c"><br>
<br>
On Nov 4, 2008, at 9:41 AM, Liz Godwin wrote:<br>
<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
I'll give it a try. I didn't actually try it - I read the docs and it didn't suggest that it would support rasters.<br>
<br>
Liz<br>
<br>
On Tue, Nov 4, 2008 at 10:13 AM, Lucena, Ivan <<a href="mailto:ivan.lucena@pmldnet.com" target="_blank">ivan.lucena@pmldnet.com</a>> wrote:<br>
Ron,<br>
<br>
Some raster driver in GDAL are not flie based but RDBMS based but most of the softwares based on GDAL did not<br>
noticed that change. In those case, instead of a file path what you need is a identification string but those software<br>
usually have code to grab the file path, to check if the file really exist, to check other files on the same folder and<br>
that is where it crashes.<br>
<br>
What I suggest to Liz is to use a VRT file instead of the identification string. As you might know, a VRT file does not<br>
contain the data but a path to the real data set.<br>
<br>
I use that trick to load images direct from the RDBMS server to OpenEv and QuantumGIS:<br>
<br>
% gdal_translate -of VRT <the identification string of your dataset> <temporary.vrt><br>
... check if it works:<br>
% gdalinfo <temporary.vrt><br>
... check what is inside it:<br>
% more <temporary.vrt><br>
... load it:<br>
% openev <temporary.vrt><br>
% qgis<br>
... click on add layer<br>
... select your <temporary.vrt><br>
<br>
I thought that it would work for mapserve too...<br>
<br>
/filepath/<temporary.vrt><br>
<br>
But Liz tried and said it doesn't. Too bad, I was counting on it. ;(<br>
<br>
Regards,<br>
<br>
Ivan<br>
<br>
> -------Original Message-------<br>
> From: Ron Goldman <<a href="mailto:ron@ocean.org.il" target="_blank">ron@ocean.org.il</a>><br>
> Subject: [mapserver-users] Re: GDAL and SDE raster<br>
> Sent: Nov 04 '08 14:01<br>
><br>
> I had a similar problem with NetCDF raster. It probably won't help much for SDE<br>
> but make sure you have absolute filepath after the "SDE:" and not before it.<br>
><br>
><br>
> Date: Tue, 4 Nov 2008 08:24:52 -0500<br>
> From: "Liz Godwin" <<a href="mailto:godwin.liz@gmail.com" target="_blank">godwin.liz@gmail.com</a>><br>
> Subject: Re: [mapserver-users] GDAL and SDE raster<br>
> To: "Lucena, Ivan" <<a href="mailto:ivan.lucena@pmldnet.com" target="_blank">ivan.lucena@pmldnet.com</a>><br>
> Cc: <a href="mailto:eidsnessl@agr.gc.ca" target="_blank">eidsnessl@agr.gc.ca</a>, <a href="mailto:mapserver-users@lists.osgeo.org" target="_blank">mapserver-users@lists.osgeo.org</a>,<br>
> <a href="mailto:whittekerc@agr.gc.ca" target="_blank">whittekerc@agr.gc.ca</a><br>
> Message-ID:<br>
> <<a href="mailto:d33d7cc00811040524o6642e27w234e060f5ed87cd4@mail.gmail.com" target="_blank">d33d7cc00811040524o6642e27w234e060f5ed87cd4@mail.gmail.com</a>><br>
> Content-Type: text/plain; charset="iso-8859-1"<br>
><br>
><br>
> Thank you, but that option doesn't appear to work for Raster data types.<br>
><br>
><br>
> Liz<br>
><br>
><br>
> On Mon, Nov 3, 2008 at 7:40 PM, Lucena, Ivan <<a href="mailto:ivan.lucena@pmldnet.com" target="_blank">ivan.lucena@pmldnet.com</a>>wrote:<br>
><br>
><br>
> > > I don't have SDE to tell you the truth but I would suggest you to create a<br>
> > > VRT version of your dataset and use the VRT on your map file. [<br>
> > > gdal_translate -of vrt<br>
> > > /filepath/SDE:server,port:5151,sde,user/pass,schema.table,RASTER<br>
> > > replacement.vrt ]<br>
> > ><br>
> ><br>
> >> > > -------Original Message-------<br>
> >> > > From: Liz Godwin <<a href="mailto:godwin.liz@gmail.com" target="_blank">godwin.liz@gmail.com</a>><br>
> >> > > Subject: [mapserver-users] GDAL and SDE raster<br>
> >> > > Sent: Nov 03 '08 22:19<br>
> >> > ><br>
> >> > > Hey folks,<br>
> >> > ><br>
> >> > > We've been beating ourselves up over this problem and I'm not sure<br>
> >> > > what to try next.<br>
> >> > ><br>
> >> > > We can't seem to connect to SDE for a raster using GDAL in mapserver.<br>
> >> > > This is happening on Linux.<br>
> >> > ><br>
> >> > > snippit from mapfile:<br>
> >> > > TYPE RASTER<br>
> >> > > DATA "SDE:server,port:5151,sde,user,pass,schema.table,RASTER"<br>
> >> > ><br>
> >> > > when trying to draw a map, i get a seg fault. When trying a<br>
> >> > > getFeatureinfo request, I get this error:<br>
> >> > ><br>
> >> > > /filepath/SDE:server,port:5151,sde,user: Image handling error. Unable to<br>
> >> > > open file LayerName for layer<br>
> >> > > `/filepath/SDE:server,port:5151,sde,user/pass,schema.table,RASTER' does<br>
> >> > > not exist in the file system, and is not recognised as a supported<br>
> >><br>
> > > dataset<br>
> ><br>
> >> > > name.<br>
> >> > > ... fatal error.<br>
> >> > > msRasterQueryByRect()<br>
> >> > ><br>
> >> > > Any ideas how I might start to debug this? I have DEBUG set to 5 in<br>
> >><br>
> > > both<br>
> ><br>
> >> > > the LAYER and MAP object in the map file.<br>
> >> > ><br>
> >> > > Thanks!<br>
> >> > ><br>
> >> > > Liz<br>
> >> > ><br>
> >> > > --------------------<br>
> >> > > _______________________________________________<br>
> >> > > mapserver-users mailing list<br>
> >> > > [LINK: compose.php?to=<a href="mailto:mapserver-users@lists.osgeo.org" target="_blank">mapserver-users@lists.osgeo.org</a>]<br>
> >> > > <a href="mailto:mapserver-users@lists.osgeo.org" target="_blank">mapserver-users@lists.osgeo.org</a><br>
> >> > > [LINK: <a href="http://lists.osgeo.org/mailman/listinfo/mapserver-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/mapserver-users</a>]<br>
> >> > > <a href="http://lists.osgeo.org/mailman/listinfo/mapserver-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/mapserver-users</a><br>
> >><br>
> > ><br>
> ><br>
> -------------- next part --------------<br>
> An HTML attachment was scrubbed...<br>
> URL: <a href="http://lists.osgeo.org/pipermail/mapserver-users/attachments/20081104/fee291c7/attachment.html" target="_blank">http://lists.osgeo.org/pipermail/mapserver-users/attachments/20081104/fee291c7/attachment.html</a><br>
><br>
> ------------------------------<br>
><br>
> _______________________________________________<br>
><br>
> mapserver-users mailing list<br>
> <a href="mailto:mapserver-users@lists.osgeo.org" target="_blank">mapserver-users@lists.osgeo.org</a><br>
> <a href="http://lists.osgeo.org/mailman/listinfo/mapserver-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/mapserver-users</a><br>
><br>
><br>
><br>
> ***********************************************************<br>
> This outgoing email was scanned for viruses and other malicious content by the IT Department of Israel<br>
Oceanographic & Limnological Research.<br>
> AntiVirus system managed by Eli W. Tel. 972-4-8565267<br>
> IMPORTANT: Do not open attachments from unrecognized senders.<br>
> Never open attached files with extensions: *.pif, *.scr, *.vbs, *.exe.<br>
><br>
***********************************************************________________________________<br>
_______________<br>
> mapserver-users mailing list<br>
> <a href="mailto:mapserver-users@lists.osgeo.org" target="_blank">mapserver-users@lists.osgeo.org</a><br>
> <a href="http://lists.osgeo.org/mailman/listinfo/mapserver-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/mapserver-users</a><br>
><br>
<br>
<br>
_______________________________________________<br>
mapserver-users mailing list<br>
<a href="mailto:mapserver-users@lists.osgeo.org" target="_blank">mapserver-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/mapserver-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/mapserver-users</a><br>
</blockquote>
<br>
</div></div></blockquote></div><br>