How to debug jdbcRealm

[Dmitry Mozheyko]

Hi all.

I try to use this howto with Payara Server 4.1.2.173 #badassfish (build 24) and my login is always failed:

[2017-08-24T17:38:44.058+0300] [Payara 4.1] [WARNING] [] [javax.enterprise.system.container.web.com.sun.web.security] [tid: _ThreadID=29 _ThreadName=http-thread-pool::http-listener-1(5)] [timeMillis: 1503585524058] [levelValue: 900] [[
  WEB9102: Web Login Failed: com.sun.enterprise.security.auth.login.common.LoginException: Login failed: Security Exception]]

I set those loggers

javax.enterprise.system.core.security
javax.enterprise.system.container.web.com.sun.web.security
com.sun.enterprise.security.auth.login

to FINEST level and don't see any new messages in log file and don't see any queries on database(PostgreSQL 9.6, log_min_duration = 0) side.

How to increase log level for Payara jdbcRealm, JAAS or something else to see detailes of problem?

[Steve Millidge]

The javax.enterprise.system.core.security logger is the correct logger.

If there are errors taling to the database there should be SEVERE log messages.

You could enable SQL Tracing on the datasource you are using for the realm. In the advanced tab of the connection pool enable "Log JDBC Calls".