(RADIATOR) a few mysqlCreate tweaks - bluesocket + airespace

[Andrew D. Clark]

I found I needed a few tweaks to the MySQL session database.  Perhaps this 
will help other folks out there.

The unique index for the RADONLINE table is NASIDENTIFIER, NASPORT.  Some 
things (like a BlueSocket gateway) don't seem to send a NASPORT.  That makes 
NASPORT default to 0 and since it's always the same for each user, you get 
key conflicts.  I've set the unique index to be 
NASIDENTIFIER,NASPORT,ACCTSESSIONID.  Seems to work well enough.

To go with this, you'll want a DeleteQuery something like:

# USERNAME and ACCTSESSIONID are already quoted by radiator
DeleteQuery     DELETE FROM RADONLINE WHERE USERNAME=%0 AND NASIDENTIFIER='%1' 
AND ACCTSESSIONID=%3

The ACCTSESSIONID field is char(30).  Some things (like a Cisco/Airespace 
appliance) send a longer ACCTSESSIONID.  Since ACCTSESSIONID then gets 
truncated on insert, deletes don't work.  I've bumped mine to 64 chars, which 
is excessive, but I don't want to have to make it bigger again!

-- 
Andrew Clark
Campus Network Programmer
University of California, Santa Barbara
andrew.clark at ucsb.edu (805) 893-5311

--
Archive at http://www.open.com.au/archives/radiator/
Announcements on radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.