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.SQLLo ginModule.login(SQL
LoginModule.java:208)
at
org.apache.geronimo.console.util.KernelManagementH elper.testLoginModu
le(KernelManagementHelper.java:414)
at
org.apache.geronimo.console.util.PortletManager.te stLoginModule(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(Port letServlet.java:229
)
at
org.apache.pluto.core.PortletServlet.doGet(Portlet Servlet.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(Portl etServlet.java:153)

at
org.apache.catalina.core.ApplicationFilterChain.in ternalDoFilter(Appl
icationFilterChain.java:252)
at
org.apache.catalina.core.ApplicationFilterChain.do Filter(ApplicationF
ilterChain.java:173)
at
org.apache.catalina.core.ApplicationDispatcher.inv oke(ApplicationDisp
atcher.java:672)
at
org.apache.catalina.core.ApplicationDispatcher.doI nclude(ApplicationD
ispatcher.java:574)
at
org.apache.catalina.core.ApplicationDispatcher.inc lude(ApplicationDis
patcher.java:499)
at
org.apache.pluto.invoker.impl.PortletInvokerImpl.i nvoke(PortletInvoke
rImpl.java:120)
at
org.apache.pluto.invoker.impl.PortletInvokerImpl.a ction(PortletInvoke
rImpl.java:68)
at
org.apache.pluto.PortletContainerImpl.processPortl etAction(PortletCon
tainerImpl.java:164)
at
org.apache.pluto.portalImpl.core.PortletContainerW rapperImpl.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.in ternalDoFilter(Appl
icationFilterChain.java:252)
at
org.apache.catalina.core.ApplicationFilterChain.do Filter(ApplicationF
ilterChain.java:173)
at
org.apache.catalina.core.StandardWrapperValve.invo ke(StandardWrapperV
alve.java:213)
at
org.apache.catalina.core.StandardContextValve.invo ke(StandardContextV
alve.java:178)
at
org.apache.geronimo.tomcat.valve.DefaultSubjectVal ve.invoke(DefaultSu
bjectValve.java:56)
at
org.apache.catalina.authenticator.AuthenticatorBas e.invoke(Authentica
torBase.java:524)
at org.apache.geronimo.tomcat.GeronimoStandardContext
$SystemMethodValve.
invoke(GeronimoStandardContext.java:342)
at
org.apache.geronimo.tomcat.valve.GeronimoBeforeAft erValve.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.invok e(StandardEngineVal
ve.java:107)
at
org.apache.catalina.valves.AccessLogValve.invoke(A ccessLogValve.java:
541)
at
org.apache.catalina.authenticator.SingleSignOn.inv oke(SingleSignOn.ja
va:419)
at
org.apache.catalina.connector.CoyoteAdapter.servic e(CoyoteAdapter.jav
a:148)
at
org.apache.coyote.http11.Http11Processor.process(H ttp11Processor.java
:869)
at org.apache.coyote.http11.Http11BaseProtocol
$Http11ConnectionHandler.p
rocessConnection(Http11BaseProtocol.java:667)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.process Socket(PoolTcpEndpo
int.java:527)
at
org.apache.tomcat.util.net.LeaderFollowerWorkerThr ead.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.SQLLo ginModule.login(SQL
LoginModule.java:208)
at
org.apache.geronimo.console.util.KernelManagementH elper.testLoginModu
le(KernelManagementHelper.java:414)
at
org.apache.geronimo.console.util.PortletManager.te stLoginModule(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(Port letServlet.java:229
)
at
org.apache.pluto.core.PortletServlet.doGet(Portlet Servlet.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(Portl etServlet.java:153)

at
org.apache.catalina.core.ApplicationFilterChain.in ternalDoFilter(Appl
icationFilterChain.java:252)
at
org.apache.catalina.core.ApplicationFilterChain.do Filter(ApplicationF
ilterChain.java:173)
at
org.apache.catalina.core.ApplicationDispatcher.inv oke(ApplicationDisp
atcher.java:672)
at
org.apache.catalina.core.ApplicationDispatcher.doI nclude(ApplicationD
ispatcher.java:574)
at
org.apache.catalina.core.ApplicationDispatcher.inc lude(ApplicationDis
patcher.java:499)
at
org.apache.pluto.invoker.impl.PortletInvokerImpl.i nvoke(PortletInvoke
rImpl.java:120)
at
org.apache.pluto.invoker.impl.PortletInvokerImpl.a ction(PortletInvoke
rImpl.java:68)
at
org.apache.pluto.PortletContainerImpl.processPortl etAction(PortletCon
tainerImpl.java:164)
at
org.apache.pluto.portalImpl.core.PortletContainerW rapperImpl.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.in ternalDoFilter(Appl
icationFilterChain.java:252)
at
org.apache.catalina.core.ApplicationFilterChain.do Filter(ApplicationF
ilterChain.java:173)
at
org.apache.catalina.core.StandardWrapperValve.invo ke(StandardWrapperV
alve.java:213)
at
org.apache.catalina.core.StandardContextValve.invo ke(StandardContextV
alve.java:178)
at
org.apache.geronimo.tomcat.valve.DefaultSubjectVal ve.invoke(DefaultSu
bjectValve.java:56)
at
org.apache.catalina.authenticator.AuthenticatorBas e.invoke(Authentica
torBase.java:524)
at org.apache.geronimo.tomcat.GeronimoStandardContext
$SystemMethodValve.
invoke(GeronimoStandardContext.java:342)
at
org.apache.geronimo.tomcat.valve.GeronimoBeforeAft erValve.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.invok e(StandardEngineVal
ve.java:107)
at
org.apache.catalina.valves.AccessLogValve.invoke(A ccessLogValve.java:
541)
at
org.apache.catalina.authenticator.SingleSignOn.inv oke(SingleSignOn.ja
va:419)
at
org.apache.catalina.connector.CoyoteAdapter.servic e(CoyoteAdapter.jav
a:148)
at
org.apache.coyote.http11.Http11Processor.process(H ttp11Processor.java
:869)
at org.apache.coyote.http11.Http11BaseProtocol
$Http11ConnectionHandler.p
rocessConnection(Http11BaseProtocol.java:667)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.process Socket(PoolTcpEndpo
int.java:527)
at
org.apache.tomcat.util.net.LeaderFollowerWorkerThr ead.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.SQLLo ginModule.login(SQL
LoginModule.java:208)
at
org.apache.geronimo.console.util.KernelManagementH elper.testLoginModu
le(KernelManagementHelper.java:414)
at
org.apache.geronimo.console.util.PortletManager.te stLoginModule(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(Port letServlet.java:229
)
at
org.apache.pluto.core.PortletServlet.doGet(Portlet Servlet.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(Portl etServlet.java:153)

at
org.apache.catalina.core.ApplicationFilterChain.in ternalDoFilter(Appl
icationFilterChain.java:252)
at
org.apache.catalina.core.ApplicationFilterChain.do Filter(ApplicationF
ilterChain.java:173)
at
org.apache.catalina.core.ApplicationDispatcher.inv oke(ApplicationDisp
atcher.java:672)
at
org.apache.catalina.core.ApplicationDispatcher.doI nclude(ApplicationD
ispatcher.java:574)
at
org.apache.catalina.core.ApplicationDispatcher.inc lude(ApplicationDis
patcher.java:499)
at
org.apache.pluto.invoker.impl.PortletInvokerImpl.i nvoke(PortletInvoke
rImpl.java:120)
at
org.apache.pluto.invoker.impl.PortletInvokerImpl.a ction(PortletInvoke
rImpl.java:68)
at
org.apache.pluto.PortletContainerImpl.processPortl etAction(PortletCon
tainerImpl.java:164)
at
org.apache.pluto.portalImpl.core.PortletContainerW rapperImpl.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.in ternalDoFilter(Appl
icationFilterChain.java:252)
at
org.apache.catalina.core.ApplicationFilterChain.do Filter(ApplicationF
ilterChain.java:173)
at
org.apache.catalina.core.StandardWrapperValve.invo ke(StandardWrapperV
alve.java:213)
at
org.apache.catalina.core.StandardContextValve.invo ke(StandardContextV
alve.java:178)
at
org.apache.geronimo.tomcat.valve.DefaultSubjectVal ve.invoke(DefaultSu
bjectValve.java:56)
at
org.apache.catalina.authenticator.AuthenticatorBas e.invoke(Authentica
torBase.java:524)
at org.apache.geronimo.tomcat.GeronimoStandardContext
$SystemMethodValve.
invoke(GeronimoStandardContext.java:342)
at
org.apache.geronimo.tomcat.valve.GeronimoBeforeAft erValve.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.invok e(StandardEngineVal
ve.java:107)
at
org.apache.catalina.valves.AccessLogValve.invoke(A ccessLogValve.java:
541)
at
org.apache.catalina.authenticator.SingleSignOn.inv oke(SingleSignOn.ja
va:419)
at
org.apache.catalina.connector.CoyoteAdapter.servic e(CoyoteAdapter.jav
a:148)
at
org.apache.coyote.http11.Http11Processor.process(H ttp11Processor.java
:869)
at org.apache.coyote.http11.Http11BaseProtocol
$Http11ConnectionHandler.p
rocessConnection(Http11BaseProtocol.java:667)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.process Socket(PoolTcpEndpo
int.java:527)
at
org.apache.tomcat.util.net.LeaderFollowerWorkerThr ead.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