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.

Reply via email to