(RADIATOR) How to time-stamp SQL Accounting database w/o timestamp attribute

Mary Grace radiator at diskserv.com
Sun Jul 27 22:10:48 CDT 2003


Hello list!  Hugh Irvine has been very kind and helped us tremendously in 
getting AuthBy SQL going with MySQL.  Hopefully Hugh will not think we are 
as clueless now as he probably has been thinking, but compared to you all 
we are still really un-clued.  However, one little thing is not working, 
and I wondered if anyone on the list has a neat way they would share for 
how to timestamp each accounting record in the MySQL database when both the 
attributes Timestamp and Event-Timestamp are missing from the incoming 
accounting packets the NAS sends.  Some of the NAS from whom we receive 
packets  send this timestamping, and some do not.

Although we have muddled through and customised the tables a bit, none of 
us are MySQL gurus and have diligently searched the Archives of this List, 
lest Hugh scold us yet again :-)

Could someone please share a clever method with us that we could use?  Our 
Trace 4 output and the radius cfg is given below. If you notice start-date 
commented out, it is because it does not work :-( Thank you!

Sr. Mary Grace

PS - is this the correct way to have all AuthBy Radius packets, auth and 
acctg, forwarded to a remote radius client to be auth'ed and have acctg 
packets copied to them, while still being able to auth the packets 
ourselves of the remote site does not answer, AND have a copy for 
accounting purposes of everything that goes to the remote site to also be 
copied into our accounting tables in MySQL?

Thanks :-)


-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: 200307272250 radius to hugh irvine.txt
URL: <http://www.open.com.au/pipermail/radiator/attachments/20030727/444104a6/attachment.txt>


More information about the radiator mailing list