What is the best solution to publish postgis rasters using Geoserver?
I have spent a lot of time trying to create a Raster datasource using Image Mosaic JDBC but with no luck.
Steps performed:
1. Downloaded and Installed the JDBC Image Mosaic extension (worked ok)
2. Created the "Connection Parameter" files:
connect.postgis.xml.inc:
mapping.postgis.xml.inc:
osm.postgis.xml:
]> &mapping; &connect;where "mosaic" is a table (columns: name, titletable,minX,minY,maxX,maxY,resX,resY) containing one row: "gfm, testrastertable, , , , , , ,"
3. Saved the config files in ../geoserver/data_dir/coverages/
4. While trying to add an Image Mosaic JDBC data store I receive the following error:
Error: Could not list layers for this store, an error occurred retrieving them: Unable to acquire a reader for this coverage with format: ImageMosaicJDBC
Update: Geoserver log
2012-10-24 14:09:11,404 DEBUG [org.geoserver] - Thread 14 locking in mode WRITE2012-10-24 14:09:11,404 DEBUG [org.geoserver] - Thread 14 got the lock in mode WRITE2012-10-24 14:09:11,406 DEBUG [geoserver.config] - Persisting coverage store raster_store2012-10-24 14:09:11,408 DEBUG [geoserver.config] - Persisted org.geoserver.catalog.impl.CoverageStoreInfoImpl to /opt/geoserver/data_dir/workspaces/raster/raster_store/coveragestore.xml2012-10-24 14:09:11,416 DEBUG [geoserver.config] - Persisted $Proxy15 to /opt/geoserver/data_dir/global.xml2012-10-24 14:09:11,438 ERROR [imagemosaic.jdbc] - 2012-10-24 14:09:11,438 WARN [imagemosaic.jdbc] - java.io.IOException at org.geotools.gce.imagemosaic.jdbc.ImageMosaicJDBCReader.(ImageMosaicJDBCReader.java:163) at org.geotools.gce.imagemosaic.jdbc.ImageMosaicJDBCFormat.getReader(ImageMosaicJDBCFormat.java:209)....2012-10-24 14:09:11,439 INFO [geoserver.web] - Getting list of coverages for saved store file:coverages/osm.postgis.xmljava.lang.RuntimeException: Could not list layers for this store, an error occurred retrieving them: Unable to acquire a reader for this coverage with format: ImageMosaicJDBC at org.geoserver.web.data.layer.NewLayerPageProvider.getItems(NewLayerPageProvider.java:115)...Caused by: java.lang.Exception: Unable to acquire a reader for this coverage with format: ImageMosaicJDBC at org.geoserver.catalog.CatalogBuilder.buildCoverage(CatalogBuilder.java:812) at org.geoserver.web.data.layer.NewLayerPageProvider.getItems(NewLayerPageProvider.java:82) ... 95 more2012-10-24 14:09:11,441 DEBUG [geoserver.config] - Removing coverage store raster_store2012-10-24 14:09:11,446 DEBUG [geoserver.config] - Persisted $Proxy15 to /opt/geoserver/data_dir/global.xml2012-10-24 14:09:11,459 DEBUG [org.geoserver] - Thread 14 releasing the lock in mode WRITE
أكثر...
I have spent a lot of time trying to create a Raster datasource using Image Mosaic JDBC but with no luck.
Steps performed:
1. Downloaded and Installed the JDBC Image Mosaic extension (worked ok)
2. Created the "Connection Parameter" files:
connect.postgis.xml.inc:
mapping.postgis.xml.inc:
osm.postgis.xml:
]> &mapping; &connect;where "mosaic" is a table (columns: name, titletable,minX,minY,maxX,maxY,resX,resY) containing one row: "gfm, testrastertable, , , , , , ,"
3. Saved the config files in ../geoserver/data_dir/coverages/
4. While trying to add an Image Mosaic JDBC data store I receive the following error:
Error: Could not list layers for this store, an error occurred retrieving them: Unable to acquire a reader for this coverage with format: ImageMosaicJDBC
Update: Geoserver log
2012-10-24 14:09:11,404 DEBUG [org.geoserver] - Thread 14 locking in mode WRITE2012-10-24 14:09:11,404 DEBUG [org.geoserver] - Thread 14 got the lock in mode WRITE2012-10-24 14:09:11,406 DEBUG [geoserver.config] - Persisting coverage store raster_store2012-10-24 14:09:11,408 DEBUG [geoserver.config] - Persisted org.geoserver.catalog.impl.CoverageStoreInfoImpl to /opt/geoserver/data_dir/workspaces/raster/raster_store/coveragestore.xml2012-10-24 14:09:11,416 DEBUG [geoserver.config] - Persisted $Proxy15 to /opt/geoserver/data_dir/global.xml2012-10-24 14:09:11,438 ERROR [imagemosaic.jdbc] - 2012-10-24 14:09:11,438 WARN [imagemosaic.jdbc] - java.io.IOException at org.geotools.gce.imagemosaic.jdbc.ImageMosaicJDBCReader.(ImageMosaicJDBCReader.java:163) at org.geotools.gce.imagemosaic.jdbc.ImageMosaicJDBCFormat.getReader(ImageMosaicJDBCFormat.java:209)....2012-10-24 14:09:11,439 INFO [geoserver.web] - Getting list of coverages for saved store file:coverages/osm.postgis.xmljava.lang.RuntimeException: Could not list layers for this store, an error occurred retrieving them: Unable to acquire a reader for this coverage with format: ImageMosaicJDBC at org.geoserver.web.data.layer.NewLayerPageProvider.getItems(NewLayerPageProvider.java:115)...Caused by: java.lang.Exception: Unable to acquire a reader for this coverage with format: ImageMosaicJDBC at org.geoserver.catalog.CatalogBuilder.buildCoverage(CatalogBuilder.java:812) at org.geoserver.web.data.layer.NewLayerPageProvider.getItems(NewLayerPageProvider.java:82) ... 95 more2012-10-24 14:09:11,441 DEBUG [geoserver.config] - Removing coverage store raster_store2012-10-24 14:09:11,446 DEBUG [geoserver.config] - Persisted $Proxy15 to /opt/geoserver/data_dir/global.xml2012-10-24 14:09:11,459 DEBUG [org.geoserver] - Thread 14 releasing the lock in mode WRITE
أكثر...