GeoServer问题 [英] GeoServer Issues

问题描述

运行服务器时，无法查看GeoServer中的图层。我选中了已启用复选框，但仍然无法查看地图。
如果我再次登录GeoServer，则未选中已启用复选框。
启动Apache Tomcat服务器后，我在日志中遇到以下错误：

While running the server, I am unable to view the layers in GeoServer. I checked the Enabled checkbox, and still I am unable to view the map. If I login once again into GeoServer, the Enabled checkbox is unchecked. The below error which I got in logs after starting the Apache Tomcat Server:

原因：java.lang.RuntimeException：无法获得连接：无法创建PoolableConnectionFactory（致命：用户 postgres的密码身份验证失败）

Caused by: java.lang.RuntimeException: Unable to obtain connection: Cannot create PoolableConnectionFactory (FATAL: password authentication failed for user "postgres")

原因：org.apache.commons.dbcp.SQLNestedException：无法创建PoolableConnectionFactory（致命错误：用户 postgres的密码身份验证失败）

Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (FATAL: password authentication failed for user "postgres")

原因：org.postgresql.util.PSQLException：致命：用户 postgres的密码身份验证失败

Caused by: org.postgresql.util.PSQLException: FATAL: password authentication failed for user "postgres"

错误[geotools.jdbc]-有些代码使用的是基于JDBC的数据存储，而没有对其进行处理。这可能会导致数据库连接暂时丢失。在释放对它的所有引用之前，请确保所有数据访问代码都调用DataStore.dispose（）。

ERROR [geotools.jdbc] - There's code using JDBC based datastore and not disposing them. This may lead to temporary loss of database connections. Please make sure all data access code calls DataStore.dispose() before freeing all references to it.

推荐答案

可能导致突然发生的一件事是PostgreSQL中的密码过期，尽管这不是典型的。

The one thing that can cause this suddenly is password expiration in PostgreSQL, though this is not typical. Most likely the password changed on one of the sides, so check that first.

PostgreSQL允许您指定密码在特定的时间戳记过期，这很可能是在一侧更改了密码。因此，您可以：

PostgreSQL allows you to specify that a password expires at a specific timestamp. So you can:

 ALTER USER foo WITH PASSWORD 'bar' VALID UNTIL 'tomorrow';

并且foo将能够使用密码 bar登录，直到系统时间第二天....

And foo will be able to log in with the password 'bar' until the next day at system time....

因此，如果您可以验证密码在两侧均未更改，请尝试以下操作：

So if you can verify that the password did not change on both sides, try this:

ALTER USER foo WITH VALID UNTIL 'infinity';

当然用您的真实用户替换 foo 。这将清除所有到期时间，或者将到期时间无限期地移动到将来。

Of course substitute your real user for foo. This will clear any expiration, or rather move the expiration time indefinitely into the future.

这篇关于GeoServer问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！