Dear all,
I received the error message below when trying to connect to a pgsql/postgis database.
‘’Error creating data store, check the parameters. Error message: Unable to obtain connection: Cannot create PoolableConnectionFactory (FATAL: password authentication failed for user “myusername”)’’.
The user I am trying to use is created and has a password, the databse exists and the table in postgis as well and the user own the table. I enter this info but I get the same error all the time. I stopped the servers, restarted them, no improvement.
Here is my config:
OS: Windows 7, 64bits
Georserver 2.3.0
Postgresql 9.2
Postgis 2.0
Java 2SE RE 6.0 update 43 64-bits
You can find the logs below.
Some help would be appreciated as Geoserver fits with my needs. Thank you.
Best regards,
Geoserver logs:
INFO | jvm 1 | 2013/03/19 10:58:09 | 19 Mar 10:58:09 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
INFO | jvm 1 | 2013/03/19 10:59:13 | 19 Mar 10:59:13 WARN [data.store] - Error obtaining new data store
INFO | jvm 1 | 2013/03/19 10:59:13 | java.io.IOException
INFO | jvm 1 | 2013/03/19 10:59:13 | at org.geoserver.catalog.ResourcePool.getDataStore(ResourcePool.java:579)
INFO | jvm 1 | 2013/03/19 10:59:13 | at org.geoserver.catalog.impl.DataStoreInfoImpl.getDataStore(DataStoreInfoImpl.java:37)
INFO | jvm 1 | 2013/03/19 10:59:13 | at org.geoserver.web.data.store.DataAccessNewPage.onSaveDataStore(DataAccessNewPage.java:91)
INFO | jvm 1 | 2013/03/19 10:59:13 | at org.geoserver.web.data.store.AbstractDataAccessPage$1.onSubmit(AbstractDataAccessPage.java:162)
INFO | jvm 1 | 2013/03/19 10:59:13 | at org.apache.wicket.ajax.markup.html.form.AjaxSubmitLink$1.onSubmit(AjaxSubmitLink.java:68)
INFO | jvm 1 | 2013/03/19 10:59:13 | at org.apache.wicket.ajax.form.AjaxFormSubmitBehavior.onEvent(AjaxFormSubmitBehavior.java:143)
INFO | jvm 1 | 2013/03/19 10:59:13 | at org.apache.wicket.ajax.AjaxEventBehavior.respond(AjaxEventBehavior.java:177)
INFO | jvm 1 | 2013/03/19 10:59:13 | at org.apache.wicket.ajax.AbstractDefaultAjaxBehavior.onRequest(AbstractDefaultAjaxBehavior.java:300)
INFO | jvm 1 | 2013/03/19 10:59:13 | at org.apache.wicket.request.target.component.listener.BehaviorRequestTarget.processEvents(BehaviorRequestTarget.java:119)
INFO | jvm 1 | 2013/03/19 10:59:13 | at org.apache.wicket.request.AbstractRequestCycleProcessor.processEvents(AbstractRequestCycleProcessor.java:92)
INFO | jvm 1 | 2013/03/19 10:59:13 | at org.apache.wicket.RequestCycle.processEventsAndRespond(RequestCycle.java:1250)
INFO | jvm 1 | 2013/03/19 10:59:13 | at org.apache.wicket.RequestCycle.step(RequestCycle.java:1329)
INFO | jvm 1 | 2013/03/19 10:59:13 | at org.apache.wicket.RequestCycle.steps(RequestCycle.java:1436)
INFO | jvm 1 | 2013/03/19 10:59:13 | at org.apache.wicket.RequestCycle.request(RequestCycle.java:545)
INFO | jvm 1 | 2013/03/19 10:59:13 | at org.apache.wicket.protocol.http.WicketFilter.doGet(WicketFilter.java:484)
INFO | jvm 1 | 2013/03/19 10:59:13 | at org.apache.wicket.protocol.http.WicketServlet.doPost(WicketServlet.java:160)
INFO | jvm 1 | 2013/03/19 10:59:13 | at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
INFO | jvm 1 | 2013/03/19 10:59:13 | at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
INFO | jvm 1 | 2013/03/19 10:59:13 | at org.springframework.web.servlet.mvc.ServletWrappingController.handleRequestInternal(ServletWrappingController.java:159)
INFO | jvm 1 | 2013/03/19 10:59:13 | at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153)
INFO | jvm 1 | 2013/03/19 10:59:13 | at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48)
INFO | jvm 1 | 2013/03/19 10:59:13 | at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:923)
INFO | jvm 1 | 2013/03/19 10:59:13 | at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:852)
INFO | jvm 1 | 2013/03/19 10:59:13 | at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:882)
INFO | jvm 1 | 2013/03/19 10:59:13 | at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:789)
INFO | jvm 1 | 2013/03/19 10:59:13 | at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
INFO | jvm 1 | 2013/03/19 10:59:13 | at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
INFO | jvm 1 | 2013/03/19 10:59:13 | at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:487)
INFO | jvm 1 | 2013/03/19 10:59:13 | at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1093)
INFO | jvm 1 | 2013/03/19 10:59:13 | at org.geoserver.filters.ThreadLocalsCleanupFilter.doFilter(ThreadLocalsCleanupFilter.java:27)
INFO | jvm 1 | 2013/03/19 10:59:13 | at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)
INFO | jvm 1 | 2013/03/19 10:59:13 | at org.geoserver.filters.SpringDelegatingFilter$Chain.doFilter(SpringDelegatingFilter.java:74)
INFO | jvm 1 | 2013/03/19 10:59:13 | at org.geoserver.filters.SpringDelegatingFilter.doFilter(SpringDelegatingFilter.java:45)
INFO | jvm 1 | 2013/03/19 10:59:13 | at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)
INFO | jvm 1 | 2013/03/19 10:59:13 | at org.geoserver.platform.AdvancedDispatchFilter.doFilter(AdvancedDispatchFilter.java:49)
INFO | jvm 1 | 2013/03/19 10:59:13 | at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)
INFO | jvm 1 | 2013/03/19 10:59:13 | at org.vfny.geoserver.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:109)
INFO | jvm 1 | 2013/03/19 10:59:13 | at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)
INFO | jvm 1 | 2013/03/19 10:59:13 | at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:311)
INFO | jvm 1 | 2013/03/19 10:59:13 | at org.geoserver.security.filter.GeoServerCompositeFilter$NestedFilterChain.doFilter(GeoServerCompositeFilter.java:68)
INFO | jvm 1 | 2013/03/19 10:59:13 | at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:116)
INFO | jvm 1 | 2013/03/19 10:59:13 | at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)
INFO | jvm 1 | 2013/03/19 10:59:13 | at org.geoserver.security.filter.GeoServerCompositeFilter$NestedFilterChain.doFilter(GeoServerCompositeFilter.java:72)
INFO | jvm 1 | 2013/03/19 10:59:13 | at org.geoserver.security.filter.GeoServerCompositeFilter.doFilter(GeoServerCompositeFilter.java:91)
INFO | jvm 1 | 2013/03/19 10:59:13 | at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
INFO | jvm 1 | 2013/03/19 10:59:13 | at org.geoserver.security.filter.GeoServerCompositeFilter$NestedFilterChain.doFilter(GeoServerCompositeFilter.java:68)
INFO | jvm 1 | 2013/03/19 10:59:13 | at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113)
INFO | jvm 1 | 2013/03/19 10:59:13 | at org.geoserver.security.filter.GeoServerCompositeFilter$NestedFilterChain.doFilter(GeoServerCompositeFilter.java:72)
INFO | jvm 1 | 2013/03/19 10:59:13 | at org.geoserver.security.filter.GeoServerCompositeFilter.doFilter(GeoServerCompositeFilter.java:91)
INFO | jvm 1 | 2013/03/19 10:59:13 | at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
INFO | jvm 1 | 2013/03/19 10:59:13 | at org.geoserver.security.filter.GeoServerAnonymousAuthenticationFilter.doFilter(GeoServerAnonymousAuthenticationFilter.java:53)
INFO | jvm 1 | 2013/03/19 10:59:13 | at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
INFO | jvm 1 | 2013/03/19 10:59:13 | at org.geoserver.security.filter.GeoServerCompositeFilter$NestedFilterChain.doFilter(GeoServerCompositeFilter.java:68)
INFO | jvm 1 | 2013/03/19 10:59:13 | at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:182)
INFO | jvm 1 | 2013/03/19 10:59:13 | at org.geoserver.security.filter.GeoServerCompositeFilter$NestedFilterChain.doFilter(GeoServerCompositeFilter.java:72)
INFO | jvm 1 | 2013/03/19 10:59:13 | at org.geoserver.security.filter.GeoServerCompositeFilter.doFilter(GeoServerCompositeFilter.java:91)
INFO | jvm 1 | 2013/03/19 10:59:13 | at org.geoserver.security.filter.GeoServerUserNamePasswordAuthenticationFilter.doFilter(GeoServerUserNamePasswordAuthenticationFilter.java:115)
INFO | jvm 1 | 2013/03/19 10:59:13 | at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
INFO | jvm 1 | 2013/03/19 10:59:13 | at org.geoserver.security.filter.GeoServerCompositeFilter$NestedFilterChain.doFilter(GeoServerCompositeFilter.java:68)
INFO | jvm 1 | 2013/03/19 10:59:13 | at org.springframework.security.web.authentication.rememberme.RememberMeAuthenticationFilter.doFilter(RememberMeAuthenticationFilter.java:146)
INFO | jvm 1 | 2013/03/19 10:59:13 | at org.geoserver.security.filter.GeoServerCompositeFilter$NestedFilterChain.doFilter(GeoServerCompositeFilter.java:72)
INFO | jvm 1 | 2013/03/19 10:59:13 | at org.geoserver.security.filter.GeoServerCompositeFilter.doFilter(GeoServerCompositeFilter.java:91)
INFO | jvm 1 | 2013/03/19 10:59:13 | at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
INFO | jvm 1 | 2013/03/19 10:59:13 | at org.geoserver.security.filter.GeoServerCompositeFilter$NestedFilterChain.doFilter(GeoServerCompositeFilter.java:68)
INFO | jvm 1 | 2013/03/19 10:59:13 | at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87)
INFO | jvm 1 | 2013/03/19 10:59:13 | at org.geoserver.security.filter.GeoServerSecurityContextPersistenceFilter$1.doFilter(GeoServerSecurityContextPersistenceFilter.java:46)
INFO | jvm 1 | 2013/03/19 10:59:13 | at org.geoserver.security.filter.GeoServerCompositeFilter$NestedFilterChain.doFilter(GeoServerCompositeFilter.java:72)
INFO | jvm 1 | 2013/03/19 10:59:13 | at org.geoserver.security.filter.GeoServerCompositeFilter.doFilter(GeoServerCompositeFilter.java:91)
INFO | jvm 1 | 2013/03/19 10:59:13 | at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)
INFO | jvm 1 | 2013/03/19 10:59:13 | at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:173)
INFO | jvm 1 | 2013/03/19 10:59:13 | at org.geoserver.security.GeoServerSecurityFilterChainProxy.doFilter(GeoServerSecurityFilterChainProxy.java:103)
INFO | jvm 1 | 2013/03/19 10:59:13 | at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)
INFO | jvm 1 | 2013/03/19 10:59:13 | at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259)
INFO | jvm 1 | 2013/03/19 10:59:13 | at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)
INFO | jvm 1 | 2013/03/19 10:59:13 | at org.geoserver.filters.LoggingFilter.doFilter(LoggingFilter.java:75)
INFO | jvm 1 | 2013/03/19 10:59:13 | at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)
INFO | jvm 1 | 2013/03/19 10:59:13 | at org.geoserver.filters.GZIPFilter.doFilter(GZIPFilter.java:42)
INFO | jvm 1 | 2013/03/19 10:59:13 | at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)
INFO | jvm 1 | 2013/03/19 10:59:13 | at org.geoserver.filters.SessionDebugFilter.doFilter(SessionDebugFilter.java:47)
INFO | jvm 1 | 2013/03/19 10:59:13 | at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)
INFO | jvm 1 | 2013/03/19 10:59:13 | at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:360)
INFO | jvm 1 | 2013/03/19 10:59:13 | at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)
INFO | jvm 1 | 2013/03/19 10:59:13 | at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)
INFO | jvm 1 | 2013/03/19 10:59:13 | at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:726)
INFO | jvm 1 | 2013/03/19 10:59:13 | at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:405)
INFO | jvm 1 | 2013/03/19 10:59:13 | at org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:206)
INFO | jvm 1 | 2013/03/19 10:59:13 | at org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:114)
INFO | jvm 1 | 2013/03/19 10:59:13 | at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
INFO | jvm 1 | 2013/03/19 10:59:13 | at org.mortbay.jetty.Server.handle(Server.java:324)
INFO | jvm 1 | 2013/03/19 10:59:13 | at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:505)
INFO | jvm 1 | 2013/03/19 10:59:13 | at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:842)
INFO | jvm 1 | 2013/03/19 10:59:13 | at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:648)
INFO | jvm 1 | 2013/03/19 10:59:13 | at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:211)
INFO | jvm 1 | 2013/03/19 10:59:13 | at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:380)
INFO | jvm 1 | 2013/03/19 10:59:13 | at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:395)
INFO | jvm 1 | 2013/03/19 10:59:13 | at org.mortbay.thread.BoundedThreadPool$PoolThread.run(BoundedThreadPool.java:450)
INFO | jvm 1 | 2013/03/19 10:59:13 | Caused by: java.lang.RuntimeException: Unable to obtain connection: Cannot create PoolableConnectionFactory (FATAL: password authentication failed for user “gofcgold”)
INFO | jvm 1 | 2013/03/19 10:59:13 | at org.geotools.jdbc.JDBCDataStore.createConnection(JDBCDataStore.java:1661)
INFO | jvm 1 | 2013/03/19 10:59:13 | at org.geotools.jdbc.JDBCDataStore.createTypeNames(JDBCDataStore.java:828)
INFO | jvm 1 | 2013/03/19 10:59:13 | at org.geotools.data.store.ContentDataStore.getTypeNames(ContentDataStore.java:300)
INFO | jvm 1 | 2013/03/19 10:59:13 | at org.vfny.geoserver.util.DataStoreUtils.getDataAccess(DataStoreUtils.java:114)
INFO | jvm 1 | 2013/03/19 10:59:13 | at org.geoserver.catalog.ResourcePool.getDataStore(ResourcePool.java:539)
INFO | jvm 1 | 2013/03/19 10:59:13 | … 95 more
INFO | jvm 1 | 2013/03/19 10:59:13 | Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (FATAL: password authentication failed for user “gofcgold”)
INFO | jvm 1 | 2013/03/19 10:59:13 | at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549)
INFO | jvm 1 | 2013/03/19 10:59:13 | at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388)
INFO | jvm 1 | 2013/03/19 10:59:13 | at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
INFO | jvm 1 | 2013/03/19 10:59:13 | at org.geotools.data.jdbc.datasource.AbstractManageableDataSource.getConnection(AbstractManageableDataSource.java:48)
INFO | jvm 1 | 2013/03/19 10:59:13 | at org.geotools.jdbc.JDBCDataStore.createConnection(JDBCDataStore.java:1647)
INFO | jvm 1 | 2013/03/19 10:59:13 | … 99 more
INFO | jvm 1 | 2013/03/19 10:59:13 | Caused by: org.postgresql.util.PSQLException: FATAL: password authentication failed for user “gofcgold”
INFO | jvm 1 | 2013/03/19 10:59:13 | at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:291)
INFO | jvm 1 | 2013/03/19 10:59:13 | at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:108)
INFO | jvm 1 | 2013/03/19 10:59:13 | at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:66)
INFO | jvm 1 | 2013/03/19 10:59:13 | at org.postgresql.jdbc2.AbstractJdbc2Connection.(AbstractJdbc2Connection.java:125)
INFO | jvm 1 | 2013/03/19 10:59:13 | at org.postgresql.jdbc3.AbstractJdbc3Connection.(AbstractJdbc3Connection.java:30)
INFO | jvm 1 | 2013/03/19 10:59:13 | at org.postgresql.jdbc3.Jdbc3Connection.(Jdbc3Connection.java:24)
INFO | jvm 1 | 2013/03/19 10:59:13 | at org.postgresql.Driver.makeConnection(Driver.java:393)
INFO | jvm 1 | 2013/03/19 10:59:13 | at org.postgresql.Driver.connect(Driver.java:267)
INFO | jvm 1 | 2013/03/19 10:59:13 | at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
INFO | jvm 1 | 2013/03/19 10:59:13 | at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)
INFO | jvm 1 | 2013/03/19 10:59:13 | at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1556)
INFO | jvm 1 | 2013/03/19 10:59:13 | at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545)
INFO | jvm 1 | 2013/03/19 10:59:13 | … 103 more