Re: [Geoserver-users] Does Geoserver cache GeoJSON?

[Baker, Matthew]

Thanks Andrea for the response.

Something bizarre is going on still, and I wonder if anyone can lend a hand.

On an external network accessing the service, everything behaves just fine – 
all updated features show up right away.

However, on my machine, and another Linux machine I have, the geojson doesn’t 
show up in Geoserver or the Leaflet map consuming it – though the features are 
returned after the geocoding function displays the results – which is truly 
bizarre.

I’ve tried clearing browser caches, using private windows, etc. etc. but 
nothing is working.

Again, the CSV, SHP and other formats are working fine on this geoserver layer, 
but the geojson doesn’t seem to be recognizing the updated data on my machines.

Thanks again for any insight!

-m



From: Andrea Aime 
Sent: Tuesday, July 17, 2018 1:30 PM
To: Baker, Matthew 
Cc: GeoServer Mailing List List 
Subject: Re: [Geoserver-users] Does Geoserver cache GeoJSON?

Hi, nope, as far as I know both GetFeature and GetFeatureInfo build the result 
every time from the request and the source data, nothing relating to data is 
cached.

What gets cached is "metadata", e.g. the structure of tables, the configuration 
of layers, and so on

Cheers
Andrea

Il mar 17 lug 2018, 20:11 Baker, Matthew 
mailto:matthew_ba...@dpsk12.org>> ha scritto:
Hi all,

I’m just wondering if Geoserver caches GeoJSON services.

I’ve updated data in the PostGIS back-end, but the GeoJSON service isn’t 
updating with the changes.

I think this ends up flushing out by the next day, but wondering if there is a 
way to force the GeoJSON service to update.

I don’t see the same behavior in the other servies (SHP, TIF, CSV, etc.)

Thanks!

Matthew Baker
Denver Public Schools
matthew_ba...@dpsk12.org<mailto:matthew_ba...@dpsk12.org>



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

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

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<mailto:Geoserver-users@lists.sourceforge.net>
https://lists.sourceforge.net/lists/listinfo/geoserver-users
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot___
Geoserver-users mailing list

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

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] Does Geoserver cache GeoJSON?

[Baker, Matthew]

Hi all,

I'm just wondering if Geoserver caches GeoJSON services.

I've updated data in the PostGIS back-end, but the GeoJSON service isn't 
updating with the changes.

I think this ends up flushing out by the next day, but wondering if there is a 
way to force the GeoJSON service to update.

I don't see the same behavior in the other servies (SHP, TIF, CSV, etc.)

Thanks!

Matthew Baker
Denver Public Schools
matthew_ba...@dpsk12.org



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

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

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] Publishing PostGIS layers - "ident authentication" failures

[Baker, Matthew]

The solution turned out to be in the pg_hba.conf file, but we're still not sure 
how it got changed to stop accepting connection from ONLY the prod machine...

>From my systems staff:

The issue turned out to be the pg_hba.conf files was restricting the 
authentication method tomcat was trying to use.

This is what was in place originally:

# "local" is for Unix domain socket connections only
local   all all peer
# IPv4 local connections:
hostall all 127.0.0.1/32ident
# IPv6 local connections:
hostall all ::1/128 ident
# Allow replication connections from localhost, by a user with the
# replication privilege.
#local   replication postgrespeer
#hostreplication postgres127.0.0.1/32ident
#hostreplication postgres::1/128 ident
host all all 0.0.0.0/0   md5


I changed it to:

local   all postgrespeer
local   all all md5
# IPv4 local connections:
#hostall all 127.0.0.1/32ident
# IPv6 local connections:
#hostall all ::1/128 ident
# Allow replication connections from localhost, by a user with the
# replication privilege.
#local   replication postgrespeer
#hostreplication postgres127.0.0.1/32ident
#hostreplication postgres::1/128 ident
host all all 0.0.0.0/0   md5


Basically, I disabled IPv6, removed the 127.0.0.1/32 line (since it was 
conflicting with the catch-all host at the bottom), and I changed the default 
line from peer to md5, forcing the use of standard passwords for, and add the 
first "postgres" line to allow trusted logins to that user when logged in as 
'postgres'

Thanks!

-m



From: Baker, Matthew
Sent: Thursday, September 28, 2017 2:41 PM
To: 'geoserver-users@lists.sourceforge.net' 
<geoserver-users@lists.sourceforge.net>
Subject: Publishing PostGIS layers - "ident authentication" failures

Hello all,

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

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

Prod was working fine yesterday.

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

Basically, all errors are throwing the same message:

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

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

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

I'm stumped!

All servers are running the following:

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

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

-m

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

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

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

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

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

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

[Baker, Matthew]

Hello all,

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

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

Prod was working fine yesterday.

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

Basically, all errors are throwing the same message:

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

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

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

I'm stumped!

All servers are running the following:

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

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

-m

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

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

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

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

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