RFC 2866 - Accounting ON / Accounting OFF packets

[Arran Cudbard-Bell]

Hi,

RFC 2866 (5.5) States 'An Accounting-Request packet MUST have an 
Acct-Session-Id' but for Accounting Request packets with 
'Acct-Status-Type' set to Accounting-On or Accounting-Off, there can be 
no Acct-Session-Id, as these are global events on the NAS...

Unless the NAS is meant to send an Accounting-On or Accounting-Off 
packet for every  session on the access point, when an Accounting-On or 
Accounting-Off event occurs...

Does anyone know of a later RFC that clarifies this ?

Also the index 'acctsessiontime' is missing for the radacct table in the 
default schema; makes the Accounting-On / Accounting-Off queries very 
slow doing a table scan on 1.4 million rows... Is this intentional or an 
oversight ?

Might be an Idea to specify the default engine as InnoDB for the MySQL 
schemas. MyISAM (with it's table locks on every update/insert) just 
doesn't cut it with a reasonably busy RADIUS server; all connections in 
the db pool get used and users start being rejected.
Not good ...

Thanks,
Arran
**

-- 
Arran Cudbard-Bell (A.Cudbard-Bell at sussex.ac.uk)
Authentication, Authorisation and Accounting Officer
Infrastructure Services | ENG1 E1-1-08 
University Of Sussex, Brighton
EXT:01273 873900 | INT: 3900