Custom Audit Log to DB

[Ps Chu]

Hi all,

Besides writing the audit log to CAS default audit database table [COM_AUDIT_TRAIL], may I know any methods that can custom my own audit log to another database table for storing the authentication result in database?

Do I need to extend the login flow and create a simple DAO class to insert record into the database after authentication action? 

Thanks,

Shing

[Ray Bon]

Shing,

Are you looking for an audit entry that is different from those in COM_AUDIT_TRAIL?

You may be able to create a web flow event to do that.

But NOTE: I was not able to insert my custom login flow after the Duo universal prompt flow. Unfortunately it looks like the cas modules (cas 6.5.x) have lowest priority, meaning that they are inserted into the webflow after others. It would be nice if the cas modules had a middle priority, making it easier for deployers to insert before or after as needed.

YMMV

Ray

On Thu, 2023-07-20 at 23:55 -0700, Ps Chu wrote:

Notice: This message was sent from outside the University of Victoria email system. Please be cautious with links and sensitive information.

---

Disclaimer This message (including any attachments) may contain confidential information intended for a specific individual and/or purpose. If you are not the intended recipient, please delete this message and notify the sender and the University immediately. Any disclosure, copying, or distribution of this message, or the taking of any action based on it, is prohibited as it may be unlawful. In addition, the University specifically denies any responsibility for the accuracy or quality of information obtained through University E-mail Facilities. Any views and opinions expressed in the email(s) are those of the author(s), and do not necessarily represent the views and opinions of the University. The University accepts no liability whatsoever for any losses or damages that may be incurred or caused to any party as a result of the use of such information.