Thats what I do have. I'm new to SQL, but I'm not that new :). So, is there
anything else that could be causing the blank fields?
..Rich
Mike McCauley wrote:
> 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.
