Very good Fernando. Thanks :)
On Fri, Jul 19, 2024, 18:43 Fernando <fernandoagu...@gmail.com> wrote: > Hi Daniel, > I had not clear that I had to define previously a Datasource in tomee.xml, > now I see your example and I did and that works! > Thanks! > > El vie, 19 jul 2024 a la(s) 12:45 p.m., Daniel Dias (d...@apache.org) > escribió: > > > Hello Fernando, > > > > you can share the project ? > > > > If not, in tomee repository have an exemple of tomee realm [1] > > > > https://github.com/apache/tomee/tree/main/examples/realm-in-tomee/ > > > > On 2024/07/19 14:52:25 Fernando wrote: > > > Hi all!, > > > I don't know if my problem must be sent the list, I apologize in > advance, > > > but I think that maybe there some problem in my configuration of Apache > > > Tomee, and maybe you could give some help. > > > Recently I added Jdbc Realm to application and this work but when I try > > to > > > execute some jpa query I obtain nothing. > > > I Believe that all in the connection is ok, I put all in the file > > > context.xml of application: > > > > > > <?xml version="1.0" encoding="UTF-8"?> > > > <Context path=""> > > > <Resource name="jdbc/Corral" > > > auth="Container" > > > type="javax.sql.DataSource" > > > driverClassName="org.postgresql.Driver" > > > url="jdbc:postgresql://localhost:5432/CoopCorralitoWeb" > > > username="myuser" > > > password="mypassword" > > > maxTotal="20" maxIdle="10" maxWaitMillis="-1"/> > > > > > > <Realm className="org.apache.catalina.realm.JDBCRealm" > > > driverName="org.postgresql.Driver" > > > > connectionURL="jdbc:postgresql://localhost:5432/CoopCorral" > > > connectionName="myuser" connectionPassword="mypassword" > > > userTable="cliente" userNameCol="username" > > > userCredCol="password" > > > userRoleTable="clienterol" roleNameCol="rol"> > > > <CredentialHandler > > > className="org.apache.catalina.realm.MessageDigestCredentialHandler" > > > algorithm="SHA-256" /> > > > </Realm> > > > </Context> > > > > > > Also I enabled logs of Apache Tomee to see was happening: > > > > > > 19-Jul-2024 11:34:02.286 DETALLADO [http-nio-8080-exec-15] > > > org.apache.catalina.authenticator.FormAuthenticator.doAuthenticate > > > Authenticating username '01652' > > > 19-Jul-2024 11:34:02.286 DETALLADO [http-nio-8080-exec-15] > > > sun.reflect.DelegatingMethodAccessorImpl.invoke Intentando autentica al > > > usuario [01652] con el reino [org.apache.catalina.realm.JDBCRealm] > > > 19-Jul-2024 11:34:02.286 DETALLADO [http-nio-8080-exec-15] > > > sun.reflect.DelegatingMethodAccessorImpl.invoke Usuario autenticado > > [01652] > > > con reino [org.apache.catalina.realm.JDBCRealm] > > > 19-Jul-2024 11:34:02.286 DETALLADO [http-nio-8080-exec-15] > > > org.apache.catalina.authenticator.FormAuthenticator.doAuthenticate > > > Authentication of '01652' was successful > > > 19-Jul-2024 11:34:02.286 DETALLADO [http-nio-8080-exec-15] > > > org.apache.catalina.authenticator.AuthenticatorBase.register > > Authenticated > > > '01652' with type 'FORM' > > > 19-Jul-2024 11:34:02.286 DETALLADO [http-nio-8080-exec-15] > > > org.apache.catalina.authenticator.AuthenticatorBase.changeSessionID > > Session > > > ID changed on authentication from [C5A2BDB72274F71B59C2DDF4C2362B68] to > > > [3F66ED486C51317146EEF8B63CBB3DEB] > > > 19-Jul-2024 11:34:02.286 DETALLADO [http-nio-8080-exec-15] > > > org.apache.catalina.authenticator.FormAuthenticator.doAuthenticate > > > Redirecting to original '/' > > > 19-Jul-2024 11:34:02.286 DETALLADO [http-nio-8080-exec-15] > > > org.apache.catalina.authenticator.AuthenticatorBase.invoke Failed > > > authenticate() test > > > 19-Jul-2024 11:34:02.302 DETALLADO [http-nio-8080-exec-17] > > > org.apache.catalina.authenticator.AuthenticatorBase.invoke Security > > > checking request GET / > > > 19-Jul-2024 11:34:02.302 DETALLADO [http-nio-8080-exec-17] > > > org.apache.catalina.authenticator.AuthenticatorBase.invoke We have > cached > > > auth type FORM for principal GenericPrincipal[01652(usuario,)] > > > 19-Jul-2024 11:34:02.302 DETALLADO [http-nio-8080-exec-17] > > > org.apache.catalina.authenticator.AuthenticatorBase.invoke Calling > > > hasUserDataPermission() > > > 19-Jul-2024 11:34:02.302 DETALLADO [http-nio-8080-exec-17] > > > org.apache.catalina.authenticator.AuthenticatorBase.invoke Calling > > > authenticate() > > > 19-Jul-2024 11:34:02.302 DETALLADO [http-nio-8080-exec-17] > > > org.apache.catalina.authenticator.FormAuthenticator.doAuthenticate > > Restore > > > request from session '3F66ED486C51317146EEF8B63CBB3DEB' > > > 19-Jul-2024 11:34:02.302 DETALLADO [http-nio-8080-exec-17] > > > org.apache.catalina.authenticator.FormAuthenticator.doAuthenticate > > Proceed > > > to restored request > > > 19-Jul-2024 11:34:02.302 DETALLADO [http-nio-8080-exec-17] > > > org.apache.catalina.authenticator.AuthenticatorBase.invoke Calling > > > accessControl() > > > 19-Jul-2024 11:34:02.302 DETALLADO [http-nio-8080-exec-17] > > > org.apache.catalina.authenticator.AuthenticatorBase.invoke Successfully > > > passed all security constraints > > > > > > But, when I execute to some queries these not returning values and > > neither > > > any error : > > > > > > [EL Fine]: 2024-07-19 > > > > > > 11:34:02.788--ServerSession(23048368)--Connection(142695858)--Thread(Thread[http-nio-8080-exec-17,5,main])--SELECT > > > ID, ADMIN, CUIT, DOMICILIO, LOCALIDAD, MAIL, NOMBRE, PASSWORD, > TELEFONO, > > > USERNAME FROM cliente > > > > > > Of course Table has values and user and password of connection are > > correct. > > > Any Idea where I can found the problem? > > > Regards! > > > > > >
