I have encountered a weird problem with apereo 5.2. I managed to log all audits to a mysql database. Then i am using the configuration properties below to check for throttling but nothing happens. It just logging these in the database. 2 records for every request. No throttle log on console too. Note that i have tried multiple combinations of
cas.authn.throttle.jdbc.auditQuery=SELECT AUD_DATE FROM COM_AUDIT_TRAIL WHERE AUD_CLIENT_IP = ? AND AUD_USER = ? AND AUD_ACTION = ? AND APPLIC_CD = ? AND AUD_DATE >= ? ORDER BY AUD_DATE DESC
cas.authn.throttle.jdbc.url=jdbc:mysql:/example/example
cas.authn.throttle.jdbc.dialect=org.hibernate.dialect.MySQLDialect
cas.authn.throttle.jdbc.user=.....
cas.authn.throttle.jdbc.ddlAuto=update
cas.authn.throttle.jdbc.password=....
cas.authn.throttle.jdbc.driverClass=com.mysql.jdbc.Driver
cas.authn.throttle.jdbc.pool.suspension=true
cas.authn.throttle.jdbc.pool.minSize=6
cas.authn.throttle.jdbc.pool.maxSize=18
cas.authn.throttle.jdbc.pool.maxWait=2000
cas.authn.throttle.usernameParameter=username
cas.authn.throttle.schedule.startDelay=10000
cas.authn.throttle.schedule.repeatInterval=20000
cas.authn.throttle.appcode=CAS
cas.authn.throttle.failure.threshold=1
cas.authn.throttle.failure.code=AUTHENTICATION_FAILED
cas.authn.throttle.failure.rangeSeconds=10
cas.rest.throttler=authenticationThrottle
cas.audit.jdbc.url=jdbc:mysql://example/example
cas.audit.jdbc.dialect=org.hibernate.dialect.MySQLDialect
cas.audit.jdbc.driverClass=com.mysql.jdbc.Driver
cas.audit.jdbc.user=....
cas.audit.jdbc.password=....
cas.audit.jdbc.ddlAuto=update