Hello,
I have a question about session-id in accounting table (using mysql):
It is appear that this field could not be unique over the table, I supposed that NAS's reuse packet id's on defined period.
I found some duplicated records on the accounting table with same session id, and sessiontime on very close time for the same user.
This cause a problem in calculating the login hours for users, I use SQL counter named Total-Time-Limit to limit some users to a predefined connection hours.
Is there a way to force freeradius to eliminate duplication
Yes, see the 'rlm_acct_unique' module and associated docs.
or configure NAS server to not send redundant packets?
Sure, you could set the nas to retry-attempts = 1 ( or 0 ), but it's better to simply use the already existing rlm_acct_unique module to create a new attribute that is a unique hash of other attributes, which will eliminate dupes if you use that unique attribute at the unique key in your DBMS.
-Chris -- \\\|||/// \ StarNet Inc. \ Chris Parker \ ~ ~ / \ WX *is* Wireless! \ Director, Engineering | @ @ | \ http://www.starnetwx.net \ (847) 963-0116 oOo---(_)---oOo--\------------------------------------------------------ \ Wholesale Internet Services - http://www.megapop.net
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
