Hello Mary Grace -
The "Timestamp" attribute is added to the incoming request by Radiator, so it is always available to be used to write to the database. I notice your configuration file already contains AcctColumnDef's for Timestamp:
AcctColumnDef timestamp,Timestamp,integer
This will give you a UNIX-style number of seconds since Midnight January 1 1970.
You can use the special characters listed in section 6.2 of the reference manual to create any format you wish.
See also section 6.28.14 in the manual ("doc/ref.html").
regards
Hugh
On Monday, Jul 28, 2003, at 13:10 Australia/Melbourne, Mary Grace wrote:
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 :-)
<200307272250 radius to hugh irvine.txt>
NB: have you included a copy of your configuration file (no secrets), together with a trace 4 debug showing what is happening?
-- Radiator: the most portable, flexible and configurable RADIUS server anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X. - Nets: internetwork inventory and management - graphical, extensible, flexible with hardware, software, platform and database independence.
=== Archive at http://www.open.com.au/archives/radiator/ Announcements on [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
