Those are access-request and access-accept packets. No accounting request is being received ! Your NAS isn't sending any accounting messages ? Maybe you should disable all those modules that you don't need ! Regards, E:S -----Original Message----- From: freeradius-users-bounces+edvin.seferovic=kolp.at@lists.freeradius.org [mailto:freeradius-users-bounces+edvin.seferovic=kolp.at@lists.freeradius.or g] On Behalf Of javkhlanbaatar@newcomsystems.mn Sent: Montag, 04. Februar 2008 07:14 To: FreeRadius users mailing list Subject: not Accountint Hi, Everything with the Authentication is OK. But Accounting is not working. I've added dialupadmin tables (such as badusers.sql, userinfo.sql .... ) to my radius table. Do I have to insert some data to them? These tables are empty. And in dialupadmin, there isn't any RADIUSClients menu on the web. When I tried to add new user by dialupadmin, "Could not open encryption library file" error. I've uncommented most of parts in the conf files. I think, Accounting Packet is not sending and sending back Reply packet. How can I manage these? Also give me brief description of unlang function, please. Here is the logging with debugging mode: Ready to process requests. rad_recv: Access-Request packet from host 203.34.37.40 port 1060, id=2, length=124 User-Name = "testuser" User-Password = "test" NAS-IP-Address = 203.34.37.40 NAS-Port = 10101001 Service-Type = Framed-User Framed-Protocol = PPP Framed-IP-Address = 192.168.160.111 Called-Station-Id = "001B2109D9EC" Calling-Station-Id = "ff-ff-ff-ff-ff-ff" Acct-Session-Id = "143" NAS-Port-Type = Virtual +- entering group authorize ++[preprocess] returns ok expand: /usr/local/var/log/radius/radacct/%{Client-IP-Address}/auth-detail-%Y%m%d -> /usr/local/var/log/radius/radacct/203.34.37.40/auth-detail-20080204 rlm_detail: /usr/local/var/log/radius/radacct/%{Client-IP-Address}/auth-detail-%Y%m%d expands to /usr/local/var/log/radius/radacct/203.34.37.40/auth-detail-20080204 expand: %t -> Mon Feb 4 12:27:56 2008 ++[auth_log] returns ok ++[chap] returns noop ++[mschap] returns noop rlm_realm: No '@' in User-Name = "testuser", looking up realm NULL rlm_realm: No such realm "NULL" ++[suffix] returns noop rlm_eap: No EAP-Message, not doing EAP ++[eap] returns noop ++[unix] returns notfound users: Matched entry DEFAULT at line 172 ++[files] returns ok expand: %{User-Name} -> testuser rlm_sql (sql): sql_set_user escaped user --> 'testuser' rlm_sql (sql): Reserving sql socket id: 1 expand: SELECT id, username, attribute, value, op FROM radcheck WHERE username = '%{SQL-User-Name}' ORDER BY id -> SELECT id, username, attribute, value, op FROM radcheck WHERE username = 'testuser' ORDER BY id rlm_sql_mysql: query: SELECT id, username, attribute, value, op FROM radcheck WHERE username = 'testuser' ORDER BY id rlm_sql (sql): User found in radcheck table expand: SELECT id, username, attribute, value, op FROM radreply WHERE username = '%{SQL-User-Name}' ORDER BY id -> SELECT id, username, attribute, value, op FROM radreply WHERE username = 'testuser' ORDER BY id rlm_sql_mysql: query: SELECT id, username, attribute, value, op FROM radreply WHERE username = 'testuser' ORDER BY id expand: SELECT groupname FROM usergroup WHERE username = '%{SQL-User-Name}' ORDER BY priority -> SELECT groupname FROM usergroup WHERE username = 'testuser' ORDER BY priority rlm_sql_mysql: query: SELECT groupname FROM usergroup WHERE username = 'testuser' ORDER BYpriority expand: SELECT id, groupname, attribute, Value, op FROM radgroupcheck WHERE groupname= '%{Sql-Group}' ORDER BY id -> SELECT id, groupname, attribute, Value, op FROM radgroupcheck WHERE groupname = 'static' ORDER BY id rlm_sql_mysql: query: SELECT id, groupname, attribute, Value, op FROM radgroupcheck WHERE groupname = 'static' ORDER BY id rlm_sql (sql): User found in group static expand: SELECT id, groupname, attribute, value, op FROM radgroupreply WHERE groupname= '%{Sql-Group}' ORDER BY id -> SELECT id, groupname, attribute, value, op FROM radgroupreply WHERE groupname = 'static' ORDER BY id rlm_sql_mysql: query: SELECT id, groupname, attribute, value, op FROM radgroupreply WHERE groupname = 'static' ORDER BY id rlm_sql (sql): Released sql socket id: 1 ++[sql] returns ok rlm_counter: Entering module authorize code rlm_counter: Could not find Check item value pair ++[daily] returns noop rlm_checkval: Item Name: Calling-Station-Id, Value: ff-ff-ff-ff-ff-ff rlm_checkval: Value Name: Calling-Station-Id, Value: ff-ff-ff-ff-ff-ff ++[checkval] returns ok ++[logintime] returns noop rlm_pap: Found existing Auth-Type, not changing it. ++[pap] returns noop rlm_sqlcounter: Entering module authorize code rlm_sqlcounter: Could not find Check item value pair ++[dailycounter] returns noop rad_check_password: Found Auth-Type Local auth: type Local auth: user supplied User-Password matches local User-Password Login OK: [testuser/test] (from client radiusbbsm port 10101001 cli ff-ff-ff-ff-ff-ff) +- entering group post-auth expand: /usr/local/var/log/radius/radacct/%{Client-IP-Address}/reply-detail-%Y%m%d -> /usr/local/var/log/radius/radacct/203.34.37.40/reply-detail-20080204 rlm_detail: /usr/local/var/log/radius/radacct/%{Client-IP-Address}/reply-detail-%Y%m%d expands to /usr/local/var/log/radius/radacct/203.34.37.40/reply-detail-20080204 expand: %t -> Mon Feb 4 12:27:56 2008 ++[reply_log] returns ok rlm_sql (sql): Processing sql_postauth expand: %{User-Name} -> borluulalt rlm_sql (sql): sql_set_user escaped user --> 'testuser' expand: %{User-Password} -> test expand: INSERT INTO radpostauth (username, pass, reply, authdate) VALUES ( '%{User-Name}', '%{%{User-Password}:-%{Chap-Password}}', '%{reply:Packet-Type}', '%S') -> INSERT INTO radpostauth (username, pass, reply, authdate) VALUES ( 'testuser', 'test', 'Access-Accept', '2008-02-04 12:27:56') expand: /usr/local/var/log/radius/sqltrace.sql -> /usr/local/var/log/radius/sqltrace.sql rlm_sql (sql) in sql_postauth: query is INSERT INTO radpostauth (username, pass, reply, authdate) VALUES ( 'testuser', 'test', 'Access-Accept', '2008-02-04 12:27:56') rlm_sql (sql): Reserving sql socket id: 0 rlm_sql_mysql: query: INSERT INTO radpostauth (username, pass, reply, authdate) VALUES ( 'testuser', 'test', 'Access-Accept', '2008-02-04 12:27:56') rlm_sql (sql): Released sql socket id: 0 ++[sql] returns ok rlm_sql_log (sql_log): Processing sql_log_postauth expand: %{User-Name} -> testuser expand: %{%{User-Name}:-DEFAULT} -> testuser rlm_sql_log (sql_log): sql_set_user escaped user --> 'testuser' WARNING: Deprecated conditional expansion ":-". See "man unlang" for details expand: INSERT INTO radpostauth (username, pass, reply, authdate) VALUES ('%{User-Name}', '%{User-Password:-Chap-Password}', '%{reply:Packet-Type}', '%S'); -> INSERT INTO radpostauth (username, pass, reply, authdate) VALUES ('testuser', 'test', 'Access-Accept', '2008-02-04 12:27:56'); expand: /usr/local/var/log/radius/radacct/sql-relay -> /usr/local/var/log/radius/radacct/sql-relay ++[sql_log] returns ok Sending Access-Accept of id 2 to 203.34.37.40 port 1060 Framed-Protocol := PPP Framed-Compression := Van-Jacobson-TCP-IP Service-Type := Framed-User Finished request 1. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html