Hello,
I want to log Start/Stop time for each session in ACCOUNTING table (use
MySQL as SQL server) using the following configuration and MySQL
setting. I want to have the time format YYYY-MM-DD HH:MM:SS( for
example: 1999-07-09 10:05:30). It works, but the content of TIME_STAMP
filed in table ACCOUNTING is strange:
Log :
insert into ACCOUNTING
(ACCTAUTHENTIC, USERNAME, FRAMEDPROTOCOL,
ACCTSTATUSTYPE, NASIPA
DDRESS, NASPORT, NASPORTTYPE, ACCTSESSIONID, FRAMEDIPADDRESS,
SERVICETYPE, TIME_
STAMP) values ('RADIUS', 'chiuchiu', 'PPP', 'Start', '210.208.161.225',
1, 'Async', '1e00004603', '210.208.164.81', 'Framed-User', 931487024)
Field content in ACCOUNTING table:
TIME_STAMP: 2000-09-31 48:70:24
Could anyone tell me why ? ( I have checked the system date is right:
Fri Jul 9 11:14:34 CST 1999) or how to set the configuration and MySQL
if I want to get the right datetime format ?
<AuthBy SQL>
...
AcctColumnDef NASIPADDRESS,NAS-IP-Address
AcctColumnDef NASPORT,NAS-Port,integer
AcctColumnDef NASPORTTYPE,NAS-Port-Type
AcctColumnDef USERNAME,User-Name
AcctColumnDef CALLEDSTATIONID,Called-Station-Id
AcctColumnDef TIME_STAMP,Timestamp,integer
...
MySQL:
Field : TIME_STAMP Type: datetime
Authur
===
Archive at http://www.thesite.com.au/~radiator/
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
