Re: radius 0.9.3 / mysql 4.0.16: no logging

[James Green]

Nick Davis wrote:

James,

All of your accounting data is being written to the details files. You must 
not have put "sql" in the accounting section of radius.conf.
 

You mean this?:

accounting {
       #
       #  Ensure that we have a semi-unique identifier for every
       #  request, and many NAS boxes are broken.
       acct_unique
       sql
       #
       #  Create a 'detail'ed log of the packets.
       #  Note that accounting requests which are proxied
       #  are also logged in the detail file.
       detail
#       daily
       unix            # wtmp file

       #
       #  For Simultaneous-Use tracking.
       #
       #  Due to packet losses in the network, the data here
       #  may be incorrect.  There's little we can do about it.
       radutmp
#       sradutmp
       #  Return an address to the IP Pool when we see a stop record.
#       main_pool
}
Been there for some time.

Also make sure the sql queries in sql.conf are correct for the "radacct" 
table.
 

I've not touched them. The only thing I did was make it use 
radacct_table1/table2, for which I searched and replaced. mysql.err 
shows nothing, and I've logged into the mysql server using the radius 
user account and successfully inserted some data.

I find it suspicous that although I see SQL queries to SELECT data in 
the authorisation and authentication phase, I see no SQL being performed 
for accounting data.

Take a look at my radius.conf for reference to using mysql for 
accounting and

user/pass/groups (auth).

http://mrtizmo.com/freeradius/
 

Thanks for this, can't see much in there that's different to mine!

James

Hope some of this helps!

Nick
 



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