from:"celati Laurent"

[Geoserver-users] URL domain becomes localhost:8080 when login

2023-02-17 Thread celati Laurent

Good morning,
I work with geoserver 2.21.1 and Jetty  (debian)
The home page loads fine: https://*SERVER_NAME.fr*/geoserver/web/?0.
But when I log in (with id/pswd), there is a problem. The URL becomes
http://*localhost:8080*/geoserver/j_spring_security_check.

Do you know why it becomes "localhost:8080" instead of keeping the server
name?
Thanks a lot for your help.
___
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

If you want to request a feature or an improvement, also see this: 
https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer


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

Re: [Geoserver-users] Geoserver : How Migrate instance Windows 2.18.1 to Debian 2.21.1?

2023-02-07 Thread celati Laurent

Hello,
Thanks.
No, I haven't tried anything yet. Before any attempt, I wanted to know the
best practice to do this task.


Le mar. 7 févr. 2023 à 13:48, Alexandre Gacon  a
écrit :

> Did you try simple copy/paste of data_dir?
>
> Le mar. 7 févr. 2023 à 12:40, celati Laurent  a
> écrit :
>
>> Good morning,
>> I'm taking the liberty to write a message. I have to migrate a geoserver
>> instance 2.18.1 (windows) to 2.21.1 (Linux Debian).
>> I would like to be able to restore all data if possible (Workspaces,
>> Warehouses, Layers ans styles).
>> FYI, I work with postgresql/postgis tables.
>> What would be good practice to do this? I found this extension in
>> particular:
>>
>> https://docs.geoserver.org/latest/en/user/community/backuprestore/index.html
>>
>> Is using this extension recommended for my case ?
>>
>> Thanks a lot.
>>
>>
>> ___
>> 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
>>
>> If you want to request a feature or an improvement, also see this:
>> https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer
>>
>>
>> Geoserver-users@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>>
>
___
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

If you want to request a feature or an improvement, also see this: 
https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer


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

[Geoserver-users] Geoserver : How Migrate instance Windows 2.18.1 to Debian 2.21.1?

2023-02-07 Thread celati Laurent

Good morning,
I'm taking the liberty to write a message. I have to migrate a geoserver
instance 2.18.1 (windows) to 2.21.1 (Linux Debian).
I would like to be able to restore all data if possible (Workspaces,
Warehouses, Layers ans styles).
FYI, I work with postgresql/postgis tables.
What would be good practice to do this? I found this extension in
particular:

https://docs.geoserver.org/latest/en/user/community/backuprestore/index.html

Is using this extension recommended for my case ?

Thanks a lot.
___
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

If you want to request a feature or an improvement, also see this: 
https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer


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

Re: [Geoserver-users] Serve more 800 JP2 files with Image Mosaic ?

2021-09-07 Thread celati Laurent

(ApplicationFilterChain.java:166)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
at
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:667)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:143)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
at
org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:690)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
at
org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:374)
at
org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
at
org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:888)
at
org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1597)
at
org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at
org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Unknown Source)
Caused by: java.io.IOException: Failed to create reader from
file://D:\SIG-GLOBAL-ANDRA\IGN\BD_SCAN25\temp\SC25_TOUR_0830_6860_L93_E100.jp2
and hints Hints:
  EXECUTOR_SERVICE = java.util.concurrent.ThreadPoolExecutor@427083a[Running,
pool size = 0, active threads = 0, queued tasks = 0, completed tasks = 0]
  REPOSITORY   = org.geoserver.catalog.CatalogRepository@7350f3e4

System defaults:
  FILTER_FACTORY   = FilterFactoryImpl

  STYLE_FACTORY= StyleFactoryImpl

  LENIENT_DATUM_SHIFT  = true

  FORCE_LONGITUDE_FIRST_AXIS_ORDER = true

  FORCE_AXIS_ORDER_HONORING= http

  COMPARISON_TOLERANCE = 1.0E-8

  FEATURE_FACTORY  =
org.geotools.feature.LenientFeatureFactoryImpl@107e4f6a
  GRID_COVERAGE_FACTORY= GridCoverageFactory

TILE_ENCODING  = null


at
org.geoserver.catalog.ResourcePool.getGridCoverageReader(ResourcePool.java:1567)
at
org.geoserver.catalog.ResourcePool.getGridCoverageReader(ResourcePool.java:1511)
at
org.geoserver.catalog.impl.CoverageStoreInfoImpl.getGridCoverageReader(CoverageStoreInfoImpl.java:53)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at
org.geoserver.catalog.impl.ModificationProxy.invoke(ModificationProxy.java:127)
at com.sun.proxy.$Proxy33.getGridCoverageReader(Unknown Source)
at
org.geoserver.web.data.layer.NewLayerPageProvider.getItemsInternal(NewLayerPageProvider.java:86)
... 140 more



Le mar. 7 sept. 2021 à 14:48, Simone Giannecchini <
simone.giannecch...@geosolutionsgroup.com> a écrit :

> Hi Laurent,
> two things:
> -1- For serving JP2 efficiently, you need to use, in my experience, the
> Kakadu SDK, either through GeoServer own direct plugin or via GDAL. Mind
> you, do not expect JP2 to be super fast, regardless of using GeoServer or
> other OS servers.
> -2- 800 files are a lot to show at the same time ( I am assuming these are
> aerial or satellite RGB imagery) when you zoom out; you will need to make
> sure you use exclusion rules based on the zoom level in your style. The
> alternative is to mix this layer with a lower resolution layer
> -3- I think you are missing a JP2 plugin. See -1- above, I would suggest
> using Kakadu, regardless of using GDAL or not.
>
> Hope this helps.
>
> Regards,
> Simone Giannecchini
> ==
> GeoServer Professional Services from the experts!
> Visit http://bit.ly/gs-services for more information.
> ==
> Ing. Simone Giannecchini
> @simogeo
> Founder/Director GeoSolutions Italy
> President GeoSolutions USA
>
> phone: +39 0584 962313
> fax: +39 0584 1660272
> mob:   +39  333 8128928
>
> http://www.geosolutionsgroup.com
> http://twitter.com/geosolutions_it
>
> ---
> This email is intended only for the person or entity to which it is
> addressed and may contain information that is privileged, confidential or
> otherwise protected from disclosure. We remind that - as provided by
> European Regulation 2016/679 “GDPR” - copying, dissemination or use of this
> e-mail or the information herein by anyone other than the intended
> recipient is prohibited. If you have received this email by mistake, please
> notify us immediately by telephone or e-mail.
>
>
> On Tue, Sep 7, 2021 at 11:47 AM celati L

Re: [Geoserver-users] Serve more 800 JP2 files with Image Mosaic ?

2021-09-07 Thread celati Laurent

Following to my previous message,
I provide an edit :
I work with windows 2019 server.

I tried to install so the gdal plugin (in order to be abble to serve 800
JP2 files with image mosaic tools)
thanks to this page:
https://docs.geoserver.org/master/en/user/data/raster/gdal.html


I install this following package from :
https://www.gisinternals.com/release.php
MSVC 2019 new x64 release-1928-x64-gdal-3-3-1-mapserver-7-6-4
<https://www.gisinternals.com/query.html?content=filelist=release-1928-x64-gdal-3-3-1-mapserver-7-6-4.zip>

I set the variables (windows 10) as :

GDAL_DATA=C:\Program
Files\release-1928-x64-gdal-3-3-1-mapserver-7-6-4\bin\gdal-data

PATH=%PATH%;C:\Program
Files\release-1928-x64-gdal-3-3-1-mapserver-7-6-4\bin;C:\Program
Files\release-1928-x64-gdal-3-3-1-mapserver-7-6-4\bin\gdal\java;

GDAL_DRIVER_PATH=C:\Program
Files\release-1928-x64-gdal-3-3-1-mapserver-7-6-4\bin\gdal\plugins


I reboot the server but unfortunatly, new formats don't appear in the store
interface. And i still can't browse my JP2 data.

Anyone has an idea?
It would be interesting to make a try with another gdal package for intance
this one, the MSVC 2017 ?
MSVC 2017 new x64 release-1916-x64-gdal-3-3-1-mapserver-7-6-4
<https://www.gisinternals.com/query.html?content=filelist=release-1916-x64-gdal-3-3-1-mapserver-7-6-4.zip>
  In my case, it would be mandatory or recommanded to install other plugins
as plugin JPEG2K or image pyramid ?

Thanks a lot.





Le mar. 7 sept. 2021 à 11:45, celati Laurent  a
écrit :

> Good morning,
>
> I am a newbie with geoserver.
>
> I work with windows and geoserver 2.18.1.
> I have to serve 800 JP2 files.
> Please find below their characteristics:
> 8 bit unsigned. 3 bands. Pixel size : 2.5,-2.5
> Dimension  : X: 4000 Y: 4000.
>
> Could you tell me which tools, which extensions allow to serve my 800 JP2
> files ?
> I just tried to create a new repository with ImageMosaic but i have this
> error message :
>
> Could not list layers for this store, an error occurred retrieving them:
> Failed to create reader from file://D:\SIG-GLOBAL-ANDRA\IGN\BD_SCAN25\temp
> and hints Hints: REPOSITORY =
> org.geoserver.catalog.CatalogRepository@2b8e2550 EXECUTOR_SERVICE =
> java.util.concurrent.ThreadPoolExecutor@2d8b60c[Running, pool size = 0,
> active threads = 0, queued tasks = 0, completed tasks = 0] System defaults:
> COMPARISON_TOLERANCE = 1.0E-8 GRID_COVERAGE_FACTORY = GridCoverageFactory
> TILE_ENCODING = null FEATURE_FACTORY =
> org.geotools.feature.LenientFeatureFactoryImpl@48e371fa
> LENIENT_DATUM_SHIFT = true FORCE_AXIS_ORDER_HONORING = http FILTER_FACTORY
> = FilterFactoryImpl STYLE_FACTORY = StyleFactoryImpl
> FORCE_LONGITUDE_FIRST_AXIS_ORDER = true
>
>
> Could you confirm to me that ImageMosaic is the relevant tool  for my need
> ?
> I have no install the gdal extension. As far i understood, i have to
> install this extension in order to be abble to serve JP2 files with
> imageMosaic ? Could you confirm to me ?
>
> If there are alternative ways to reach my goals ? Thanks a lot.
>
>
>
___
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

If you want to request a feature or an improvement, also see this: 
https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer


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

[Geoserver-users] Serve more 800 JP2 files with Image Mosaic ?

2021-09-07 Thread celati Laurent

Good morning,

I am a newbie with geoserver.

I work with windows and geoserver 2.18.1.
I have to serve 800 JP2 files.
Please find below their characteristics:
8 bit unsigned. 3 bands. Pixel size : 2.5,-2.5
Dimension  : X: 4000 Y: 4000.

Could you tell me which tools, which extensions allow to serve my 800 JP2
files ?
I just tried to create a new repository with ImageMosaic but i have this
error message :

Could not list layers for this store, an error occurred retrieving them:
Failed to create reader from file://D:\SIG-GLOBAL-ANDRA\IGN\BD_SCAN25\temp
and hints Hints: REPOSITORY =
org.geoserver.catalog.CatalogRepository@2b8e2550 EXECUTOR_SERVICE =
java.util.concurrent.ThreadPoolExecutor@2d8b60c[Running, pool size = 0,
active threads = 0, queued tasks = 0, completed tasks = 0] System defaults:
COMPARISON_TOLERANCE = 1.0E-8 GRID_COVERAGE_FACTORY = GridCoverageFactory
TILE_ENCODING = null FEATURE_FACTORY =
org.geotools.feature.LenientFeatureFactoryImpl@48e371fa LENIENT_DATUM_SHIFT
= true FORCE_AXIS_ORDER_HONORING = http FILTER_FACTORY = FilterFactoryImpl
STYLE_FACTORY = StyleFactoryImpl FORCE_LONGITUDE_FIRST_AXIS_ORDER = true


Could you confirm to me that ImageMosaic is the relevant tool  for my need
?
I have no install the gdal extension. As far i understood, i have to
install this extension in order to be abble to serve JP2 files with
imageMosaic ? Could you confirm to me ?

If there are alternative ways to reach my goals ? Thanks a lot.
___
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

If you want to request a feature or an improvement, also see this: 
https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer


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

[Geoserver-users] Generate raster tiles for basemap : best practices?

2021-08-26 Thread celati Laurent

I work with *Qgis* and *geoserver* on windows.

We need to generate *raster tiles* for basemap *(with a style defined for
different viewing scales)* to serve them throw our geoserver.
Our area of interest is quite important: approximately 5 french
"departments" of the "Grand Est" region/area.
We plan to do testing of raster and vector tiles. But I would first like to
validate a method for raster tiles.
Up to now now, I make tests with the *qgis Tile Generation RASTER XYZ
(Mbtiles)* tool because there is a *geoserver mbtiles plugin* to support
this format. Regarding the input data which are used as input layer for the
tiling, I mainly made tests from the WMS/WMTS basemap provided by the
french mapping agency. The tool works but the processing times are very
long, and seem very memory intensive. Moreover, since I generate the tiles
from a WMS / WMTS stream, the final result also depends on the stability of
the network (high probability of having missing tiles ...). Finally, the
mbtiles file has a quite size (5 or 6 giga for our area of interest). And
the visual result is not that great either.
I don't know if this is because they are raster tiles. Or a reason for EPSG?
It is therefore not optimal.

I am taking the liberty to ask several questions:

*A /* Qgis is a relevant tool for generating tiled files? If not, which
*tool* would be interesting (mapnik, tilemill, gdal, other? I don't know
much about these tools).

*B /* If yes, what is the *most efficient qgis tool*? QTILES plugin?
Gdal2tiles tools? Tools for generating tiles in mbtiles, XYZ, directory
structure? Or generate a Virtual Raster?

*C /* Is there an *output format *to prioritize? (mbtiles, XYZ, directory
structure? VRT ?) *with a view to being made available by geoserver?*

*D /* What would be the *recommendations* in terms of *input layers *(stream,
vector data, raster). In terms of *EPSG*?

*E / *What are the *advantages */ limitations of *vector tiles *compared to
raster tiles?

Thanks a lot.
___
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

If you want to request a feature or an improvement, also see this:
https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer

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

[Geoserver-users] Set a new style (sld file).

2021-08-10 Thread celati Laurent

Good afternoon,
I'm taking the liberty to post a new message
regarding this time style aspects.
I try to upload a new style thanks to a sld file generated from qgis.
But i have an error message when i try to browse the sld. Please find below
the error message :


   - java.lang.RuntimeException: Parsing failed for Filter:
   java.lang.RuntimeException: Unable to find function Literal


For information,
This attempt does not generate geosever additional logs.

For information, please find below the sld file :
Thanks.


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

  GeotekEauCigeo_po_210503
  

  AFFLEUREMENT-EAU
  
AFFLEUREMENT-EAU
  
  http://www.opengis.net/ogc;>

  Type_Ouvra
  AFFLEUREMENT-EAU

  
  0
  50
  

  
circle

  #9db4ec


  #232323
  0.5

  
  7

  


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

  Type_Ouvra
  BASSIN

  
  0
  50
  

  
circle

  #108be4


  #232323
  0.5

  
  7

  


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

  Type_Ouvra
  FONTAINE

  
  0
  50
  

  
circle

  #25e9b8


  #232323
  0.5

  
  7

  


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

  Type_Ouvra
  FORAGE

  
  0
  50
  

  
triangle

  #dba78b


  #232323
  0.5

  
  7

  


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

  Type_Ouvra
  GUE

  
  0
  50
  

  
circle

  #1ada10


  #232323
  0.5

  
  7

  


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

  Type_Ouvra
  INCONNUE

  
  0
  50
  

  
square

  #ff


  #232323
  0.5

  
  7

  


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

  Type_Ouvra
  PERTE

  
  0
  50
  

  
circle

  #8a7d53


  #232323
  0.5

  
  7

  


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

  Type_Ouvra
  PIEZOMETRE

  
  0
  50
  

  
circle

  #6355ff


  #232323
  0.5

  
  7

  


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

Re: [Geoserver-users] wfs : load in qgis a postgis materialized view

2021-08-10 Thread celati Laurent

Thanks for your replies.
Indeed, thanks to CREATE UNIQUE INDEX _idx ON xxx(gid);
it's works well this times with no longer error message when loading WFS
via qgis.

Le mar. 10 août 2021 à 14:15, Bart Zwemmer | GIS Specialisten <
b...@gisspecialisten.nl> a écrit :

> Materialized views can not have a primary key, that why you add a unique
> index (source:
> https://stackoverflow.com/questions/54154897/create-primary-key-on-materialized-view-in-postgres
> )
>
>
>
> I thought the unique ID would take care of your error. Do you have an ID
> field in your materialized view?
>
>
>
> *From:* celati Laurent 
> *Sent:* Tuesday, 10 August 2021 14:03
> *To:* Bart Zwemmer | GIS Specialisten ;
> geoserver-users 
> *Subject:* Re: [Geoserver-users] wfs : load in qgis a postgis
> materialized view
>
>
>
> Thanks for your reply.
>
> In your previous message, i can see indeed the line for create index.
>
> But i can't see the line for add a primary key. Is it possible to you to
> tell how do add the primary key?
>
> Because on my side i don't succeed in adding a primary key on my
> materilzed view thanks to folowing lines :
>
>
>
> ALTER TABLE XXX
> ADD CONSTRAINT XXX PRIMARY KEY (gid);
>
>
>
> pg admin don't recognize ma view as a table.
>
> Thanks.
>
>
>
> Le mar. 10 août 2021 à 13:41, Bart Zwemmer | GIS Specialisten <
> b...@gisspecialisten.nl> a écrit :
>
> Dear Laurant,
>
>
>
> Currently I am busy implementing Materialized Views for a client. In order
> to have a unique ID, you need to add that to the materialized view:
>
>
>
> The materialized view needs a unique column to support concurrent
> refreshing. That means you have to determine a “primary key” and create a
> unique index:
>
> 1
>
> 2
>
> 3
>
> 4
>
> demo=# CREATE UNIQUE INDEX idx_grp ON mat_view (grp);
>
> CREATE INDEX
>
> demo=# REFRESH MATERIALIZED VIEW CONCURRENTLY mat_view;
>
> REFRESH MATERIALIZED VIEW
>
>
>
>
>
> This is taken from:
> https://www.cybertec-postgresql.com/en/creating-and-refreshing-materialized-views-in-postgresql/
>
> Which you might find useful.
>
>
>
> Kind regards,
>
>
>
> Bart
>
>
>
> *From:* celati Laurent 
> *Sent:* Tuesday, 10 August 2021 13:15
> *To:* geoserver-users 
> *Subject:* [Geoserver-users] wfs : load in qgis a postgis materialized
> view
>
>
>
> Good morning,
>
>
>
> I succeed in loading into geoserver a  Postgis materialized view.
>
> With qgis, no problem for display the data in WMS .
>
> But the data does not display with WFS.
>
> I paste below the log. Geoserver logs seems to deal with especially to :
> "Caused by: java.io.IOException: Cannot do natural order without a primary
> key, please add it or specify a manual sort over existing attributes".
>
> According to you, it would be the main reason explaining the issue? If yes
> How to specify a manual sort order ? Or how to create a primary key on a
> materialized view which might be recognized by geoserver ?
>
> Thanks a lot.
>
>
>
> *Please fond below QGIS log : *
>
>
>
>
>
>  2021-08-10T12:04:48 WARNINGLe téléchargement des entités à
> échoué: Error transferring
> https://sig-geo-prd.andra.fr/geoserver/andra/wfs?SERVICE=WFS=GetFeature=2.0.0=andra:bdd_forages_ouvrages=andra:bdd_forages_ouvrages=0=100=urn:ogc:def:crs:EPSG::2154=1344789.26224076747894287,6375548.67891552019864321,2060610.88769835303537548,6698990.50836040545254946,urn:ogc:def:crs:EPSG::2154
> - server replied:
>
>
>
> *Please find below Geoserver log : *
>
>
>
> 2021-08-10 12:04:48,736 INFO [geoserver.wfs] -
> Request: getServiceInfo
> 2021-08-10 12:04:48,736 INFO [geoserver.wfs] -
> Request: getFeature
> service = WFS
> version = 2.0.0
> baseUrl = https://sig-geo-prd.andra.fr/geoserver/
> count = 100
> outputFormat = application/gml+xml; version=3.2
> resolve = none
> resolveDepth = *
> resolveTimeout = 300
> resultType = results
> startIndex = 0
> abstractQueryExpressionGroup[0] =
> wfs:abstractQueryExpression=net.opengis.wfs20.impl.QueryTypeImpl@51ac097e
> (handle: null) (abstractProjectionClause: null, abstractSelectionClause: [
>  bbox ReferencedEnvelope[1344789.2622407675 : 2060610.887698353,
> 6375548.67891552 : 6698990.508360405] ], abstractSortingClause: null,
> aliases: null, typeNames: [{andra}bdd_forages_ouvrages]) (featureVersion:
> null, srsName: urn:ogc:def:crs:EPSG::2154, filter: null, propertyNames:
> null, sortBy: null)
> abstractQueryExpression[0]:
> abstractSelectionClause = [  bbox
> Ref

Re: [Geoserver-users] wfs : load in qgis a postgis materialized view

2021-08-10 Thread celati Laurent

Thanks for your reply.
In your previous message, i can see indeed the line for create index.
But i can't see the line for add a primary key. Is it possible to you to
tell how do add the primary key?
Because on my side i don't succeed in adding a primary key on my materilzed
view thanks to folowing lines :

ALTER TABLE XXX
ADD CONSTRAINT XXX PRIMARY KEY (gid);

pg admin don't recognize ma view as a table.
Thanks.

Le mar. 10 août 2021 à 13:41, Bart Zwemmer | GIS Specialisten <
b...@gisspecialisten.nl> a écrit :

> Dear Laurant,
>
>
>
> Currently I am busy implementing Materialized Views for a client. In order
> to have a unique ID, you need to add that to the materialized view:
>
>
>
> The materialized view needs a unique column to support concurrent
> refreshing. That means you have to determine a “primary key” and create a
> unique index:
>
> 1
>
> 2
>
> 3
>
> 4
>
> demo=# CREATE UNIQUE INDEX idx_grp ON mat_view (grp);
>
> CREATE INDEX
>
> demo=# REFRESH MATERIALIZED VIEW CONCURRENTLY mat_view;
>
> REFRESH MATERIALIZED VIEW
>
>
>
>
>
> This is taken from:
> https://www.cybertec-postgresql.com/en/creating-and-refreshing-materialized-views-in-postgresql/
>
> Which you might find useful.
>
>
>
> Kind regards,
>
>
>
> Bart
>
>
>
> *From:* celati Laurent 
> *Sent:* Tuesday, 10 August 2021 13:15
> *To:* geoserver-users 
> *Subject:* [Geoserver-users] wfs : load in qgis a postgis materialized
> view
>
>
>
> Good morning,
>
>
>
> I succeed in loading into geoserver a  Postgis materialized view.
>
> With qgis, no problem for display the data in WMS .
>
> But the data does not display with WFS.
>
> I paste below the log. Geoserver logs seems to deal with especially to :
> "Caused by: java.io.IOException: Cannot do natural order without a primary
> key, please add it or specify a manual sort over existing attributes".
>
> According to you, it would be the main reason explaining the issue? If yes
> How to specify a manual sort order ? Or how to create a primary key on a
> materialized view which might be recognized by geoserver ?
>
> Thanks a lot.
>
>
>
> *Please fond below QGIS log : *
>
>
>
>
>
>  2021-08-10T12:04:48 WARNINGLe téléchargement des entités à
> échoué: Error transferring
> https://sig-geo-prd.andra.fr/geoserver/andra/wfs?SERVICE=WFS=GetFeature=2.0.0=andra:bdd_forages_ouvrages=andra:bdd_forages_ouvrages=0=100=urn:ogc:def:crs:EPSG::2154=1344789.26224076747894287,6375548.67891552019864321,2060610.88769835303537548,6698990.50836040545254946,urn:ogc:def:crs:EPSG::2154
> - server replied:
>
>
>
> *Please find below Geoserver log : *
>
>
>
> 2021-08-10 12:04:48,736 INFO [geoserver.wfs] -
> Request: getServiceInfo
> 2021-08-10 12:04:48,736 INFO [geoserver.wfs] -
> Request: getFeature
> service = WFS
> version = 2.0.0
> baseUrl = https://sig-geo-prd.andra.fr/geoserver/
> count = 100
> outputFormat = application/gml+xml; version=3.2
> resolve = none
> resolveDepth = *
> resolveTimeout = 300
> resultType = results
> startIndex = 0
> abstractQueryExpressionGroup[0] =
> wfs:abstractQueryExpression=net.opengis.wfs20.impl.QueryTypeImpl@51ac097e
> (handle: null) (abstractProjectionClause: null, abstractSelectionClause: [
>  bbox ReferencedEnvelope[1344789.2622407675 : 2060610.887698353,
> 6375548.67891552 : 6698990.508360405] ], abstractSortingClause: null,
> aliases: null, typeNames: [{andra}bdd_forages_ouvrages]) (featureVersion:
> null, srsName: urn:ogc:def:crs:EPSG::2154, filter: null, propertyNames:
> null, sortBy: null)
> abstractQueryExpression[0]:
> abstractSelectionClause = [  bbox
> ReferencedEnvelope[1344789.2622407675 : 2060610.887698353, 6375548.67891552
> : 6698990.508360405] ]
> typeNames[0] = {andra}bdd_forages_ouvrages
> srsName = urn:ogc:def:crs:EPSG::2154
> filter = [  bbox ReferencedEnvelope[1344789.2622407675 :
> 2060610.887698353, 6375548.67891552 : 6698990.508360405] ]
> 2021-08-10 12:04:48,736 INFO [geoserver.servlets] - OutputStream was
> successfully aborted.
> 2021-08-10 12:04:48,736 ERROR [geoserver.ows] -
> java.lang.RuntimeException: Failed to get property: {
> http://www.opengis.net/wfs/2.0}boundedBy
> at
> org.geotools.xsd.impl.GetPropertyExecutor.visit(GetPropertyExecutor.java:102)
> at
> org.geotools.xsd.impl.BindingWalker$BindingExecutionChain.execute(BindingWalker.java:220)
> at org.geotools.xsd.impl.BindingWalker.walk(BindingWalker.java:186)
> at
> org.geotools.xsd.impl.BindingVisitorDispatch.walk(BindingVisitorDispatch.java:65)
> at
> org.geotools.xs

[Geoserver-users] wfs : load in qgis a postgis materialized view

2021-08-10 Thread celati Laurent

Good morning,

I succeed in loading into geoserver a  Postgis materialized view.
With qgis, no problem for display the data in WMS .
But the data does not display with WFS.
I paste below the log. Geoserver logs seems to deal with especially to
: "Caused
by: java.io.IOException: Cannot do natural order without a primary key,
please add it or specify a manual sort over existing attributes".
According to you, it would be the main reason explaining the issue? If yes
How to specify a manual sort order ? Or how to create a primary key on a
materialized view which might be recognized by geoserver ?
Thanks a lot.

*Please fond below QGIS log : *


 2021-08-10T12:04:48 WARNINGLe téléchargement des entités à échoué:
Error transferring
https://sig-geo-prd.andra.fr/geoserver/andra/wfs?SERVICE=WFS=GetFeature=2.0.0=andra:bdd_forages_ouvrages=andra:bdd_forages_ouvrages=0=100=urn:ogc:def:crs:EPSG::2154=1344789.26224076747894287,6375548.67891552019864321,2060610.88769835303537548,6698990.50836040545254946,urn:ogc:def:crs:EPSG::2154
- server replied:


*Please find below Geoserver log : *


2021-08-10 12:04:48,736 INFO [geoserver.wfs] -
Request: getServiceInfo
2021-08-10 12:04:48,736 INFO [geoserver.wfs] -
Request: getFeature
service = WFS
version = 2.0.0
baseUrl = https://sig-geo-prd.andra.fr/geoserver/
count = 100
outputFormat = application/gml+xml; version=3.2
resolve = none
resolveDepth = *
resolveTimeout = 300
resultType = results
startIndex = 0
abstractQueryExpressionGroup[0] =
wfs:abstractQueryExpression=net.opengis.wfs20.impl.QueryTypeImpl@51ac097e
(handle: null) (abstractProjectionClause: null, abstractSelectionClause: [
 bbox ReferencedEnvelope[1344789.2622407675 : 2060610.887698353,
6375548.67891552 : 6698990.508360405] ], abstractSortingClause: null,
aliases: null, typeNames: [{andra}bdd_forages_ouvrages]) (featureVersion:
null, srsName: urn:ogc:def:crs:EPSG::2154, filter: null, propertyNames:
null, sortBy: null)
abstractQueryExpression[0]:
abstractSelectionClause = [  bbox
ReferencedEnvelope[1344789.2622407675 : 2060610.887698353, 6375548.67891552
: 6698990.508360405] ]
typeNames[0] = {andra}bdd_forages_ouvrages
srsName = urn:ogc:def:crs:EPSG::2154
filter = [  bbox ReferencedEnvelope[1344789.2622407675 :
2060610.887698353, 6375548.67891552 : 6698990.508360405] ]
2021-08-10 12:04:48,736 INFO [geoserver.servlets] - OutputStream was
successfully aborted.
2021-08-10 12:04:48,736 ERROR [geoserver.ows] -
java.lang.RuntimeException: Failed to get property: {
http://www.opengis.net/wfs/2.0}boundedBy
at
org.geotools.xsd.impl.GetPropertyExecutor.visit(GetPropertyExecutor.java:102)
at
org.geotools.xsd.impl.BindingWalker$BindingExecutionChain.execute(BindingWalker.java:220)
at org.geotools.xsd.impl.BindingWalker.walk(BindingWalker.java:186)
at
org.geotools.xsd.impl.BindingVisitorDispatch.walk(BindingVisitorDispatch.java:65)
at
org.geotools.xsd.impl.BindingVisitorDispatch.walk(BindingVisitorDispatch.java:45)
at
org.geotools.xsd.impl.BindingPropertyExtractor.properties(BindingPropertyExtractor.java:92)
at org.geotools.xsd.Encoder.encode(Encoder.java:988)
at org.geotools.xsd.Encoder.encode(Encoder.java:549)
at
org.geoserver.wfs.xml.GML32OutputFormat.encode(GML32OutputFormat.java:151)
at org.geoserver.wfs.xml.GML3OutputFormat.write(GML3OutputFormat.java:314)
at
org.geoserver.wfs.WFSGetFeatureOutputFormat.write(WFSGetFeatureOutputFormat.java:195)
at org.geoserver.ows.Dispatcher.response(Dispatcher.java:1030)
at org.geoserver.ows.Dispatcher.handleRequestInternal(Dispatcher.java:269)
at
org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:177)
at
org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:52)
at
org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1040)
at
org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:943)
at
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
at
org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:898)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:626)
at
org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:733)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at
org.geoserver.filters.ThreadLocalsCleanupFilter.doFilter(ThreadLocalsCleanupFilter.java:26)
at

Re: [Geoserver-users] import raster mbtiles : error message

2021-08-09 Thread celati Laurent

I also thought of reach some disk space/file size limit.
Do you know how to know the space/file size limit ?
Regarding the corrupted aspects, i succeed in loading this raster mbtiles
file without problem with qgis GIS.

Le lun. 9 août 2021 à 12:13, Andrea Aime  a
écrit :

> On Mon, Aug 9, 2021 at 12:10 PM celati Laurent 
> wrote:
>
>>
>> 2021-08-09 11:08:02,728 WARN [mbtiles.mosaic] -
>> org.sqlite.SQLiteException: [SQLITE_CORRUPT]  The database disk image is
>> malformed (database disk image is malformed)
>> java.io.IOException: org.sqlite.SQLiteException: [SQLITE_CORRUPT]  The
>> database disk image is malformed (database disk image is malformed)
>>
>
> The SQLIte database library claims the mbtiles file is corrupted. Try to
> download it again, or see if you reached some disk space/file size limit?
>
> Cheers
> Andrea
>
>
___
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

If you want to request a feature or an improvement, also see this: 
https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer


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

Re: [Geoserver-users] import raster mbtiles : error message

2021-08-09 Thread celati Laurent

Thanks for your replies.
Unfortunatly, i have still the same error message when i try a test with
three forward slashes.


For information, the size of the file : 6.22Go
The projection : EPSG:3857 - WGS 84 / Pseudo-Mercator - Projeté
Footprint : 452313.3158163701300509,6140043.7520201280713081 :
705899.3149351503234357,6306447.4168875329196453

I paste below the (hoping usefull) full log.Thanks again for your help :


2021-08-09 11:08:02,728 WARN [mbtiles.mosaic] - org.sqlite.SQLiteException:
[SQLITE_CORRUPT]  The database disk image is malformed (database disk image
is malformed)
java.io.IOException: org.sqlite.SQLiteException: [SQLITE_CORRUPT]  The
database disk image is malformed (database disk image is malformed)
at org.geotools.mbtiles.mosaic.MBTilesReader.(MBTilesReader.java:100)
at
org.geotools.mbtiles.mosaic.MBTilesFormat.getReader(MBTilesFormat.java:78)
at
org.geoserver.catalog.ResourcePool.getGridCoverageReader(ResourcePool.java:1565)
at
org.geoserver.catalog.ResourcePool.getGridCoverageReader(ResourcePool.java:1511)
at
org.geoserver.catalog.impl.CoverageStoreInfoImpl.getGridCoverageReader(CoverageStoreInfoImpl.java:53)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at
org.geoserver.catalog.impl.ModificationProxy.invoke(ModificationProxy.java:127)
at com.sun.proxy.$Proxy33.getGridCoverageReader(Unknown Source)
at
org.geoserver.web.data.layer.NewLayerPageProvider.getItemsInternal(NewLayerPageProvider.java:86)
at
org.geoserver.web.data.layer.NewLayerPageProvider.getItems(NewLayerPageProvider.java:47)
at
org.geoserver.web.wicket.GeoServerDataProvider.getFilteredItems(GeoServerDataProvider.java:190)
at
org.geoserver.web.data.layer.NewLayerPageProvider.getFilteredItems(NewLayerPageProvider.java:186)
at
org.geoserver.web.wicket.GeoServerDataProvider.size(GeoServerDataProvider.java:208)
at
org.geoserver.web.wicket.GeoServerTablePanel$PagerDelegate.updateMatched(GeoServerTablePanel.java:664)
at
org.geoserver.web.wicket.GeoServerTablePanel$PagerDelegate.(GeoServerTablePanel.java:659)
at
org.geoserver.web.wicket.GeoServerTablePanel.(GeoServerTablePanel.java:237)
at
org.geoserver.web.wicket.GeoServerTablePanel.(GeoServerTablePanel.java:106)
at org.geoserver.web.data.layer.NewLayerPage$1.(NewLayerPage.java:99)
at org.geoserver.web.data.layer.NewLayerPage.(NewLayerPage.java:98)
at
org.geoserver.web.data.store.CoverageStoreNewPage.onSuccessfulSave(CoverageStoreNewPage.java:86)
at
org.geoserver.web.data.store.CoverageStoreNewPage.onSave(CoverageStoreNewPage.java:71)
at
org.geoserver.web.data.store.AbstractCoverageStorePage$1.onSubmit(AbstractCoverageStorePage.java:141)
at
org.apache.wicket.ajax.markup.html.form.AjaxSubmitLink$1.onSubmit(AjaxSubmitLink.java:111)
at
org.apache.wicket.ajax.form.AjaxFormSubmitBehavior$AjaxFormSubmitter.onSubmit(AjaxFormSubmitBehavior.java:215)
at org.apache.wicket.markup.html.form.Form.delegateSubmit(Form.java:1309)
at org.apache.wicket.markup.html.form.Form.process(Form.java:976)
at org.apache.wicket.markup.html.form.Form.onFormSubmitted(Form.java:797)
at
org.apache.wicket.ajax.form.AjaxFormSubmitBehavior.onEvent(AjaxFormSubmitBehavior.java:171)
at
org.apache.wicket.ajax.AjaxEventBehavior.respond(AjaxEventBehavior.java:155)
at
org.apache.wicket.ajax.AbstractDefaultAjaxBehavior.onRequest(AbstractDefaultAjaxBehavior.java:601)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at
org.apache.wicket.RequestListenerInterface.internalInvoke(RequestListenerInterface.java:258)
at
org.apache.wicket.RequestListenerInterface.invoke(RequestListenerInterface.java:241)
at
org.apache.wicket.core.request.handler.ListenerInterfaceRequestHandler.invokeListener(ListenerInterfaceRequestHandler.java:248)
at
org.apache.wicket.core.request.handler.ListenerInterfaceRequestHandler.respond(ListenerInterfaceRequestHandler.java:234)
at
org.apache.wicket.request.cycle.RequestCycle$HandlerExecutor.respond(RequestCycle.java:895)
at
org.apache.wicket.request.RequestHandlerStack.execute(RequestHandlerStack.java:64)
at
org.apache.wicket.request.cycle.RequestCycle.execute(RequestCycle.java:265)
at
org.apache.wicket.request.cycle.RequestCycle.processRequest(RequestCycle.java:222)
at
org.apache.wicket.request.cycle.RequestCycle.processRequestAndDetach(RequestCycle.java:293)
at
org.apache.wicket.protocol.http.WicketFilter.processRequestCycle(WicketFilter.java:261)
at
org.apache.wicket.protocol.http.WicketFilter.processRequest(WicketFilter.java:203)
at
org.apache.wicket.protocol.http.WicketServlet.doPost(WicketServlet.java:159)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:652)
at

[Geoserver-users] import raster mbtiles : error message

2021-08-09 Thread celati Laurent

Good morning,
Last week, i succeed in importing one "small" raster mbtiles file (1Go).
Today, when i try to import a new bigger mbtiles raster files i have an
error message

Please find below the URL that i filled :

file://D:\SIG-GLOBAL-ANDRA\IGN\FOND_PLAN_IGN\IGN_FOND_PLAN_V2_GRANDE_ZONE.mbtiles

Then, please find below the error message :

Could not list layers for this store, an error occurred retrieving them:
Failed to create reader from
file://D:\SIG-GLOBAL-ANDRA\IGN\FOND_PLAN_IGN\IGN_FOND_PLAN_V2_GRANDE_ZONE.mbtiles
and hints Hints: EXECUTOR_SERVICE =
java.util.concurrent.ThreadPoolExecutor@28210b62[Running, pool size = 0,
active threads = 0, queued tasks = 0, completed tasks = 0] REPOSITORY =
org.geoserver.catalog.CatalogRepository@3aa5bd1c System defaults:
LENIENT_DATUM_SHIFT = true FILTER_FACTORY = FilterFactoryImpl
FORCE_AXIS_ORDER_HONORING = http GRID_COVERAGE_FACTORY =
GridCoverageFactory TILE_ENCODING = null FORCE_LONGITUDE_FIRST_AXIS_ORDER =
true COMPARISON_TOLERANCE = 1.0E-8 FEATURE_FACTORY =
org.geotools.feature.LenientFeatureFactoryImpl@44e7e996 STYLE_FACTORY =
StyleFactoryImpl

If anyone might an idea of the source of the error?
Thanks a lot.
___
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

If you want to request a feature or an improvement, also see this: 
https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer


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

Re: [Geoserver-users] Problem with wfs display (postgis geometry?)

2021-08-06 Thread celati Laurent

I just load the postgis data into qgis. I run a process vector -> geometry
tools -> check the validity.
Zero geometry mistakes has been detected by the tools. The data seems to be
reliable and relevant.



You could try loading from PostgreSQL/PostGIS into QGIS and  run a tool
from processing.

Processing >Vector geometry, Fix geometries.

Once fixed export and overwrite the existing data in Postgres (using QGIS
Database > Database Manager).

Or create a new table in Postgres and define a new WFS-layer in GeoServer.



If an invalid geometry is the cause I would expect these actions to fix the
problem.

>From your original post I understand that you have sufficient access to the
Postgres-DB to perform these actions.



Kind regards,

Le ven. 6 août 2021 à 16:08, celati Laurent  a
écrit :

> celati Laurent 
> 15:40 (il y a 26 minutes)
> À *Jan*, *Brad*, geoserver-users
> Thanks for your replies.
> @Brad Hards  @JukkaRahkonen
>  According to you, the problem could comes rather from qgis client or/and
> geoserver ?
> @ *Jan Tjalling van der Wal * OK, i will make a test for check geometry
> aspects.
> It's really strange because the data is displaying well when i load it
> directly from postgis via qgis. No problem also with WMS.
> This big problem appears only with WFS.
> Hoping find where the issue comes from.
> THanks.
>
> Le ven. 6 août 2021 à 13:00, Wal, Jan Tjalling van der <
> jan_tjalling.vander...@wur.nl> a écrit :
>
>> Hello Laurent,
>>
>>
>>
>> There is an error about ‘invalid geometry’ encountered by GeoServer when
>> rendering the WFS.
>>
>>
>>
>> You could try loading from PostgreSQL/PostGIS into QGIS and  run a tool
>> from processing.
>>
>> Processing >Vector geometry, Fix geometries.
>>
>> Once fixed export and overwrite the existing data in Postgres (using QGIS
>> Database > Database Manager).
>>
>> Or create a new table in Postgres and define a new WFS-layer in GeoServer.
>>
>>
>>
>> If an invalid geometry is the cause I would expect these actions to fix
>> the problem.
>>
>> From your original post I understand that you have sufficient access to
>> the Postgres-DB to perform these actions.
>>
>>
>>
>> Kind regards,
>>
>>
>>
>> *Jan Tjalling van der Wal*
>>
>>
>>
>> jan_tjalling.vander...@wur.nl
>>
>>
>>
>> Tel. +31 (0)317-4 87147 #
>>
>> GSM +31(0)626120915 (privé) #
>>
>> # Ma+Di 09:00-18:00, Wo XX, Do+Vr 09:00-18:00
>>
>>
>>
>>
>>
>> *From:* celati Laurent 
>> *Sent:* 06 August 2021 12:15
>> *To:* Brad Hards 
>> *Cc:* geoserver-users 
>> *Subject:* Re: [Geoserver-users] Problem with wfs display (postgis
>> geometry?)
>>
>>
>>
>> Thanks for your reply.
>>
>> For the client, i use qgis desktop soft.
>>
>>
>>
>> Please find below the qgis log appearing during the wfs loading  :
>>
>>
>>
>> 2021-08-06T10:31:19 WARNINGLe téléchargement des entités à
>> échoué: Error transferring
>> https://sig-geo-prd.andra.fr/geoserver/ign_bd_topo/wfs?SERVICE=WFS=GetFeature=2.0.0=ign_bd_topo:surface_hydrographique=ign_bd_topo:surface_hydrographique=0=100=urn:ogc:def:crs:EPSG::2154=-179769313486231570814527423731704356798070567525844996598917476803157260780028538760589558632766878171540458953514382464234321326889464182768467546703537516986049910576551282076245490090389328944075868508455133942304583236903222948165808559332123348274797826204144723168738177180919299881250404026184124858368,-179769313486231570814527423731704356798070567525844996598917476803157260780028538760589558632766878171540458953514382464234321326889464182768467546703537516986049910576551282076245490090389328944075868508455133942304583236903222948165808559332123348274797826204144723168738177180919299881250404026184124858368,179769313486231570814527423731704356798070567525844996598917476803157260780028538760589558632766878171540458953514382464234321326889464182768467546703537516986049910576551282076245490090389328944075868508455133942304583236903222948165808559332123348274797826204144723168738177180919299881250404026184124858368,179769313486231570814527423731704356798070567525844996598917476803157260780028538760589558632766878171540458953514382464234321326889464182768467546703537516986049910576551282076245490090389328944075868508455133942304583236903222948165808559332123348274797826204144723168738177180919299881250404026184124858368,urn:ogc:def:crs:EPSG::2154
>> <https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fsig-geo-prd.andra.fr%2Fgeoserver%2

Re: [Geoserver-users] Problem with wfs display (postgis geometry?)

2021-08-06 Thread celati Laurent

celati Laurent 
15:40 (il y a 26 minutes)
À *Jan*, *Brad*, geoserver-users
Thanks for your replies.
@Brad Hards  @JukkaRahkonen
 According to you, the problem could comes rather from qgis client or/and
geoserver ?
@ *Jan Tjalling van der Wal * OK, i will make a test for check geometry
aspects.
It's really strange because the data is displaying well when i load it
directly from postgis via qgis. No problem also with WMS.
This big problem appears only with WFS.
Hoping find where the issue comes from.
THanks.

Le ven. 6 août 2021 à 13:00, Wal, Jan Tjalling van der <
jan_tjalling.vander...@wur.nl> a écrit :

> Hello Laurent,
>
>
>
> There is an error about ‘invalid geometry’ encountered by GeoServer when
> rendering the WFS.
>
>
>
> You could try loading from PostgreSQL/PostGIS into QGIS and  run a tool
> from processing.
>
> Processing >Vector geometry, Fix geometries.
>
> Once fixed export and overwrite the existing data in Postgres (using QGIS
> Database > Database Manager).
>
> Or create a new table in Postgres and define a new WFS-layer in GeoServer.
>
>
>
> If an invalid geometry is the cause I would expect these actions to fix
> the problem.
>
> From your original post I understand that you have sufficient access to
> the Postgres-DB to perform these actions.
>
>
>
> Kind regards,
>
>
>
> *Jan Tjalling van der Wal*
>
>
>
> jan_tjalling.vander...@wur.nl
>
>
>
> Tel. +31 (0)317-4 87147 #
>
> GSM +31(0)626120915 (privé) #
>
> # Ma+Di 09:00-18:00, Wo XX, Do+Vr 09:00-18:00
>
>
>
>
>
> *From:* celati Laurent 
> *Sent:* 06 August 2021 12:15
> *To:* Brad Hards 
> *Cc:* geoserver-users 
> *Subject:* Re: [Geoserver-users] Problem with wfs display (postgis
> geometry?)
>
>
>
> Thanks for your reply.
>
> For the client, i use qgis desktop soft.
>
>
>
> Please find below the qgis log appearing during the wfs loading  :
>
>
>
> 2021-08-06T10:31:19 WARNINGLe téléchargement des entités à
> échoué: Error transferring
> https://sig-geo-prd.andra.fr/geoserver/ign_bd_topo/wfs?SERVICE=WFS=GetFeature=2.0.0=ign_bd_topo:surface_hydrographique=ign_bd_topo:surface_hydrographique=0=100=urn:ogc:def:crs:EPSG::2154=-179769313486231570814527423731704356798070567525844996598917476803157260780028538760589558632766878171540458953514382464234321326889464182768467546703537516986049910576551282076245490090389328944075868508455133942304583236903222948165808559332123348274797826204144723168738177180919299881250404026184124858368,-179769313486231570814527423731704356798070567525844996598917476803157260780028538760589558632766878171540458953514382464234321326889464182768467546703537516986049910576551282076245490090389328944075868508455133942304583236903222948165808559332123348274797826204144723168738177180919299881250404026184124858368,179769313486231570814527423731704356798070567525844996598917476803157260780028538760589558632766878171540458953514382464234321326889464182768467546703537516986049910576551282076245490090389328944075868508455133942304583236903222948165808559332123348274797826204144723168738177180919299881250404026184124858368,179769313486231570814527423731704356798070567525844996598917476803157260780028538760589558632766878171540458953514382464234321326889464182768467546703537516986049910576551282076245490090389328944075868508455133942304583236903222948165808559332123348274797826204144723168738177180919299881250404026184124858368,urn:ogc:def:crs:EPSG::2154
> <https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fsig-geo-prd.andra.fr%2Fgeoserver%2Fign_bd_topo%2Fwfs%3FSERVICE%3DWFS%26REQUEST%3DGetFeature%26VERSION%3D2.0.0%26TYPENAMES%3Dign_bd_topo%3Asurface_hydrographique%26TYPENAME%3Dign_bd_topo%3Asurface_hydrographique%26STARTINDEX%3D0%26COUNT%3D100%26SRSNAME%3Durn%3Aogc%3Adef%3Acrs%3AEPSG%3A%3A2154%26BBOX%3D-179769313486231570814527423731704356798070567525844996598917476803157260780028538760589558632766878171540458953514382464234321326889464182768467546703537516986049910576551282076245490090389328944075868508455133942304583236903222948165808559332123348274797826204144723168738177180919299881250404026184124858368%2C-179769313486231570814527423731704356798070567525844996598917476803157260780028538760589558632766878171540458953514382464234321326889464182768467546703537516986049910576551282076245490090389328944075868508455133942304583236903222948165808559332123348274797826204144723168738177180919299881250404026184124858368%2C179769313486231570814527423731704356798070567525844996598917476803157260780028538760589558632766878171540458953514382464234321326889464182768467546703537516986049910576551282076245490090389328944075868508455133942304583236903222948165808559332123348274797826204144723168738177180919299881250404026184124858368%2C1797693134862315

Re: [Geoserver-users] Problem with wfs display (postgis geometry?)

2021-08-06 Thread celati Laurent

Thanks for your reply.
For the client, i use qgis desktop soft.

Please find below the qgis log appearing during the wfs loading  :

2021-08-06T10:31:19 WARNINGLe téléchargement des entités à échoué:
Error transferring
https://sig-geo-prd.andra.fr/geoserver/ign_bd_topo/wfs?SERVICE=WFS=GetFeature=2.0.0=ign_bd_topo:surface_hydrographique=ign_bd_topo:surface_hydrographique=0=100=urn:ogc:def:crs:EPSG::2154=-179769313486231570814527423731704356798070567525844996598917476803157260780028538760589558632766878171540458953514382464234321326889464182768467546703537516986049910576551282076245490090389328944075868508455133942304583236903222948165808559332123348274797826204144723168738177180919299881250404026184124858368,-179769313486231570814527423731704356798070567525844996598917476803157260780028538760589558632766878171540458953514382464234321326889464182768467546703537516986049910576551282076245490090389328944075868508455133942304583236903222948165808559332123348274797826204144723168738177180919299881250404026184124858368,179769313486231570814527423731704356798070567525844996598917476803157260780028538760589558632766878171540458953514382464234321326889464182768467546703537516986049910576551282076245490090389328944075868508455133942304583236903222948165808559332123348274797826204144723168738177180919299881250404026184124858368,179769313486231570814527423731704356798070567525844996598917476803157260780028538760589558632766878171540458953514382464234321326889464182768467546703537516986049910576551282076245490090389328944075868508455133942304583236903222948165808559332123348274797826204144723168738177180919299881250404026184124858368,urn:ogc:def:crs:EPSG::2154
- server replied:


When i paste the previous URL into a webpage i get :


This XML file does not appear to have any style information associated with
it. The document tree is shown below.
http://www.w3.org/2001/XMLSchema; xmlns:ows="
http://www.opengis.net/ows/1.1; xmlns:xsi="
http://www.w3.org/2001/XMLSchema-instance; version="2.0.0"
xsi:schemaLocation="http://www.opengis.net/ows/1.1
https://sig-geo-prd.andra.fr/geoserver/schemas/ows/1.1.0/owsAll.xsd;>

java.lang.RuntimeException: java.io.IOException
java.io.IOExceptionERREUR: parse error - invalid geometry Indice :
POLYGON ((-I -- parse error at position 12 within geometry







Le ven. 6 août 2021 à 11:54, Brad Hards  a écrit :

> On Friday, 6 August 2021 7:48:18 PM AEST celati Laurent wrote:
>
> > i work with postgis and geoserver. *2.18.1. and qgis client.*
>
> > For some data, no problem when i load the data directly from postgis db
> via
>
> > qgis.
>
> > No problem too with the display WMS. However, there is problem with WFS.
>
> What is the WFS query you are making?
>
> Brad
>
>
___
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

If you want to request a feature or an improvement, also see this: 
https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer


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

[Geoserver-users] qgis : mbtiles data (geoserver) does not display

2021-07-27 Thread celati Laurent

Hello,

I succeed in geoserver to set a new mbtiles file. I can see the preview
data (openlayers view) in geoserver.
Then i try to display the data throw qgis (WMS). But the data does not
display in the canvas.

For information when i paste in a webpage the following link :
SERVICE=WMS=1.1.1=GetMap=4.21875,47.8125,5.6249987566,49.21875=EPSG:4326=4=4=test%3AIGN_PLAN_V2==image/png=96_RESOLUTION=96_OPTIONS=dpi:96=TRUE

)

I have a GWC error message :

400: The requested tile dimensions 4x4 do not match those of the grid set
(256x256)

In qgis log i have an error message :

2021-07-27T17:39:10 WARNINGErreur de requête de carte (Réponse :
Error transferring
https://sig-geo-prd.andra.fr/geoserver/gwc/service/wms?SERVICE=WMS=1.1.1=GetMap=4.21875,47.8125,5.6249987566,49.21875=EPSG:4326=4=4=test%3AIGN_PLAN_V2==image/png=96_RESOLUTION=96_OPTIONS=dpi:96=TRUE
-
server replied: ; URL :
https://sig-geo-prd.andra.fr/geoserver/gwc/service/wms?SERVICE=WMS=1.1.1=GetMap=4.21875,47.8125,5.6249987566,49.21875=EPSG:4326=4=4=test%3AIGN_PLAN_V2==image/png=96_RESOLUTION=96_OPTIONS=dpi:96=TRUE
)


Thanks a lot.
___
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

If you want to request a feature or an improvement, also see this: 
https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer


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

Re: [Geoserver-users] remote WMS ressource : error message for preview data

2021-07-15 Thread celati Laurent

Thanks a lot for your quick replies. Could you just confirm to me that the
following url is the relevant ressource for guidance? :

https://docs.geoserver.org/latest/en/user/security/tutorials/cert/index.html

Thanks again.


Le jeu. 15 juil. 2021 à 17:30, Alexandre Gacon 
a écrit :

> Hi,
>
> You perhaps have to register the IGN certificate into the TOMCAT
> certificate store of your geoserver instance.
>
> Alexandre
>
> Le jeu. 15 juil. 2021 à 17:19, celati Laurent 
> a écrit :
>
>> Good afternoon,
>> I succeed in setting a remote WMS data store (from french IGN ressources)
>> in filling the following URl in geoserver :
>>
>>
>> http://gpp3-wxs.ign.fr//geoportail/r/wms?SERVICE=WMS=1.3.0=GetCapabilities
>>
>> It works and i can see several data shared by the french IGN. But when i
>> select one of them and i try to preview the data,
>> I have the following error message.
>>
>> [image: image.png]
>>
>>  As far as i understood, i have to do an additional action to validate,
>> certificate something.
>> Could you help me ? Thanks a lot. Please find below the geoserver
>> logfiles :
>>
>> Code:
>>
>> at 
>> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
>> at 
>> org.geoserver.filters.FlushSafeFilter.doFilter(FlushSafeFilter.java:42)
>> at 
>> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
>> at 
>> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
>> at 
>> org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
>> at 
>> org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
>> at 
>> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
>> at 
>> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
>> at 
>> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202)
>> at 
>> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
>> at 
>> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:667)
>> at 
>> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:143)
>> at 
>> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
>> at 
>> org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:690)
>> at 
>> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
>> at 
>> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
>> at 
>> org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:374)
>> at 
>> org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
>> at 
>> org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:888)
>> at 
>> org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1597)
>> at 
>> org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
>> at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
>> at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
>> at 
>> org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
>> at java.lang.Thread.run(Unknown Source)
>> Caused by: org.geoserver.platform.ServiceException: 
>> javax.net.ssl.SSLHandshakeException: 
>> sun.security.validator.ValidatorException: PKIX path validation failed: 
>> java.security.cert.CertPathValidatorException: validity check failed
>> at 
>> org.geoserver.wms.map.RenderedImageMapOutputFormat.directRasterRender(RenderedImageMapOutputFormat.java:1096)
>> at 
>> org.geoserver.wms.map.RenderedImageMapOutputFormat.produceMap(RenderedImageMapOutputFormat.java:345)
>> ... 127 more
>> Caused by: javax.net.ssl.SSLHandshakeException: 
>> sun.security.validator.ValidatorException: PKIX path validation failed: 
>> java.security.cert.CertPathValidatorException: validity check failed
>> at sun.security.ssl.Alert.createSSLException(Unknown Source)
>> at sun.security.ssl.TransportContext.fatal(Unknown Source)
>> at sun.security.ssl.TransportContext.fatal(Unknown Source)
>> at sun.security.ssl.TransportContext.fatal(Unknow

[Geoserver-users] remote WMS ressource : error message for preview data

2021-07-15 Thread celati Laurent

Good afternoon,
I succeed in setting a remote WMS data store (from french IGN ressources)
in filling the following URl in geoserver :

http://gpp3-wxs.ign.fr//geoportail/r/wms?SERVICE=WMS=1.3.0=GetCapabilities

It works and i can see several data shared by the french IGN. But when i
select one of them and i try to preview the data,
I have the following error message.

[image: image.png]

 As far as i understood, i have to do an additional action to validate,
certificate something.
Could you help me ? Thanks a lot. Please find below the geoserver logfiles
:

Code:

at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.geoserver.filters.FlushSafeFilter.doFilter(FlushSafeFilter.java:42)
at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at 
org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
at 
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at 
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202)
at 
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
at 
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:667)
at 
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:143)
at 
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
at 
org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:690)
at 
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
at 
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
at 
org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:374)
at 
org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
at 
org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:888)
at 
org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1597)
at 
org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at 
org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Unknown Source)
Caused by: org.geoserver.platform.ServiceException:
javax.net.ssl.SSLHandshakeException:
sun.security.validator.ValidatorException: PKIX path validation
failed: java.security.cert.CertPathValidatorException: validity check
failed
at 
org.geoserver.wms.map.RenderedImageMapOutputFormat.directRasterRender(RenderedImageMapOutputFormat.java:1096)
at 
org.geoserver.wms.map.RenderedImageMapOutputFormat.produceMap(RenderedImageMapOutputFormat.java:345)
... 127 more
Caused by: javax.net.ssl.SSLHandshakeException:
sun.security.validator.ValidatorException: PKIX path validation
failed: java.security.cert.CertPathValidatorException: validity check
failed
at sun.security.ssl.Alert.createSSLException(Unknown Source)
at sun.security.ssl.TransportContext.fatal(Unknown Source)
at sun.security.ssl.TransportContext.fatal(Unknown Source)
at sun.security.ssl.TransportContext.fatal(Unknown Source)
at 
sun.security.ssl.CertificateMessage$T12CertificateConsumer.checkServerCerts(Unknown
Source)
at 
sun.security.ssl.CertificateMessage$T12CertificateConsumer.onCertificate(Unknown
Source)
at 
sun.security.ssl.CertificateMessage$T12CertificateConsumer.consume(Unknown
Source)
at sun.security.ssl.SSLHandshake.consume(Unknown Source)
at sun.security.ssl.HandshakeContext.dispatch(Unknown Source)
at sun.security.ssl.HandshakeContext.dispatch(Unknown Source)
at sun.security.ssl.TransportContext.dispatch(Unknown Source)
at sun.security.ssl.SSLTransport.decode(Unknown Source)
at sun.security.ssl.SSLSocketImpl.decode(Unknown Source)
at sun.security.ssl.SSLSocketImpl.readHandshakeRecord(Unknown Source)
at sun.security.ssl.SSLSocketImpl.startHandshake(Unknown Source)
at sun.security.ssl.SSLSocketImpl.ensureNegotiated(Unknown Source)
at sun.security.ssl.SSLSocketImpl.access$200(Unknown Source)
at sun.security.ssl.SSLSocketImpl$AppOutputStream.write(Unknown Source)
at java.io.BufferedOutputStream.flushBuffer(Unknown Source)
at java.io.BufferedOutputStream.flush(Unknown Source)
at 
org.apache.commons.httpclient.HttpConnection.flushRequestOutputStream(HttpConnection.java:828)
at

[Geoserver-users] Publish postgis data : error message

2021-07-09 Thread celati Laurent

Good afternoon,
I succeed in create a postgis data store with geoserver. When i try to add
new layer, i can see my postgis tables. But when i try to publish the
tables, i have an error message :
My geometry column, is "geom" for information.
Below a extract of the error message :

Caused by: org.postgresql.util.PSQLException: ERREUR: la relation «
geometry_columns » does not exist Position : 18 at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2532)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2267)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:312)
at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:448) at
org.postgresql.jdbc.PgStatement.execute(PgStatement.java:369) at
org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:310) at
org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:296) at
org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:273) at
org.postgresql.jdbc.PgStatement.executeQuery(PgStatement.java:226) at
org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
at
org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
at
org.geotools.data.postgis.PostGISDialect.lookupGeometryType(PostGISDialect.java:637)
at
org.geotools.data.postgis.PostGISDialect.getMappingInternal(PostGISDialect.java:582)
at
org.geotools.data.postgis.PostGISDialect.getMapping(PostGISDialect.java:555)
at
org.geotools.jdbc.JDBCFeatureSource.getColumnMetadata(JDBCFeatureSource.java:811)
at
org.geotools.jdbc.JDBCFeatureSource.buildFeatureType(JDBCFeatureSource.java:192)
... 129 more

 Thanks a lot
___
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

If you want to request a feature or an improvement, also see this: 
https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer


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

Re: [Geoserver-users] How to add a WMS/WMTS connection?

2021-07-08 Thread celati Laurent

Thanks a lot for your reply. Regarding WMS/WMTS  side, do you know how to
set a OSM wms/wmts server ? Which URL capabilities must be filled in?

Le jeu. 8 juil. 2021 à 22:39, Nuno Silva  a écrit :

> You are trying to get a tile server, not wmts server...try MapProxy
> instead for that
>
> A quinta, 8/07/2021, 21:34, celati Laurent 
> escreveu:
>
>> I want to set some WMS/WMTS in order to add several basemap (for instance
>> : OSM or other).
>> I tried to set a new WMTS connection :
>>
>> https://tile.openstreetmap.org/{z}/{x}/{y}.png
>>
>> But i have an error message : connection time out.
>>
>> Could you tell me how to do? I paste a screen shot.
>>
>> Thanks.
>>
>> [image: image.png]
>> ___
>> 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
>>
>> If you want to request a feature or an improvement, also see this:
>> https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer
>>
>>
>> Geoserver-users@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>>
>
___
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

If you want to request a feature or an improvement, also see this: 
https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer


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

[Geoserver-users] How to add a WMS/WMTS connection?

2021-07-08 Thread celati Laurent

I want to set some WMS/WMTS in order to add several basemap (for instance :
OSM or other).
I tried to set a new WMTS connection :

https://tile.openstreetmap.org/{z}/{x}/{y}.png

But i have an error message : connection time out.

Could you tell me how to do? I paste a screen shot.

Thanks.

[image: image.png]
___
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

If you want to request a feature or an improvement, also see this: 
https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer


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

[Geoserver-users] URL domain becomes localhost:8080 when login

Re: [Geoserver-users] Geoserver : How Migrate instance Windows 2.18.1 to Debian 2.21.1?

[Geoserver-users] Geoserver : How Migrate instance Windows 2.18.1 to Debian 2.21.1?

Re: [Geoserver-users] Serve more 800 JP2 files with Image Mosaic ?

Re: [Geoserver-users] Serve more 800 JP2 files with Image Mosaic ?

[Geoserver-users] Serve more 800 JP2 files with Image Mosaic ?

[Geoserver-users] Generate raster tiles for basemap : best practices?

[Geoserver-users] Set a new style (sld file).

Re: [Geoserver-users] wfs : load in qgis a postgis materialized view

Re: [Geoserver-users] wfs : load in qgis a postgis materialized view

[Geoserver-users] wfs : load in qgis a postgis materialized view

Re: [Geoserver-users] import raster mbtiles : error message

Re: [Geoserver-users] import raster mbtiles : error message

[Geoserver-users] import raster mbtiles : error message

Re: [Geoserver-users] Problem with wfs display (postgis geometry?)

Re: [Geoserver-users] Problem with wfs display (postgis geometry?)

Re: [Geoserver-users] Problem with wfs display (postgis geometry?)

[Geoserver-users] qgis : mbtiles data (geoserver) does not display

Re: [Geoserver-users] remote WMS ressource : error message for preview data

[Geoserver-users] remote WMS ressource : error message for preview data

[Geoserver-users] Publish postgis data : error message

Re: [Geoserver-users] How to add a WMS/WMTS connection?

[Geoserver-users] How to add a WMS/WMTS connection?

23 matches

Site Navigation

Mail list logo

Footer information