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 COM_AUDIT_TRAIL FOR EACH ROW
BEGIN
IF NEW.AUD_ACTION = 'AUTHENTICATION_SUCCESS' THEN
UPDATE users
SET date_lastloginsuccess = NEW.AUD_DATE
WHERE email = NEW.AUD_USER;
END IF;
END;//
In cas.properties :
cas.audit.enabled=true
cas.audit.number-of-days-in-history=30
#cas.audit.jdbc.max-age-days=30
cas.audit.jdbc.url=${cas.authn.jdbc.query[0].url}
cas.audit.jdbc.dialect=${cas.authn.jdbc.query[0].dialect}
cas.audit.jdbc.user=${cas.authn.jdbc.query[0].user}
cas.audit.jdbc.password=${cas.authn.jdbc.query[0].password}
cas.audit.jdbc.driver-class=${cas.authn.jdbc.query[0].driver-class}
I wonder what is the purpose of max-age-days. Is it the same as
nomber-of-days-in-history.
There is also a column-length=100 default property.
Anyone knowing whate those properties do ? If not I will review the
source code.
documentation link here
<https://apereo.github.io/cas/6.2.x/configuration/Configuration-Properties.html#database-audits>
Thanks in advance,
Marc
Le 23/09/2020 à 15:06, [email protected] a écrit :
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 AM UTC-4 Marc Maurice wrote:
Hello,
I'm using jdbc/mysql to authenticate my users.
I have a simple need : I want to add a last_login_date field,
updated at
each successful login
I want to be able to know if some accounts have not been used from a
very long time.
I red carefully the doc and reviewed the list of properties, but I
see
nothing about that.
Do I need to write some custom code ? Do you know what code or
class I
should extend ?
note: just updated my overlay to 6.2 successfully.
Thanks in advance,
Marc
--
- Website: https://apereo.github.io/cas
- Gitter Chatroom: https://gitter.im/apereo/cas
- List Guidelines: https://goo.gl/1VRrw7
- Contributions: https://goo.gl/mh7qDG
---
You received this message because you are subscribed to the Google Groups "CAS Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/a/apereo.org/d/msgid/cas-user/df59036b-06fb-f6ff-3282-450ad738e877%40clever-age.com.
