[Geoserver-users] ImageMosaic-JDBC Tutorial Issues

Weiss_Kevin · August 5, 2013, 8:39pm

I'm trying to configure an ImageMosaic-JDBC coverage per the instructions (http://docs.geoserver.org/2.3.0/user/tutorials/imagemosaic-jdbc/imagemosaic-jdbc_tutorial.html) and keep getting the following error "Could not list layers for this store, an error occurred retrieving them: Argument "value" should not be null."

I've searched through the mailing list and have seen similar threads, but can't find a solution to the problem. If anyone can help me out I'd appreciate it. I'll attach pastebin links for the typically requested files.

The system is GeoServer 2.3.0 with the WPS and ImagePyramid plugins added. Java 1.6.0_38 running on a CentOS 6 box and a postgres-9.2/PostGIS 2.0 database.

As a side note, my end goal is to construct a Raster Catalog containing temporal imagery which can be retrieved and looped via GeoServer with the rasters being persisted in postgres/postgis. If anyone has accomplished something similar and is willing to give me some help or tips I would greatly appreciate it.

Here is the relevant stacktrace from geoserver.log
http://pastebin.com/trL6zpmX

osm.postgis.xml
http://pastebin.com/x0KaJB0n

mapping.postgis.xml.inc
http://pastebin.com/KLpFDmtK

connect.postgis.xml.inc
http://pastebin.com/P8FwtcKS

Thanks,

Kevin M. Weiss

Christian_Mueller · August 6, 2013, 10:15am

Hi Kevin

A question, do you want to use PostGis Raster columns as described here
http://docs.geoserver.org/stable/en/user/data/raster/postgisraster.html

or do you want to use Blobs for your image data.

At the moment, I have no access to pastebin.com due to firewall rules of my customer.

Cheers
Christian

···

On Mon, Aug 5, 2013 at 10:39 PM, Weiss, Kevin <kweiss01@anonymised.com> wrote:

I’m trying to configure an ImageMosaic-JDBC coverage per the instructions (http://docs.geoserver.org/2.3.0/user/tutorials/imagemosaic-jdbc/imagemosaic-jdbc_tutorial.html) and keep getting the following error “Could not list layers for this store, an error occurred retrieving them: Argument “value” should not be null.”

I’ve searched through the mailing list and have seen similar threads, but can’t find a solution to the problem. If anyone can help me out I’d appreciate it. I’ll attach pastebin links for the typically requested files.

The system is GeoServer 2.3.0 with the WPS and ImagePyramid plugins added. Java 1.6.0_38 running on a CentOS 6 box and a postgres-9.2/PostGIS 2.0 database.

As a side note, my end goal is to construct a Raster Catalog containing temporal imagery which can be retrieved and looped via GeoServer with the rasters being persisted in postgres/postgis. If anyone has accomplished something similar and is willing to give me some help or tips I would greatly appreciate it.

Here is the relevant stacktrace from geoserver.log
http://pastebin.com/trL6zpmX

osm.postgis.xml
http://pastebin.com/x0KaJB0n

mapping.postgis.xml.inc
http://pastebin.com/KLpFDmtK

connect.postgis.xml.inc
http://pastebin.com/P8FwtcKS

Thanks,

Kevin M. Weiss

Get your SQL database under version control now!
Version control is standard for application code, but databases havent
caught up. So what steps can you take to put your SQL databases under
version control? Why should you start doing it? Read more to find out.
http://pubads.g.doubleclick.net/gampad/clk?id=49501711&iu=/4140/ostg.clktrk

Geoserver-users mailing list
Geoserver-users@anonymised.comsts.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

–

DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH

Weiss_Kevin · August 6, 2013, 11:44am

Hello Christian,

For the purpose of the exercise I was using the Blobs for image data storage. With regards to my end goal, I’m not sold on one approach over the other. I’m just looking to prototype a solution that allows me to programmatically store spatial imagery in the database from a java application and have it available for display via GeoServer while allowing temporal queries. Along the lines of looping weather radar imagery.

Any help you could provide in either direction would be great.

Is there a preferred location for providing stack traces and such? I didn’t want to attach the files and spam the whole mailing list.

Thanks,

Kevin M. Weiss

···

From: Christian Mueller [mailto:christian.mueller@anonymised.com]
Sent: Tuesday, August 06, 2013 5:16 AM
To: Weiss, Kevin
Cc: geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] ImageMosaic-JDBC Tutorial Issues

Hi Kevin

A question, do you want to use PostGis Raster columns as described here

http://docsgeoserver.org/stable/en/user/data/raster/postgisraster.html

or do you want to use Blobs for your image data.

At the moment, I have no access to pastebin.com due to firewall rules of my customer.

Cheers

Christian

On Mon, Aug 5, 2013 at 10:39 PM, Weiss, Kevin <kweiss01@anonymised.com> wrote:

I’m trying to configure an ImageMosaic-JDBC coverage per the instructions (http://docs.geoserver.org/2.3.0/user/tutorials/imagemosaic-jdbc/imagemosaic-jdbc_tutorial.html) and keep getting the following error “Could not list layers for this store, an error occurred retrieving them: Argument “value” should not be null.”

I’ve searched through the mailing list and have seen similar threads, but can’t find a solution to the problem. If anyone can help me out I’d appreciate it. I’ll attach pastebin links for the typically requested files.

The system is GeoServer 2.3.0 with the WPS and ImagePyramid plugins added. Java 1.6.0_38 running on a CentOS 6 box and a postgres-9.2/PostGIS 2.0 database.

As a side note, my end goal is to construct a Raster Catalog containing temporal imagery which can be retrieved and looped via GeoServer with the rasters being persisted in postgres/postgis. If anyone has accomplished something similar and is willing to give me some help or tips I would greatly appreciate it.

Here is the relevant stacktrace from geoserver.log
http://pastebin.com/trL6zpmX

osm.postgis.xml
http://pastebin.com/x0KaJB0n

mapping.postgis.xml.inc
http://pastebin.com/KLpFDmtK

connect.postgis.xml.inc
http://pastebin.com/P8FwtcKS

Thanks,

Kevin M. Weiss

Get your SQL database under version control now!
Version control is standard for application code, but databases havent
caught up. So what steps can you take to put your SQL databases under
version control? Why should you start doing it? Read more to find out.
http://pubads.g.doubleclick.net/gampad/clk?id=49501711&iu=/4140/ostg.clktrk

Geoserver-users mailing list
Geoserver-users@anonymised.comsts.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

–

DI Christian Mueller MSc (GIS), MSc (IT-Security)

OSS Open Source Solutions GmbH

Christian_Mueller · August 6, 2013, 12:41pm

Hi Kevin

I would use PostGis raster columns.

Using pastebin.com for stack traces is ok, will have a look at it later.

About temporal queries. Do you want to use the “time” parameter in WMS requests ? I never used it and the imagemosiac-JDBC module has no temporal support !!!

Cheers
Christian

···

On Tue, Aug 6, 2013 at 1:44 PM, Weiss, Kevin <kweiss01@anonymised.com> wrote:

Hello Christian,

For the purpose of the exercise I was using the Blobs for image data storage. With regards to my end goal, I’m not sold on one approach over the other. I’m just looking to prototype a solution that allows me to programmatically store spatial imagery in the database from a java application and have it available for display via GeoServer while allowing temporal queries. Along the lines of looping weather radar imagery.

Any help you could provide in either direction would be great.

Is there a preferred location for providing stack traces and such? I didn’t want to attach the files and spam the whole mailing list.

Thanks,

Kevin M. Weiss

From: Christian Mueller [mailto:christian.mueller@anonymised.com]
Sent: Tuesday, August 06, 2013 5:16 AM
To: Weiss, Kevin
Cc: geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] ImageMosaic-JDBC Tutorial Issues

Hi Kevin

A question, do you want to use PostGis Raster columns as described here

http://docsgeoserver.org/stable/en/user/data/raster/postgisraster.html

or do you want to use Blobs for your image data.

At the moment, I have no access to pastebin.com due to firewall rules of my customer.

Cheers

Christian

On Mon, Aug 5, 2013 at 10:39 PM, Weiss, Kevin <kweiss01@anonymised.com> wrote:

I’m trying to configure an ImageMosaic-JDBC coverage per the instructions (http://docs.geoserver.org/2.3.0/user/tutorials/imagemosaic-jdbc/imagemosaic-jdbc_tutorial.html) and keep getting the following error “Could not list layers for this store, an error occurred retrieving them: Argument “value” should not be null.”

I’ve searched through the mailing list and have seen similar threads, but can’t find a solution to the problem. If anyone can help me out I’d appreciate it. I’ll attach pastebin links for the typically requested files.

The system is GeoServer 2.3.0 with the WPS and ImagePyramid plugins added. Java 1.6.0_38 running on a CentOS 6 box and a postgres-9.2/PostGIS 2.0 database.

As a side note, my end goal is to construct a Raster Catalog containing temporal imagery which can be retrieved and looped via GeoServer with the rasters being persisted in postgres/postgis. If anyone has accomplished something similar and is willing to give me some help or tips I would greatly appreciate it.

Here is the relevant stacktrace from geoserver.log
http://pastebin.com/trL6zpmX

osm.postgis.xml
http://pastebin.com/x0KaJB0n

mapping.postgis.xml.inc
http://pastebin.com/KLpFDmtK

connect.postgis.xml.inc
http://pastebin.com/P8FwtcKS

Thanks,

Kevin M. Weiss

Get your SQL database under version control now!
Version control is standard for application code, but databases havent
caught up. So what steps can you take to put your SQL databases under
version control? Why should you start doing it? Read more to find out.
http://pubads.g.doubleclick.net/gampad/clk?id=49501711&iu=/4140/ostg.clktrk

Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

–

DI Christian Mueller MSc (GIS), MSc (IT-Security)

OSS Open Source Solutions GmbH

–

DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH

Weiss_Kevin · August 6, 2013, 1:38pm

Hello Christian,

Yes, I was hoping to use the “time” parameter in WMS. I had prototyped an example using the time & elevation tutorial (link below) a while back and just assumed that the ImageMosaic-JDBC was an extension of the ImageMosaic plugin and would support time-series as well.
http://docs.geoserver.org/latest/en/user/tutorials/imagemosaic_timeseries/imagemosaic_timeseries.html#tutorial-imagemosaic-timeseries

Is this the best tutorial for configuring GeoServer with PostGIS Raster? Even if it doesn’t support the time parameter, I’d at least like to get a prototype running.
http://docs.geotools.org/latest/userguide/library/coverage/pgraster.html

Thanks,

Kevin M. Weiss

···

From: Christian Mueller [mailto:christian.mueller@anonymised.com]
Sent: Tuesday, August 06, 2013 7:42 AM
To: Weiss, Kevin
Cc: geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] ImageMosaic-JDBC Tutorial Issues

Hi Kevin

I would use PostGis raster columns.

Using pastebin.com for stack traces is ok, will have a look at it later.

About temporal queries. Do you want to use the “time” parameter in WMS requests ? I never used it and the imagemosiac-JDBC module has no temporal support !!!

Cheers

Christian

On Tue, Aug 6, 2013 at 1:44 PM, Weiss, Kevin <kweiss01@anonymised.com> wrote:

Hello Christian,

For the purpose of the exercise I was using the Blobs for image data storage. With regards to my end goal, I’m not sold on one approach over the other. I’m just looking to prototype a solution that allows me to programmatically store spatial imagery in the database from a java application and have it available for display via GeoServer while allowing temporal queries. Along the lines of looping weather radar imagery.

Any help you could provide in either direction would be great.

Is there a preferred location for providing stack traces and such? I didn’t want to attach the files and spam the whole mailing list.

Thanks,

Kevin M. Weiss

From: Christian Mueller [mailto:christian.mueller@anonymised.com]
Sent: Tuesday, August 06, 2013 5:16 AM
To: Weiss, Kevin
Cc: geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] ImageMosaic-JDBC Tutorial Issues

Hi Kevin

A question, do you want to use PostGis Raster columns as described here

http://docsgeoserver.org/stable/en/user/data/raster/postgisraster.html

or do you want to use Blobs for your image data.

At the moment, I have no access to pastebin.com due to firewall rules of my customer.

Cheers

Christian

On Mon, Aug 5, 2013 at 10:39 PM, Weiss, Kevin <kweiss01@anonymised.com> wrote:

I’m trying to configure an ImageMosaic-JDBC coverage per the instructions (http://docs.geoserver.org/2.3.0/user/tutorials/imagemosaic-jdbc/imagemosaic-jdbc_tutorial.html) and keep getting the following error “Could not list layers for this store, an error occurred retrieving them: Argument “value” should not be null.”

I’ve searched through the mailing list and have seen similar threads, but can’t find a solution to the problem. If anyone can help me out I’d appreciate it. I’ll attach pastebin links for the typically requested files.

The system is GeoServer 2.3.0 with the WPS and ImagePyramid plugins added. Java 1.6.0_38 running on a CentOS 6 box and a postgres-9.2/PostGIS 2.0 database.

As a side note, my end goal is to construct a Raster Catalog containing temporal imagery which can be retrieved and looped via GeoServer with the rasters being persisted in postgres/postgis. If anyone has accomplished something similar and is willing to give me some help or tips I would greatly appreciate it.

Here is the relevant stacktrace from geoserver.log
http://pastebin.com/trL6zpmX

osm.postgis.xml
http://pastebin.com/x0KaJB0n

mapping.postgis.xml.inc
http://pastebin.com/KLpFDmtK

connect.postgis.xml.inc
http://pastebin.com/P8FwtcKS

Thanks,

Kevin M. Weiss

Get your SQL database under version control now!
Version control is standard for application code, but databases havent
caught up. So what steps can you take to put your SQL databases under
version control? Why should you start doing it? Read more to find out.
http://pubads.g.doubleclick.net/gampad/clk?id=49501711&iu=/4140/ostg.clktrk

Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

–

DI Christian Mueller MSc (GIS), MSc (IT-Security)

OSS Open Source Solutions GmbH

–

DI Christian Mueller MSc (GIS), MSc (IT-Security)

OSS Open Source Solutions GmbH

Christian_Mueller · August 6, 2013, 2:03pm

The imagemosiac-jdbc is NOT an extension of the ImageMosaic plugin and lacks temporal support.

The tutorial link in your previous mail is a good starting point.

Cheers
Christian

···

On Tue, Aug 6, 2013 at 3:38 PM, Weiss, Kevin <kweiss01@anonymised.com740…> wrote:

Hello Christian,

Yes, I was hoping to use the “time” parameter in WMS. I had prototyped an example using the time & elevation tutorial (link below) a while back and just assumed that the ImageMosaic-JDBC was an extension of the ImageMosaic plugin and would support time-series as well.
http://docs.geoserver.org/latest/en/user/tutorials/imagemosaic_timeseries/imagemosaic_timeseries.html#tutorial-imagemosaic-timeseries

Is this the best tutorial for configuring GeoServer with PostGIS Raster? Even if it doesn’t support the time parameter, I’d at least like to get a prototype running.
http://docs.geotools.org/latest/userguide/library/coverage/pgraster.html

Thanks,

Kevin M. Weiss

From: Christian Mueller [mailto:christian.mueller@anonymised.com]
Sent: Tuesday, August 06, 2013 7:42 AM

To: Weiss, Kevin
Cc: geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] ImageMosaic-JDBC Tutorial Issues

Hi Kevin

I would use PostGis raster columns.

Using pastebin.com for stack traces is ok, will have a look at it later.

About temporal queries. Do you want to use the “time” parameter in WMS requests ? I never used it and the imagemosiac-JDBC module has no temporal support !!!

Cheers

Christian

On Tue, Aug 6, 2013 at 1:44 PM, Weiss, Kevin <kweiss01@anonymised.com> wrote:

Hello Christian,

For the purpose of the exercise I was using the Blobs for image data storage. With regards to my end goal, I’m not sold on one approach over the other. I’m just looking to prototype a solution that allows me to programmatically store spatial imagery in the database from a java application and have it available for display via GeoServer while allowing temporal queries. Along the lines of looping weather radar imagery.

Any help you could provide in either direction would be great.

Is there a preferred location for providing stack traces and such? I didn’t want to attach the files and spam the whole mailing list.

Thanks,

Kevin M. Weiss

From: Christian Mueller [mailto:christian.mueller@anonymised.com]
Sent: Tuesday, August 06, 2013 5:16 AM
To: Weiss, Kevin
Cc: geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] ImageMosaic-JDBC Tutorial Issues

Hi Kevin

A question, do you want to use PostGis Raster columns as described here

http://docsgeoserver.org/stable/en/user/data/raster/postgisraster.html

or do you want to use Blobs for your image data.

At the moment, I have no access to pastebin.com due to firewall rules of my customer.

Cheers

Christian

On Mon, Aug 5, 2013 at 10:39 PM, Weiss, Kevin <kweiss01@anonymised.com> wrote:

I’m trying to configure an ImageMosaic-JDBC coverage per the instructions (http://docs.geoserver.org/2.3.0/user/tutorials/imagemosaic-jdbc/imagemosaic-jdbc_tutorial.html) and keep getting the following error “Could not list layers for this store, an error occurred retrieving them: Argument “value” should not be null.”

I’ve searched through the mailing list and have seen similar threads, but can’t find a solution to the problem. If anyone can help me out I’d appreciate it. I’ll attach pastebin links for the typically requested files.

The system is GeoServer 2.3.0 with the WPS and ImagePyramid plugins added. Java 1.6.0_38 running on a CentOS 6 box and a postgres-9.2/PostGIS 2.0 database.

As a side note, my end goal is to construct a Raster Catalog containing temporal imagery which can be retrieved and looped via GeoServer with the rasters being persisted in postgres/postgis. If anyone has accomplished something similar and is willing to give me some help or tips I would greatly appreciate it.

Here is the relevant stacktrace from geoserver.log
http://pastebin.com/trL6zpmX

osm.postgis.xml
http://pastebin.com/x0KaJB0n

mapping.postgis.xml.inc
http://pastebin.com/KLpFDmtK

connect.postgis.xml.inc
http://pastebin.com/P8FwtcKS

Thanks,

Kevin M. Weiss

Get your SQL database under version control now!
Version control is standard for application code, but databases havent
caught up. So what steps can you take to put your SQL databases under
version control? Why should you start doing it? Read more to find out.
http://pubads.g.doubleclick.net/gampad/clk?id=49501711&iu=/4140/ostg.clktrk

Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

–

DI Christian Mueller MSc (GIS), MSc (IT-Security)

OSS Open Source Solutions GmbH

–

DI Christian Mueller MSc (GIS), MSc (IT-Security)

OSS Open Source Solutions GmbH

–

DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH

Weiss_Kevin · August 6, 2013, 3:37pm

Christian,

I have followed the PostGIS raster tutorial and seemed to have ended up in the same situation as before. When I try to add the ImageMosaic-JDBC store I receive the dreaded “Could not list layers for this store, an error occurred retrieving them: Argument “value” should not be null.” error.

Here are the steps I took.

I loaded the raster into the DB:

raster2pgsql –I –C –s 4326 satellite.png public.satellite > pgraster.sql

psql –U xxxx –d xxxx –h xxxx –f pgraster.sql

Then I created the mosaic table using the sql in the tutorial and added a row for my previously loaded raster:

insert into mosaic (name, tiletable) values (‘satellite’, ‘satellite’);

Then I created the mapping, connect and coverage xml files as described in the tutorial only modifying the DB connection info and the coverageName value in the coverage xml file to match the value in the mosaic table.

One thing I’ve noticed is that despite my coverageName specifying ‘satellite’ all lower case, I get an error stating “No level available for Satellite” in the GeoServer logs. When I update the name in the mosaic table to ‘Satellite’ then I get a NullPointerException in ImageMosaicJDBCReader line 164. I’m not sure why it would auto-capitalize my coverage name as all the references I’ve made are lower case.

Kevin M. Weiss

···

From: Christian Mueller [mailto:christian.mueller@anonymised.com]
Sent: Tuesday, August 06, 2013 9:04 AM
To: Weiss, Kevin
Cc: geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] ImageMosaic-JDBC Tutorial Issues

The imagemosiac-jdbc is NOT an extension of the ImageMosaic plugin and lacks temporal support.

The tutorial link in your previous mail is a good starting point.

Cheers

Christian

On Tue, Aug 6, 2013 at 3:38 PM, Weiss, Kevin <kweiss01@anonymised.com> wrote:

Hello Christian,

Yes, I was hoping to use the “time” parameter in WMS. I had prototyped an example using the time & elevation tutorial (link below) a while back and just assumed that the ImageMosaic-JDBC was an extension of the ImageMosaic plugin and would support time-series as well.
http://docs.geoserver.org/latest/en/user/tutorials/imagemosaic_timeseries/imagemosaic_timeseries.html#tutorial-imagemosaic-timeseries

Is this the best tutorial for configuring GeoServer with PostGIS Raster? Even if it doesn’t support the time parameter, I’d at least like to get a prototype running.
http://docs.geotools.org/latest/userguide/library/coverage/pgraster.html

Thanks,

Kevin M. Weiss

From: Christian Mueller [mailto:christian.mueller@anonymised.com]
Sent: Tuesday, August 06, 2013 7:42 AM

To: Weiss, Kevin
Cc: geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] ImageMosaic-JDBC Tutorial Issues

Hi Kevin

I would use PostGis raster columns.

Using pastebin.com for stack traces is ok, will have a look at it later.

About temporal queries. Do you want to use the “time” parameter in WMS requests ? I never used it and the imagemosiac-JDBC module has no temporal support !!!

Cheers

Christian

On Tue, Aug 6, 2013 at 1:44 PM, Weiss, Kevin <kweiss01@anonymised.com> wrote:

Hello Christian,

For the purpose of the exercise I was using the Blobs for image data storage. With regards to my end goal, I’m not sold on one approach over the other. I’m just looking to prototype a solution that allows me to programmatically store spatial imagery in the database from a java application and have it available for display via GeoServer while allowing temporal queries. Along the lines of looping weather radar imagery.

Any help you could provide in either direction would be great.

Is there a preferred location for providing stack traces and such? I didn’t want to attach the files and spam the whole mailing list.

Thanks,

Kevin M. Weiss

From: Christian Mueller [mailto:christian.mueller@anonymised.com]
Sent: Tuesday, August 06, 2013 5:16 AM
To: Weiss, Kevin
Cc: geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] ImageMosaic-JDBC Tutorial Issues

Hi Kevin

A question, do you want to use PostGis Raster columns as described here

http://docsgeoserver.org/stable/en/user/data/raster/postgisraster.html

or do you want to use Blobs for your image data.

At the moment, I have no access to pastebin.com due to firewall rules of my customer.

Cheers

Christian

On Mon, Aug 5, 2013 at 10:39 PM, Weiss, Kevin <kweiss01@anonymised.com> wrote:

I’m trying to configure an ImageMosaic-JDBC coverage per the instructions (http://docs.geoserver.org/2.3.0/user/tutorials/imagemosaic-jdbc/imagemosaic-jdbc_tutorial.html) and keep getting the following error “Could not list layers for this store, an error occurred retrieving them: Argument “value” should not be null.”

I’ve searched through the mailing list and have seen similar threads, but can’t find a solution to the problem. If anyone can help me out I’d appreciate it. I’ll attach pastebin links for the typically requested files.

The system is GeoServer 2.3.0 with the WPS and ImagePyramid plugins added. Java 1.6.0_38 running on a CentOS 6 box and a postgres-9.2/PostGIS 2.0 database.

As a side note, my end goal is to construct a Raster Catalog containing temporal imagery which can be retrieved and looped via GeoServer with the rasters being persisted in postgres/postgis. If anyone has accomplished something similar and is willing to give me some help or tips I would greatly appreciate it.

Here is the relevant stacktrace from geoserver.log
http://pastebin.com/trL6zpmX

osm.postgis.xml
http://pastebin.com/x0KaJB0n

mapping.postgis.xml.inc
http://pastebin.com/KLpFDmtK

connect.postgis.xml.inc
http://pastebin.com/P8FwtcKS

Thanks,

Kevin M. Weiss

Get your SQL database under version control now!
Version control is standard for application code, but databases havent
caught up. So what steps can you take to put your SQL databases under
version control? Why should you start doing it? Read more to find out.
http://pubads.g.doubleclick.net/gampad/clk?id=49501711&iu=/4140/ostg.clktrk

Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

–

DI Christian Mueller MSc (GIS), MSc (IT-Security)

OSS Open Source Solutions GmbH

–

DI Christian Mueller MSc (GIS), MSc (IT-Security)

OSS Open Source Solutions GmbH

–

DI Christian Mueller MSc (GIS), MSc (IT-Security)

OSS Open Source Solutions GmbH

Christian_Mueller · August 8, 2013, 3:19pm

Hi Kevin

Did you change the value of the xml element “spatialExtension” to “PGRASTER”

···

On Tue, Aug 6, 2013 at 5:37 PM, Weiss, Kevin <kweiss01@anonymised.com> wrote:

Christian,

I have followed the PostGIS raster tutorial and seemed to have ended up in the same situation as before. When I try to add the ImageMosaic-JDBC store I receive the dreaded “Could not list layers for this store, an error occurred retrieving them: Argument “value” should not be null.” error.

Here are the steps I took.

I loaded the raster into the DB:

raster2pgsql –I –C –s 4326 satellite.png public.satellite > pgraster.sql

psql –U xxxx –d xxxx –h xxxx –f pgraster.sql

Then I created the mosaic table using the sql in the tutorial and added a row for my previously loaded raster:

insert into mosaic (name, tiletable) values (‘satellite’, ‘satellite’);

Then I created the mapping, connect and coverage xml files as described in the tutorial only modifying the DB connection info and the coverageName value in the coverage xml file to match the value in the mosaic table.

One thing I’ve noticed is that despite my coverageName specifying ‘satellite’ all lower case, I get an error stating “No level available for Satellite” in the GeoServer logs. When I update the name in the mosaic table to ‘Satellite’ then I get a NullPointerException in ImageMosaicJDBCReader line 164. I’m not sure why it would auto-capitalize my coverage name as all the references I’ve made are lower case.

Kevin M. Weiss

From: Christian Mueller [mailto:christian.mueller@anonymised.com]
Sent: Tuesday, August 06, 2013 9:04 AM
To: Weiss, Kevin
Cc: geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] ImageMosaic-JDBC Tutorial Issues

The imagemosiac-jdbc is NOT an extension of the ImageMosaic plugin and lacks temporal support.

The tutorial link in your previous mail is a good starting point.

Cheers

Christian

On Tue, Aug 6, 2013 at 3:38 PM, Weiss, Kevin <kweiss01@anonymised.com> wrote:

Hello Christian,

Yes, I was hoping to use the “time” parameter in WMS. I had prototyped an example using the time & elevation tutorial (link below) a while back and just assumed that the ImageMosaic-JDBC was an extension of the ImageMosaic plugin and would support time-series as well.
http://docs.geoserver.org/latest/en/user/tutorials/imagemosaic_timeseries/imagemosaic_timeseries.html#tutorial-imagemosaic-timeseries

Is this the best tutorial for configuring GeoServer with PostGIS Raster? Even if it doesn’t support the time parameter, I’d at least like to get a prototype running.
http://docs.geotools.org/latest/userguide/library/coverage/pgraster.html

Thanks,

Kevin M. Weiss

From: Christian Mueller [mailto:christian.mueller@anonymised.com]
Sent: Tuesday, August 06, 2013 7:42 AM

To: Weiss, Kevin
Cc: geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] ImageMosaic-JDBC Tutorial Issues

Hi Kevin

I would use PostGis raster columns.

Using pastebin.com for stack traces is ok, will have a look at it later.

About temporal queries. Do you want to use the “time” parameter in WMS requests ? I never used it and the imagemosiac-JDBC module has no temporal support !!!

Cheers

Christian

On Tue, Aug 6, 2013 at 1:44 PM, Weiss, Kevin <kweiss01@anonymised.com> wrote:

Hello Christian,

For the purpose of the exercise I was using the Blobs for image data storage. With regards to my end goal, I’m not sold on one approach over the other. I’m just looking to prototype a solution that allows me to programmatically store spatial imagery in the database from a java application and have it available for display via GeoServer while allowing temporal queries. Along the lines of looping weather radar imagery.

Any help you could provide in either direction would be great.

Is there a preferred location for providing stack traces and such? I didn’t want to attach the files and spam the whole mailing list.

Thanks,

Kevin M. Weiss

From: Christian Mueller [mailto:christian.mueller@anonymised.com]
Sent: Tuesday, August 06, 2013 5:16 AM
To: Weiss, Kevin
Cc: geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] ImageMosaic-JDBC Tutorial Issues

Hi Kevin

A question, do you want to use PostGis Raster columns as described here

http://docsgeoserver.org/stable/en/user/data/raster/postgisraster.html

or do you want to use Blobs for your image data.

At the moment, I have no access to pastebin.com due to firewall rules of my customer.

Cheers

Christian

On Mon, Aug 5, 2013 at 10:39 PM, Weiss, Kevin <kweiss01@anonymised.com> wrote:

I’m trying to configure an ImageMosaic-JDBC coverage per the instructions (http://docs.geoserver.org/2.3.0/user/tutorials/imagemosaic-jdbc/imagemosaic-jdbc_tutorial.html) and keep getting the following error “Could not list layers for this store, an error occurred retrieving them: Argument “value” should not be null.”

I’ve searched through the mailing list and have seen similar threads, but can’t find a solution to the problem. If anyone can help me out I’d appreciate it. I’ll attach pastebin links for the typically requested files.

The system is GeoServer 2.3.0 with the WPS and ImagePyramid plugins added. Java 1.6.0_38 running on a CentOS 6 box and a postgres-9.2/PostGIS 2.0 database.

As a side note, my end goal is to construct a Raster Catalog containing temporal imagery which can be retrieved and looped via GeoServer with the rasters being persisted in postgres/postgis. If anyone has accomplished something similar and is willing to give me some help or tips I would greatly appreciate it.

Here is the relevant stacktrace from geoserver.log
http://pastebin.com/trL6zpmX

osm.postgis.xml
http://pastebin.com/x0KaJB0n

mapping.postgis.xml.inc
http://pastebin.com/KLpFDmtK

connect.postgis.xml.inc
http://pastebin.com/P8FwtcKS

Thanks,

Kevin M. Weiss

Get your SQL database under version control now!
Version control is standard for application code, but databases havent
caught up. So what steps can you take to put your SQL databases under
version control? Why should you start doing it? Read more to find out.
http://pubads.g.doubleclick.net/gampad/clk?id=49501711&iu=/4140/ostg.clktrk

Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

–

DI Christian Mueller MSc (GIS), MSc (IT-Security)

OSS Open Source Solutions GmbH

–

DI Christian Mueller MSc (GIS), MSc (IT-Security)

OSS Open Source Solutions GmbH

–

DI Christian Mueller MSc (GIS), MSc (IT-Security)

OSS Open Source Solutions GmbH

–

DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH

Weiss_Kevin · August 8, 2013, 3:24pm

Hello Christian,
Yes, the mapping xml file is copied verbatim from the tutorial. The connect and coverage xml files were only modified for our connection info and to change the coverage name from "oek" to "satellite" to match my data.

Kevin M. Weiss

Software Engineer

HARRIS IT Services

1408 Fort Crook Road South

Bellevue, NE 68005

kweiss01@anonymised.com

________________________________________
From: Christian Mueller [christian.mueller@anonymised.com]
Sent: Thursday, August 08, 2013 10:19 AM
To: Weiss, Kevin
Cc: geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] ImageMosaic-JDBC Tutorial Issues

Hi Kevin

Did you change the value of the xml element "spatialExtension" to "PGRASTER"

On Tue, Aug 6, 2013 at 5:37 PM, Weiss, Kevin <kweiss01@anonymised.com<mailto:kweiss01@anonymised.com>> wrote:
Christian,
I have followed the PostGIS raster tutorial and seemed to have ended up in the same situation as before. When I try to add the ImageMosaic-JDBC store I receive the dreaded “Could not list layers for this store, an error occurred retrieving them: Argument "value" should not be null.” error.
Here are the steps I took

I loaded the raster into the DB:
raster2pgsql –I –C –s 4326 satellite.png public.satellite > pgraster.sql
psql –U xxxx –d xxxx –h xxxx –f pgraster.sql

Then I created the mosaic table using the sql in the tutorial and added a row for my previously loaded raster:
insert into mosaic (name, tiletable) values (‘satellite’, ‘satellite’);

Then I created the mapping, connect and coverage xml files as described in the tutorial only modifying the DB connection info and the coverageName value in the coverage xml file to match the value in the mosaic table.

One thing I’ve noticed is that despite my coverageName specifying ‘satellite’ all lower case, I get an error stating “No level available for Satellite” in the GeoServer logs. When I update the name in the mosaic table to ‘Satellite’ then I get a NullPointerException in ImageMosaicJDBCReader line 164. I’m not sure why it would auto-capitalize my coverage name as all the references I’ve made are lower case.

Kevin M. Weiss

From: Christian Mueller [mailto:christian.mueller@anonymised.com]
Sent: Tuesday, August 06, 2013 9:04 AM
To: Weiss, Kevin
Cc: geoserver-users@lists.sourceforge.net<mailto:geoserver-users@anonymised.comceforge.net>
Subject: Re: [Geoserver-users] ImageMosaic-JDBC Tutorial Issues

The imagemosiac-jdbc is NOT an extension of the ImageMosaic plugin and lacks temporal support.

The tutorial link in your previous mail is a good starting point.

Cheers
Christian

On Tue, Aug 6, 2013 at 3:38 PM, Weiss, Kevin <kweiss01@anonymised.com<mailto:kweiss01@anonymised.com>> wrote:
Hello Christian,

Yes, I was hoping to use the “time” parameter in WMS. I had prototyped an example using the time & elevation tutorial (link below) a while back and just assumed that the ImageMosaic-JDBC was an extension of the ImageMosaic plugin and would support time-series as well.
http://docs.geoserver.org/latest/en/user/tutorials/imagemosaic_timeseries/imagemosaic_timeseries.html#tutorial-imagemosaic-timeseries

Is this the best tutorial for configuring GeoServer with PostGIS Raster? Even if it doesn’t support the time parameter, I’d at least like to get a prototype running.
http://docs.geotools.org/latest/userguide/library/coverage/pgraster.html

Thanks,

Kevin M. Weiss

From: Christian Mueller [mailto:christian.mueller@anonymised.com]
Sent: Tuesday, August 06, 2013 7:42 AM

To: Weiss, Kevin
Cc: geoserver-users@lists.sourceforge.net<mailto:geoserver-users@anonymised.comceforge.net>
Subject: Re: [Geoserver-users] ImageMosaic-JDBC Tutorial Issues

Hi Kevin

I would use PostGis raster columns.

Using pastebin.com<http://pastebin.com> for stack traces is ok, will have a look at it later.

About temporal queries. Do you want to use the "time" parameter in WMS requests ? I never used it and the imagemosiac-JDBC module has no temporal support !!!

Cheers
Christian

On Tue, Aug 6, 2013 at 1:44 PM, Weiss, Kevin <kweiss01@anonymised.com<mailto:kweiss01@anonymised.com>> wrote:
Hello Christian,
For the purpose of the exercise I was using the Blobs for image data storage. With regards to my end goal, I’m not sold on one approach over the other. I’m just looking to prototype a solution that allows me to programmatically store spatial imagery in the database from a java application and have it available for display via GeoServer while allowing temporal queries. Along the lines of looping weather radar imagery.

Any help you could provide in either direction would be great.

Is there a preferred location for providing stack traces and such? I didn’t want to attach the files and spam the whole mailing list.

Thanks,

Kevin M. Weiss

From: Christian Mueller [mailto:christian.mueller@anonymised.com]
Sent: Tuesday, August 06, 2013 5:16 AM
To: Weiss, Kevin
Cc: geoserver-users@lists.sourceforge.net<mailto:geoserver-users@anonymised.comceforge.net>
Subject: Re: [Geoserver-users] ImageMosaic-JDBC Tutorial Issues

Hi Kevin

A question, do you want to use PostGis Raster columns as described here
http://docsgeoserver.org/stable/en/user/data/raster/postgisraster.html<http://docs.geoserver.org/stable/en/user/data/raster/postgisraster.html>

or do you want to use Blobs for your image data.

At the moment, I have no access to pastebin.com<http://pastebin.com> due to firewall rules of my customer.

Cheers
Christian

On Mon, Aug 5, 2013 at 10:39 PM, Weiss, Kevin <kweiss01@anonymised.com<mailto:kweiss01@anonymised.com>> wrote:
I'm trying to configure an ImageMosaic-JDBC coverage per the instructions (http://docs.geoserver.org/2.3.0/user/tutorials/imagemosaic-jdbc/imagemosaic-jdbc_tutorial.html<http://docs.geoserver.org/2.30/user/tutorials/imagemosaic-jdbc/imagemosaic-jdbc_tutorial.html>\) and keep getting the following error "Could not list layers for this store, an error occurred retrieving them: Argument "value" should not be null."

I've searched through the mailing list and have seen similar threads, but can't find a solution to the problem. If anyone can help me out I'd appreciate it. I'll attach pastebin links for the typically requested files.

The system is GeoServer 2.3.0 with the WPS and ImagePyramid plugins added. Java 1.6.0_38 running on a CentOS 6 box and a postgres-9.2/PostGIS 2.0 database.

As a side note, my end goal is to construct a Raster Catalog containing temporal imagery which can be retrieved and looped via GeoServer with the rasters being persisted in postgres/postgis. If anyone has accomplished something similar and is willing to give me some help or tips I would greatly appreciate it.

Here is the relevant stacktrace from geoserver.log
http://pastebin.com/trL6zpmX

osm.postgis.xml
http://pastebin.com/x0KaJB0n

mapping.postgis.xml.inc
http://pastebin.com/KLpFDmtK

connect.postgis.xml.inc
http://pastebin.com/P8FwtcKS

Thanks,

Kevin M. Weiss
------------------------------------------------------------------------------
Get your SQL database under version control now!
Version control is standard for application code, but databases havent
caught up. So what steps can you take to put your SQL databases under
version control? Why should you start doing it? Read more to find out.
http://pubads.g.doubleclick.net/gampad/clk?id=49501711&iu=/4140/ostg.clktrk
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net<mailto:Geoserver-users@anonymised.comrge.net>
https://lists.sourceforge.net/lists/listinfo/geoserver-users

--
DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH

Christian_Mueller · August 8, 2013, 3:29pm

No I am confused. Did you change and test with spatialExtension=“pgraster” instead of “postgis”. (After importing with raster2pgsql)

···

On Thu, Aug 8, 2013 at 5:24 PM, Weiss, Kevin <kweiss01@anonymised.com> wrote:

Hello Christian,
Yes, the mapping xml file is copied verbatim from the tutorial. The connect and coverage xml files were only modified for our connection info and to change the coverage name from “oek” to “satellite” to match my data.

Kevin M. Weiss

Software Engineer

HARRIS IT Services

1408 Fort Crook Road South

Bellevue, NE 68005

kweiss01@anonymised.com

From: Christian Mueller [christian.mueller@anonymised.com]
Sent: Thursday, August 08, 2013 10:19 AM

To: Weiss, Kevin
Cc: geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] ImageMosaic-JDBC Tutorial Issues

Hi Kevin

Did you change the value of the xml element “spatialExtension” to “PGRASTER”

On Tue, Aug 6, 2013 at 5:37 PM, Weiss, Kevin <kweiss01@anonymised.com mailto:[kweiss01@anonymised.com](mailto:kweiss01@anonymised.com)> wrote:
Christian,
I have followed the PostGIS raster tutorial and seemed to have ended up in the same situation as before. When I try to add the ImageMosaic-JDBC store I receive the dreaded “Could not list layers for this store, an error occurred retrieving them: Argument “value” should not be null.” error.
Here are the steps I took

I loaded the raster into the DB:
raster2pgsql –I –C –s 4326 satellite.png public.satellite > pgraster.sql
psql –U xxxx –d xxxx –h xxxx –f pgraster.sql

Then I created the mosaic table using the sql in the tutorial and added a row for my previously loaded raster:
insert into mosaic (name, tiletable) values (‘satellite’, ‘satellite’);

Then I created the mapping, connect and coverage xml files as described in the tutorial only modifying the DB connection info and the coverageName value in the coverage xml file to match the value in the mosaic table.

One thing I’ve noticed is that despite my coverageName specifying ‘satellite’ all lower case, I get an error stating “No level available for Satellite” in the GeoServer logs. When I update the name in the mosaic table to ‘Satellite’ then I get a NullPointerException in ImageMosaicJDBCReader line 164. I’m not sure why it would auto-capitalize my coverage name as all the references I’ve made are lower case.

Kevin M. Weiss

From: Christian Mueller [mailto:christian.mueller@anonymised.com mailto:[christian.mueller@anonymised.com](mailto:christian.mueller@anonymised.com)]

Sent: Tuesday, August 06, 2013 9:04 AM
To: Weiss, Kevin

Cc: geoserver-users@lists.sourceforge.net mailto:[geoserver-users@lists.sourceforge.net](mailto:geoserver-users@lists.sourceforge.net)

Subject: Re: [Geoserver-users] ImageMosaic-JDBC Tutorial Issues

The imagemosiac-jdbc is NOT an extension of the ImageMosaic plugin and lacks temporal support.

The tutorial link in your previous mail is a good starting point.

Cheers
Christian

On Tue, Aug 6, 2013 at 3:38 PM, Weiss, Kevin <kweiss01@anonymised.com mailto:[kweiss01@anonymised.com](mailto:kweiss01@anonymised.com)> wrote:
Hello Christian,

Yes, I was hoping to use the “time” parameter in WMS. I had prototyped an example using the time & elevation tutorial (link below) a while back and just assumed that the ImageMosaic-JDBC was an extension of the ImageMosaic plugin and would support time-series as well.
http://docs.geoserver.org/latest/en/user/tutorials/imagemosaic_timeseries/imagemosaic_timeseries.html#tutorial-imagemosaic-timeseries

Is this the best tutorial for configuring GeoServer with PostGIS Raster? Even if it doesn’t support the time parameter, I’d at least like to get a prototype running.
http://docs.geotools.org/latest/userguide/library/coverage/pgraster.html

Thanks,

Kevin M. Weiss

From: Christian Mueller [mailto:christian.mueller@anonymised.com mailto:[christian.mueller@anonymised.com](mailto:christian.mueller@anonymised.com)]

Sent: Tuesday, August 06, 2013 7:42 AM

To: Weiss, Kevin

Cc: geoserver-users@lists.sourceforge.net mailto:[geoserver-users@lists.sourceforge.net](mailto:geoserver-users@lists.sourceforge.net)

Subject: Re: [Geoserver-users] ImageMosaic-JDBC Tutorial Issues

Hi Kevin

I would use PostGis raster columns.

Using pastebin.com<http://pastebin.com> for stack traces is ok, will have a look at it later.

About temporal queries. Do you want to use the “time” parameter in WMS requests ? I never used it and the imagemosiac-JDBC module has no temporal support !!!

Cheers
Christian

On Tue, Aug 6, 2013 at 1:44 PM, Weiss, Kevin <kweiss01@anonymised.com mailto:[kweiss01@anonymised.com](mailto:kweiss01@anonymised.com)> wrote:
Hello Christian,
For the purpose of the exercise I was using the Blobs for image data storage. With regards to my end goal, I’m not sold on one approach over the other. I’m just looking to prototype a solution that allows me to programmatically store spatial imagery in the database from a java application and have it available for display via GeoServer while allowing temporal queries. Along the lines of looping weather radar imagery.

Any help you could provide in either direction would be great.

Is there a preferred location for providing stack traces and such? I didn’t want to attach the files and spam the whole mailing list.

Thanks,

Kevin M. Weiss

From: Christian Mueller [mailto:christian.mueller@anonymised.com mailto:[christian.mueller@anonymised.com](mailto:christian.mueller@anonymised.com)]

Sent: Tuesday, August 06, 2013 5:16 AM
To: Weiss, Kevin

Cc: geoserver-users@lists.sourceforge.net mailto:[geoserver-users@lists.sourceforge.net](mailto:geoserver-users@lists.sourceforge.net)

Subject: Re: [Geoserver-users] ImageMosaic-JDBC Tutorial Issues

Hi Kevin

A question, do you want to use PostGis Raster columns as described here

http://docsgeoserver.org/stable/en/user/data/raster/postgisraster.html<http://docs.geoserver.org/stable/en/user/data/raster/postgisraster.html>

or do you want to use Blobs for your image data.

At the moment, I have no access to pastebin.com<http://pastebin.com> due to firewall rules of my customer.

Cheers
Christian

On Mon, Aug 5, 2013 at 10:39 PM, Weiss, Kevin <kweiss01@anonymised.com mailto:[kweiss01@anonymised.com](mailto:kweiss01@...5740...)> wrote:
I’m trying to configure an ImageMosaic-JDBC coverage per the instructions (http://docs.geoserver.org/2.3.0/user/tutorials/imagemosaic-jdbc/imagemosaic-jdbc_tutorial.html<http://docs.geoserver.org/2.30/user/tutorials/imagemosaic-jdbc/imagemosaic-jdbc_tutorial.html>) and keep getting the following error “Could not list layers for this store, an error occurred retrieving them: Argument “value” should not be null.”

I’ve searched through the mailing list and have seen similar threads, but can’t find a solution to the problem. If anyone can help me out I’d appreciate it. I’ll attach pastebin links for the typically requested files.

The system is GeoServer 2.3.0 with the WPS and ImagePyramid plugins added. Java 1.6.0_38 running on a CentOS 6 box and a postgres-9.2/PostGIS 2.0 database.

As a side note, my end goal is to construct a Raster Catalog containing temporal imagery which can be retrieved and looped via GeoServer with the rasters being persisted in postgres/postgis. If anyone has accomplished something similar and is willing to give me some help or tips I would greatly appreciate it.

Here is the relevant stacktrace from geoserver.log
http://pastebin.com/trL6zpmX

osm.postgis.xml
http://pastebin.com/x0KaJB0n

mapping.postgis.xml.inc
http://pastebin.com/KLpFDmtK

connect.postgis.xml.inc
http://pastebin.com/P8FwtcKS

Thanks,

Kevin M. Weiss

Get your SQL database under version control now!
Version control is standard for application code, but databases havent
caught up. So what steps can you take to put your SQL databases under
version control? Why should you start doing it? Read more to find out.
http://pubads.g.doubleclick.net/gampad/clk?id=49501711&iu=/4140/ostg.clktrk

Geoserver-users mailing list

Geoserver-users@lists.sourceforge.net mailto:[Geoserver-users@lists.sourceforge.net](mailto:Geoserver-users@anonymised.comists.sourceforge.net)

https://lists.sourceforge.net/lists/listinfo/geoserver-users

–
DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH

–
DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH

–
DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH

–
DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH

–

DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH

Weiss_Kevin · August 8, 2013, 3:34pm

Christian,
Rather than altering the files I had created while following the first tutorial, I started fresh following the tutorial here:
http://docs.geotools.org/latest/userguide/library/coverage/pgraster.html

The mapping xml file in that tutorial already has the spatialExtension set to "pgraster" so I didn't need to modify anything. I merely copied & pasted for that file.

Kevin M. Weiss

Software Engineer

HARRIS IT Services

1408 Fort Crook Road South

Bellevue, NE 68005

kweiss01@anonymised.com

________________________________________
From: Christian Mueller [christian.mueller@anonymised.com]
Sent: Thursday, August 08, 2013 10:29 AM
To: Weiss, Kevin
Cc: geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] ImageMosaic-JDBC Tutorial Issues

No I am confused. Did you change and test with spatialExtension="pgraster" instead of "postgis". (After importing with raster2pgsql)

On Thu, Aug 8, 2013 at 5:24 PM, Weiss, Kevin <kweiss01@anonymised.com<mailto:kweiss01@anonymised.com>> wrote:
Hello Christian,
Yes, the mapping xml file is copied verbatim from the tutorial. The connect and coverage xml files were only modified for our connection info and to change the coverage name from "oek" to "satellite" to match my data.

Kevin M. Weiss

Software Engineer

HARRIS IT Services

1408 Fort Crook Road South

Bellevue, NE 68005

kweiss01@anonymised.com<mailto:kweiss01@anonymised.com>

________________________________________
From: Christian Mueller [christian.mueller@anonymised.com<mailto:christian.mueller@anonymised.com>]
Sent: Thursday, August 08, 2013 10:19 AM
To: Weiss, Kevin
Cc: geoserver-users@lists.sourceforge.net<mailto:geoserver-users@anonymised.comceforge.net>
Subject: Re: [Geoserver-users] ImageMosaic-JDBC Tutorial Issues

Hi Kevin

Did you change the value of the xml element "spatialExtension" to "PGRASTER"

On Tue, Aug 6, 2013 at 5:37 PM, Weiss, Kevin <kweiss01@anonymised.com<mailto:kweiss01@anonymised.com><mailto:kweiss01@anonymised.com>> wrote:
Christian,
I have followed the PostGIS raster tutorial and seemed to have ended up in the same situation as before. When I try to add the ImageMosaic-JDBC store I receive the dreaded “Could not list layers for this store, an error occurred retrieving them: Argument "value" should not be null.” error.
Here are the steps I took

I loaded the raster into the DB:
raster2pgsql –I –C –s 4326 satellite.png public.satellite > pgraster.sql
psql –U xxxx –d xxxx –h xxxx –f pgraster.sql

Then I created the mosaic table using the sql in the tutorial and added a row for my previously loaded raster:
insert into mosaic (name, tiletable) values (‘satellite’, ‘satellite’);

Then I created the mapping, connect and coverage xml files as described in the tutorial only modifying the DB connection info and the coverageName value in the coverage xml file to match the value in the mosaic table.

One thing I’ve noticed is that despite my coverageName specifying ‘satellite’ all lower case, I get an error stating “No level available for Satellite” in the GeoServer logs. When I update the name in the mosaic table to ‘Satellite’ then I get a NullPointerException in ImageMosaicJDBCReader line 164. I’m not sure why it would auto-capitalize my coverage name as all the references I’ve made are lower case.

Kevin M. Weiss

From: Christian Mueller [mailto:christian.mueller@anonymised.com<mailto:christian.mueller@anonymised.com>]
Sent: Tuesday, August 06, 2013 9:04 AM
To: Weiss, Kevin
Cc: geoserver-users@lists.sourceforge.net<mailto:geoserver-users@anonymised.comceforge.net><mailto:geoserver-users@lists.sourceforge.net>
Subject: Re: [Geoserver-users] ImageMosaic-JDBC Tutorial Issues

The imagemosiac-jdbc is NOT an extension of the ImageMosaic plugin and lacks temporal support.

The tutorial link in your previous mail is a good starting point.

Cheers
Christian

On Tue, Aug 6, 2013 at 3:38 PM, Weiss, Kevin <kweiss01@anonymised.com<mailto:kweiss01@anonymised.com><mailto:kweiss01@anonymised.com>> wrote:
Hello Christian,

Yes, I was hoping to use the “time” parameter in WMS. I had prototyped an example using the time & elevation tutorial (link below) a while back and just assumed that the ImageMosaic-JDBC was an extension of the ImageMosaic plugin and would support time-series as well.
http://docs.geoserver.org/latest/en/user/tutorials/imagemosaic_timeseries/imagemosaic_timeseries.html#tutorial-imagemosaic-timeseries

Is this the best tutorial for configuring GeoServer with PostGIS Raster? Even if it doesn’t support the time parameter, I’d at least like to get a prototype running.
http://docs.geotools.org/latest/userguide/library/coverage/pgraster.html

Thanks,

Kevin M. Weiss

From: Christian Mueller [mailto:christian.mueller@anonymised.com<mailto:christian.mueller@anonymised.com>]
Sent: Tuesday, August 06, 2013 7:42 AM

To: Weiss, Kevin
Cc: geoserver-users@lists.sourceforge.net<mailto:geoserver-users@anonymised.comceforge.net><mailto:geoserver-users@lists.sourceforge.net>
Subject: Re: [Geoserver-users] ImageMosaic-JDBC Tutorial Issues

Hi Kevin

I would use PostGis raster columns.

Using pastebin.com<http://pastebin.com><http://pastebin.com> for stack traces is ok, will have a look at it later.

About temporal queries. Do you want to use the "time" parameter in WMS requests ? I never used it and the imagemosiac-JDBC module has no temporal support !!!

Cheers
Christian

On Tue, Aug 6, 2013 at 1:44 PM, Weiss, Kevin <kweiss01@anonymised.com<mailto:kweiss01@anonymised.com><mailto:kweiss01@anonymised.com>> wrote:
Hello Christian,
For the purpose of the exercise I was using the Blobs for image data storage. With regards to my end goal, I’m not sold on one approach over the other. I’m just looking to prototype a solution that allows me to programmatically store spatial imagery in the database from a java application and have it available for display via GeoServer while allowing temporal queries. Along the lines of looping weather radar imagery.

Any help you could provide in either direction would be great.

Is there a preferred location for providing stack traces and such? I didn’t want to attach the files and spam the whole mailing list.

Thanks,

Kevin M. Weiss

From: Christian Mueller [mailto:christian.mueller@anonymised.com<mailto:christian.mueller@anonymised.com>]
Sent: Tuesday, August 06, 2013 5:16 AM
To: Weiss, Kevin
Cc: geoserver-users@lists.sourceforge.net<mailto:geoserver-users@anonymised.comceforge.net><mailto:geoserver-users@lists.sourceforge.net>
Subject: Re: [Geoserver-users] ImageMosaic-JDBC Tutorial Issues

Hi Kevin

A question, do you want to use PostGis Raster columns as described here
http://docsgeoserver.org/stable/en/user/data/raster/postgisraster.html<http://docs.geoserver.org/stable/en/user/data/raster/postgisraster.html>

or do you want to use Blobs for your image data.

At the moment, I have no access to pastebin.com<http://pastebin.com><http://pastebin.com> due to firewall rules of my customer.

Cheers
Christian

On Mon, Aug 5, 2013 at 10:39 PM, Weiss, Kevin <kweiss01@anonymised.com<mailto:kweiss01@anonymised.com><mailto:kweiss01@anonymised.com>> wrote:
I'm trying to configure an ImageMosaic-JDBC coverage per the instructions (http://docs.geoserverorg/2.3.0/user/tutorials/imagemosaic-jdbc/imagemosaic-jdbc_tutorial.html<http://docs.geoserver.org/2.3.0/user/tutorials/imagemosaic-jdbc/imagemosaic-jdbc_tutorial.html><http://docs.geoserver.org/2.30/user/tutorials/imagemosaic-jdbc/imagemosaic-jdbc_tutorial.html>\) and keep getting the following error "Could not list layers for this store, an error occurred retrieving them: Argument "value" should not be null."

I've searched through the mailing list and have seen similar threads, but can't find a solution to the problem. If anyone can help me out I'd appreciate it. I'll attach pastebin links for the typically requested files.

The system is GeoServer 2.3.0 with the WPS and ImagePyramid plugins added. Java 1.6.0_38 running on a CentOS 6 box and a postgres-9.2/PostGIS 2.0 database.

As a side note, my end goal is to construct a Raster Catalog containing temporal imagery which can be retrieved and looped via GeoServer with the rasters being persisted in postgres/postgis. If anyone has accomplished something similar and is willing to give me some help or tips I would greatly appreciate it.

Here is the relevant stacktrace from geoserver.log
http://pastebin.com/trL6zpmX

osm.postgis.xml
http://pastebin.com/x0KaJB0n

mapping.postgis.xml.inc
http://pastebin.com/KLpFDmtK

connect.postgis.xml.inc
http://pastebin.com/P8FwtcKS

Thanks,

Kevin M. Weiss
------------------------------------------------------------------------------
Get your SQL database under version control now!
Version control is standard for application code, but databases havent
caught up. So what steps can you take to put your SQL databases under
version control? Why should you start doing it? Read more to find out.
http://pubads.g.doubleclick.net/gampad/clk?id=49501711&iu=/4140/ostg.clktrk
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net<mailto:Geoserver-users@anonymised.comrge.net><mailto:Geoserver-users@lists.sourceforge.net>
https://lists.sourceforge.net/lists/listinfo/geoserver-users

--
DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH

Christian_Mueller · August 8, 2013, 3:47pm

Hi Kevin

Maybe your image data is not supported by the java image IO library. Can you post me the the output of

gdalinfo myimage

Christian

···

On Thu, Aug 8, 2013 at 5:34 PM, Weiss, Kevin <kweiss01@anonymised.com> wrote:

Christian,
Rather than altering the files I had created while following the first tutorial, I started fresh following the tutorial here:
http://docs.geotools.org/latest/userguide/library/coverage/pgraster.html

The mapping xml file in that tutorial already has the spatialExtension set to “pgraster” so I didn’t need to modify anything. I merely copied & pasted for that file.

Kevin M. Weiss

Software Engineer

HARRIS IT Services

1408 Fort Crook Road South

Bellevue, NE 68005

kweiss01@anonymised.com

From: Christian Mueller [christian.mueller@anonymised.com]

Sent: Thursday, August 08, 2013 10:29 AM

To: Weiss, Kevin
Cc: geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] ImageMosaic-JDBC Tutorial Issues

No I am confused. Did you change and test with spatialExtension=“pgraster” instead of “postgis”. (After importing with raster2pgsql)

On Thu, Aug 8, 2013 at 5:24 PM, Weiss, Kevin <kweiss01@anonymised.com mailto:[kweiss01@anonymised.com](mailto:kweiss01@anonymised.com)> wrote:
Hello Christian,

Yes, the mapping xml file is copied verbatim from the tutorial. The connect and coverage xml files were only modified for our connection info and to change the coverage name from “oek” to “satellite” to match my data.

Kevin M. Weiss

Software Engineer

HARRIS IT Services

1408 Fort Crook Road South

Bellevue, NE 68005

kweiss01@anonymised.com mailto:[kweiss01@anonymised.com](mailto:kweiss01@anonymised.com)

From: Christian Mueller [christian.mueller@anonymised.com mailto:[christian.mueller@anonymised.com](mailto:christian.mueller@anonymised.com)]

Sent: Thursday, August 08, 2013 10:19 AM
To: Weiss, Kevin

Cc: geoserver-users@lists.sourceforge.net mailto:[geoserver-users@anonymised.comge.net](mailto:geoserver-users@lists.sourceforge.net)
Subject: Re: [Geoserver-users] ImageMosaic-JDBC Tutorial Issues

Hi Kevin

Did you change the value of the xml element “spatialExtension” to “PGRASTER”

On Tue, Aug 6, 2013 at 5:37 PM, Weiss, Kevin <kweiss01@anonymised.com mailto:[kweiss01@anonymised.com](mailto:kweiss01@anonymised.com)<mailto:kweiss01@anonymised.com mailto:[kweiss01@anonymised.com](mailto:kweiss01@anonymised.com)>> wrote:
Christian,
I have followed the PostGIS raster tutorial and seemed to have ended up in the same situation as before. When I try to add the ImageMosaic-JDBC store I receive the dreaded “Could not list layers for this store, an error occurred retrieving them: Argument “value” should not be null.” error.
Here are the steps I took

I loaded the raster into the DB:
raster2pgsql –I –C –s 4326 satellite.png public.satellite > pgraster.sql
psql –U xxxx –d xxxx –h xxxx –f pgraster.sql

Then I created the mosaic table using the sql in the tutorial and added a row for my previously loaded raster:
insert into mosaic (name, tiletable) values (‘satellite’, ‘satellite’);

Then I created the mapping, connect and coverage xml files as described in the tutorial only modifying the DB connection info and the coverageName value in the coverage xml file to match the value in the mosaic table.

One thing I’ve noticed is that despite my coverageName specifying ‘satellite’ all lower case, I get an error stating “No level available for Satellite” in the GeoServer logs. When I update the name in the mosaic table to ‘Satellite’ then I get a NullPointerException in ImageMosaicJDBCReader line 164. I’m not sure why it would auto-capitalize my coverage name as all the references I’ve made are lower case.

Kevin M. Weiss

From: Christian Mueller [mailto:christian.mueller@anonymised.com mailto:[christian.mueller@anonymised.com](mailto:christian.mueller@anonymised.com)<mailto:christian.mueller@anonymised.com mailto:[christian.mueller@anonymised.com](mailto:christian.mueller@anonymised.com)>]

Sent: Tuesday, August 06, 2013 9:04 AM
To: Weiss, Kevin

Cc: geoserver-users@lists.sourceforge.net mailto:[geoserver-users@lists.sourceforge.net](mailto:geoserver-users@lists.sourceforge.net)<mailto:geoserver-users@lists.sourceforge.net mailto:[geoserver-users@lists.sourceforge.net](mailto:geoserver-users@lists.sourceforge.net)>

Subject: Re: [Geoserver-users] ImageMosaic-JDBC Tutorial Issues

The imagemosiac-jdbc is NOT an extension of the ImageMosaic plugin and lacks temporal support.

The tutorial link in your previous mail is a good starting point.

Cheers
Christian

On Tue, Aug 6, 2013 at 3:38 PM, Weiss, Kevin <kweiss01@anonymised.com mailto:[kweiss01@anonymised.com](mailto:kweiss01@anonymised.com)<mailto:kweiss01@anonymised.com mailto:[kweiss01@anonymised.com](mailto:kweiss01@anonymised.com)>> wrote:
Hello Christian,

Yes, I was hoping to use the “time” parameter in WMS. I had prototyped an example using the time & elevation tutorial (link below) a while back and just assumed that the ImageMosaic-JDBC was an extension of the ImageMosaic plugin and would support time-series as well.
http://docs.geoserver.org/latest/en/user/tutorials/imagemosaic_timeseries/imagemosaic_timeseries.html#tutorial-imagemosaic-timeseries

Is this the best tutorial for configuring GeoServer with PostGIS Raster? Even if it doesn’t support the time parameter, I’d at least like to get a prototype running.
http://docs.geotools.org/latest/userguide/library/coverage/pgraster.html

Thanks,

Kevin M. Weiss

From: Christian Mueller [mailto:christian.mueller@anonymised.com mailto:[christian.mueller@anonymised.com](mailto:christian.mueller@anonymised.com)<mailto:christian.mueller@anonymised.com mailto:[christian.mueller@anonymised.com](mailto:christian.mueller@anonymised.com)>]

Sent: Tuesday, August 06, 2013 7:42 AM

To: Weiss, Kevin

Cc: geoserver-users@lists.sourceforge.net mailto:[geoserver-users@lists.sourceforge.net](mailto:geoserver-users@lists.sourceforge.net)<mailto:geoserver-users@lists.sourceforge.net mailto:[geoserver-users@lists.sourceforge.net](mailto:geoserver-users@lists.sourceforge.net)>

Subject: Re: [Geoserver-users] ImageMosaic-JDBC Tutorial Issues

Hi Kevin

I would use PostGis raster columns.

Using pastebin.com<http://pastebin.com><http://pastebin.com> for stack traces is ok, will have a look at it later.

About temporal queries. Do you want to use the “time” parameter in WMS requests ? I never used it and the imagemosiac-JDBC module has no temporal support !!!

Cheers
Christian

On Tue, Aug 6, 2013 at 1:44 PM, Weiss, Kevin <kweiss01@anonymised.com mailto:[kweiss01@anonymised.com](mailto:kweiss01@anonymised.com)<mailto:kweiss01@anonymised.com mailto:[kweiss01@anonymised.com](mailto:kweiss01@anonymised.com)>> wrote:
Hello Christian,
For the purpose of the exercise I was using the Blobs for image data storage. With regards to my end goal, I’m not sold on one approach over the other. I’m just looking to prototype a solution that allows me to programmatically store spatial imagery in the database from a java application and have it available for display via GeoServer while allowing temporal queries. Along the lines of looping weather radar imagery.

Any help you could provide in either direction would be great.

Is there a preferred location for providing stack traces and such? I didn’t want to attach the files and spam the whole mailing list.

Thanks,

Kevin M. Weiss

From: Christian Mueller [mailto:christian.mueller@anonymised.com mailto:[christian.mueller@anonymised.com](mailto:christian.mueller@anonymised.com)<mailto:christian.mueller@anonymised.com mailto:[christian.mueller@anonymised.com](mailto:christian.mueller@anonymised.com)>]

Sent: Tuesday, August 06, 2013 5:16 AM
To: Weiss, Kevin

Cc: geoserver-users@lists.sourceforge.net mailto:[geoserver-users@lists.sourceforge.net](mailto:geoserver-users@lists.sourceforge.net)<mailto:geoserver-users@lists.sourceforge.net mailto:[geoserver-users@lists.sourceforge.net](mailto:geoserver-users@lists.sourceforge.net)>

Subject: Re: [Geoserver-users] ImageMosaic-JDBC Tutorial Issues

Hi Kevin

A question, do you want to use PostGis Raster columns as described here
http://docsgeoserver.org/stable/en/user/data/raster/postgisraster.html<http://docs.geoserver.org/stable/en/user/data/raster/postgisraster.html>

or do you want to use Blobs for your image data.

At the moment, I have no access to pastebin.com<http://pastebin.com><http://pastebin.com> due to firewall rules of my customer.

Cheers
Christian

On Mon, Aug 5, 2013 at 10:39 PM, Weiss, Kevin <kweiss01@anonymised.com mailto:[kweiss01@anonymised.com](mailto:kweiss01@...5740...)<mailto:kweiss01@anonymised.com mailto:[kweiss01@anonymised.com](mailto:kweiss01@...5740...)>> wrote:
I’m trying to configure an ImageMosaic-JDBC coverage per the instructions (http://docs.geoserverorg/2.3.0/user/tutorials/imagemosaic-jdbc/imagemosaic-jdbc_tutorial.html<http://docs.geoserver.org/2.3.0/user/tutorials/imagemosaic-jdbc/imagemosaic-jdbc_tutorial.html><http://docs.geoserver.org/2.30/user/tutorials/imagemosaic-jdbc/imagemosaic-jdbc_tutorial.html>) and keep getting the following error “Could not list layers for this store, an error occurred retrieving them: Argument “value” should not be null.”

I’ve searched through the mailing list and have seen similar threads, but can’t find a solution to the problem. If anyone can help me out I’d appreciate it. I’ll attach pastebin links for the typically requested files.

The system is GeoServer 2.3.0 with the WPS and ImagePyramid plugins added. Java 1.6.0_38 running on a CentOS 6 box and a postgres-9.2/PostGIS 2.0 database.

As a side note, my end goal is to construct a Raster Catalog containing temporal imagery which can be retrieved and looped via GeoServer with the rasters being persisted in postgres/postgis. If anyone has accomplished something similar and is willing to give me some help or tips I would greatly appreciate it.

Here is the relevant stacktrace from geoserver.log
http://pastebin.com/trL6zpmX

osm.postgis.xml
http://pastebin.com/x0KaJB0n

mapping.postgis.xml.inc
http://pastebin.com/KLpFDmtK

connect.postgis.xml.inc
http://pastebin.com/P8FwtcKS

Thanks,

Kevin M. Weiss

Get your SQL database under version control now!
Version control is standard for application code, but databases havent
caught up. So what steps can you take to put your SQL databases under
version control? Why should you start doing it? Read more to find out.
http://pubads.g.doubleclick.net/gampad/clk?id=49501711&iu=/4140/ostg.clktrk

Geoserver-users mailing list

Geoserver-users@lists.sourceforge.net mailto:[Geoserver-users@lists.sourceforge.net](mailto:Geoserver-users@anonymised.comists.sourceforge.net)<mailto:Geoserver-users@lists.sourceforge.net mailto:[Geoserver-users@lists.sourceforge.net](mailto:Geoserver-users@anonymised.coms.sourceforge.net)>

https://lists.sourceforge.net/lists/listinfo/geoserver-users

–
DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH

–
DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH

–
DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH

–
DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH

–
DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH

–

DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH

Weiss_Kevin · August 8, 2013, 3:54pm

Christian,
Here is the output from gdalinfo

$>gdalinfo ecnremappedir.png
Driver: PNG/Portable Network Graphics
Files: ecnremappedir.png
ecnremappedir.pgw
Size is 2880, 2880
Coordinate System is `'
Origin = (-128.015625000000000,90.015625000000000)
Pixel Size = (0.031250000000000,-0.031250000000000)
Image Structure Metadata:
INTERLEAVE=PIXEL
Corner Coordinates:
Upper Left (-128.0156250, 90.0156250)
Lower Left (-128.0156250, 0.0156250)
Upper Right ( -38.0156250, 90.0156250)
Lower Right ( -38.0156250, 0.0156250)
Center ( -83.0156250, 45.0156250)
Band 1 Block=2880x1 Type=Byte, ColorInterp=Red
Band 2 Block=2880x1 Type=Byte, ColorInterp=Green
Band 3 Block=2880x1 Type=Byte, ColorInterp=Blue

Kevin M. Weiss

Software Engineer

HARRIS IT Services

1408 Fort Crook Road South

Bellevue, NE 68005

kweiss01@anonymised.com

________________________________________
From: Christian Mueller [christian.mueller@anonymised.com]
Sent: Thursday, August 08, 2013 10:47 AM
To: Weiss, Kevin
Cc: geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] ImageMosaic-JDBC Tutorial Issues

Hi Kevin

Maybe your image data is not supported by the java image IO library. Can you post me the the output of

gdalinfo myimage

Christian

On Thu, Aug 8, 2013 at 5:34 PM, Weiss, Kevin <kweiss01@anonymised.com<mailto:kweiss01@anonymised.com>> wrote:
Christian,
Rather than altering the files I had created while following the first tutorial, I started fresh following the tutorial here:
http://docs.geotools.org/latest/userguide/library/coverage/pgraster.html

The mapping xml file in that tutorial already has the spatialExtension set to "pgraster" so I didn't need to modify anything. I merely copied & pasted for that file.

Kevin M. Weiss

Software Engineer

HARRIS IT Services

1408 Fort Crook Road South

Bellevue, NE 68005

kweiss01@anonymised.com<mailto:kweiss01@anonymised.com>

________________________________________
From: Christian Mueller [christian.mueller@anonymised.com<mailto:christian.mueller@anonymised.com>]
Sent: Thursday, August 08, 2013 10:29 AM
To: Weiss, Kevin
Cc: geoserver-users@lists.sourceforge.net<mailto:geoserver-users@anonymised.comceforge.net>
Subject: Re: [Geoserver-users] ImageMosaic-JDBC Tutorial Issues

No I am confused. Did you change and test with spatialExtension="pgraster" instead of "postgis". (After importing with raster2pgsql)

On Thu, Aug 8, 2013 at 5:24 PM, Weiss, Kevin <kweiss01@anonymised.com<mailto:kweiss01@anonymised.com><mailto:kweiss01@anonymised.com>> wrote:
Hello Christian,
Yes, the mapping xml file is copied verbatim from the tutorial. The connect and coverage xml files were only modified for our connection info and to change the coverage name from "oek" to "satellite" to match my data.

Kevin M. Weiss

Software Engineer

HARRIS IT Services

1408 Fort Crook Road South

Bellevue, NE 68005

kweiss01@anonymised.com<mailto:kweiss01@anonymised.com><mailto:kweiss01@anonymised.com>

________________________________________
From: Christian Mueller [christian.mueller@anonymised.com<mailto:christian.mueller@anonymised.com><mailto:christian.mueller@anonymised.com>]
Sent: Thursday, August 08, 2013 10:19 AM
To: Weiss, Kevin
Cc: geoserver-users@lists.sourceforge.net<mailto:geoserver-users@anonymised.comceforge.net><mailto:geoserver-users@lists.sourceforge.net>
Subject: Re: [Geoserver-users] ImageMosaic-JDBC Tutorial Issues

Hi Kevin

Did you change the value of the xml element "spatialExtension" to "PGRASTER"

On Tue, Aug 6, 2013 at 5:37 PM, Weiss, Kevin <kweiss01@anonymised.com<mailto:kweiss01@anonymised.com><mailto:kweiss01@anonymised.com><mailto:kweiss01@anonymised.com<mailto:kweiss01@anonymised.com740...<mailto:kweiss01@anonymised.com>>>> wrote:
Christian,
I have followed the PostGIS raster tutorial and seemed to have ended up in the same situation as before. When I try to add the ImageMosaic-JDBC store I receive the dreaded “Could not list layers for this store, an error occurred retrieving them: Argument "value" should not be null.” error.
Here are the steps I took

I loaded the raster into the DB:
raster2pgsql –I –C –s 4326 satellite.png public.satellite > pgraster.sql
psql –U xxxx –d xxxx –h xxxx –f pgraster.sql

Then I created the mosaic table using the sql in the tutorial and added a row for my previously loaded raster:
insert into mosaic (name, tiletable) values (‘satellite’, ‘satellite’);

Then I created the mapping, connect and coverage xml files as described in the tutorial only modifying the DB connection info and the coverageName value in the coverage xml file to match the value in the mosaic table.

One thing I’ve noticed is that despite my coverageName specifying ‘satellite’ all lower case, I get an error stating “No level available for Satellite” in the GeoServer logs. When I update the name in the mosaic table to ‘Satellite’ then I get a NullPointerException in ImageMosaicJDBCReader line 164. I’m not sure why it would auto-capitalize my coverage name as all the references I’ve made are lower case.

Kevin M. Weiss

From: Christian Mueller [mailto:christian.mueller@anonymised.com<mailto:christian.mueller@anonymised.com><mailto:christian.mueller@anonymised.com<mailto:christian.mueller@anonymised.com>>]
Sent: Tuesday, August 06, 2013 9:04 AM
To: Weiss, Kevin
Cc: geoserver-users@lists.sourceforge.net<mailto:geoserver-users@anonymised.comceforge.net><mailto:geoserver-users@lists.sourceforge.net><mailto:geoserver-users@lists.sourceforge.net<mailto:geoserver-users@anonymised.comsourceforge.net<mailto:geoserver-users@lists.sourceforge.net>>>
Subject: Re: [Geoserver-users] ImageMosaic-JDBC Tutorial Issues

The imagemosiac-jdbc is NOT an extension of the ImageMosaic plugin and lacks temporal support.

The tutorial link in your previous mail is a good starting point.

Cheers
Christian

On Tue, Aug 6, 2013 at 3:38 PM, Weiss, Kevin <kweiss01@anonymised.com<mailto:kweiss01@anonymised.com><mailto:kweiss01@anonymised.com><mailto:kweiss01@anonymised.com<mailto:kweiss01@anonymised.com740...<mailto:kweiss01@anonymised.com>>>> wrote:
Hello Christian,

Yes, I was hoping to use the “time” parameter in WMS. I had prototyped an example using the time & elevation tutorial (link below) a while back and just assumed that the ImageMosaic-JDBC was an extension of the ImageMosaic plugin and would support time-series as well.
http://docs.geoserver.org/latest/en/user/tutorials/imagemosaic_timeseries/imagemosaic_timeseries.html#tutorial-imagemosaic-timeseries

Is this the best tutorial for configuring GeoServer with PostGIS Raster? Even if it doesn’t support the time parameter, I’d at least like to get a prototype running.
http://docs.geotools.org/latest/userguide/library/coverage/pgraster.html

Thanks,

Kevin M. Weiss

From: Christian Mueller [mailto:christian.mueller@anonymised.com<mailto:christian.mueller@anonymised.com><mailto:christian.mueller@anonymised.com<mailto:christian.mueller@anonymised.com>>]
Sent: Tuesday, August 06, 2013 7:42 AM

To: Weiss, Kevin
Cc: geoserver-users@lists.sourceforge.net<mailto:geoserver-users@anonymised.comceforge.net><mailto:geoserver-users@lists.sourceforge.net><mailto:geoserver-users@lists.sourceforge.net<mailto:geoserver-users@anonymised.comsourceforge.net<mailto:geoserver-users@lists.sourceforge.net>>>
Subject: Re: [Geoserver-users] ImageMosaic-JDBC Tutorial Issues

Hi Kevin

I would use PostGis raster columns.

Using pastebin.com<http://pastebin.com><http://pastebin.com><http://pastebin.com> for stack traces is ok, will have a look at it later.

About temporal queries. Do you want to use the "time" parameter in WMS requests ? I never used it and the imagemosiac-JDBC module has no temporal support !!!

Cheers
Christian

On Tue, Aug 6, 2013 at 1:44 PM, Weiss, Kevin <kweiss01@anonymised.com<mailto:kweiss01@anonymised.com><mailto:kweiss01@anonymised.com><mailto:kweiss01@anonymised.com<mailto:kweiss01@anonymised.com740...<mailto:kweiss01@anonymised.com>>>> wrote:
Hello Christian,
For the purpose of the exercise I was using the Blobs for image data storage. With regards to my end goal, I’m not sold on one approach over the other. I’m just looking to prototype a solution that allows me to programmatically store spatial imagery in the database from a java application and have it available for display via GeoServer while allowing temporal queries. Along the lines of looping weather radar imagery.

Any help you could provide in either direction would be great.

Is there a preferred location for providing stack traces and such? I didn’t want to attach the files and spam the whole mailing list.

Thanks,

Kevin M. Weiss

From: Christian Mueller [mailto:christian.mueller@anonymised.com<mailto:christian.mueller@anonymised.com><mailto:christian.mueller@anonymised.com<mailto:christian.mueller@anonymised.com>>]
Sent: Tuesday, August 06, 2013 5:16 AM
To: Weiss, Kevin
Cc: geoserver-users@lists.sourceforge.net<mailto:geoserver-users@anonymised.comceforge.net><mailto:geoserver-users@lists.sourceforge.net><mailto:geoserver-users@lists.sourceforge.net<mailto:geoserver-users@anonymised.comsourceforge.net<mailto:geoserver-users@lists.sourceforge.net>>>
Subject: Re: [Geoserver-users] ImageMosaic-JDBC Tutorial Issues

Hi Kevin

A question, do you want to use PostGis Raster columns as described here
http://docsgeoserver.org/stable/en/user/data/raster/postgisraster.html<http://docs.geoserver.org/stable/en/user/data/raster/postgisraster.html>

or do you want to use Blobs for your image data.

At the moment, I have no access to pastebin.com<http://pastebin.com><http://pastebin.com><http://pastebin.com> due to firewall rules of my customer.

Cheers
Christian

On Mon, Aug 5, 2013 at 10:39 PM, Weiss, Kevin <kweiss01@anonymised.com<mailto:kweiss01@anonymised.com><mailto:kweiss01@anonymised.com><mailto:kweiss01@anonymised.com<mailto:kweiss01@anonymised.com5740...<mailto:kweiss01@anonymised.com>>>> wrote:
I'm trying to configure an ImageMosaic-JDBC coverage per the instructions (http://docs.geoserverorg/2.3.0/user/tutorials/imagemosaic-jdbc/imagemosaic-jdbc_tutorial.html<http://docs.geoserver.org/2.3.0/user/tutorials/imagemosaic-jdbc/imagemosaic-jdbc_tutorial.html>><http://docs.geoserver.org/2.30/user/tutorials/imagemosaic-jdbc/imagemosaic-jdbc_tutorial.html>\) and keep getting the following error "Could not list layers for this store, an error occurred retrieving them: Argument "value" should not be null."

I've searched through the mailing list and have seen similar threads, but can't find a solution to the problem. If anyone can help me out I'd appreciate it. I'll attach pastebin links for the typically requested files.

The system is GeoServer 2.3.0 with the WPS and ImagePyramid plugins added. Java 1.6.0_38 running on a CentOS 6 box and a postgres-9.2/PostGIS 2.0 database.

As a side note, my end goal is to construct a Raster Catalog containing temporal imagery which can be retrieved and looped via GeoServer with the rasters being persisted in postgres/postgis. If anyone has accomplished something similar and is willing to give me some help or tips I would greatly appreciate it.

Here is the relevant stacktrace from geoserver.log
http://pastebin.com/trL6zpmX

osm.postgis.xml
http://pastebin.com/x0KaJB0n

mapping.postgis.xml.inc
http://pastebin.com/KLpFDmtK

connect.postgis.xml.inc
http://pastebin.com/P8FwtcKS

Thanks,

Kevin M. Weiss
------------------------------------------------------------------------------
Get your SQL database under version control now!
Version control is standard for application code, but databases havent
caught up. So what steps can you take to put your SQL databases under
version control? Why should you start doing it? Read more to find out.
http://pubads.g.doubleclick.net/gampad/clk?id=49501711&iu=/4140/ostg.clktrk
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net<mailto:Geoserver-users@anonymised.comrge.net><mailto:Geoserver-users@lists.sourceforge.net><mailto:Geoserver-users@lists.sourceforge.net<mailto:Geoserver-users@anonymised.comceforge.net<mailto:Geoserver-users@lists.sourceforge.net>>>
https://lists.sourceforge.net/lists/listinfo/geoserver-users

--
DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH

Christian_Mueller · August 8, 2013, 4:13pm

Output from gdalinfo looks good.

I think I will do some debugging tomorrow.

Is it possible that you can you send me your pgraster.sql and your image, (Only to me, not on the mailing list).

Christian

···

On Thu, Aug 8, 2013 at 5:54 PM, Weiss, Kevin <kweiss01@anonymised.com> wrote:

Christian,
Here is the output from gdalinfo

$>gdalinfo ecnremappedir.png
Driver: PNG/Portable Network Graphics
Files: ecnremappedir.png
ecnremappedir.pgw
Size is 2880, 2880
Coordinate System is `’
Origin = (-128.015625000000000,90.015625000000000)
Pixel Size = (0.031250000000000,-0.031250000000000)
Image Structure Metadata:
INTERLEAVE=PIXEL
Corner Coordinates:
Upper Left (-128.0156250, 90.0156250)
Lower Left (-128.0156250, 0.0156250)
Upper Right ( -38.0156250, 90.0156250)
Lower Right ( -38.0156250, 0.0156250)
Center ( -83.0156250, 45.0156250)
Band 1 Block=2880x1 Type=Byte, ColorInterp=Red
Band 2 Block=2880x1 Type=Byte, ColorInterp=Green
Band 3 Block=2880x1 Type=Byte, ColorInterp=Blue

Kevin M. Weiss

Software Engineer

HARRIS IT Services

1408 Fort Crook Road South

Bellevue, NE 68005

kweiss01@anonymised.com

From: Christian Mueller [christian.mueller@anonymised.com]

Sent: Thursday, August 08, 2013 10:47 AM

To: Weiss, Kevin
Cc: geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] ImageMosaic-JDBC Tutorial Issues

Hi Kevin

Maybe your image data is not supported by the java image IO library. Can you post me the the output of

gdalinfo myimage

Christian

On Thu, Aug 8, 2013 at 5:34 PM, Weiss, Kevin <kweiss01@anonymised.com mailto:[kweiss01@anonymised.com](mailto:kweiss01@anonymised.com)> wrote:
Christian,
Rather than altering the files I had created while following the first tutorial, I started fresh following the tutorial here:
http://docs.geotools.org/latest/userguide/library/coverage/pgraster.html

The mapping xml file in that tutorial already has the spatialExtension set to “pgraster” so I didn’t need to modify anything. I merely copied & pasted for that file.

Kevin M. Weiss

Software Engineer

HARRIS IT Services

1408 Fort Crook Road South

Bellevue, NE 68005

kweiss01@anonymised.com5740…mailto:[kweiss01@anonymised.com40...](mailto:kweiss01@anonymised.com)

From: Christian Mueller [christian.mueller@anonymised.com mailto:[christian.mueller@anonymised.com](mailto:christian.mueller@anonymised.com)]

Sent: Thursday, August 08, 2013 10:29 AM
To: Weiss, Kevin

Cc: geoserver-users@lists.sourceforge.net mailto:[geoserver-users@anonymised.comge.net](mailto:geoserver-users@lists.sourceforge.net)
Subject: Re: [Geoserver-users] ImageMosaic-JDBC Tutorial Issues

No I am confused. Did you change and test with spatialExtension=“pgraster” instead of “postgis”. (After importing with raster2pgsql)

On Thu, Aug 8, 2013 at 5:24 PM, Weiss, Kevin <kweiss01@anonymised.com mailto:[kweiss01@anonymised.com](mailto:kweiss01@anonymised.com)<mailto:kweiss01@anonymised.com mailto:[kweiss01@anonymised.com](mailto:kweiss01@anonymised.com)>> wrote:
Hello Christian,

Yes, the mapping xml file is copied verbatim from the tutorial. The connect and coverage xml files were only modified for our connection info and to change the coverage name from “oek” to “satellite” to match my data.

Kevin M. Weiss

Software Engineer

HARRIS IT Services

1408 Fort Crook Road South

Bellevue, NE 68005

kweiss01@anonymised.com mailto:[kweiss01@anonymised.com](mailto:kweiss01@anonymised.com)<mailto:kweiss01@anonymised.com mailto:[kweiss01@anonymised.com](mailto:kweiss01@anonymised.com)>

From: Christian Mueller [christian.mueller@anonymised.com mailto:[christian.mueller@anonymised.com](mailto:christian.mueller@anonymised.com)<mailto:christian.mueller@anonymised.com mailto:[christian.mueller@anonymised.com...](mailto:christian.mueller@anonymised.com)>]

Sent: Thursday, August 08, 2013 10:19 AM
To: Weiss, Kevin

Cc: geoserver-users@lists.sourceforge.net mailto:[geoserver-users@anonymised.comge.net](mailto:geoserver-users@lists.sourceforge.net)<mailto:geoserver-users@lists.sourceforge.net mailto:[geoserver-users@anonymised.comnet](mailto:geoserver-users@lists.sourceforge.net)>
Subject: Re: [Geoserver-users] ImageMosaic-JDBC Tutorial Issues

Hi Kevin

Did you change the value of the xml element “spatialExtension” to “PGRASTER”

On Tue, Aug 6, 2013 at 5:37 PM, Weiss, Kevin <kweiss01@anonymised.com mailto:[kweiss01@anonymised.com](mailto:kweiss01@anonymised.com)<mailto:kweiss01@anonymised.com mailto:[kweiss01@anonymised.com](mailto:kweiss01@anonymised.com)><mailto:kweiss01@anonymised.com mailto:[kweiss01@anonymised.com](mailto:kweiss01@anonymised.com)<mailto:kweiss01@anonymised.com mailto:[kweiss01@anonymised.com](mailto:kweiss01@anonymised.com)>>> wrote:
Christian,
I have followed the PostGIS raster tutorial and seemed to have ended up in the same situation as before. When I try to add the ImageMosaic-JDBC store I receive the dreaded “Could not list layers for this store, an error occurred retrieving them: Argument “value” should not be null.” error.
Here are the steps I took

I loaded the raster into the DB:
raster2pgsql –I –C –s 4326 satellite.png public.satellite > pgraster.sql
psql –U xxxx –d xxxx –h xxxx –f pgraster.sql

Then I created the mosaic table using the sql in the tutorial and added a row for my previously loaded raster:
insert into mosaic (name, tiletable) values (‘satellite’, ‘satellite’);

Then I created the mapping, connect and coverage xml files as described in the tutorial only modifying the DB connection info and the coverageName value in the coverage xml file to match the value in the mosaic table.

One thing I’ve noticed is that despite my coverageName specifying ‘satellite’ all lower case, I get an error stating “No level available for Satellite” in the GeoServer logs. When I update the name in the mosaic table to ‘Satellite’ then I get a NullPointerException in ImageMosaicJDBCReader line 164. I’m not sure why it would auto-capitalize my coverage name as all the references I’ve made are lower case.

Kevin M. Weiss

From: Christian Mueller [mailto:christian.mueller@anonymised.com mailto:[christian.mueller@anonymised.com](mailto:christian.mueller@anonymised.com)<mailto:christian.mueller@anonymised.com mailto:[christian.mueller@anonymised.com](mailto:christian.mueller@anonymised.com)><mailto:christian.mueller@anonymised.com mailto:[christian.mueller@anonymised.com](mailto:christian.mueller@anonymised.com)<mailto:christian.mueller@anonymised.com.mailto:[christian.mueller@anonymised.com](mailto:christian.mueller@anonymised.com)>>]

Sent: Tuesday, August 06, 2013 9:04 AM
To: Weiss, Kevin

Cc: geoserver-users@lists.sourceforge.net mailto:[geoserver-users@lists.sourceforge.net](mailto:geoserver-users@lists.sourceforge.net)<mailto:geoserver-users@lists.sourceforge.net mailto:[geoserver-users@lists.sourceforge.net](mailto:geoserver-users@lists.sourceforge.net)><mailto:geoserver-users@lists.sourceforge.net mailto:[geoserver-users@lists.sourceforge.net](mailto:geoserver-users@lists.sourceforge.net)<mailto:geoserver-users@lists.sourceforge.net mailto:[geoserver-users@lists.sourceforge.net](mailto:geoserver-users@anonymised.comsts.sourceforge.net)>>

Subject: Re: [Geoserver-users] ImageMosaic-JDBC Tutorial Issues

The imagemosiac-jdbc is NOT an extension of the ImageMosaic plugin and lacks temporal support.

The tutorial link in your previous mail is a good starting point.

Cheers
Christian

On Tue, Aug 6, 2013 at 3:38 PM, Weiss, Kevin <kweiss01@anonymised.com mailto:[kweiss01@anonymised.com](mailto:kweiss01@anonymised.com)<mailto:kweiss01@anonymised.com mailto:[kweiss01@anonymised.com](mailto:kweiss01@anonymised.com)><mailto:kweiss01@anonymised.com mailto:[kweiss01@anonymised.com](mailto:kweiss01@anonymised.com)<mailto:kweiss01@anonymised.com mailto:[kweiss01@anonymised.com](mailto:kweiss01@anonymised.com)>>> wrote:
Hello Christian,

Yes, I was hoping to use the “time” parameter in WMS. I had prototyped an example using the time & elevation tutorial (link below) a while back and just assumed that the ImageMosaic-JDBC was an extension of the ImageMosaic plugin and would support time-series as well.
http://docs.geoserver.org/latest/en/user/tutorials/imagemosaic_timeseries/imagemosaic_timeseries.html#tutorial-imagemosaic-timeseries

Is this the best tutorial for configuring GeoServer with PostGIS Raster? Even if it doesn’t support the time parameter, I’d at least like to get a prototype running.
http://docs.geotools.org/latest/userguide/library/coverage/pgraster.html

Thanks,

Kevin M. Weiss

From: Christian Mueller [mailto:christian.mueller@anonymised.com mailto:[christian.mueller@anonymised.com](mailto:christian.mueller@anonymised.com)<mailto:christian.mueller@anonymised.com mailto:[christian.mueller@anonymised.com](mailto:christian.mueller@anonymised.com)><mailto:christian.mueller@anonymised.com mailto:[christian.mueller@anonymised.com](mailto:christian.mueller@anonymised.com)<mailto:christian.mueller@anonymised.com.mailto:[christian.mueller@anonymised.com](mailto:christian.mueller@anonymised.com)>>]

Sent: Tuesday, August 06, 2013 7:42 AM

To: Weiss, Kevin

Cc: geoserver-users@lists.sourceforge.net mailto:[geoserver-users@lists.sourceforge.net](mailto:geoserver-users@lists.sourceforge.net)<mailto:geoserver-users@lists.sourceforge.net mailto:[geoserver-users@lists.sourceforge.net](mailto:geoserver-users@lists.sourceforge.net)><mailto:geoserver-users@lists.sourceforge.net mailto:[geoserver-users@lists.sourceforge.net](mailto:geoserver-users@lists.sourceforge.net)<mailto:geoserver-users@lists.sourceforge.net mailto:[geoserver-users@lists.sourceforge.net](mailto:geoserver-users@anonymised.comsts.sourceforge.net)>>

Subject: Re: [Geoserver-users] ImageMosaic-JDBC Tutorial Issues

Hi Kevin

I would use PostGis raster columns.

Using pastebin.com<http://pastebin.com><http://pastebin.com><http://pastebin.com> for stack traces is ok, will have a look at it later.

About temporal queries. Do you want to use the “time” parameter in WMS requests ? I never used it and the imagemosiac-JDBC module has no temporal support !!!

Cheers
Christian

On Tue, Aug 6, 2013 at 1:44 PM, Weiss, Kevin <kweiss01@anonymised.com mailto:[kweiss01@anonymised.com](mailto:kweiss01@anonymised.com)<mailto:kweiss01@anonymised.com mailto:[kweiss01@anonymised.com](mailto:kweiss01@anonymised.com)><mailto:kweiss01@anonymised.com mailto:[kweiss01@anonymised.com](mailto:kweiss01@anonymised.com)<mailto:kweiss01@anonymised.com mailto:[kweiss01@anonymised.com](mailto:kweiss01@anonymised.com)>>> wrote:
Hello Christian,
For the purpose of the exercise I was using the Blobs for image data storage. With regards to my end goal, I’m not sold on one approach over the other. I’m just looking to prototype a solution that allows me to programmatically store spatial imagery in the database from a java application and have it available for display via GeoServer while allowing temporal queries. Along the lines of looping weather radar imagery.

Any help you could provide in either direction would be great.

Is there a preferred location for providing stack traces and such? I didn’t want to attach the files and spam the whole mailing list.

Thanks,

Kevin M. Weiss

From: Christian Mueller [mailto:christian.mueller@anonymised.com mailto:[christian.mueller@anonymised.com](mailto:christian.mueller@anonymised.com)<mailto:christian.mueller@anonymised.com mailto:[christian.mueller@anonymised.com](mailto:christian.mueller@anonymised.com)><mailto:christian.mueller@anonymised.com mailto:[christian.mueller@anonymised.com](mailto:christian.mueller@anonymised.com)<mailto:christian.mueller@anonymised.com.mailto:[christian.mueller@anonymised.com](mailto:christian.mueller@anonymised.com)>>]

Sent: Tuesday, August 06, 2013 5:16 AM
To: Weiss, Kevin

Cc: geoserver-users@lists.sourceforge.net mailto:[geoserver-users@lists.sourceforge.net](mailto:geoserver-users@lists.sourceforge.net)<mailto:geoserver-users@lists.sourceforge.net mailto:[geoserver-users@lists.sourceforge.net](mailto:geoserver-users@lists.sourceforge.net)><mailto:geoserver-users@lists.sourceforge.net mailto:[geoserver-users@lists.sourceforge.net](mailto:geoserver-users@lists.sourceforge.net)<mailto:geoserver-users@lists.sourceforge.net mailto:[geoserver-users@lists.sourceforge.net](mailto:geoserver-users@anonymised.comsts.sourceforge.net)>>

Subject: Re: [Geoserver-users] ImageMosaic-JDBC Tutorial Issues

Hi Kevin

A question, do you want to use PostGis Raster columns as described here
http://docsgeoserver.org/stable/en/user/data/raster/postgisraster.html<http://docs.geoserver.org/stable/en/user/data/raster/postgisraster.html>

or do you want to use Blobs for your image data.

At the moment, I have no access to pastebin.com<http://pastebin.com><http://pastebin.com><http://pastebin.com> due to firewall rules of my customer.

Cheers
Christian

On Mon, Aug 5, 2013 at 10:39 PM, Weiss, Kevin <kweiss01@anonymised.com mailto:[kweiss01@anonymised.com](mailto:kweiss01@...5740...)<mailto:kweiss01@anonymised.com mailto:[kweiss01@anonymised.com](mailto:kweiss01@...5740...)><mailto:kweiss01@anonymised.com mailto:[kweiss01@anonymised.com](mailto:kweiss01@anonymised.com)<mailto:kweiss01@anonymised.com mailto:[kweiss01@anonymised.com](mailto:kweiss01@anonymised.com)>>> wrote:
I’m trying to configure an ImageMosaic-JDBC coverage per the instructions (http://docs.geoserverorg/2.3.0/user/tutorials/imagemosaic-jdbc/imagemosaic-jdbc_tutorial.html<http://docs.geoserverorg/2.3.0/user/tutorials/imagemosaic-jdbc/imagemosaic-jdbc_tutorial.html<http://docs.geoserver.org/2.3.0/user/tutorials/imagemosaic-jdbc/imagemosaic-jdbc_tutorial.html>><http://docs.geoserver.org/2.30/user/tutorials/imagemosaic-jdbc/imagemosaic-jdbc_tutorial.html>) and keep getting the following error “Could not list layers for this store, an error occurred retrieving them: Argument “value” should not be null.”

I’ve searched through the mailing list and have seen similar threads, but can’t find a solution to the problem. If anyone can help me out I’d appreciate it. I’ll attach pastebin links for the typically requested files.

The system is GeoServer 2.3.0 with the WPS and ImagePyramid plugins added. Java 1.6.0_38 running on a CentOS 6 box and a postgres-9.2/PostGIS 2.0 database.

As a side note, my end goal is to construct a Raster Catalog containing temporal imagery which can be retrieved and looped via GeoServer with the rasters being persisted in postgres/postgis. If anyone has accomplished something similar and is willing to give me some help or tips I would greatly appreciate it.

Here is the relevant stacktrace from geoserver.log
http://pastebin.com/trL6zpmX

osm.postgis.xml
http://pastebin.com/x0KaJB0n

mapping.postgis.xml.inc
http://pastebin.com/KLpFDmtK

connect.postgis.xml.inc
http://pastebin.com/P8FwtcKS

Thanks,

Kevin M. Weiss

Get your SQL database under version control now!
Version control is standard for application code, but databases havent
caught up. So what steps can you take to put your SQL databases under
version control? Why should you start doing it? Read more to find out.
http://pubads.g.doubleclick.net/gampad/clk?id=49501711&iu=/4140/ostg.clktrk

Geoserver-users mailing list

Geoserver-users@lists.sourceforge.net mailto:[Geoserver-users@lists.sourceforge.net](mailto:Geoserver-users@anonymised.comists.sourceforge.net)<mailto:Geoserver-users@lists.sourceforge.net mailto:[Geoserver-users@lists.sourceforge.net](mailto:Geoserver-users@anonymised.coms.sourceforge.net)><mailto:Geoserver-users@lists.sourceforge.net mailto:[Geoserver-users@lists.sourceforge.net](mailto:Geoserver-users@anonymised.comts.sourceforge.net)<mailto:Geoserver-users@anonymised.comists.sourceforge.net mailto:[Geoserver-users@lists.sourceforge.net](mailto:Geoserver-users@anonymised.comsourceforge.net)>>

https://lists.sourceforge.net/lists/listinfo/geoserver-users

–
DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH

–
DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH

–
DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH

–
DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH

–
DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH

–
DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH

–

DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH