[Geoserver-users] Getting an error when trying to save imagemosaic store

thanks. I tried that and I get:

Error creating data store, check the parameters. Error message: Cannot find JNDI data source: java:comp/env/jdbc/WxCasterData

Note: I am a Meteorologist who writes applications to process and display various weather products (radar and satellite imagery, model graphics, forecaster created graphics, etc). I know enough about web hosting on my Windows PC to get IIS installed and running, installing php, etc., I know enough to get GeoServer running (I love viewing my vector graphics products in GeoServer that were stored in Postgres (watches, warnings, mesoscale discussions, convective outlooks, etc), which I appreciate your hard work (because it was easy for me to stand up (first products up within 1 hour of GeoServer install). I however have 0% knowledge on how to set up the JNDI at all.

       If someone can direct me to how to do it in Windows, I'd really appreciate it. I can live with WorldImage, but I'd love to provide my users with more than just the most recent image (for looping , etc).

Earl

---- Simone Giannecchini <simone.giannecchini@anonymised.com> wrote:

Ciao Earl,
please, find my answer inline below...

Regards,
Simone Giannecchini

Our support, Your Success! Visit http://opensdi.geo-solutions.it for
more information.

Ing. Simone Giannecchini
@simogeo
Founder/Director

GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054 Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39 333 8128928

http://www.geo-solutions.it
http://twitter.com/geosolutions_it

-------------------------------------------------------

On Sat, Mar 1, 2014 at 8:17 PM, <ebarker111@anonymised.com> wrote:
> Trying to create the Image Mosaic store from scratch. Getting this error trying to connect to the
>
> Caused by: java.lang.IllegalArgumentException: java.io.IOException: Cannot find JNDI data source: java:comp/env/jdbc/postgres
> at org.geotools.gce.imagemosaic.catalog.GTDataStoreGranuleCatalog.<init>(GTDataStoreGranuleCatalog.java:194)
> at org.geotools.gce.imagemosaic.catalog.GranuleCatalogFactory.createGranuleCatalog(GranuleCatalogFactory.java:68)
> at org.geotools.gce.imagemosaic.CatalogManager.createGranuleCatalogFromDatastore(CatalogManager.java:163)

It looks like you are trying to access a JNDI connection pool which is
not available. Try to create a datastore directly in the UI for
GeoServer for that JNDI name to make sure is correct
and double check the config in Tomcat (or whateevr the application
server you are using is).

That said, I would not explicitly force preparedStatements to true.

Let us know how it goes.

>
> Three files in additional to the png and pgw files:
>
> datastore.properties :
>
> SPI=org.geotools.data.postgis.PostgisNGJNDIDataStoreFactory
> jndiReferenceName=java:comp/env/jdbc/postgres
> host=localhost
> port 5432
> database=WxCasterData
> schema=public
> Loose\ bbox=true
> Estimated\ extends=false
> validate\ connections=true
> Connection\ timeout=10
> preparedStatements=true
>
> indexer.properties:
>
> TimeAttribute=time
> Schema=*geom:Polygon,location:String,time:java.util.Date,
> PropertyCollectors=TimestampFileNameExtractorSPI[timeregex](ingestion)
>
> timeregex.properties:
>
> regex=[0-9]{8}T[0-9]{9}Z(\?!.\*[0-9]{8}T[0-9]{9}Z.\*)
>
> ---- ebarker111@anonymised.com wrote:
>> Yes, pretty simple image, here is the content:
>>
>>
>> 0.01
>> 0.0
>> 0.0
>> -0.01
>> -125.0
>> 50.0
>> ---- Daniele Romagnoli <daniele.romagnoli@anonymised.com> wrote:
>> > Hi,
>> > Do you also have world files for those images?
>> >
>> > Daniele
>> >
>> > ==
>> > Our support, Your Success! Visit http://opensdi.geo-solutions.it for more
>> > information.
>> > ==
>> > Ing. Daniele Romagnoli
>> > Senior Software Engineer
>> >
>> > GeoSolutions S.A.S.
>> > Via Poggio alle Viti 1187
>> > 55054 Massarosa (LU)
>> > Italy
>> > phone: +39 0584 962313
>> > fax: +39 0584 1660272
>> >
>> > http://www.geo-solutions.it
>> > http://twitter.com/geosolutions_it
>> >
>> > -------------------------------------------------------
>> >
>> >
>> > On Mon, Feb 24, 2014 at 4:00 PM, <ebarker111@anonymised.com> wrote:
>> >
>> > > Sorry about that.
>> > >
>> > > There are X number of files (I haven't worked out the purging of the db,
>> > > etc yet). The files are named with the date time. etc
>> > > 20140222T200300Z.png
>> > >
>> > > I'll try the mosaic configuration using the mosaicking machinery.
>> > >
>> > > thanks.
>> > > ---- Daniele Romagnoli <daniele.romagnoli@anonymised.com> wrote:
>> > > > Hi,
>> > > > keeping the mailing list in the loop for future reference regarding
>> > > similar
>> > > > issues.
>> > > > That property file will be automatically created by the mosaicking
>> > > > machinery.
>> > > > Could you retry the mosaic configuration without that file in the folder?
>> > > > Not sure to fully understand: do you have a single PNG file?
>> > > >
>> > > > Cheers,
>> > > > Daniele
>> > > >
>> > > > ==
>> > > > Our support, Your Success! Visit http://opensdi.geo-solutions.it for
>> > > more
>> > > > information.
>> > > > ==
>> > > > Ing. Daniele Romagnoli
>> > > > Senior Software Engineer
>> > > >
>> > > > GeoSolutions S.A.S.
>> > > > Via Poggio alle Viti 1187
>> > > > 55054 Massarosa (LU)
>> > > > Italy
>> > > > phone: +39 0584 962313
>> > > > fax: +39 0584 1660272
>> > > >
>> > > > http://www.geo-solutions.it
>> > > > http://twitter.com/geosolutions_it
>> > > >
>> > > > -------------------------------------------------------
>> > > >
>> > > >
>> > > > On Mon, Feb 24, 2014 at 3:26 PM, <ebarker111@anonymised.com> wrote:
>> > > >
>> > > > > Daniele,
>> > > > >
>> > > > > Thanks.. the image is a png, here is the
>> > > > > RADAR_NATIONAL_BREF.properties file content: I created the file
>> > > manually.
>> > > > >
>> > > > > Levels=0.01,0.01
>> > > > > Heterogeneous=false
>> > > > > TimeAttribute=time
>> > > > > AbsolutePath=false
>> > > > > Name=RADAR_NATIONAL_BREF
>> > > > > TypeName=RADAR_NATIONAL_BREF
>> > > > > Caching=false
>> > > > > ExpandToRGB=false
>> > > > > LocationAttribute=location
>> > > > >
>> > > SuggestedSPI=com.sun.media.imageioimpl.plugins.png.CLibPNGImageReaderSpi
>> > > > > LevelsNum=1
>> > > > > ---- Daniele Romagnoli <daniele.romagnoli@anonymised.com> wrote:
>> > > > > > Hi,
>> > > > > > A couple of questions to gather some more info:
>> > > > > > Which format of data are you mosaicking?
>> > > > > > Could you please report the content of
>> > > RADAR_NATIONAL_BREF.properties?
>> > > > > > Does that file it have been automatically created on configuration
>> > > or did
>> > > > > > you set it by yourself?
>> > > > > >
>> > > > > > Please, let us know.
>> > > > > > Best Regards,
>> > > > > > Daniele
>> > > > > >
>> > > > > > ==
>> > > > > > Our support, Your Success! Visit http://opensdi.geo-solutions.it for
>> > > > > more
>> > > > > > information.
>> > > > > > ==
>> > > > > > Ing. Daniele Romagnoli
>> > > > > > Senior Software Engineer
>> > > > > >
>> > > > > > GeoSolutions S.A.S.
>> > > > > > Via Poggio alle Viti 1187
>> > > > > > 55054 Massarosa (LU)
>> > > > > > Italy
>> > > > > > phone: +39 0584 962313
>> > > > > > fax: +39 0584 1660272
>> > > > > >
>> > > > > > http://www.geo-solutions.it
>> > > > > > http://twitter.com/geosolutions_it
>> > > > > >
>> > > > > > -------------------------------------------------------
>> > > > > >
>> > > > > >
>> > > > > > On Sun, Feb 23, 2014 at 1:45 AM, <ebarker111@anonymised.com> wrote:
>> > > > > >
>> > > > > > > I'm trying to create a imagemosaic store of radar mosaics using
>> > > > > postgres
>> > > > > > > for feature info. I'm getting the below error when trying to save
>> > > the
>> > > > > > > store. I have a datastore.properties,
>> > > RADAR_NATIONAL_BREF.properties
>> > > > > files
>> > > > > > > in the data directory. I created a layer from the failed store
>> > > > > (allowed me
>> > > > > > > to save but still had the error), the feature info (validtime,
>> > > location
>> > > > > > > (filename), region, type are all fine. Just no image. I saw a
>> > > post in
>> > > > > > > Sept 25 2013 similar but no resolution other than update for Linux
>> > > > > (I'm on
>> > > > > > > windows). I am running GeoServer 2.4.4. any help would be greatly
>> > > > > > > appreciated. thanks. Below is the error message.
>> > > > > > >
>> > > > > > > Failed to create reader from
>> > > > > > > file://e:\earl-web\radar\geoserver\RADAR_NATIONAL_BREF and hints
>> > > Hints:
>> > > > > > > FILTER_FACTORY = FilterFactoryImpl STYLE_FACTORY = StyleFactoryImpl
>> > > > > > > FEATURE_FACTORY =
>> > > > >
>> > > org.geotools.feature.LenientFeatureFactoryImpl@anonymised.com=
>> > > http FORCE_LONGITUDE_FIRST_AXIS_ORDER = true
>> > > > > > > EXECUTOR_SERVICE = java.util.concurrent.ThreadPoolExecutor@anonymised.com
>> > > > > [Running,
>> > > > > > > pool size = 0, active threads = 0, queued tasks = 0, completed
>> > > tasks =
>> > > > > 0]
>> > > > > > > LENIENT_DATUM_SHIFT = true COMPARISON_TOLERANCE = 1.0E-9
>> > > > > > >
>> > > > > > >
>> > > > > > >
>> > > > > > >
>> > > > >
>> > > ------------------------------------------------------------------------------
>> > > > > > > Managing the Performance of Cloud-Based Applications
>> > > > > > > Take advantage of what the Cloud has to offer - Avoid Common
>> > > Pitfalls.
>> > > > > > > Read the Whitepaper.
>> > > > > > >
>> > > > > > >
>> > > > >
>> > > http://pubads.g.doubleclick.net/gampad/clk?id=121054471&iu=/4140/ostg.clktrk
>> > > > > > > _______________________________________________
>> > > > > > > Geoserver-users mailing list
>> > > > > > > Geoserver-users@lists.sourceforge.net
>> > > > > > > https://lists.sourceforge.net/lists/listinfo/geoserver-users
>> > > > > > >
>> > > > >
>> > > > >
>> > >
>> > >
>>
>>
>> ------------------------------------------------------------------------------
>> Flow-based real-time traffic analytics software. Cisco certified tool.
>> Monitor traffic, SLAs, QoS, Medianet, WAAS etc. with NetFlow Analyzer
>> Customize your own dashboards, set traffic alerts and generate reports.
>> Network behavioral analysis & security monitoring. All-in-one tool.
>> http://pubads.g.doubleclick.net/gampad/clk?id=126839071&iu=/4140/ostg.clktrk
>> _______________________________________________
>> Geoserver-users mailing list
>> Geoserver-users@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>
>
> ------------------------------------------------------------------------------
> Flow-based real-time traffic analytics software. Cisco certified tool.
> Monitor traffic, SLAs, QoS, Medianet, WAAS etc. with NetFlow Analyzer
> Customize your own dashboards, set traffic alerts and generate reports.
> Network behavioral analysis & security monitoring. All-in-one tool.
> http://pubads.g.doubleclick.net/gampad/clk?id=126839071&iu=/4140/ostg.clktrk
> _______________________________________________
> Geoserver-users mailing list
> Geoserver-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/geoserver-users

Earl,

···

Error creating data store, check the parameters. Error message: Cannot find JNDI data source: java:comp/env/jdbc/WxCasterData

This is probably why you still have to configure the connection pool as resource into your application server.
Here is a quick howto to get this working in tomcat:

http://docs.geoserver.org/stable/en/user/tutorials/tomcat-jndi/tomcat-jndi.html

Let we know if this is the case.
Cheers,
Carlo

Note: I am a Meteorologist who writes applications to process and display various weather products (radar and satellite imagery, model graphics, forecaster created graphics, etc). I know enough about web hosting on my Windows PC to get IIS installed and running, installing php, etc., I know enough to get GeoServer running (I love viewing my vector graphics products in GeoServer that were stored in Postgres (watches, warnings, mesoscale discussions, convective outlooks, etc), which I appreciate your hard work (because it was easy for me to stand up (first products up within 1 hour of GeoServer install). I however have 0% knowledge on how to set up the JNDI at all.

If someone can direct me to how to do it in Windows, I’d really appreciate it. I can live with WorldImage, but I’d love to provide my users with more than just the most recent image (for looping , etc).

Earl

---- Simone Giannecchini <simone.giannecchini@anonymised.com> wrote:

Ciao Earl,
please, find my answer inline below…

Regards,
Simone Giannecchini

Our support, Your Success! Visit http://opensdi.geo-solutions.it for
more information.

Ing. Simone Giannecchini
@simogeo
Founder/Director

GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054 Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39 333 8128928

http://www.geo-solutions.it
http://twitter.com/geosolutions_it


On Sat, Mar 1, 2014 at 8:17 PM, <ebarker111@anonymised.com> wrote:

Trying to create the Image Mosaic store from scratch. Getting this error trying to connect to the

Caused by: java.lang.IllegalArgumentException: java.io.IOException: Cannot find JNDI data source: java:comp/env/jdbc/postgres
at org.geotools.gce.imagemosaic.catalog.GTDataStoreGranuleCatalog.(GTDataStoreGranuleCatalog.java:194)
at org.geotools.gce.imagemosaic.catalog.GranuleCatalogFactory.createGranuleCatalog(GranuleCatalogFactory.java:68)
at org.geotools.gce.imagemosaic.CatalogManager.createGranuleCatalogFromDatastore(CatalogManager.java:163)

It looks like you are trying to access a JNDI connection pool which is
not available. Try to create a datastore directly in the UI for
GeoServer for that JNDI name to make sure is correct
and double check the config in Tomcat (or whateevr the application
server you are using is).

That said, I would not explicitly force preparedStatements to true.

Let us know how it goes.

Three files in additional to the png and pgw files:

datastore.properties :

SPI=org.geotools.data.postgis.PostgisNGJNDIDataStoreFactory
jndiReferenceName=java:comp/env/jdbc/postgres
host=localhost
port 5432
database=WxCasterData
schema=public
Loose\ bbox=true
Estimated\ extends=false
validate\ connections=true
Connection\ timeout=10
preparedStatements=true

indexer.properties:

TimeAttribute=time
Schema=*geom:Polygon,location:String,time:java.util.Date,
PropertyCollectors=TimestampFileNameExtractorSPItimeregex

timeregex.properties:

regex=[0-9]{8}T[0-9]{9}Z(?!.*[0-9]{8}T[0-9]{9}Z.*)

---- ebarker111@anonymised.com… wrote:

Yes, pretty simple image, here is the content:

0.01
0.0
0.0
-0.01
-125.0
50.0
---- Daniele Romagnoli <daniele.romagnoli@anonymised.com> wrote:

Hi,
Do you also have world files for those images?

Daniele

==
Our support, Your Success! Visit http://opensdi.geo-solutions.it for more
information.

Ing. Daniele Romagnoli
Senior Software Engineer

GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054 Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 1660272

http://www.geo-solutions.it
http://twitter.com/geosolutions_it


On Mon, Feb 24, 2014 at 4:00 PM, <ebarker111@anonymised.com> wrote:

Sorry about that.

There are X number of files (I haven’t worked out the purging of the db,
etc yet). The files are named with the date time. etc
20140222T200300Z.png

I’ll try the mosaic configuration using the mosaicking machinery.

thanks.
---- Daniele Romagnoli <daniele.romagnoli@anonymised.com> wrote:

Hi,
keeping the mailing list in the loop for future reference regarding
similar
issues.
That property file will be automatically created by the mosaicking
machinery.
Could you retry the mosaic configuration without that file in the folder?
Not sure to fully understand: do you have a single PNG file?

Cheers,
Daniele

==
Our support, Your Success! Visit http://opensdi.geo-solutions.it for
more
information.

Ing. Daniele Romagnoli
Senior Software Engineer

GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054 Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 1660272

http://www.geo-solutions.it
http://twitter.com/geosolutions_it


On Mon, Feb 24, 2014 at 3:26 PM, <ebarker111@anonymised.com> wrote:

Daniele,

Thanks… the image is a png, here is the
RADAR_NATIONAL_BREF.properties file content: I created the file
manually.

Levels=0.01,0.01
Heterogeneous=false
TimeAttribute=time
AbsolutePath=false
Name=RADAR_NATIONAL_BREF
TypeName=RADAR_NATIONAL_BREF
Caching=false
ExpandToRGB=false
LocationAttribute=location

SuggestedSPI=com.sun.media.imageioimpl.plugins.png.CLibPNGImageReaderSpi

LevelsNum=1
---- Daniele Romagnoli <daniele.romagnoli@anonymised.com> wrote:

Hi,
A couple of questions to gather some more info:
Which format of data are you mosaicking?
Could you please report the content of
RADAR_NATIONAL_BREF.properties?
Does that file it have been automatically created on configuration
or did
you set it by yourself?

Please, let us know.
Best Regards,
Daniele

==
Our support, Your Success! Visit http://opensdi.geo-solutions.it for
more
information.

Ing. Daniele Romagnoli
Senior Software Engineer

GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054 Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 1660272

http://www.geo-solutions.it
http://twitter.com/geosolutions_it


On Sun, Feb 23, 2014 at 1:45 AM, <ebarker111@anonymised.com> wrote:

I’m trying to create a imagemosaic store of radar mosaics using
postgres
for feature info. I’m getting the below error when trying to save
the
store. I have a datastore.properties,
RADAR_NATIONAL_BREF.properties
files
in the data directory. I created a layer from the failed store
(allowed me
to save but still had the error), the feature info (validtime,
location
(filename), region, type are all fine. Just no image. I saw a
post in
Sept 25 2013 similar but no resolution other than update for Linux
(I’m on
windows). I am running GeoServer 2.4.4. any help would be greatly
appreciated. thanks. Below is the error message.

Failed to create reader from
file://e:\earl-web\radar\geoserver\RADAR_NATIONAL_BREF and hints
Hints:
FILTER_FACTORY = FilterFactoryImpl STYLE_FACTORY = StyleFactoryImpl
FEATURE_FACTORY =

org.geotools.feature.LenientFeatureFactoryImpl@anonymised.com380…=
http FORCE_LONGITUDE_FIRST_AXIS_ORDER = true

EXECUTOR_SERVICE = java.util.concurrent.ThreadPoolExecutor@anonymised.com
[Running,
pool size = 0, active threads = 0, queued tasks = 0, completed
tasks =
0]
LENIENT_DATUM_SHIFT = true COMPARISON_TOLERANCE = 1.0E-9


Managing the Performance of Cloud-Based Applications
Take advantage of what the Cloud has to offer - Avoid Common
Pitfalls.
Read the Whitepaper.

http://pubads.g.doubleclick.net/gampad/clk?id=121054471&iu=/4140/ostg.clktrk


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


Flow-based real-time traffic analytics software. Cisco certified tool.
Monitor traffic, SLAs, QoS, Medianet, WAAS etc. with NetFlow Analyzer
Customize your own dashboards, set traffic alerts and generate reports.
Network behavioral analysis & security monitoring. All-in-one tool.
http://pubads.g.doubleclick.net/gampad/clk?id=126839071&iu=/4140/ostg.clktrk


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


Flow-based real-time traffic analytics software. Cisco certified tool.
Monitor traffic, SLAs, QoS, Medianet, WAAS etc. with NetFlow Analyzer
Customize your own dashboards, set traffic alerts and generate reports.
Network behavioral analysis & security monitoring. All-in-one tool.
http://pubads.g.doubleclick.net/gampad/clk?id=126839071&iu=/4140/ostg.clktrk


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


Learn Graph Databases - Download FREE O’Reilly Book
“Graph Databases” is the definitive new guide to graph databases and their
applications. Written by three acclaimed leaders in the field,
this first edition is now available. Download your free book today!
http://p.sf.net/sfu/13534_NeoTech


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

==
Meet us at GEO Business 2014! in London! Visit http://goo.gl/fES3aK for more information.

Dott. Carlo Cancellieri
@cancellieric
Software Engineer

GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054 Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 1660272

http://www.geo-solutions.it
http://twitter.com/geosolutions_it