Hi Can you
- Remove the store - Stop Geoserver and remove the logs/geoserver.log file - Start GeoServer - Switch the GeoServer Debug Level to "Geotools Debugging", - Add your store - Send me the logs/geoserver.log file (zipped or gzipped) Cheers Christian On Wed, Jan 6, 2016 at 11:41 PM, Ty Swavely <[email protected]> wrote: > Hello! > > I'm trying to add an ImageMosaicJDBC data store to my Geoserver 2.8.0 > instance, but am receiving this error: > > Error: could not list layers for this store, an error occurred retrieving > them: Failed to create reader from …. and hints null. > > I've spent some time searching for solutions, but thus far have been > stumped. A little background about the process: > > -Followed this link as tutorial/Mastering Geoserver book: > http://docs.geotools.org/latest/userguide/library/coverage/pgraster.html > > -local Geoserver version (2.8.0) matches ImageMosaicJDBC Plugin version > (gt-imagemosaic-jdbc-14.0), which is the 2.8.0 extension jar > > -able to create ImagePyramid in local data directory using same dataset, > able to preview layer created from ImagePyramid > > *Dataset:* > > 3 inch imagery from USGS covering small section of Maryland > > *Preprocessing:* > > -ImagePyramid processed using gdal_retile > > -ImageMosaicJDBC imported to Postgres using raster2pgsql > -populated public schema with md_3inch, o_2_md_3inch, o_4_md_3inch, > o_8_md_3inch, o_16_md_3inch > > *Metadata table:* > > `CREATE TABLE watersuite_raster_metadata > ( > coverage_name character varying(254) NOT NULL, > tiletable character varying(254) NOT NULL, > minx double precision, > miny double precision, > maxx double precision, > maxy double precision, > resx double precision, > resy double precision, > CONSTRAINT watersuite_raster_metadata_pkey PRIMARY KEY (coverage_name, > tiletable)` > > -Metadata table populated with record for each table. > > *XML Configuration files:* > > connect.pgraster.xml.inc > > <connect> > <dstype value="DBCP" /> > <username value="####" /> > <password value="####" /> > <jdbcUrl value="jdbc:postgresql://localhost:5432/Test" /> > <driverClassName value="org.postgresql.Driver" /> > <maxActive value="10" /> > <maxIdle value="0" /> > </connect> > > mapping.pgraster.xml.inc > > <spatialExtension name="pgraster"/> > <mapping> > <masterTable name="watersuite_raster_metadata" > > <coverageNameAttribute name="coverage_name" /> > <maxXAttribute name="maxx" /> > <maxYAttribute name="maxy" /> > <minXAttribute name="minx" /> > <minYAttribute name="miny" /> > <resXAttribute name="resx" /> > <resYAttribute name="resy" /> > <tileTableNameAttribute name="tiletable" /> > </masterTable> > <tileTable> > <blobAttributeName name="rast" /> > </tileTable> > </mapping> > > md3inch.pgraster.xml > > <?xml version="1.0" encoding="UTF-8" standalone="no"?> > <!DOCTYPE ImageMosaicJDBCConfig [ > <!ENTITY mapping PUBLIC "mapping" "mapping.pgraster.xml.inc"> > <!ENTITY connect PUBLIC "connect" "connect.pgraster.xml.inc">]> > <config version="1.0"> > <coverageName name="md_3inch"/> > <coordsys name="EPSG:4326"/> > <!-- interpolation 1 = nearest neighbor, 2 = bipolar, 3 = bicubic --> > <scaleop interpolation="1"/> > <axisOrder ignore ="false"/> > &mapping; > &connect; > > </config> > > Any help would be greatly appreciated! > > -- > Ty Swavely > GIS Analyst > Corona Environmental Consulting > > > ------------------------------------------------------------------------------ > > _______________________________________________ > Geoserver-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/geoserver-users > > -- DI Christian Mueller MSc (GIS), MSc (IT-Security) OSS Open Source Solutions GmbH
------------------------------------------------------------------------------
_______________________________________________ Geoserver-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users
