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

[Hugh Irvine]

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 radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.