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! >
