Accounting issue , no entry in database
RADIUS web management application
Brought to you by:
lirantal
Hi,
When i run my radius server in debug mode the following errors are highlighted
1) [acct_unique] Attribute nas port was not found
2) [suffix] no @ in user_name ="XXX", looking up realm null, no such realm
3) IN Accounting [sql]-> rlm_sql_mysql: MySQL check_error:1054 recieved
[sql] couldn't insert sql accounting START record- unknown coloumn 'xascendsessionsvrkey' in 'field list'
My main concern is that i am not getting accounting information in mysql radacct table though my nas is working perfectly.
please if somebody can help in resolving this issue
Thanks.
Anonymous
It seems like the issue is with item (3), possibly you have an older or not an original FreeRADIUS db schema imported.