[Geoserver-users] imagemosaic-jdbc failed with "Could not list layers for this store"

GeoServer GeoServer User
1

hello everybody,

i tried to follow the tutorial http://docs.geoserver.org/stable/en/user/tutorials/imagemosaic-jdbc/imagemosaic-jdbc_tutorial.html

everything is ok until i tried to add a store in geoserver, imagemosaic-jdbc failed with this message :

ImageMosaicJDBC - Image mosaicking/pyramidal jdbc plugin

Paramètres de connexion
URL : file:coverages/start_postgis.xml

Could not list layers for this store, an error occurred retrieving them: Failed to create reader from file:coverages/start_postgis.xml and hints null

what did i do ?

1) rgb2pct -of png start_rgb.png start.png
Attached to the email you can find the gdalinfo of start.png

2) gdal_retile.py -co "WORLDFILE=YES" -r bilinear -ps 128 128 -of PNG -levels 2 -targetDir tiles_start start.png

  1. here are the three xml files I used to configure the mosaic, attached to this email.
  • connect.postgis.xml.inc
  • mapping.postgis.xml.inc
  • start_postgis.xml
  1. i used ddl to generate sql scripts

mkdir sqlscripts
java -jar /var/lib/tomcat8/webapps/geoserver/WEB-INF/lib/gt-imagemosaic-jdbc-14.1.jar ddl \
-config /var/lib/tomcat8/webapps/geoserver/data/coverages/start_postgis.xml \
-spatialTNPrefix tile_start \
-pyramids 2 \
-statementDelim ";" \
-srs 4326 \
-targetDir sqlscripts

  1. the tables were created :
    psql geoserver -U geoserver -W < sqlscripts/createmeta.sql
    psql geoserver -U geoserver -W < sqlscripts/add_start.sql

  2. the following statement imported the tiles including all pyramids into the database
    java -jar /var/lib/tomcat8/webapps/geoserver/WEB-INF/lib/gt-imagemosaic-jdbc-14.1.jar import \
    -config /var/lib/tomcat8/webapps/geoserver/data/coverages/start_postgis.xml \
    -spatialTNPrefix tile_start \
    -tileTNPrefix tile_start \
    -dir tiles_start \
    -ext png

the table tile_start_0 contains 45 records, but zero record in tables tile_start_1 and tile_start_2.

  1. and then the plugin failed when i try to add a new store… :-\

in attachment, you will find the geoserver.log

I have searched on the archives without finding any hints on how to solve this issue.
i appreciated this discussion : http://osgeo-org.1560.x6.nabble.com/ImageMosaic-JDBC-plugin-fails-with-GeoServer-2-5-1-and-PostGIS-2-1-3-td5152829.html
but the problem is not the same.

my configuration :

geoserver-2.8.1
gt-imagemosaic-jdbc-14.1
postgresql-9.4-postgis-2.1
postgresql-9.4-1201-jdbc41.jar (in jre/lib/ext)

Thank you for your attention

Ernest.

connect.postgis.xml.inc (350 Bytes)

(Attachment gdalinfo_start.png is missing)

geoserver.log (26.3 KB)

mapping.postgis.xml.inc (924 Bytes)

start_postgis.xml (476 Bytes)

··· 
-- 
Ernest CHIARELLO  -  [Ernest.Chiarello@anonymised.com](mailto:Ernest.Chiarello@anonymised.com)
UMR6049 ThéMA - Théoriser et Modiliser pour Aménager
CNRS / université de Bourgogne Franche-Comté
32 rue Mégevand 25030 BESANÇON Cedex

Tel : 03 81 66 54 80           Mob : 07 82 99 11 08