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