Re: [Geoserver-users] OpenID Connect pluging gives 404 not found

[Vera Green]

I had a similar issue with a general geoserver install. The issue was cors.
Did you set cors correctly in your web host?

Vera

On Fri., Jul. 9, 2021, 1:07 a.m. Bart Zwemmer | GIS Specialisten, <
b...@gisspecialisten.nl> wrote:

> Dear Alessio,
>
>
>
> I tried with an empty cache and a private navigation window, but I keep
> getting the 404 error. Any other suggestions?
>
>
>
> Kind regards,
>
>
>
> Bart Zwemmer | GIS Specialisten
>
>
>
> *From:* Alessio Fabiani 
> *Sent:* Thursday, 8 July 2021 15:42
> *To:* Bart Zwemmer | GIS Specialisten 
> *Cc:* geoserver-users@lists.sourceforge.net
> *Subject:* Re: [Geoserver-users] OpenID Connect pluging gives 404 not
> found
>
>
>
> Dear Bart,
>
> I guess it is just an issue of the admin UI session.
>
>
>
> Try maybe to login/logout from a clean browser session and/or login/logout
> from the base GeoServer admin gui URL (you can reach that by clicking over
> the GeoServer logo).
>
>
>
>
>
> On Wed, Jul 7, 2021 at 3:32 PM Bart Zwemmer | GIS Specialisten <
> b...@gisspecialisten.nl> wrote:
>
> Dear Community,
>
>
>
> On a test server I added the OpenID Connect authentication
> 
> extension. I then added the configuration through the discovery URL of the
> service provider (Azure AD), as can be seen below:
>
> Originally, this gave a redirect url of localhost:8080/Geoserver, but in
> the screenshot I tried already several variations with HTTP and HTTPS.
> Other than that, this is a vanilla install of the latest Geoserver WAR
> (2.18.4) on Tomcat. Everything else seems to be working fine.
>
>
>
> When I try to login through the web interface using the new login button,
> it gives me a 404 error. The same when I try to access the logout URL. As
> far as I can tell, I followed the instructions for the plugin properly
> (first link) as well as the instructions for Azure
> .
> I posted the problematic URL below, in case you want to experiment. Being
> an app service on the free Azure plan, I can’t guarantee it’s always up
> though.
>
>
>
>
> https://gs-with-ad.azurewebsites.net/geoserver/web/j_spring_oauth2_openid_connect_login
>
>
>
> ---
>
> Met vriendelijke groet / Kind regards,
>
>
>
> *Bart Zwemmer*
>
> Technical Manager   
>
>
>
>
>
> *M: +31(0)642 343 911*
>
> *E: b...@gisspecialisten.nl *
>
>
>
> 
>
>
> Van Deventerlaan 31-51 | 3528 AG Utrecht | +31 (0)85 7 325 825
>
> LinkedIn  | Twitter
>  | Facebook
>  | Instagram
>  | YouTube
>  |
> GeoService.cloud 
>
>
>
> *Disclaimer*
> De informatie in dit e-mailbericht, inclusief eventuele bijlage(s) is
> vertrouwelijk en uitsluitend bestemd voor de geadresseerde(n). Gebruik van
> deze informatie door anderen dan de geadresseerde(n) is niet toegestaan.
> Openbaarmaking, verspreiding en/of verstrekking van deze informatie aan
> derden wordt niet gepermitteerd. Wanneer u dit bericht ten onrechte heeft
> ontvangen, dient u de afzender hiervan per e-mail op de hoogte te brengen
> en dit bericht te verwijderen.
>
> ___
> 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
>
>
>
>
> --
>
> Regards,
>
> Alessio Fabiani
>
> ==
> GeoServer Professional Services from the experts!
>
> Visit http://bit.ly/gs-services-us for more information.
> ==
>
> Ing. Alessio Fabiani
>
> @alfa7691
> Founder/Technical Lead
>
>
> GeoSolutions Group
> phone: +39 0584 962313
>
> fax: +39 0584 1660272
>
> mob:   +39  333 8128928
>
>
>
> https://www.geosolutionsgroup.com/
>
> http://twitter.com/geosolutions_it
>
> ---
>
>
> Con riferimento alla normativa sul trattamento dei dati personali (Reg. UE
> 2016/679 - Regolamento generale sulla protezione dei dati “GDPR”), si
> precisa che ogni circostanza inerente alla presente email (il suo
> contenuto, gli eventuali allegati, etc.) è un dato la cui conoscenza è
> riservata al/i solo/i destinatario/i indicati dallo scrivente. Se il
> 

Re: [Geoserver-users] Publish postgis data : error message

[Thayer Young via Geoserver-users]

 I think this may be a PostgreSQL permissions problem in your database. 
Geoserver needs to be able to 'SELECT * FROM' the 'geometry_columns' view in 
your database. So you need to make sure that the user/role that Geoserver is 
using for authentication has the ability to do that. If that is not the 
problem, then you can check the settings in pg_hba.conf etc..
-Thayer

On Friday, July 9, 2021, 10:45:55 AM EDT, celati Laurent 
 wrote:  
 
 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
  ___
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] Publish postgis data : error message

[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?

[Rahkonen Jukka (MML)]

Lähettäjä: celati Laurent 
Lähetetty: perjantai 9. heinäkuuta 2021 0.06
Vastaanottaja: Olivier Gagnon 
Kopio: geoserver-users@lists.sourceforge.net
Aihe: Re: [Geoserver-users] How to add a WMS/WMTS connection?

Hi,

WMS and WMTS are different services. The URL that you used should work for WMS 
store and it certainly will not work for WMTS store.

-Jukka Rahkonen-


Thanks.
I just make a try in filling this following  URL :

https://ows.terrestris.de/osm/service?SERVICE=WMS=1.1.1=GetCapabilities


https://gis.stackexchange.com/questions/271642/adding-openstreetmap-wms-layer-to-qgis

https://www.terrestris.de/en/openstreetmap-wms/


___
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] OpenID Connect pluging gives 404 not found

[Bart Zwemmer | GIS Specialisten]

Dear Alessio,

I tried with an empty cache and a private navigation window, but I keep getting 
the 404 error. Any other suggestions?

Kind regards,

Bart Zwemmer | GIS Specialisten

From: Alessio Fabiani 
Sent: Thursday, 8 July 2021 15:42
To: Bart Zwemmer | GIS Specialisten 
Cc: geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] OpenID Connect pluging gives 404 not found

Dear Bart,
I guess it is just an issue of the admin UI session.

Try maybe to login/logout from a clean browser session and/or login/logout from 
the base GeoServer admin gui URL (you can reach that by clicking over the 
GeoServer logo).


On Wed, Jul 7, 2021 at 3:32 PM Bart Zwemmer | GIS Specialisten 
mailto:b...@gisspecialisten.nl>> wrote:
Dear Community,

On a test server I added the OpenID Connect 
authentication
 extension. I then added the configuration through the discovery URL of the 
service provider (Azure AD), as can be seen below:
[cid:image001.png@01D7749F.54769A80]
Originally, this gave a redirect url of localhost:8080/Geoserver, but in the 
screenshot I tried already several variations with HTTP and HTTPS. Other than 
that, this is a vanilla install of the latest Geoserver WAR (2.18.4) on Tomcat. 
Everything else seems to be working fine.

When I try to login through the web interface using the new login button, it 
gives me a 404 error. The same when I try to access the logout URL. As far as I 
can tell, I followed the instructions for the plugin properly (first link) as 
well as the instructions for 
Azure.
 I posted the problematic URL below, in case you want to experiment. Being an 
app service on the free Azure plan, I can’t guarantee it’s always up though.

https://gs-with-ad.azurewebsites.net/geoserver/web/j_spring_oauth2_openid_connect_login

---
Met vriendelijke groet / Kind regards,

Bart Zwemmer
Technical Manager  [cid:image002.png@01D7749F.54769A80] 



M: +31(0)642 343 911
E: b...@gisspecialisten.nl

[https://www.gisspecialisten.nl/images/logo.jpg]

Van Deventerlaan 31-51 | 3528 AG Utrecht | +31 (0)85 7 325 825

LinkedIn | 
Twitter | 
Facebook | 
Instagram | 
YouTube | 
GeoService.cloud


Disclaimer
De informatie in dit e-mailbericht, inclusief eventuele bijlage(s) is 
vertrouwelijk en uitsluitend bestemd voor de geadresseerde(n). Gebruik van deze 
informatie door anderen dan de geadresseerde(n) is niet toegestaan. 
Openbaarmaking, verspreiding en/of verstrekking van deze informatie aan derden 
wordt niet gepermitteerd. Wanneer u dit bericht ten onrechte heeft ontvangen, 
dient u de afzender hiervan per e-mail op de hoogte te brengen en dit bericht 
te verwijderen.
___
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


--

Regards,

Alessio Fabiani

==
GeoServer Professional Services from the experts!

Visit http://bit.ly/gs-services-us for more information.
==

Ing. Alessio Fabiani

@alfa7691
Founder/Technical Lead

GeoSolutions Group
phone: +39 0584 962313

fax: +39 0584 1660272

mob:   +39  333 8128928


https://www.geosolutionsgroup.com/

http://twitter.com/geosolutions_it

---

Con riferimento alla normativa sul trattamento dei dati personali (Reg. UE 
2016/679 - Regolamento generale sulla protezione dei dati “GDPR”), si precisa 
che ogni circostanza inerente alla presente email (il suo contenuto, gli 
eventuali allegati, etc.) è un dato la cui conoscenza è riservata al/i solo/i 
destinatario/i indicati dallo scrivente. Se il messaggio Le è giunto per 
errore, è tenuta/o a cancellarlo, ogni altra operazione è illecita. Le sarei 
comunque grato se potesse darmene notizia.

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