I think here the problem is the encoding of the password defined in the
datasource.
Basically since I'm migrating from JBoss, where I have a configuration like
that:
<login-module code="Database" flag="required">
<module-option name="dsJndiName"
value="java:jboss/datasources/testDS"/>
<module-option name="principalsQuery"
value="SELECT vpassword FROM VUser WHERE vname=?"/>
<module-option name="rolesQuery" value="SELECT
vrole, 'Roles' FROM VRole WHERE vname=?"/>
<module-option name="hashAlgorithm"
value="MD5"/>
<module-option name="hashEncoding" value="HEX"/>
</login-module>
While on TomEE I have this
<Realm className="org.apache.catalina.realm.DataSourceRealm"
localDataSource="true"
dataSourceName="MyDS"
userTable="VUser" userNameCol="vname" userCredCol="vpassword"
userRoleTable="VRole" roleNameCol="vrole"
digest="MD5"/>
I don't think there is an hashEncoding option for DataSourceRealm. Should I
use a different Realm to have the same encoding like for JBoss?
On Thu, Aug 30, 2012 at 11:20 PM, Romain Manni-Bucau
<rmannibu...@gmail.com>wrote:
> Hmm,
>
> Did you check values (login/pwd), database (do you use the one you expect).
>
> Here we need to know why it fail (user not found, bad credential etc)
>
> Any more info?
> Le 30 août 2012 23:09, "Luca Merolla" <luca.mero...@gmail.com> a écrit :
>
> > Yes, the persistence.xml was in a jar library that by mistaken got
> deployed
> > in two different places. Now this is working.
> >
> > However I have a problem with an existing web application where I'm not
> > able to authenticate. I have the login form which is failing while trying
> > to authenticating the user.
> > It's trying to perform a HttpServletRequest "request.login(user, pwd)"
> and
> > I get
> >
> > SEVERE: Error logging in
> > javax.servlet.ServletException: Login failed
> > at
> >
> >
> org.apache.catalina.authenticator.AuthenticatorBase.doLogin(AuthenticatorBase.java:820)
> > at
> >
> >
> org.apache.catalina.authenticator.AuthenticatorBase.login(AuthenticatorBase.java:800)
> > at org.apache.catalina.connector.Request.login(Request.java:2613)
> > at
> >
> org.apache.catalina.connector.RequestFacade.login(RequestFacade.java:1065)
> > at
> > org.pn.infiniti.login.LoginViewModel.doLogin(LoginViewModel.java:47)
> > 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.zkoss.bind.impl.ParamCall.call(ParamCall.java:108)
> > at org.zkoss.bind.impl.BinderImpl.doExecute(BinderImpl.java:1576)
> > at org.zkoss.bind.impl.BinderImpl.doCommand(BinderImpl.java:1329)
> > at org.zkoss.bind.impl.BinderImpl.access$1500(BinderImpl.java:94)
> > at
> >
> >
> org.zkoss.bind.impl.BinderImpl$CommandEventListener.onEvent0(BinderImpl.java:1213)
> > at
> >
> >
> org.zkoss.bind.impl.BinderImpl$CommandEventListener.onEvent(BinderImpl.java:1171)
> > at
> > org.zkoss.zk.ui.AbstractComponent.onEvent(AbstractComponent.java:2736)
> > at
> > org.zkoss.zk.ui.AbstractComponent.service(AbstractComponent.java:2707)
> > at
> > org.zkoss.zk.ui.AbstractComponent.service(AbstractComponent.java:2648)
> > at
> > org.zkoss.zk.ui.impl.EventProcessor.process(EventProcessor.java:136)
> > at
> > org.zkoss.zk.ui.impl.UiEngineImpl.processEvent(UiEngineImpl.java:1702)
> > at
> > org.zkoss.zk.ui.impl.UiEngineImpl.process(UiEngineImpl.java:1487)
> > at
> > org.zkoss.zk.ui.impl.UiEngineImpl.execUpdate(UiEngineImpl.java:1204)
> > at
> >
> >
> org.zkoss.zk.au.http.DHtmlUpdateServlet.process(DHtmlUpdateServlet.java:558)
> > at
> >
> org.zkoss.zk.au.http.DHtmlUpdateServlet.doGet(DHtmlUpdateServlet.java:456)
> > at
> >
> org.zkoss.zk.au.http.DHtmlUpdateServlet.doPost(DHtmlUpdateServlet.java:464)
> > at javax.servlet.http.HttpServlet.service(HttpServlet.java:641)
> > at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
> > at
> >
> >
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
> > at
> >
> >
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
> > at
> >
> >
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:225)
> > at
> >
> >
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
> > at
> > org.apache.tomee.catalina.OpenEJBValve.invoke(OpenEJBValve.java:45)
> > at
> >
> >
> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:581)
> > at
> >
> >
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)
> > at
> >
> >
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
> > at
> > org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:927)
> > at
> >
> >
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
> > at
> >
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
> > at
> >
> >
> org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1001)
> > at
> >
> >
> org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:585)
> > at
> >
> >
> org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312)
> > at
> >
> >
> java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
> > at
> >
> >
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
> > at java.lang.Thread.run(Thread.java:662)
> >
> >
> >
> > On Thu, Aug 30, 2012 at 6:00 PM, Romain Manni-Bucau
> > <rmannibu...@gmail.com>wrote:
> >
> > > Where is the persistence.xml? Sure it is not in the war too?
> > >
> > > - Romain
> > > Le 30 août 2012 13:47, "Luca Merolla" <luca.mero...@gmail.com> a
> écrit :
> > >
> > > > Hi,
> > > >
> > > > I'm using TomEE 1.1.0-SNAPSHOT version from the 29/08/2012.
> > > > I have an EAR folder which I have deployed in the apps/ folder. The
> EAR
> > > > consists of 2 jar libraries, 1 ejb module and 2 war application.
> > > >
> > > > For the security and authentication of the users I want to use a DB
> so
> > I
> > > > have configured TomEE in this way.
> > > >
> > > > in tomee.xml I have my 2 datasources
> > > > <Resource id="MyDS" type="DataSource">
> > > > JdbcDriver org.postgresql.Driver
> > > > JdbcUrl jdbc:postgresql://127.0.0.1:5432/test
> > > > UserName test
> > > > # For Production password should be a ciphered value Static3DES
> > codec.
> > > > Check OpenEJB cipher
> > > > Password test1
> > > > JtaManaged true
> > > > </Resource>
> > > >
> > > > <Resource id="MyUnmanagedDS" type="DataSource">
> > > > JdbcDriver org.postgresql.Driver
> > > > JdbcUrl jdbc:postgresql://127.0.0.1:5432/test
> > > > UserName test
> > > > # For Production password should be a ciphered value Static3DES
> > codec.
> > > > Check OpenEJB cipher
> > > > Password test1
> > > > JtaManaged false
> > > > </Resource>
> > > >
> > > > in server.xml I have
> > > > <Realm className="org.apache.catalina.realm.DataSourceRealm"
> > > > localDataSource="true"
> > > > dataSourceName="MyDS"
> > > > userTable="VUser" userNameCol="vname" userCredCol="vpassword"
> > > > userRoleTable="VRole" roleNameCol="vrole"
> > > > digest="MD5"/>
> > > >
> > > >
> > > > I get this error for all the EAO classes which uses the
> EntityManager,
> > as
> > > > an example:
> > > >
> > > > SEVERE: FAIL ... PayoutStructureEAO: The reference
> > > > @PersistenceContext(name="em", unitName="gamgamEJB") cannot be
> resolved
> > > as
> > > > there are 2 units with the same name. Update your unitName to one of
> > the
> > > > following:gamgamEJB 500754579
> > > > gamgamEJB 811645777
> > > >
> > > > All the EAO beans extends AbstractEAO which contains the following
> > > >
> > > > public abstract class AbstractEAO {
> > > >
> > > > @PersistenceContext(unitName = "gamgamEJB")
> > > > protected EntityManager em;
> > > >
> > > > }
> > > >
> > > > persistence.xml
> > > >
> > > > <?xml version="1.0" encoding="UTF-8"?>
> > > > <persistence version="2.0" xmlns="
> > http://java.sun.com/xml/ns/persistence
> > > "
> > > > xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";
> > > xsi:schemaLocation="
> > > > http://java.sun.com/xml/ns/persistence
> > > > http://java.sun.com/xml/ns/persistence/persistence_2_0.xsd";>
> > > > <persistence-unit name="gamgamEJB" transaction-type="JTA">
> > > > <!-- Enable Hibernate provider. Add dependency pom.xml -->
> > > > <provider>org.hibernate.ejb.HibernatePersistence</provider>
> > > > <jta-data-source>MyDS</jta-data-source>
> > > > <non-jta-data-source>MyUnmanagedDS</non-jta-data-source>
> > > >
> > > > <class>...</class>
> > > > <properties>
> > > > <property name="hibernate.dialect"
> > > > value="org.hibernate.dialect.PostgreSQLDialect" />
> > > > <property name="hibernate.hbm2ddl.auto" value="update" />
> > > > <!-- property name="hibernate.hbm2ddl.auto" value="create-drop"/ -->
> > > > <!-- enable sql log, not for production -->
> > > > <property name="hibernate.show_sql" value="false"/>
> > > > </properties>
> > > > </persistence-unit>
> > > > </persistence>
> > > >
> > > > I'm using hibernate as persistence provider and I have followed the
> > guide
> > > > from the TomEE website.
> > > >
> > > > About a year ago I did managed to make it run on Tomcat + OpenEJB,
> so I
> > > > believe i'm actually missing something in the configuration.
> > > >
> > > > Thanks in advance for any help,
> > > > Luca
> > > >
> > > > --
> > > > *Luca Merolla*
> > > > Management, Business & Technology Consultant
> > > >
> > > >
> > > > <http://maps.google.com/maps?q=&hl=en> *Mobile:* +393774569974
> > > > *http://nl.linkedin.com/in/lucamerolla*
> > > > *Blog <http://lucamerolla.wordpress.com>*
> > > >
> > > >
> > > > Merolla Consulting Limited
> > > >
> > >
> >
> >
> >
> > --
> > *Luca Merolla*
> > Management, Business & Technology Consultant
> >
> >
> > <http://maps.google.com/maps?q=&hl=en> *Mobile:* +393774569974
> > *Email:* luca.mero...@gmail.com
> > *http://nl.linkedin.com/in/lucamerolla*
> > *Blog <http://lucamerolla.wordpress.com>*
> >
> >
> > Merolla Consulting Limited
> >
>
--
*Luca Merolla*
Management, Business & Technology Consultant
<http://maps.google.com/maps?q=&hl=en> *Mobile:* +393774569974
*Email:* luca.mero...@gmail.com
*http://nl.linkedin.com/in/lucamerolla*
*Blog <http://lucamerolla.wordpress.com>*
Merolla Consulting Limited
