Postauth_query semi-duplicates records...
Hi! 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}', '%{NAS-Identifier}')" 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 | 192.168.20.7 | Linksys BEFW11S4-V4.X | | 50 | jairo | 20050713132629 | | | | | | 51 | jairo | 20050713132629 | 00-0b-7d-0f-f7-35 | 00-0c-41-b1-37-07 | 192.168.20.7 | 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', '192.168.20.7', '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', '192.168.20.7', '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? Thks!
participants (2)
-
Alan DeKok -
Mario Alberto Cruz Gartner