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 [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.