not Accountint
javkhlanbaatar at newcomsystems.mn
javkhlanbaatar at newcomsystems.mn
Mon Feb 4 07:14:26 CET 2008
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.
More information about the Freeradius-Users
mailing list