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.cancellieri@anonymised.com> 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 <ebarker111@anonymised.com> 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.cancellieri@anonymised.com> 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.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.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, <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
> > >
> > >
> > >
> > >
> ------------------------------------------------------------------------------
> > > 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/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
> >
> > -------------------------------------------------------
>
>