Hello Authur,

The Timestamp attribute is set in each accounting request, with the time of the
session start or stop, so you could add a TIME_STAMP integer column, and add
this to your config:

AcctColumnDef   TIME_STAMP,Timestamp,integer


Hope that helps.

Cheers.

On Jul 6,  4:05pm, Authur Lin wrote:
> Subject: (RADIATOR) log start/stop time in ACCOUNTING table
>
> [ Attachment (text/plain): 594 bytes
>   Character set: big5
>   plain text ]
>-- End of excerpt from Authur Lin


Hello,

I want to log the start/stop time for each session in ACCOUNTING table.
Please tell me how to do it ? (I use MySQL as SQL server)

 <AuthBy SQL>
        ...
        AcctColumnDef   NASIPADDRESS,NAS-IP-Address
        AcctColumnDef   NASPORT,NAS-Port,integer
        AcctColumnDef   NASPORTTYPE,NAS-Port-Type
        AcctColumnDef   USERNAME,User-Name
        AcctColumnDef   CALLEDSTATIONID,Called-Station-Id
        ...

Authur

-- 
Mike McCauley                               [EMAIL PROTECTED]
Open System Consultants Pty. Ltd            Unix, Perl, Motif, C++, WWW
24 Bateman St Hampton, VIC 3188 Australia   http://www.open.com.au
Phone +61 3 9598-0985                       Fax   +61 3 9598-0955

Radiator: the most portable, flexible and configurable RADIUS server 
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald, 
Platypus, Freeside, TACACS+, PAM, external, etc etc on Unix, Win95/8, 
NT, Rhapsody
===
Archive at http://www.thesite.com.au/~radiator/
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.

Reply via email to