[Geoserver-users] DataSource not available after calling dispose() or before being set

[Ashley Mort via Geoserver-users]

I am getting:
code=”internalError”Rendering process failed
DataSource not available after calling dispose() or before being set.

I am on GeoServer 2.17.2 on RedHat and using Andrea’s workspace from the 
osm-styles repo and connecting to a PostGIS DataStore which I loaded with some 
OSM data via imposm.

I get this error somewhat randomly and if I restart GeoServer, it seems to stop 
happening for a while but will eventually come back (even when making the exact 
same WMS request for an exact / known area that worked earlier).

Is this something that may be fixed in a later version of GeoServer?  Does it 
have something to do with the speed of the connection to my DataStore?  Any 
tips would be appreciated as this is a tough one for me.  Thank you!


PS: If I re-enter my DataStore passwd and Save, that seems like it may trigger 
the error on subsequent requests.



Ashley Mort
Sr. Software Engineer
972-638-6317 office
814-571-3039 cell
___
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 2.19-RC Release Candidate available for testing

[Verbeeck Bart (AIV)]

Before anyone starts investigating (), I created a new app service and now 
everything works (at first sight), so you can ignore my mail.

Van: Verbeeck Bart (AIV) 
Verzonden: Tuesday, March 9, 2021 2:18 PM
Aan: Jody Garnett ; GeoServer Users 

Onderwerp: Re: [Geoserver-users] GeoServer 2.19-RC Release Candidate available 
for testing

I tried the RC on

Azure app service
Java 8
Tomcat 8.5.58

Deployed the war, checked the sample data.

We have several similar app services running in production (2.18) in the same 
environment, dealing with millions of requests (wms/wfs/wmts) daily

The administration interface loads (style preview not working)
Wfs works, didn’t check in detail yet
Wms requests timeout or response is 404
Layer preview doesn’t work

I didn’t find anything in the logs, but I included the log file.

Bart

Van: Jody Garnett mailto:jody.garn...@gmail.com>>
Verzonden: Monday, March 8, 2021 8:13 AM
Aan: GeoServer Users 
mailto:geoserver-users@lists.sourceforge.net>>
Onderwerp: [Geoserver-users] GeoServer 2.19-RC Release Candidate available for 
testing

The GeoServer 2.19-RC Release 
candidate
 is available for testing, see release 
announcement
 for a tour of what is new.

Thanks to Jody, Andrea and Brad for working on this release and blog posting, 
and the whole team for making GeoServer possible.

This release includes a number of new extensions and we need your help to test 
and ensure everything is packaged correctly.

  *   Release candidates are a community building exercise
  *   We ask the community (everyone: individuals, organizations, service 
providers) to download and thoroughly test this release candidate and report 
back.
  *   Participating in testing release candidates is a key expectation of our 
open source social 
contract.
 We make an effort to thank each person who tests in our release announcement 
and project presentations!
  *   GeoServer commercial service 
providers
 are fully expected to test on behalf of their customers.
--
Jody Garnett
___
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] aerial basemap from New York's DoITT

[Stephen Sacks]

*YES  That's exactly what I need.  It gives me just what I want. 
THANK YOU !*



On 3/9/2021 10:27 AM, Russ Hore wrote:
I know it is a QGis answer but I could mail him privately or let 
people know it is sorted.


This is the GetCapabilities URL

https://maps.nyc.gov/wmts/1.0.0/?REQUEST=getcapabilities 



Create a new WMTS connection in QGis, plonk that in the URL field and 
save it.

Opening the new connection shows lots of layers from 1924 to 2018

Russ

On 9 Mar 2021, at 14:00, Stephen Sacks > wrote:


Hi Alexandre,
    Thank you for your response.  My apologies for posting to the 
GeoServer list, but my previous efforts with the QGIS list didn't 
quite solve my problem.  Also, the NY site says they "publish [their 
TMS] using GeoServer."
   In order to establish a new connection to the New York city 
WMS/WMTS map service, I need its URL.  It must be somewhere on the NY 
DoITT web site but I can't find it.  I'd be very grateful if someone 
can give it to me, or better yet, tell me where I can get the 
appropriate URL.

   Thank you.
  Steve


On 3/9/2021 2:08 AM, Alexandre Gacon wrote:

Hi Steve,

This user group is about GeoServer so I suggest posting your 
question on QGIS related user groups.


For your case, you have to declare the NYC server under wms/wmts in 
QGIS first, then connect to it to get the list of the available layers.


Regards
Alexandre

Le mar. 9 mars 2021 à 05:33, Stephen Sacks > a écrit :


I want to use aerial photography from New York City's DoITT as a
basemap in my desktop QGIS.  Then I'll use the qgis2web plug-in
to put the map on my website at InfinityFree.  On a DoITT page
(NYC Map Tiles
) I see the map
I want (Aerial Photography Tile Layers, WMTS
) but I don't
know how to grab that map and put into my desktop project.
Unfortunately, I have almost no experience with Java or HTML.
   Any advice will be welcome.
 Steve

___
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




--
Alexandre Gacon


___
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

Re: [Geoserver-users] aerial basemap from New York's DoITT

[Russ Hore]

I know it is a QGis answer but I could mail him privately or let people know it 
is sorted.

This is the GetCapabilities URL

https://maps.nyc.gov/wmts/1.0.0/?REQUEST=getcapabilities 


Create a new WMTS connection in QGis, plonk that in the URL field and save it.
Opening the new connection shows lots of layers from 1924 to 2018

Russ

> On 9 Mar 2021, at 14:00, Stephen Sacks  wrote:
> 
> Hi Alexandre,
> Thank you for your response.  My apologies for posting to the GeoServer 
> list, but my previous efforts with the QGIS list didn't quite solve my 
> problem.  Also, the NY site says they "publish [their TMS] using GeoServer."
>In order to establish a new connection to the New York city WMS/WMTS map 
> service, I need its URL.  It must be somewhere on the NY DoITT web site but I 
> can't find it.  I'd be very grateful if someone can give it to me, or better 
> yet, tell me where I can get the appropriate URL.
>Thank you.
>   Steve
> 
> 
> On 3/9/2021 2:08 AM, Alexandre Gacon wrote:
>> Hi Steve,
>> 
>> This user group is about GeoServer so I suggest posting your question on 
>> QGIS related user groups.
>> 
>> For your case, you have to declare the NYC server under wms/wmts in QGIS 
>> first, then connect to it to get the list of the available layers.
>> 
>> Regards
>> Alexandre
>> 
>> Le mar. 9 mars 2021 à 05:33, Stephen Sacks > > a écrit :
>> I want to use aerial photography from New York City's  DoITT as a basemap in 
>> my desktop QGIS.  Then I'll use the qgis2web plug-in to put the map on my 
>> website at InfinityFree.  On a DoITT page (NYC Map Tiles 
>> ) I see the map I want 
>> (Aerial Photography Tile Layers, WMTS 
>> ) but I don't know how to 
>> grab that map and put into my desktop project.   Unfortunately, I have 
>> almost no experience with Java or HTML.  
>>Any advice will be welcome.
>>  Steve
>> 
>> ___
>> 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 
>> 
>> 
>> 
>> -- 
>> Alexandre Gacon
> 
> ___
> 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] What's the purpose of ROLE_GROUP_ADMIN?

[Peter Smythe]

Hi all

According to
https://docs.geoserver.org/stable/en/user/security/usergrouprole/roles.html,
there are 4 reserved role names:


   -

   ROLE_ADMINISTRATOR—Provides access to all operations and resources
   -

   ROLE_GROUP_ADMIN—Special role for administrating user groups
   -

   ROLE_AUTHENTICATED—Assigned to every user authenticating successfully
   -

   ROLE_ANONYMOUS—Assigned if anonymous authentication is enabled and user
   does not log on

I understand and have used these, except for ROLE_GROUP_ADMIN.

*(I have also configured the workspace/layer level admin mode in Layer
Security (ref:
https://docs.geoserver.org/latest/en/user/security/layer.html#access-modes
)
which gives a user access to the configuration of the specified workspace,
and I believe this has nothing to do with ROLE_GROUP_ADMIN )*

When I configure a test user with ROLE_GROUP_ADMIN:

[image: image.png]

I see that the *Administrator for groups* combo box is greyed out - is that
correct?  Should I be able to select which of multiple groups this user can
administer?

And when this user logs into the web admin interface, they get no
additional functionality:

[image: image.png]

Can someone please explain to me how this "Special role for administrating
user groups" works?  Is it only applicable to the REST interface?

Thank you

Peter
___
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] aerial basemap from New York's DoITT

[Stephen Sacks]

Hi Alexandre,
    Thank you for your response.  My apologies for posting to the 
GeoServer list, but my previous efforts with the QGIS list didn't quite 
solve my problem.  Also, the NY site says they "publish [their TMS] 
using GeoServer."
   In order to establish a new connection to the New York city WMS/WMTS 
map service, I need its URL.  It must be somewhere on the NY DoITT web 
site but I can't find it.  I'd be very grateful if someone can give it 
to me, or better yet, tell me where I can get the appropriate URL.

   Thank you.
  Steve


On 3/9/2021 2:08 AM, Alexandre Gacon wrote:

Hi Steve,

This user group is about GeoServer so I suggest posting your question 
on QGIS related user groups.


For your case, you have to declare the NYC server under wms/wmts in 
QGIS first, then connect to it to get the list of the available layers.


Regards
Alexandre

Le mar. 9 mars 2021 à 05:33, Stephen Sacks > a écrit :


I want to use aerial photography from New York City's  DoITT as a
basemap in my desktop QGIS. Then I'll use the qgis2web plug-in to
put the map on my website at InfinityFree.  On a DoITT page (NYC
Map Tiles ) I see
the map I want (Aerial Photography Tile Layers, WMTS
) but I don't know
how to grab that map and put into my desktop project.
Unfortunately, I have almost no experience with Java or HTML.
   Any advice will be welcome.
 Steve

___
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




--
Alexandre Gacon


___
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] aerial basemap from New York's DoITT

[Brad Hards]

Instructions for using WMTS in QGIS are provided at 

https://docs.qgis.org/3.16/en/docs/user_manual/working_with_ogc/ogc_client_support.html#overview-of-wmts-support

 

If your HTML stretches to a little cut’n’paste with substitution, you might 
like to look at going directly to a Javascript library like OpenLayers:

https://openlayers.org/en/latest/examples/wmts.html

 

I agree that this is more of a QGIS question than a GeoServer question though. 
It’s the same irrespective of the WMTS server.

 

Hope this helps.

 

Brad

 

 

From: Stephen Sacks  
Sent: Tuesday, 9 March 2021 3:31 PM
To: geoserver-users@lists.sourceforge.net
Subject: [Geoserver-users] aerial basemap from New York's DoITT

 

I want to use aerial photography from New York City's  DoITT as a basemap in my 
desktop QGIS.  Then I'll use the qgis2web plug-in to put the map on my website 
at InfinityFree.  On a DoITT page (NYC Map Tiles 
 ) I see the map I want 
(Aerial Photography Tile Layers, WMTS 
 ) but I don't know how to grab 
that map and put into my desktop project.   Unfortunately, I have almost no 
experience with Java or HTML.  
   Any advice will be welcome.
 Steve

___
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] JDBC authentication

[Ian Turton]

You need to look in the GeoServer log file to find out what's gone wrong.
You really need to add some more detail as to how you put the roles into
PostGresql

Ian

On Tue, 9 Mar 2021 at 05:52, krishna lodha  wrote:

> Hi, I tested the solution https://gis.stackexchange.com/a/388940/79 mentioned
> here, it works perfectly fine as long as roles are Default when I tried to
> put roles in PG as well, it gives me HTTP error 500 for the users.
> What should I do?
> [image: Screenshot 2021-03-09 at 11.20.20 AM.png]
>
> On Sat, Mar 6, 2021 at 4:20 AM Vera Green  wrote:
>
>> Absolutely. We use PG to control authentication across our entire system.
>> This includes authenticated WMS calls to geoServer. It's critical for us.
>>
>> On Wed., Mar. 3, 2021, 11:01 a.m. Andrea Aime, <
>> andrea.a...@geo-solutions.it> wrote:
>>
>>> Each of those source file has an author tag, they all say:
>>>
>>> @author christian
>>>
>>> About a reason to do so, database centric security can be a reason. A
>>> system where the access restrictions are enforced
>>> at the relational database level. In that case, you want to authenticate
>>> using database users, and then use impersonation
>>> to connect to the database as that user, while fetching data:
>>>
>>> https://docs.geoserver.org/latest/en/user/data/database/sqlsession.html#data-sqlsession
>>>
>>> Cheers
>>> Andrea
>>>
>>>
>>> On Wed, Mar 3, 2021 at 6:52 PM Ian Turton  wrote:
>>>
 So who did write it? I'm still trying to come up with a reason to let
 my database users log into geoserver.

 Ian

 On Wed, 3 Mar 2021, 17:39 Andrea Aime, 
 wrote:

> Quoting from stack overflow: "After much head scratching and asking
> the guys who wrote this stuff on the users mailing list"
>
> Hell no, I had nothing to do with those modules! :-D
>
> Cheers
> Andrea
>
> On Wed, Mar 3, 2021 at 6:35 PM Ian Turton  wrote:
>
>> Thanks to everyone for their help on this I have finally got my head
>> around it and have added an answer to the gis.stackoverflow question I
>> linked to earlier (https://gis.stackexchange.com/a/388940/79) - If I
>> get some time over the weekend I'll see if I can try to make the
>> documentation clearer.
>>
>> Ian
>>
>> On Wed, 3 Mar 2021 at 15:03, Andrea Aime <
>> andrea.a...@geo-solutions.it> wrote:
>>
>>> Hi Ian,
>>> the role handling is a third class:
>>>
>>> [image: image.png]
>>>
>>> 1: authentication via database users (tries to connect to the
>>> database using the username/password provided in the request)
>>> 2: authentication via table contents (looks up a user with the same
>>> name provided in the request, and verifies the password)
>>> 3: adds role to a given user, after it has been authenticated
>>>
>>> Cheers
>>> Andrea
>>>
>>> On Wed, Mar 3, 2021 at 3:50 PM Ian Turton 
>>> wrote:
>>>


 On Wed, 3 Mar 2021 at 13:33, Andrea Aime <
 andrea.a...@geo-solutions.it> wrote:

> Hi Ian,
> there are both functionalities, they are separate classes and are
> configured in a different way:
>
>
>- Authenticating using the database own users:
>
> https://docs.geoserver.geo-solutions.it/edu/en/security/jdbc_authentication.html
>- Storing credentials in the database, use the table contents
>for authentication:
>
> https://docs.geoserver.geo-solutions.it/edu/en/security/jdbcusergroup_services.html
>
>
 I think (and I may be wrong) that this one only assigns a role to a
 postgres user (that is why you can set the password field to empty) -  
 if
 it was intended to work that way I can try to find some time to debug 
 it
 (when I finish this course).


 Back when we wrote the training material they were both working,
> not sure about the present.
>

 I'm pretty sure it used to work (when I wrote my training notes
 too) but it's been a while since I had a trainee choose the JDBC path
 instead of the LDAP path through the course (we have a lot of windows
 users) so I can't recall for sure (and if I used ian as my test user 
 then
 it would have worked as I have a DB login).


> Just a note, one has to be very careful when using the auth
> subsystem, many options, lots of complexity. I know I curse every 
> time :-D
>

 Oh, yes that is for sure!

 Ian



> Cheers
> Andrea
>
> On Wed, Mar 3, 2021 at 12:42 PM Ian Turton 
> wrote:
>
>>
>> Just to check before I break out the debugger:
>>
>> When you use JDBC