Re: radacct table empty

[Thor Spruyt]

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