Thanks for you reply, but I don't understand just one thing, I have a lot of logs in the directory /usr/local/var/log/radius/radacct/192.168.2.253/ In this directory I have logs auth-detail-<something> and reply-detail-<something>. This isn't accounting information??
Regards, André Zenun Thor Spruyt <[EMAIL PROTECTED]> wrote: 1) Please send your mails as PLAIN TEXT!!! 2) You don't have anything in radacct because the NAS didn't send any accounting packets (according to your debugging output) 3) Regarding the 'unknown attribute' error message: copy the queries as they appear in the debugging output and paste them at your mysql prompt -- Regards, Thor Spruyt E: [EMAIL PROTECTED] W: www.thor-spruyt.com M: +32 (0)475 67 22 65 Bestel nu uw exemplaar van Operationele verkoop (Walter Spruyt - Liesbeth Huysmans) via www.salesguide.be Ontdek de Telenet Hotspot service op www.telenet.be/hotspots ----- Original Message ----- From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, November 24, 2004 3:14 PM Subject: radacct table empty 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:& nbsp; '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! - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html _______________________________________________________ Yahoo! Acesso Grátis - Internet rápida e grátis. Instale o discador agora! http://br.acesso.yahoo.com/ - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html