-
Realm Problems
I'm just evaluating websphere, using the latest community edition.
I'm trying to port from Tomcat, and can't seem to get the database
security realm working.
I've used the console to set things up - bit of a no-brainer requiring
an SQL statement for user (select itemid,password from users where
itemid=?) and group (select itemid,realm from role where itemid=?),
and a database pool name for the Oracle database connection (the pool
is tested and working, the SQL statements are correct).
When I test the realm, I get the message "Login Failed: no message"
The command session goes a little berserk, as follows:
--------------------------------------------------------------------------------------
javax.security.auth.login.FailedLoginException
at
org.apache.geronimo.security.realm.providers.SQLLoginModule.login(SQL
LoginModule.java:208)
at
org.apache.geronimo.console.util.KernelManagementHelper.testLoginModu
le(KernelManagementHelper.java:414)
at
org.apache.geronimo.console.util.PortletManager.testLoginModule(Portl
etManager.java:159)
at
org.apache.geronimo.console.securitymanager.realm.SecurityRealmPortle
t.actionAttemptLogin(SecurityRealmPortlet.java:333)
at
org.apache.geronimo.console.securitymanager.realm.SecurityRealmPortle
t.processAction(SecurityRealmPortlet.java:217)
at
org.apache.pluto.core.PortletServlet.dispatch(PortletServlet.java:229
)
at
org.apache.pluto.core.PortletServlet.doGet(PortletServlet.java:158)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:
595)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:
688)
at
org.apache.pluto.core.PortletServlet.service(PortletServlet.java:153)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:252)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:173)
at
org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDisp
atcher.java:672)
at
org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationD
ispatcher.java:574)
at
org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDis
patcher.java:499)
at
org.apache.pluto.invoker.impl.PortletInvokerImpl.invoke(PortletInvoke
rImpl.java:120)
at
org.apache.pluto.invoker.impl.PortletInvokerImpl.action(PortletInvoke
rImpl.java:68)
at
org.apache.pluto.PortletContainerImpl.processPortletAction(PortletCon
tainerImpl.java:164)
at
org.apache.pluto.portalImpl.core.PortletContainerWrapperImpl.processP
ortletAction(PortletContainerWrapperImpl.java:82)
at org.apache.pluto.portalImpl.Servlet.doGet(Servlet.java:227)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:
595)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:
688)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:252)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:173)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:213)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:178)
at
org.apache.geronimo.tomcat.valve.DefaultSubjectValve.invoke(DefaultSu
bjectValve.java:56)
at
org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authentica
torBase.java:524)
at org.apache.geronimo.tomcat.GeronimoStandardContext
$SystemMethodValve.
invoke(GeronimoStandardContext.java:342)
at
org.apache.geronimo.tomcat.valve.GeronimoBeforeAfterValve.invoke(Gero
nimoBeforeAfterValve.java:31)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:126)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:105)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:107)
at
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:
541)
at
org.apache.catalina.authenticator.SingleSignOn.invoke(SingleSignOn.ja
va:419)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:148)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java
:869)
at org.apache.coyote.http11.Http11BaseProtocol
$Http11ConnectionHandler.p
rocessConnection(Http11BaseProtocol.java:667)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpo
int.java:527)
at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFol
lowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool
$ControlRunnable.run(ThreadP
ool.java:869)
at java.lang.Thread.run(Unknown Source)
21:33:31,292 WARN [SecurityRealmPortlet] Test login failed
javax.security.auth.login.FailedLoginException
at
org.apache.geronimo.security.realm.providers.SQLLoginModule.login(SQL
LoginModule.java:208)
at
org.apache.geronimo.console.util.KernelManagementHelper.testLoginModu
le(KernelManagementHelper.java:414)
at
org.apache.geronimo.console.util.PortletManager.testLoginModule(Portl
etManager.java:159)
at
org.apache.geronimo.console.securitymanager.realm.SecurityRealmPortle
t.actionAttemptLogin(SecurityRealmPortlet.java:333)
at
org.apache.geronimo.console.securitymanager.realm.SecurityRealmPortle
t.processAction(SecurityRealmPortlet.java:217)
at
org.apache.pluto.core.PortletServlet.dispatch(PortletServlet.java:229
)
at
org.apache.pluto.core.PortletServlet.doGet(PortletServlet.java:158)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:
595)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:
688)
at
org.apache.pluto.core.PortletServlet.service(PortletServlet.java:153)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:252)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:173)
at
org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDisp
atcher.java:672)
at
org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationD
ispatcher.java:574)
at
org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDis
patcher.java:499)
at
org.apache.pluto.invoker.impl.PortletInvokerImpl.invoke(PortletInvoke
rImpl.java:120)
at
org.apache.pluto.invoker.impl.PortletInvokerImpl.action(PortletInvoke
rImpl.java:68)
at
org.apache.pluto.PortletContainerImpl.processPortletAction(PortletCon
tainerImpl.java:164)
at
org.apache.pluto.portalImpl.core.PortletContainerWrapperImpl.processP
ortletAction(PortletContainerWrapperImpl.java:82)
at org.apache.pluto.portalImpl.Servlet.doGet(Servlet.java:227)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:
595)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:
688)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:252)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:173)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:213)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:178)
at
org.apache.geronimo.tomcat.valve.DefaultSubjectValve.invoke(DefaultSu
bjectValve.java:56)
at
org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authentica
torBase.java:524)
at org.apache.geronimo.tomcat.GeronimoStandardContext
$SystemMethodValve.
invoke(GeronimoStandardContext.java:342)
at
org.apache.geronimo.tomcat.valve.GeronimoBeforeAfterValve.invoke(Gero
nimoBeforeAfterValve.java:31)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:126)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:105)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:107)
at
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:
541)
at
org.apache.catalina.authenticator.SingleSignOn.invoke(SingleSignOn.ja
va:419)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:148)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java
:869)
at org.apache.coyote.http11.Http11BaseProtocol
$Http11ConnectionHandler.p
rocessConnection(Http11BaseProtocol.java:667)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpo
int.java:527)
at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFol
lowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool
$ControlRunnable.run(ThreadP
ool.java:869)
at java.lang.Thread.run(Unknown Source)
21:54:35,683 WARN [SecurityRealmPortlet] Test login failed
javax.security.auth.login.FailedLoginException
at
org.apache.geronimo.security.realm.providers.SQLLoginModule.login(SQL
LoginModule.java:208)
at
org.apache.geronimo.console.util.KernelManagementHelper.testLoginModu
le(KernelManagementHelper.java:414)
at
org.apache.geronimo.console.util.PortletManager.testLoginModule(Portl
etManager.java:159)
at
org.apache.geronimo.console.securitymanager.realm.SecurityRealmPortle
t.actionAttemptLogin(SecurityRealmPortlet.java:333)
at
org.apache.geronimo.console.securitymanager.realm.SecurityRealmPortle
t.processAction(SecurityRealmPortlet.java:217)
at
org.apache.pluto.core.PortletServlet.dispatch(PortletServlet.java:229
)
at
org.apache.pluto.core.PortletServlet.doGet(PortletServlet.java:158)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:
595)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:
688)
at
org.apache.pluto.core.PortletServlet.service(PortletServlet.java:153)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:252)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:173)
at
org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDisp
atcher.java:672)
at
org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationD
ispatcher.java:574)
at
org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDis
patcher.java:499)
at
org.apache.pluto.invoker.impl.PortletInvokerImpl.invoke(PortletInvoke
rImpl.java:120)
at
org.apache.pluto.invoker.impl.PortletInvokerImpl.action(PortletInvoke
rImpl.java:68)
at
org.apache.pluto.PortletContainerImpl.processPortletAction(PortletCon
tainerImpl.java:164)
at
org.apache.pluto.portalImpl.core.PortletContainerWrapperImpl.processP
ortletAction(PortletContainerWrapperImpl.java:82)
at org.apache.pluto.portalImpl.Servlet.doGet(Servlet.java:227)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:
595)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:
688)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:252)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:173)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:213)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:178)
at
org.apache.geronimo.tomcat.valve.DefaultSubjectValve.invoke(DefaultSu
bjectValve.java:56)
at
org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authentica
torBase.java:524)
at org.apache.geronimo.tomcat.GeronimoStandardContext
$SystemMethodValve.
invoke(GeronimoStandardContext.java:342)
at
org.apache.geronimo.tomcat.valve.GeronimoBeforeAfterValve.invoke(Gero
nimoBeforeAfterValve.java:31)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:126)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:105)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:107)
at
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:
541)
at
org.apache.catalina.authenticator.SingleSignOn.invoke(SingleSignOn.ja
va:419)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:148)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java
:869)
at org.apache.coyote.http11.Http11BaseProtocol
$Http11ConnectionHandler.p
rocessConnection(Http11BaseProtocol.java:667)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpo
int.java:527)
at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFol
lowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool
$ControlRunnable.run(ThreadP
ool.java:869)
at java.lang.Thread.run(Unknown Source)
--------------------------------------------------------------------------------------
Can anyone give me an idea of where to look ?
Thanks in anticipation
