when I remove the postgres driver from geoserver WEB-INF/lib causes my postgres stores that worked to fail
---- Simone Giannecchini <simone.giannecchini@anonymised.com> wrote:
Ciao,
you also need to remove the driver from the geoserver WEB-INF/lib
directory for this to work.Check this post:
http://bit.ly/1hgM5wnRegards,
Simone GiannecchiniMeet us at GEO Business 2014! in London! Visit http://goo.gl/fES3aK
for more information.Ing. Simone Giannecchini
@simogeo
Founder/DirectorGeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054 Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39 333 8128928http://www.geo-solutions.it
http://twitter.com/geosolutions_it-------------------------------------------------------
On Thu, Mar 13, 2014 at 11:20 PM, <ebarker111@anonymised.com> wrote:
> 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
>> > >
>> > > -------------------------------------------------------
>> >
>> >
>