On Mar 22, 2:02pm, Richard Hawley wrote:
> Subject: Re: Couple of things
>
>
> Mike McCauley wrote:
>
> > Hi Richard,
> >
> > On Mar 19, 11:56am, Richard Hawley wrote:
> > > Subject: Couple of things
> > > You mentioned that you needed to know what kind of database I ran before
> > > you could help me configure it for human readable dates. I run MySQL.
> >
> > In that case, you will need to make your Timestamp column a DATETIME data
type,
> > thnn you can have something like this in you Radiator config:
> >
> > AcctColumnDef AcctColumnDef
TIME_STAMP,Timestamp,formatted-date,'%Y-%m-%e
> > %H:%M:%S'
When I said "something like" I meant you will need to adjust it for your
particular field names. In your case, you will want exactly:
AcctColumnDef TimeStamp,Timestamp,formatted-date,'%Y-%m-%e %H:%M:%S'
The first name in the arg list is the name of the SQL column.
Cheers.
> >
>
> The timestamp is now coming out like this: '0000-00-00 0:00:00' on every
accounting
> start and stop. What did I do wrong?
>
> Trace level 4 output
>
> Mon Mar 22 13:56:48 1999: DEBUG: Query is: insert into Acct0399
> (CallerID, UserName, ModType, InputOctets, OutputOctets,
> StatusType, NASPort, FramedIPAddress, SessionID, SessionTime, TimeStamp,
NASIdent,
> TerminateCause, ConnectSpeed, PopID, DelayTime)
> values
> ('4015965324', 'user', NULL, 212, 186, 'Stop', 109,
> '209.150.4.208', '0000796c', 111, '922129008', '209.150.4.3',
> 'ACCT_TERM_USER_REQUEST', NULL, '3263000', 0)
>
> Here is how I created the table:
>
> CREATE TABLE Acct0399 (
> UserName char(50) DEFAULT '' NOT NULL,
> TimeStamp datetime,
> StatusType char(10),
> DelayTime int(11),
> InputOctets int(11),
> OutputOctets int(11),
> SessionID char(30),
> SessionTime int(11),
> TerminateCause char(50),
> NASIdent char(50),
> NASPort int(11),
> FramedIPAddress char(16),
> ConnectSpeed char(50),
> ModType char(50),
> CallerID char(30),
> PopID char(30),
> KEY Accounting_I (UserName)
> );
>
> I need to fix this fast :). Thanks.
>
> ..Rich
>
>
>-- End of excerpt from Richard Hawley
--
Mike McCauley [EMAIL PROTECTED]
Open System Consultants Pty. Ltd Unix, Perl, Motif, C++, WWW
24 Bateman St Hampton, VIC 3188 Australia Consulting and development
Phone, Fax: +61 3 9598-0985 http://www.open.com.au
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald,
Platypus, Freeside, external, etc etc on Unix, Win95/8, NT, Rhapsody
===
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
