(RADIATOR) Change to mySQL

[Hugh Irvine]

Hello Barry -

On Thursday 22 November 2001 11:20, Barry Andersson wrote:
> Hi,
>
> I'm just about ready to start logging accounting requests to a mySQL
> database. I've setup the following AuthBy SQL in my radius.cfg.
>
> My question is I would like to save the timestamp as a datetime format
> rather than integer. Do I have my AcctColumnDef set correctly to do that?
>
> <AuthBy SQL>
> Identifier SQLAccounting
> DBSource radius
> DBUsername #######
> DBAuth #######
> AuthSelect
> AccountingTable ACCOUNTING
> AccountingStopsOnly
> AcctColumnDef USERNAME,UserName
> AcctColumnDef DATETIME,timestamp,datetime
> AcctColumnDef ACCTINPUTOCTETS,Acct-Input-Octets,integer
> AcctColumnDef ACCTOUTPUTOCTETS,Acct-Output-Octets,integer
> AcctColumnDef ACCTSESSIONTIME,Acct-Session-Time,integer
> AcctColumnDef ACCTTERMINATECAUSE,Acct-Terminate-Cause
> AcctColumnDef ACCTTERMINATECAUSE,Ascend-Disconnect-Cause
> AcctColumnDef CONNECTSPEED,Acc-Connect-Tx-Speed,integer
> </AuthBy>
>

This is how to format the AcctColumnDef:

AcctColumnDef DATETIME,Timestamp,integer-date

and of course the DATETIME column will have to be correctly set up in the 
database.

Have a look at section 6.28.13 in the Radiator 2.19 reference manual 
(included in the distribution in the file "doc/ref.html").

regards

Hugh


-- 
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.