Accounting and SQL, help!

[Maqbool Hashim]

Anson Rinesmith wrote:
Run radius in debug mode (radiusd -X) and see if you can figure out 
what is
happening.

 

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:freeradius-
[EMAIL PROTECTED] On Behalf Of Maqbool Hashim
Sent: Wednesday, June 30, 2004 11:24 AM
To: [EMAIL PROTECTED]
Subject: problems with radius accounting when using mysql
Hi,
I have radius set up to get authentication information from a mysql
database.  I want it to log accounting information to the radacct table
in my
mysql database.  I have set up the accounting section in my radiusd.conf
file as follows:
accounting {
                     acct_unique
                     detail
                     unix
                     sql
                     radutmp
                  }
However radius is still logging accounting information to the files and
I can't see anything in the radacct table in my database.  (I have
rebooted the radius server).
Am I missing a crucial setting here?
Regards,
Maqbool
-
List info/subscribe/unsubscribe? See
http://www.freeradius.org/list/users.html
  

- List info/subscribe/unsubscribe? See 
http://www.freeradius.org/list/users.html
 

Thanks, I had another look at the debug messages from the radiusd 
server, I can't see anything that illuminating in there.  I see the sql 
module being loaded:

Module: Loaded SQL
.
.
.
.
sql: accounting_update_query = "UPDATE radacct SET FramedIPAddress = 
'%{Framed-IP-Address}' WHERE AcctSessionId =
'%{Acct-Session-Id}' AND UserName = '%{SQL-User-Name}' AND NASIPAddress= 
'%{NAS-IP-Address}' AND AcctStopTime = 0"
sql: accounting_update_query_alt = ""

Thats the sql query that should get executed when the accounting section 
is processed.  However when there is an authentication request from a 
NAS, I only see sql queries and connections to the mysql server during 
the authorize section:

modcall[authorize]: module "suffix" returns noop for request 1
radius_xlat:  'ben'
rlm_sql (sql): sql_set_user escaped user --> 'ben'
radius_xlat:  'SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE 
Username = 'ben' ORDER BY id'
rlm_sql (sql): Reserving sql socket id: 3
rlm_sql_mysql: query:  SELECT id,UserName,Attribute,Value,op FROM 
radcheck WHERE Username = 'ben' ORDER BY id
:
:
:

But I don't see anything like modcall[accounting] and an sql query.  
Should I be? And if I'm not what setting have I missed?  The accounting 
section in radiusd.conf looks as I gave above.

Regards,
Maqbool
- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html