[cas-user] Re: Update a date database field on successful login

2020-09-25 Thread Marc MAURICE
Thanks mike. This may not be the cleanest solution, but it works and will be easy to maintain accross CAS upgrades. I just configured jdbc audit, and a trigger to update my users table. delimiter // CREATE TRIGGER COM_AUDIT_TRAIL_on_insert_update_users_datelastlogin AFTER INSERT ON

[cas-user] Re: Update a date database field on successful login

2020-09-23 Thread mbar...@scad.edu
Marc, I'd suggest taking a look at JDBC Audits - https://apereo.github.io/cas/6.2.x/installation/Audits.html#database-audits I won't do exactly what you want, but you'll be able to get a last login date from the table it creates. Good luck! -Mike On Wednesday, September 23, 2020 at 4:06:10