Earl,
I'm with my tablet so I can't verify your jndi configuration anyhow
consider that my suggestions are just in addiction to the Simone's ones.
If you need an image mosaic with jndi support you still have to use the
image mosaic coverage store pointing to the target folder containing the
images and datastore.properties as previously suggested.
Ciao,
Carlo
Il 13/mar/2014 23:21 <ebarker...@cox.net> ha scritto:
> Cario,
>
> Thanks, no luck yet, but at least I have Tomcat installed and running.
>
> I'm running postgresql for my db. So I downloaded
> postgresql-9.3-1101.jdbc41.jar and copied it to the C:\Program Files\Apache
> Software Foundation\Tomcat 7.0\lib
>
> I added to content.xml in C:\Program Files\Apache Software
> Foundation\Tomcat 7.0\conf
>
> Context allowLinking="true">
> <Resource name="jdbc/postgres" auth="Container"
> type="javax.sql.DataSource"
> url="jdbc:postgresql://127.0.0.1:5432/WxCasterData"
> driverClassName="org.postgresql.driver"
> maxActive="20" maxIdle="3" maxWait="10000"
> poolPreparedStatements="true"
> maxOpenPreparedStatements="100" />
> </Context>
>
> (I removed username and password of course).
>
> In C:\Program Files (x86)\GeoServer 2.4.4\webapps\geoserver\WEB-INF
>
> I added to the end of web.xml:
>
> <welcome-file-list>
> <welcome-file>index.html</welcome-file>
> </welcome-file-list>
> <web-app><resource-ref> <description>Postgres GeoServer
> Datasource</description> <res-ref-name>jdbc/postgres</res-ref-name>
> <res-type>javax.sql.DataSource</res-type> <res-auth>Container</res-auth>
> </resource-ref> </web-app>
>
> Both services restarted.
>
> In GeoServer 2.4.4 Admin gui, I selected in Data->Store, the Add New
> Store widget...
>
> I then selected PostGIS (JNDI).
>
> Here is where I may be having problems with...
>
> I added for Data source name I typed WxCasterDataRaster (I already have
> a GeoServer Postgres store for WxCasterData (for my vector products)..
>
> In the jndiRefeerenceName I had : java:comp/env/jdbc/postgres
>
> schema: public
>
> nothing for anything else.. I could be wrong on the entire GeoServer
> for this store.
>
> thanks,
> Earl
>
> ---- carlo cancellieri <carlo.cancelli...@geo-solutions.it> wrote:
> > Earl,
> > Tomcat is a java based application so it is usable under jvm.
> > Take a look here:
> >
> > http://tomcat.apache.org/tomcat-7.0-doc/windows-service-howto.html
> >
> > Regards,
> > Carlo
> > Il 13/mar/2014 20:04 <ebarker...@cox.net> ha scritto:
> >
> > > Cario
> > >
> > > thanks. But the only OS that I've seen TomCat on are Linux and SUN.
> > > I'm on a Windows box, so any instructions on setting up the connection
> > > pool from a Windows machine would be awesome.
> > >
> > > Earl
> > > ---- carlo cancellieri <carlo.cancelli...@geo-solutions.it> wrote:
> > > > 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.giannecch...@geo-solutions.it>
> wrote:
> > > > > > Ciao Earl,
> > > > > > please, find my answer inline below...
> > > > > >
> > > > > >
> > > > > > Regards,
> > > > > > Simone Giannecchini
> > > > > > ==
> > > > > > Our support, Your Success! Visit http://opensdi.geo-solutions.itfor
> > > > > > 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, <ebarker...@cox.net> 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.\*)
> > > > > > >
> > > > > > > ---- ebarker...@cox.net wrote:
> > > > > > >> Yes, pretty simple image, here is the content:
> > > > > > >>
> > > > > > >>
> > > > > > >> 0.01
> > > > > > >> 0.0
> > > > > > >> 0.0
> > > > > > >> -0.01
> > > > > > >> -125.0
> > > > > > >> 50.0
> > > > > > >> ---- Daniele Romagnoli <daniele.romagn...@geo-solutions.it>
> > > wrote:
> > > > > > >> > Hi,
> > > > > > >> > Do you also have world files for those images?
> > > > > > >> >
> > > > > > >> > Daniele
> > > > > > >> >
> > > > > > >> > ==
> > > > > > >> > Our support, Your Success! Visit
> > > http://opensdi.geo-solutions.itfor 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, <ebarker...@cox.net>
> 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.romagn...@geo-solutions.it>
> > > > > 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, <ebarker...@cox.net>
> > > 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.romagn...@geo-solutions.it>
> > > > > 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, <
> ebarker...@cox.net>
> > > > > 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@1155013FORCE_AXIS_ORDER_HONORING
> > > > > =
> > > > > > >> > > http FORCE_LONGITUDE_FIRST_AXIS_ORDER = true
> > > > > > >> > > > > > > EXECUTOR_SERVICE =
> > > > > java.util.concurrent.ThreadPoolExecutor@1bb310f
> > > > > > >> > > > > [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@lists.sourceforge.net
> > > > > https://lists.sourceforge.net/lists/listinfo/geoserver-users
> > > > >
> > > >
> > > >
> > > >
> > > > --
> > > > ==
> > > > Meet us at GEO Business 2014! in London! Visit http://goo.gl/fES3aKfor
> > > > 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
> > > >
> > > > -------------------------------------------------------
> > >
> > >
>
>
------------------------------------------------------------------------------
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@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
