(RADIATOR) 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' > The timestamp is now coming out like this: '-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', '796c', 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 === To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
(RADIATOR) Re: Couple of things
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: '-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', '796c', 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. LtdUnix, 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.
(RADIATOR) Re: Couple of things
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: '-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', '796c', 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. LtdUnix, 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.