raster query broken on SDE raster

[bartvde]

Currently WMS GetFeatureInfo, which results in a raster query, does not work for SDE raster layers accessed through GDAL. Errors you get are something like:

/data/geopakhuis/SDE:geodatabase.ad.rws.nl,5151,SDE,RWS_LEZEN,R: Image handling error. Unable to open
 file AAA14 for layer `/data/geopakhuis/SDE:geodatabase.ad.rws.nl,5151,SDE,RWS_LEZEN,RWS_LEZEN,HOOGTE
.AHN_100,RASTER' does not exist in the file system,
and is not recognised as a supported dataset name.
 ... fatal error.
msRasterQueryByRect()

I've tested the following fix for maprasterquery.c but the disadvantage is that with new GDAL database drivers things will need to be expanded again:

        if (strstr(filename, "SDE:") == NULL) {
          hDS = GDALOpen(
            msBuildPath3( szPath, map->mappath, map->shapepath, filename ),
            GA_ReadOnly );
        } else {
          hDS = GDALOpen(filename, GA_ReadOnly);
        }

TIA

[warmerdam]

The proper fix will presumably be to use the same path building logic as in the drawing code. I'll dig into this as time permits.

[bartvde]

Another issue is that Mapserver outputs the database password in the error message ....

[bartvde]

Frank, any news on this?

[warmerdam]

I am not aware of any progress on this.

[warmerdam]

I believe the fix for #3253 also fixes this for SDE. Any chance you could test with trunk, and make notes on if it works in #3253?

[warmerdam]

I have forked the password encryption aspect as #3416.