[Geoserver-users] Database pooling for clustered Geoserver configuration

2017-02-08 Thread dimmihel
Hi, *Problem:* Cannot find resources to implement database pooling for a clustered Geoserver configuration. *Background:* I have a Geoserver (2.10) cluster (4 x) using Tomcat 7 containers (4 x) and using apache2 as a front-end proxy/load balancer on Ubuntu 16.04.1 LTS. All Geoservers can be used

[Geoserver-users] footprints

2017-02-08 Thread admire
Hi How can I configure my mosaic with a footprint shapefile using the REST API. 1) How can I post my footprint shapefile to my data store using rest ? 2) Are there any tools or commands using the REST API to generate footprints shapefile or I need to use gdal ---

[Geoserver-users] SLD filename path

2017-02-08 Thread Hemin Tofiq
Hi, When I create a style in GeoServer, a stylename.xml and a stylename.sld file will be created, stylename.xml points to stylename.sld, my question is whether it is possible to locate the *.sld file at another location? or in other words; Can I specify another directory for styles? I far as I ca

Re: [Geoserver-users] Creating a spatial view from an XY table in MS SQL Server?

2017-02-08 Thread Andrea Aime
On Tue, Feb 7, 2017 at 7:56 PM, Martin Davis wrote: > Another user reported that this even works with defining the view as a > GeoServer SQL View, which is a very handy capability. It would be nice if > this worked for Oracle as well! > For Oracle to work this fella needs to be fixed (basically

Re: [Geoserver-users] Error when creating SQL view with parameters via REST

2017-02-08 Thread Andrea Aime
Hi David, I don't know what's going on, but generally speaking, the REST API is best used via XML payloads, the JSON ones have suffered from some hiccups here and there. Cheers Andrea On Tue, Feb 7, 2017 at 7:03 PM, David Haynes II wrote: > Hello, > > I am running into an error when creating a

Re: [Geoserver-users] footprints

2017-02-08 Thread Andrea Aime
On Wed, Feb 8, 2017 at 1:58 PM, admire wrote: > Hi > > How can I configure my mosaic with a footprint shapefile using the REST > API. > > 1) How can I post my footprint shapefile to my data store using rest ? > There is no way, you have to add the footprints in the mosaic directly. > > 2) Are

Re: [Geoserver-users] Database pooling for clustered Geoserver configuration

2017-02-08 Thread Andrea Aime
Hi, it is not clear to me what you want to achieve here. GeoServer datastores already use pooling out of the box, they are suitably used as is, unless you have many stores connecting to the same database. If that's the case, then pools configured in JNDI are a better option, allowing to share a si

Re: [Geoserver-users] Error when creating SQL view with parameters via REST

2017-02-08 Thread Andrea Aime
On Wed, Feb 8, 2017 at 8:03 PM, David Haynes II wrote: > I will try switching it to xml and see how that works. Are you sure the > REST isn't skipping the java layer and submitting directly to PostgreSQL? > Hum... I did not write the REST api, but I cannot see how it might submit direclty to pos

Re: [Geoserver-users] Error when creating SQL view with parameters via REST

2017-02-08 Thread David Haynes II
Hello everyone, I guess this is more a question about how the REST API is functioning and if it is perhaps submitting information straight to PosgreSQL instead of encountering the java layer first and allowing it to submit to PostgreSQL Here is a JSON request that does not work This sql is buried

[Geoserver-users] Style Editor Preview Legend Errors

2017-02-08 Thread sikeoka
Using the Preview Legend feature on YSLD styles causes an XML parsing error "Content is not allowed in prolog" since org.geoserver.wms.web.data.StyleAdminPanel currently only handles SLD styles: StyleInfo si = new StyleInfoImpl(stylePage.getCatalog()); String styleName = "tmp" + UUID.randomUUID().

Re: [Geoserver-users] Style Editor Preview Legend Errors

2017-02-08 Thread Jody Garnett
Thanks for the bug report - I have gone ahead and added it to the community issue tracker: https://osgeo-org.atlassian.net/browse/GEOT-5638 There are instructions for reporting bugs on the website here for future use. One of my co-workers, Alex Goudine, was looking

Re: [Geoserver-users] SLD filename path

2017-02-08 Thread Jody Garnett
I am not sure if you can do that (perhaps via the rest api?). Ut would be a good feature request. One thing to keep in mind is that the styles folders are special in that they are published via a URL (this is how the relative links to icons and fonts are expected to function if an external server

Re: [Geoserver-users] Error when creating SQL view with parameters via REST

2017-02-08 Thread P O'Toole
David - >I will try switching it to xml and see how that works. Are you sure the >> REST isn't skipping the java layer and submitting directly to PostgreSQL? >Hum... I did not write the REST api, but I cannot see how it might submit >direclty to postgresql, makes no sense. >Can you also share the