Yes the url should be fine.
I have configured the Realm inside the Engine like this:
<Realm className="org.apache.catalina.realm.DataSourceRealm"
localDataSource="true"
dataSourceName="MyDS"
userTable="VUser" userNameCol="vname" userCredCol="vpassword"
userRoleTable="VRole" roleNameCol="vrole"
digest="MD5"/>
<!-- Use the LockOutRealm to prevent attempts to guess user passwords
via a brute-force attack -->
<Realm className="org.apache.catalina.realm.LockOutRealm">
<!-- This Realm uses the UserDatabase configured in the global JNDI
resources under the key "UserDatabase". Any edits
that are performed against this UserDatabase are immediately
available for use by the Realm. -->
<Realm className="org.apache.catalina.realm.UserDatabaseRealm"
resourceName="UserDatabase"/>
</Realm>
Looking in the jconsole I see 3 realm:
/realm0 [TomEERealm]
/realm0/realm0 [LockOutRealm]
/realm0/realm0/realm0 [UserDatabaseRealm]
I don't know if TomEERealm is my Realm, but if it is so, then there is a
problem with the MD5 digest because the digest and digestEncoding
attributes of this Realm are empty.
On Fri, Aug 31, 2012 at 9:46 PM, Romain Manni-Bucau
<rmannibu...@gmail.com>wrote:
> You checked the url?
>
> Hmm no more idea, is the ds is good, the realm well configured it should be
> fine
> Le 31 août 2012 19:27, "Luca Merolla" <luca.mero...@gmail.com> a écrit :
>
> > I can see my datasource with the jconsole, but still I get the same
> error.
> >
> > On Fri, Aug 31, 2012 at 1:52 PM, Romain Manni-Bucau
> > <rmannibu...@gmail.com>wrote:
> >
> > > You should be able to check your datasource config through JMX.
> > >
> > > - Romain
> > > Le 31 août 2012 12:55, "Luca Merolla" <luca.mero...@gmail.com> a
> écrit :
> > >
> > > > I think it must be something wrong with the configuration of the
> > > > datasource.
> > > >
> > > > In fact in the database for "admin:admin" I have
> > > >
> > > > admin:21232f297a57a5a743894a0e4a801fc3
> > > >
> > > > and If I try to generate the MD5 digest from the command line I get
> the
> > > > same value:
> > > >
> > > > java -classpath
> > "*:/home/luca/bin/apache-tomee-plus-1.1.0-SNAPSHOT/bin/*"
> > > > org.apache.catalina.realm.RealmBase -a MD5 admin
> > > > admin:21232f297a57a5a743894a0e4a801fc3
> > > >
> > > > On Fri, Aug 31, 2012 at 10:04 AM, Romain Manni-Bucau
> > > > <rmannibu...@gmail.com>wrote:
> > > >
> > > > > Did you play with digest attribute?
> > > > > Le 30 août 2012 23:46, "Luca Merolla" <luca.mero...@gmail.com> a
> > > écrit :
> > > > >
> > > > > > 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:*
> > > > > > > > *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:*
> > > > > > *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
> > > > *
> > > > *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:*
> > *http://nl.linkedin.com/in/lucamerolla*
> > *Blog <http://lucamerolla.wordpress.com>*
> >
> >
> > Merolla Consulting Limited
> >
>
