Hello All, We used the Freeradius 2.X version. We use the accounting SQL module and i remark something. When a user is rejected (Wrong password), i always have this error in radius.log Mon Nov 8 18:07:40 2010 : Auth: Login incorrect: [BCgXXX] Mon Nov 8 18:07:41 2010 : Info: [ACCOUNTING-01] stop packet with zero session length. Mon Nov 8 18:07:41 2010 : Info: rlm_sql (ACCOUNTING-02): Attempting to connect rlm_sql_mysql #13 Mon Nov 8 18:07:41 2010 : Info: rlm_sql_mysql: Starting connect to MySQL server for #13 Mon Nov 8 18:07:41 2010 : Info: rlm_sql (ACCOUNTING-02): Connected new DB handle, #13 Mon Nov 8 18:07:41 2010 : Info: [ACCOUNTING-02] stop packet with zero session length. Accounting-01 thinks that stop packet with zero session length is an error and tried to connect to Accounting-02 sql server. Is it the correct behaviour ? Is it possible to remove this "logging". Thanks Breuer Nicolas Network Supervisor Sales Executive BELCENTER sprl/bvba Avenue Henri Consciencelaan, 94 Bruxelles 1140 Brussel T. : +32 (0)2 403 04 60 F. : +32 (0)2 403 04 63 M. :+32 (0)486 50 27 87 E. : Nicolas.Breuer@Belcenter.biz W. : http://www.BelCenter.be | http://www.BelCenter.net
I have the very same behaviour here on my FR2.1.6 setup with PGSQL accoutning. It produce noisy logs but nothing unacceptable. You can change this by not doing accouting for Stop Accounting packet that show up null session-time: in your acccouting section: if (Acct-Status-Type == Stop && Session-Time != 0) { sql_accounting_module_name } Maybe relying on Session-Time is not a good idea. Try finding out another relevant attribute. Cdt Le lundi 08 novembre 2010 à 18:10 +0100, Breuer Nicolas a écrit :
Hello All,
We used the Freeradius 2.X version.
We use the accounting SQL module and i remark something.
When a user is rejected (Wrong password), i always have this error in radius.log
Mon Nov 8 18:07:40 2010 : Auth: Login incorrect: [BCgXXX] Mon Nov 8 18:07:41 2010 : Info: [ACCOUNTING-01] stop packet with zero session length.
Mon Nov 8 18:07:41 2010 : Info: rlm_sql (ACCOUNTING-02): Attempting to connect rlm_sql_mysql #13 Mon Nov 8 18:07:41 2010 : Info: rlm_sql_mysql: Starting connect to MySQL server for #13 Mon Nov 8 18:07:41 2010 : Info: rlm_sql (ACCOUNTING-02): Connected new DB handle, #13 Mon Nov 8 18:07:41 2010 : Info: [ACCOUNTING-02] stop packet with zero session length.
Accounting-01 thinks that stop packet with zero session length is an error and tried to connect to Accounting-02 sql server.
Is it the correct behaviour ?
Is it possible to remove this "logging".
Thanks
Breuer Nicolas Network Supervisor Sales Executive
BELCENTER sprl/bvba Avenue Henri Consciencelaan, 94 Bruxelles 1140 Brussel
T. : +32 (0)2 403 04 60 F. : +32 (0)2 403 04 63 M. :+32 (0)486 50 27 87 E. : Nicolas.Breuer@Belcenter.biz W. : http://www.BelCenter.be | http://www.BelCenter.net
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
-- Follow us on: twitter https://www.twitter.com/manainternet
Hi,
in your acccouting section:
if (Acct-Status-Type == Stop && Session-Time != 0) { sql_accounting_module_name }
we do a similar thing - except that we do this around a call to the 'detail' virtual-server system instead. doing live SQL inserts/updates of accounting is a bad idea when you get to large numbers of AAA hitting your server. alan
participants (4)
-
Alan Buxey -
Alan DeKok -
Alexandre Chapellon -
Breuer Nicolas