(RADIATOR) Change to mySQL

[Barry Andersson]

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>

Regards

Barry Andersson


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