Re: [RADIATOR] A way to verify that the number of failed attempt is lesser than 3 in the las 30 minutes

2013-05-22 Thread Jim Tyrrell
Could you log failed auth attempts to a database table (AuthLog SQL?) and when a user connects have an initial AuthBy that checks this table 1st, and if they have 3 Auth failures in the last 30 minutes take the appropriate action: eg If Authlog updates a table called authlog then have an AuthB

Re: [RADIATOR] A way to verify that the number of failed attempt is lesser than 3 in the las 30 minutes

2013-05-22 Thread Anders Bandholm
On Wed, May 22, 2013 at 03:09:20PM +, Pascal Beauregard wrote: > Hi, > > We would like to block request to our Active Directory if a wireless > user have been rejected 3 times in the last 30 minutes. > > We have Cisco Wireless Controllers, Radiator and AD. In a university > environment a lot of

Re: [RADIATOR] Radmin and Database

2013-05-22 Thread rohan.henry
Inline comments below. On Wed, 22 May 2013 17:35:35 +1000 Hugh Irvine wrote: > >Hello Rohan - > >You can do this more simply by only processing stop records and subtracting >the Acct-Session-Time from the Timestamp to get the start time. > >This can be done directly in the SQL statement. Yes.

[RADIATOR] A way to verify that the number of failed attempt is lesser than 3 in the las 30 minutes

2013-05-22 Thread Pascal Beauregard
Hi, We would like to block request to our Active Directory if a wireless user have been rejected 3 times in the last 30 minutes. We have Cisco Wireless Controllers, Radiator and AD. In a university environment a lot of our users have multiple wireless devices all authenticating trough Radiato

Re: [RADIATOR] Radmin and Database

2013-05-22 Thread Heikki Vatiainen
On 05/22/2013 10:35 AM, Hugh Irvine wrote: > You can do this more simply by only processing stop records and subtracting > the Acct-Session-Time from the Timestamp to get the start time. > > This can be done directly in the SQL statement. Seconded. This is a good idea. Thanks, Hugh. Heikki --

Re: [RADIATOR] Custom AuthBy Identifier not being picked up

2013-05-22 Thread Tim Jones
Turns out the initialize method wasn't calling its super :( Just re-added the below line and it worked. $self->SUPER::initialize; Many thanks, Tim Jones *Technology & Quality * ** ** tim.jo...@fon.com Skype: Tim.Jones.Fon C/ Quintanavides 15. Edificio 2, Planta 1ª Parque Empresarial Vía Norte

Re: [RADIATOR] Radmin and Database

2013-05-22 Thread Hugh Irvine
Hello Rohan - You can do this more simply by only processing stop records and subtracting the Acct-Session-Time from the Timestamp to get the start time. This can be done directly in the SQL statement. regards Hugh On 22 May 2013, at 17:11, Heikki Vatiainen wrote: > On 05/22/2013 12:30 AM

Re: [RADIATOR] Radmin and Database

2013-05-22 Thread Heikki Vatiainen
On 05/22/2013 12:30 AM, rohan.he...@cwjamaica.com wrote: > Sample records below include one row per session (I haven't yet been able to > do a proper conversion of epoch time to date for the START_TIME). You are thinking of consolidating the start and stop records into one session record, did I