131 ERROR registered_services does not exist
If the following is being seen in the catalina.out log every 30 seconds:
2023-02-14 10:03:09 ERROR org.hib.eng.jdb.spi.SqlExceptionHelper:131 (Async:CAS Audit-83) - ERROR: relation "registered_services" does not exist 2023-02-14 10:03:39 ERROR org.hib.eng.jdb.spi.SqlExceptionHelper:131 (Async:CAS Audit-35) - ERROR: relation "registered_services" does not exist 2023-02-14 10:04:09 ERROR org.hib.eng.jdb.spi.SqlExceptionHelper:131 (Async:CAS Audit-84) - ERROR: relation "registered_services" does not exist
How can the logging of this event be stopped?
The PAM system is working correctly and all records are accessible.
-
Add the property xtam.cas.audit.auth=false in the catalina.properties file.
-
Restart the PamManagement/pammanager service.
This will stop Async:CAS Audit from querying the registered_services table, which is normally done to validate that CAS exists and is used in this deployment.
Note: Adding this setting will prevent login and logout audit events being recorded in the audit log.