radacct table empty

[andremail82-radius]

Hello folks, I have done tests and more tests here to log the accounting logs in the mysql. I ahev search in the web and found some tips in how to do this, but I still does't have success.

 

In my radiusd.conf in the section regarding accounting I have this:

 

accounting {
        sql
}

 

And in the sql.conf file I have this:

 

sql {

 

driver = "rlm_sql_mysql"

login = "root"

password = ""
radius_db = "radius"

acct_table1 = "radacct"
acct_table2 = "radacct"

postauth_table = "radpostauth"

authcheck_table = "radcheck"
authreply_table = "radreply"

groupcheck_table = "radgroupcheck"
groupreply_table = "radgroupreply"

usergroup_table = "usergroup"

etc....

}

basically I have the default sql.conf file that was generated by freeradius at the compilation.

 

When I run the radius in debug mode I have the following output when my user authenticate.

 

rad_recv: Access-Request packet from host 192.168.2.253:8314, id=26, length=66
        User-Name = "00045700A43B"
        User-Password = "default"
        NAS-IP-Address = 192.168.2.253
        Service-Type = 0x38
        NAS-Identifier = "192"
  Processing the authorize section of radiusd.conf
modcall: entering group authorize for request 2
  modcall[authorize]: module "preprocess" returns ok for request 2
    rlm_realm: No '@' in User-Name = "00045700A43B", looking up realm NULL
    rlm_realm: No such realm "NULL"
  modcall[authorize]: module "suffix" returns noop for request 2
radius_xlat:  '00045700A43B'
rlm_sql (sql): sql_set_user escaped user --> '00045700A43B'
radius_xlat:  'SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE Username = '00045700A43B' ORDER BY id'
rlm_sql (sql): Reserving sql socket id: 1
rlm_sql_mysql: query:  SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE Username = '00045700A43B' ORDER BY id
radius_xlat:  'SELECT radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgroupcheck.Value,radgroupcheck.op  FROM radgroupcheck,usergroup WHERE usergroup.Username = '00045700A43B' AND usergroup.GroupName = radgroupcheck.GroupName ORDER BY radgroupcheck.id'
rlm_sql_mysql: query:  SELECT radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgroupcheck.Value,radgroupcheck.op  FROM radgroupcheck,usergroup WHERE usergroup.Username = '00045700A43B' AND usergroup.GroupName = radgroupcheck.GroupName ORDER BY radgroupcheck.id
radius_xlat:  'SELECT id,UserName,Attribute,Value,op FROM radreply WHERE Username = '00045700A43B' ORDER BY id'
rlm_sql_mysql: query:  SELECT id,UserName,Attribute,Value,op FROM radreply WHERE Username = '00045700A43B' ORDER BY id
radius_xlat:  'SELECT radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgroupreply.Value,radgroupreply.op  FROM radgroupreply,usergroup WHERE usergroup.Username = '00045700A43B' AND usergroup.GroupName = radgroupreply.GroupName ORDER BY radgroupreply.id'
rlm_sql_mysql: query:  SELECT radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgroupreply.Value,radgroupreply.op  FROM radgroupreply,usergroup WHERE usergroup.Username = '00045700A43B' AND usergroup.GroupName = radgroupreply.GroupName ORDER BY radgroupreply.id
rlm_sql: unknown attribute
rlm_sql (sql): Error getting data from database
rlm_sql (sql): Released sql socket id: 1
  modcall[authorize]: module "sql" returns ok for request 2
modcall: group authorize returns ok for request 2
  rad_check_password:  Found Auth-Type Local
auth: type Local
auth: user supplied User-Password matches local User-Password
radius_xlat:  ''
Login OK: [00045700A43B/default] (from client 192 port 0)
Sending Access-Accept of id 26 to 192.168.2.253:8314
        Reply-Message := ""
        State = 0x313032
Finished request 2
Going to the next request
--- Walking the entire request list ---
Waking up in 6 seconds...
--- Walking the entire request list ---
Cleaning up request 2 ID 26 with timestamp 41a4b27a
Nothing to do.  Sleeping until we see a request.

 

 

I see that I have basically 2 problems, one is that I just see SELECT querys to the mysql and the other is that I have this:                             rlm_sql: unknown attribute
rlm_sql (sql): Error getting data from database

Please, if some one could help me to do this I will appreciate.

Thanks a lot!

Andr� Zenun

---

Yahoo! Acesso Gr�tis - Internet r�pida e gr�tis. Instale o discador agora!