Search code examples
postgresqltomcatgisgeoserver

GeoServer Issues

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:

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

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

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

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.

Solution

  • 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 allows you to specify that a password expires at a specific timestamp. So you can:

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

    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';

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