Postauth_query semi-duplicates records...

Mario Alberto Cruz Gartner mario.cruz at
Wed Jul 13 20:30:36 CEST 2005

I've changed the postauth_query from the sql.conf to insert there some
extra info (and changed the BD table to reflect this).

postauth_query = "INSERT into ${postauth_table} (id, user, date,
clt_mac, ap_mac, ap_ip, ap_id) values ('', '%{User-Name}', NOW(),
'%{Calling-Station-Id}', '%{Called-Station-Id}', '%{NAS-IP-Address}',

The wierd thing is that when a EAP/TLS client joins, the record on the
BD keeps their info well. BUT, when a EAP/PEAP client authenticates,
the record it's almost duplicated:

| id | user     | date           | clt_mac           | ap_mac         
  | ap_ip        | ap_id                 |
| 49 | john    | 20050713132540 | 00-0b-7d-0f-f7-35 |
00-0c-41-b1-37-07 | | Linksys BEFW11S4-V4.X |
| 50 | jairo    | 20050713132629 |                   |                
  |              |                       |
| 51 | jairo    | 20050713132629 | 00-0b-7d-0f-f7-35 |
00-0c-41-b1-37-07 | | Linksys BEFW11S4-V4.X |

Here, "john" it's a EAP/TLS auth. and "jairo" is the EAP/PEAP auth.

On the server debug i see:
modcall: entering group post-auth for request 47
rlm_sql (sql): Processing sql_postauth
radius_xlat:  'jairo'
rlm_sql (sql): sql_set_user escaped user --> 'jairo'
radius_xlat:  'INSERT into radpostauth (id, user, date, clt_mac,
ap_mac, ap_ip, ap_id) values ('', '
jairo', NOW(), '00-0b-7d-0f-f7-35', '00-0c-41-b1-37-07',
'', 'Linksys BEFW11S4-V4.X')'
rlm_sql (sql) in sql_postauth: query is INSERT into radpostauth (id,
user, date, clt_mac, ap_mac, ap
_ip, ap_id) values ('', 'jairo', NOW(), '00-0b-7d-0f-f7-35',
'00-0c-41-b1-37-07', '', 'L
inksys BEFW11S4-V4.X')
rlm_sql (sql): Reserving sql socket id: 0
rlm_sql (sql): Released sql socket id: 0
  modcall[post-auth]: module "sql" returns ok for request 47
modcall: group post-auth returns ok for request 47

and that "SEEMS" ok, but, on the DB appears 2 records for that query.

Do you know why is happening this?


More information about the Freeradius-Users mailing list