[Geoserver-users] ImagePyramid using Postgresql for granules

[Darell van der Voort]

Hello everybody,

I'm running Geoserver 2.11.2 on Java 1.8.0_144 32 bits on Amazon Linux
together with Tomcat 9. The plugins I have installed are imagemosaic,
imagepyramid, GeowebCache (internal) and Geofence.

When using the imagemosaic plugin I am able to use a Postgresql DB for
storing the granules and time dimension via a datastore.properties file.
The file looks like:

SPI=org.geotools.data.postgis.PostgisNGJNDIDataStoreFactory
schema=database_schema_name
Loose\ bbox=true
Estimated\ extends=false
validate\ connections=true
Connection\ timeout=10
preparedStatements=true
jndiReferenceName=java:comp/env/jdbc/postgis

Which work as expected. However when I add the same file in the
imagepyramid datastructure, this setup fails. When I add this
datastore.properties in just the lowest level (0) then that level gets
configured in a database table, while the higher levels are configured
using a shapefile. When I add a datastore.properties to all levels,
geoserver returns the following error:

2017-09-28 07:39:40,780 ERROR [gce.imagemosaic] -
java.io.IOException
at
org.geotools.gce.imagemosaic.ImageMosaicConfigHandler.createGranuleCatalogFromDatastore(ImageMosaicConfigHandler.java:406)
at
org.geotools.gce.imagemosaic.ImageMosaicConfigHandler.createCatalog(ImageMosaicConfigHandler.java:329)
at
org.geotools.gce.imagemosaic.ImageMosaicConfigHandler.buildCatalog(ImageMosaicConfigHandler.java:962)
at
org.geotools.gce.imagemosaic.ImageMosaicConfigHandler.indexingPreamble(ImageMosaicConfigHandler.java:941)
at
org.geotools.gce.imagemosaic.ImageMosaicDirectoryWalker$MosaicDirectoryWalker.(ImageMosaicDirectoryWalker.java:109)
at
org.geotools.gce.imagemosaic.ImageMosaicDirectoryWalker.run(ImageMosaicDirectoryWalker.java:197)
at org.geotools.gce.imagemosaic.Utils.createMosaic(Utils.java:460)
at org.geotools.gce.imagemosaic.Utils.checkSource(Utils.java:1336)
at
org.geotools.gce.imagemosaic.ImageMosaicReader.initReaderFromURL(ImageMosaicReader.java:532)
at
org.geotools.gce.imagemosaic.ImageMosaicReader.(ImageMosaicReader.java:479)
at
org.geotools.gce.imagemosaic.ImageMosaicFormat.getReader(ImageMosaicFormat.java:504)
at org.geotools.gce.imagepyramid.Utils.checkSource(Utils.java:200)
at
org.geotools.gce.imagepyramid.ImagePyramidReader.(ImagePyramidReader.java:177)
at
org.geotools.gce.imagepyramid.ImagePyramidFormat.getReader(ImagePyramidFormat.java:249)
at
org.geotools.gce.imagepyramid.ImagePyramidFormat.getReader(ImagePyramidFormat.java:56)
at
org.geoserver.catalog.ResourcePool.getGridCoverageReader(ResourcePool.java:1511)
at
org.geoserver.catalog.ResourcePool.getGridCoverageReader(ResourcePool.java:1441)
at
org.geoserver.catalog.impl.CoverageStoreInfoImpl.getGridCoverageReader(CoverageStoreInfoImpl.java:59)
.
at
org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:748)
Caused by: java.lang.NullPointerException
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:264)
at
org.geotools.gce.imagemosaic.ImageMosaicConfigHandler.createGranuleCatalogFromDatastore(ImageMosaicConfigHandler.java:389)
... 160 more

Is it possible to configure the granules of all levels in the database? And
if so, how would my datastore.properties file look like? Like I said, it
works fine for the lowest level (0) but it fails for all the levels above.
If it may not be possible, is it sufficient to use the shapefiles as an
index for the granules? The geoserver is used in a production environment
and I am worried about performance issues when using the shapefiles as
index.

Furthermore the imagepyramid automatically names the table after the level
folder (0). This folder and table name are automatically created when
configuring the datastore. Is there a way to custom name the folder and
thus the table name? Otherwise I could end up with multiple '0' tables in
the same schema.

Many thanks!

Kind regards,
Darell
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot___
Geoserver-users mailing list

Please make sure you read the following two resources before posting to this 
list:
- Earning your support instead of buying it, but Ian Turton: 
http://www.ianturton.com/talks/foss4g.html#/
- The GeoServer user list posting guidelines: 
http://geoserver.org/comm/userlist-guidelines.html

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

[Geoserver-users] Publishing PostGIS layers - "ident authentication" failures

[Baker, Matthew]

Hello all,

First time poster... hope this isn't too major a problem:

For some reason all of the sudden my production geoserver instance can't 
connect to my postgis database, *BUT my development instance CAN*.

Prod was working fine yesterday.

(Here is the URL for the prod instance, in case anyone wants to have a look:
https://open-geo.dpsk12.org/geoserver/web/wicket/bookmarkable/org.geoserver.web.demo.MapPreviewPage?0)

Basically, all errors are throwing the same message:

FATAL: Ident authentication failed for user "dpsdata"
Unable to obtain connection: FATAL: Ident authentication failed for user 
"dpsdata"

But again, why using my Dev instance, am I able to create a new workspace and a 
new store and point to the same production database and have no issues?

I did some digging into the back-end of the postgresql configuration, and it 
all looks good, and again the fact that Dev can connect just fine... I can use 
the Dev geoserver to connect to the Prod database, make an edit in QGIS 
directly to the Prod database, and see in the openlayers preview from Dev 
showing the updated data.

I'm stumped!

All servers are running the following:

Dev: Geoserver 2.10
Prod: Geoserver 2.11
Servers: CentOS 6
Apache Tomcat
PostgreSQL: 9.5
PostGIS:  2.3.3

Thanks for any help you can give or suggestions for more troubleshooting.

-m

Matthew Baker
Sr. GIS Analyst
Department of Planning and Analysis
Denver Public Schools
matthew_ba...@dpsk12.org
720-423-3419 / x33419

Denver Public Schools Shared Core Values:
Students First * Integrity * Equity * Collaboration * Accountability * Fun

--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot___
Geoserver-users mailing list

Please make sure you read the following two resources before posting to this 
list:
- Earning your support instead of buying it, but Ian Turton: 
http://www.ianturton.com/talks/foss4g.html#/
- The GeoServer user list posting guidelines: 
http://geoserver.org/comm/userlist-guidelines.html

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

[Geoserver-users] rotation on lie pattern fills

[Paul van Genuchten]

Hi i have a typical use case of setting a line pattern fill of 3 colors in 
arbitrary angle

I just created this issue 
https://osgeo-org.atlassian.net/projects/GEOS/issues/GEOS-8306 
, but I noticed 
aspects are already covered by other issues like this one: 
https://osgeo-org.atlassian.net/browse/GEOT-5499 


So maybe better to close my issue, unless it can act as a user story for the 
other issues?

The issue of various wellknownname seem already covered in #GEOT-5500

Related to #GEOT-5499  the 
challenge seems already in the specification, or is it what you are proposing 
there Andrea to reposition subsequent graphics to align with previous?

To set the offset for the various lines would it be the best option to 
introduce the displacement as in #GEOS-5794 
? or does someone has an 
alternative suggestion? Else would be good to reopen this issue

To set the spacing between lines, i didn’t find a parameter in the spec. 
PerpendicularOffset seems not available for fills, any ideas?

Regards, Paul.



--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot___
Geoserver-users mailing list

Please make sure you read the following two resources before posting to this 
list:
- Earning your support instead of buying it, but Ian Turton: 
http://www.ianturton.com/talks/foss4g.html#/
- The GeoServer user list posting guidelines: 
http://geoserver.org/comm/userlist-guidelines.html

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

[Geoserver-users] Get Layer Style as svg imagess according to Category of object

[chhoturam jat]

Hi,
I need to display on layer SVG images instead of the point according to the
category of object.

I have multiple objects with a category, for example, an object as the car,
bus etc.

I created Objects style on GeoServer with two different rule.When applying
on the layer according to category object image are not display showing
blank.

Following is the style I have created  on GeoServer:




http://www.opengis.net/sld; xmlns:ogc="
http://www.opengis.net/ogc; xmlns:xsi="
http://www.w3.org/2001/XMLSchema-instance; version="1.1.0" xmlns:xlink="
http://www.w3.org/1999/xlink; xsi:schemaLocation="http://www.opengis.net/sld
http://schemas.opengis.net/sld/1.1.0/StyledLayerDescriptor.xsd; xmlns:se="
http://www.opengis.net/se;>
  
customObjectLayer

  Objects
  

  bus
  
bus
  
  http://www.opengis.net/ogc;>

  bus
  bus

  
  

  

image/svg+xml
  
  7

  


  car
  
Car
  
  http://www.opengis.net/ogc;>

  car
  car

  
  

  

image/svg+xml
  
  7

  

  

  



Please tell me how to achieve same and where I committing the mistake.


Thanks
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot___
Geoserver-users mailing list

Please make sure you read the following two resources before posting to this 
list:
- Earning your support instead of buying it, but Ian Turton: 
http://www.ianturton.com/talks/foss4g.html#/
- The GeoServer user list posting guidelines: 
http://geoserver.org/comm/userlist-guidelines.html

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

Re: [Geoserver-users] rest/seed/workspace:layername Problem communicating with GeoServer

[steve.omondi]

Hi,Did you get any solutions for this?I'm facing same issue and I can't
figure out how to go about it.Kindly share yours solution.



-
Kind Regards,

Steve Omondi
GIS & DB Developer/DBA
Ramani Online, Ramani Geosystems
--
Sent from: http://osgeo-org.1560.x6.nabble.com/GeoServer-User-f3786390.html--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot___
Geoserver-users mailing list

Please make sure you read the following two resources before posting to this 
list:
- Earning your support instead of buying it, but Ian Turton: 
http://www.ianturton.com/talks/foss4g.html#/
- The GeoServer user list posting guidelines: 
http://geoserver.org/comm/userlist-guidelines.html

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