PostAUth SQL logging

2006-12-29 Thread Cory Robson
I have freeradius logging failed login attempts to the postauth table, what in the sql syntax do I need to change to log the reason for the access-reject (ie password invalid, account expired, or session limit reached)? Cory - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/

Re: dailup admin and badusers

2006-12-29 Thread Kostas Kalevras
[EMAIL PROTECTED] wrote: hi, i don't understand why dialup admin need its own sql table "badusers" and a script to get bad logins whereas rejected users can be found in the freeradius table "radpostauth" ? badusers serves a completely different purpose. As for log_badlogins: 1. It was crea

Possible to define range of users?

2006-12-29 Thread Ran Shenhar
Hi All, I was wondering if the users file can hold some definition for a group of users, for example users with IP 192.168.1.*? I've seen the group example (http://wiki.freeradius.org/index.php/FAQ#How_do_I_deny_access_to_a_spec ific_user.2C_or_group_of_users.3F), but didn't understand if that also

Can anyone prove that := works as the documentation says it does?

2006-12-29 Thread Mike
Hi List, Can anyone here demonstrate a simple sql configuration that proves that the := operator will in fact replace any attribute of the same name, as the documentation says it does? Specfically, I want to see an attribute set in radreply which is then overwritten in radgroupreply, if the u

Freeradius, MySQL and unique accounting records.

2006-12-29 Thread Mark J Elkins
I'm getting multiple "accounting_start_query" records in my "radacct" table. When a "Stop" arrives, each gets the same accounting info (time online, bytes in, bytes out - etc)... However - when I run SQL queries - I do not get true stats - which is a problem. My "accounting_start_query" are st

dailup admin and badusers

2006-12-29 Thread [EMAIL PROTECTED]
hi, i don't understand why dialup admin need its own sql table "badusers" and a script to get bad logins whereas rejected users can be found in the freeradius table "radpostauth" ? Regards, Thomas- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html