Cannot open connection with Postgresql

[Abhishek Dhodapkar]

Hi All

We are running EurekaStream server (with jetty) on Windows XP.
We are able to connect to Postgresql using psql shell and pgAdmin. We
have created few users in our database in Postgresql using following
command from psql shell-
eurekastreamdb1=# CREATE USER abhi1 WITH PASSWORD '<mypassword>';
1. When we try to log in with above username and password (and also
default username and password), then this error message is displayed
"The user name or password you entered was incorrect".
On checking the logs (pasted below), we found that while loading the
user from DB, following exception occured in spring-
org.springframework.dao.DataRetrievalFailureException: Error loading
user detail
s for: abhi1; nested exception is
javax.persistence.PersistenceException: org.hi
bernate.exception.GenericJDBCException: Cannot open connection
at
org.eurekastreams.server.service.security.userdetails.UserDetailsServ
iceImpl.loadUserByUsername(UserDetailsServiceImpl.java:152)
[More detailed logs pasted below]

Also, logs for password auth failure of default user [postgres] can be
found-
org.postgresql.util.PSQLException: FATAL: password authentication
failed for use
r "postgres"


Please assist in resolving above issues.

Regards
Abhishek
---------------------------

2011-09-21 19:54:41.623:WARN::/j_spring_security_check
org.springframework.dao.DataRetrievalFailureException: Error loading
user detail
s for: abhi1; nested exception is
javax.persistence.PersistenceException: org.hi
bernate.exception.GenericJDBCException: Cannot open connection
at
org.eurekastreams.server.service.security.userdetails.UserDetailsServ
iceImpl.loadUserByUsername(UserDetailsServiceImpl.java:152)
at
org.eurekastreams.server.service.security.openaccess.OpenAccessAuthen
ticationProvider.authenticate(OpenAccessAuthenticationProvider.java:
64)
at
org.springframework.security.providers.ProviderManager.doAuthenticati
on(ProviderManager.java:188)
at
org.springframework.security.AbstractAuthenticationManager.authentica
te(AbstractAuthenticationManager.java:46)
at
org.springframework.security.ui.webapp.AuthenticationProcessingFilter
.attemptAuthentication(AuthenticationProcessingFilter.java:82)
at
org.springframework.security.ui.AbstractProcessingFilter.doFilterHttp
(AbstractProcessingFilter.java:258)
at
org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringS
ecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy
$VirtualFilterChain
.doFilter(FilterChainProxy.java:390)
at
org.springframework.security.ui.logout.LogoutFilter.doFilterHttp(Logo
utFilter.java:89)
at
org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringS
ecurityFilter.java:53)




2011-09-21 19:54:41.686:WARN::Nested in
org.springframework.dao.DataRetrievalFai
lureException: Error loading user details for: abhi1; nested exception
is javax.
persistence.PersistenceException:
org.hibernate.exception.GenericJDBCException:
Cannot open connection:
org.postgresql.util.PSQLException: FATAL: password authentication
failed for use
r "postgres"
at
org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(Connect
ionFactoryImpl.java:276)
at
org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(Conne
ctionFactoryImpl.java:95)
at
org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactor
y.java:66)
at
org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Conn
ection.java:124)
at
org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Conn
ection.java:30)
at
org.postgresql.jdbc4.AbstractJdbc4Connection.<init>(AbstractJdbc4Conn
ection.java:29)
at
org.postgresql.jdbc4.Jdbc4Connection.<init>(Jdbc4Connection.java:24)
at org.postgresql.Driver.makeConnection(Driver.java:386)
at org.postgresql.Driver.connect(Driver.java:260)

[Blake Caldwell]

did you give this user access to Eureka's database?

[Abhishek Dhodapkar]

Yes, we have granted access to of database to this user.
We found that after running various scripts, we have solved this
issue.
But still, user login is not successful due to ldap exception --

[2011-09-22 22:05:32,643] ERROR
org.eurekastreams.server.service.security.jaas.JaasAuthenticationProviderWrapper
- Error loading user details for: abhi1
org.springframework.ldap.CommunicationException: ldap.example.com:636;
nested exception is javax.naming.CommunicationException:
ldap.example.com:636 [Root exception is java.net.UnknownHostException:
ldap.example.com]

We think that ldap is executed as there is no entry for this user in
person table. We want to resolve this exception in ldap.

Please assist in resolving this issue in ldap.
------------------------------




[2011-09-22 22:05:21,024] ERROR
org.eurekastreams.server.persistence.mappers.cache.MemcachedCache -
Error in setListCAS communicating with memcache. Key
BufferedActivites: Exception
net.spy.memcached.OperationTimeoutException: Timeout waiting for value
[2011-09-22 22:05:32,643] ERROR
org.eurekastreams.commons.server.service.ServiceActionController -
Error occurred performing transaction.
org.springframework.ldap.CommunicationException: ldap.example.com:636;
nested exception is javax.naming.CommunicationException:
ldap.example.com:636 [Root exception is java.net.UnknownHostException:
ldap.example.com]
at
org.springframework.ldap.support.LdapUtils.convertLdapException(LdapUtils.java:
100)
at
org.springframework.ldap.core.support.AbstractContextSource.createContext(AbstractContextSource.java:
266)
at
org.springframework.ldap.core.support.AbstractContextSource.getContext(AbstractContextSource.java:
106)
at
org.springframework.ldap.core.support.AbstractContextSource.getReadOnlyContext(AbstractContextSource.java:
125)
at
org.springframework.ldap.core.LdapTemplate.search(LdapTemplate.java:
287)
at
org.springframework.ldap.core.LdapTemplate.search(LdapTemplate.java:
259)
at
org.eurekastreams.server.persistence.mappers.ldap.PagedLdapSearchStrategy.searchLdap(PagedLdapSearchStrategy.java:
93)
at
org.eurekastreams.server.persistence.mappers.ldap.LdapLookup.execute(LdapLookup.java:
116)
at
org.eurekastreams.server.service.actions.strategies.ldap.PersonLookupViaAttribute.findPeople(PersonLookupViaAttribute.java:
62)
at
org.eurekastreams.server.action.execution.CreatePersonFromLdapExecution.execute(CreatePersonFromLdapExecution.java:
76)
at
org.eurekastreams.server.action.execution.CreatePersonFromLdapExecution.execute(CreatePersonFromLdapExecution.java:
33)
at sun.reflect.GeneratedMethodAccessor69.invoke(Unknown Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:
25)
at java.lang.reflect.Method.invoke(Method.java:597)
at
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:
307)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:
182)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:
149)
at
org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:
77)
at
org.eurekastreams.server.aop.PerformanceTimer.profile(PerformanceTimer.java:
52)
at sun.reflect.GeneratedMethodAccessor63.invoke(Unknown Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:
25)
at java.lang.reflect.Method.invoke(Method.java:597)
at
org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:
627)
at
org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:
616)
at
org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:
64)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:
171)
at
org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:
89)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:
171)
at
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:
204)
at $Proxy96.execute(Unknown Source)
at
org.eurekastreams.commons.server.service.ServiceActionController.execute(ServiceActionController.java:
174)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:
39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:
25)
at java.lang.reflect.Method.invoke(Method.java:597)
at
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:
307)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:
182)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:
149)
at
org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:
77)
at
org.eurekastreams.server.aop.PerformanceTimer.profile(PerformanceTimer.java:
52)
at sun.reflect.GeneratedMethodAccessor63.invoke(Unknown Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:
25)
at java.lang.reflect.Method.invoke(Method.java:597)
at
org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:
627)
at
org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:
616)
at
org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:
64)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:
171)
at
org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:
89)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:
171)
at
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:
204)
at $Proxy98.execute(Unknown Source)
at
org.eurekastreams.server.service.security.userdetails.UserDetailsServiceImpl.loadUserByUsername(UserDetailsServiceImpl.java:
143)
at
org.eurekastreams.server.service.security.openaccess.OpenAccessAuthenticationProvider.authenticate(OpenAccessAuthenticationProvider.java:
64)
at
org.springframework.security.providers.ProviderManager.doAuthentication(ProviderManager.java:
188)
at
org.springframework.security.AbstractAuthenticationManager.authenticate(AbstractAuthenticationManager.java:
46)
at
org.springframework.security.ui.webapp.AuthenticationProcessingFilter.attemptAuthentication(AuthenticationProcessingFilter.java:
82)
at
org.springframework.security.ui.AbstractProcessingFilter.doFilterHttp(AbstractProcessingFilter.java:
258)
at
org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:
53)
at org.springframework.security.util.FilterChainProxy
$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at
org.springframework.security.ui.logout.LogoutFilter.doFilterHttp(LogoutFilter.java:
89)
at
org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:
53)
at org.springframework.security.util.FilterChainProxy
$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at
org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:
235)
at
org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:
53)
at org.springframework.security.util.FilterChainProxy
$VirtualFilterChain.doFilter(FilterChainProxy.java:390)
at
org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:
175)
at
org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:
236)
at
org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:
167)
at org.mortbay.jetty.servlet.ServletHandler
$CachedChain.doFilter(ServletHandler.java:1212)
at
org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:
399)
at
org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:
216)
at
org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:
182)
at
org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:
766)
at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:
450)
at
org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:
230)
at
org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:
114)
at
org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:
152)
at org.mortbay.jetty.Server.handle(Server.java:326)
at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:
542)
at org.mortbay.jetty.HttpConnection
$RequestHandler.content(HttpConnection.java:945)
at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:756)
at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:218)
at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404)
at
org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:
410)
at org.mortbay.thread.QueuedThreadPool
$PoolThread.run(QueuedThreadPool.java:582)
Caused by: javax.naming.CommunicationException: ldap.example.com:636
[Root exception is java.net.UnknownHostException: ldap.example.com]
at com.sun.jndi.ldap.Connection.<init>(Connection.java:200)
at com.sun.jndi.ldap.LdapClient.<init>(LdapClient.java:118)
at com.sun.jndi.ldap.LdapClient.getInstance(LdapClient.java:1580)
at com.sun.jndi.ldap.LdapCtx.connect(LdapCtx.java:2652)
at com.sun.jndi.ldap.LdapCtx.<init>(LdapCtx.java:293)
at com.sun.jndi.ldap.LdapCtxFactory.getUsingURL(LdapCtxFactory.java:
175)
at com.sun.jndi.ldap.LdapCtxFactory.getUsingURLs(LdapCtxFactory.java:
193)
at
com.sun.jndi.ldap.LdapCtxFactory.getLdapCtxInstance(LdapCtxFactory.java:
136)
at
com.sun.jndi.ldap.LdapCtxFactory.getInitialContext(LdapCtxFactory.java:
66)
at
javax.naming.spi.NamingManager.getInitialContext(NamingManager.java:
667)
at javax.naming.InitialContext.getDefaultInitCtx(InitialContext.java:
288)
at javax.naming.InitialContext.init(InitialContext.java:223)
at
javax.naming.ldap.InitialLdapContext.<init>(InitialLdapContext.java:
134)
at
org.springframework.ldap.core.support.LdapContextSource.getDirContextInstance(LdapContextSource.java:
43)
at
org.springframework.ldap.core.support.AbstractContextSource.createContext(AbstractContextSource.java:
254)
... 83 more
Caused by: java.net.UnknownHostException: ldap.example.com
at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:177)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)
at java.net.Socket.connect(Socket.java:529)
at
com.sun.net.ssl.internal.ssl.SSLSocketImpl.connect(SSLSocketImpl.java:
550)
at
com.sun.net.ssl.internal.ssl.SSLSocketImpl.<init>(SSLSocketImpl.java:
353)
at
com.sun.net.ssl.internal.ssl.SSLSocketFactoryImpl.createSocket(SSLSocketFactoryImpl.java:
71)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:
39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:
25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.sun.jndi.ldap.Connection.createSocket(Connection.java:317)
at com.sun.jndi.ldap.Connection.<init>(Connection.java:187)
... 97 more
[2011-09-22 22:05:32,643] ERROR
org.eurekastreams.server.service.security.jaas.JaasAuthenticationProviderWrapper
- Error loading user details for: abhi1
org.springframework.ldap.CommunicationException: ldap.example.com:636;
nested exception is javax.naming.CommunicationException:
ldap.example.com:636 [Root exception is java.net.UnknownHostException:
ldap.example.com]