---
Foreground LogStdout LogDir /usr/local/src/Radiator-3.7/log DbDir . #DbDir /usr/local/srd/Radiator-3.7/raddb Trace 4
# You will probably want to add other Clients to suit your site. <Client x.x.x.x)> #<Client DEFAULT> Secret adaajah DupInterval 0 </Client>
<Realm DEFAULT> AuthByPolicy ContinueAlways RewriteUsername s/^([EMAIL PROTECTED]).*/$1/ # AcctLogFileName %L/details
<AuthBy SQL> #do the accounting but not authentication AuthSelect DBSource dbi:Pg:dbname=radiator;host=x.x.x.x DBUsername post DBAuth post AccountingTable accounting AcctColumnDef username,User-Name AcctColumnDef time_stamp,Timestamp,formatted-date,to_date \ ('%e %m %Y %H:%M:%S', 'DD MM YYYY HH:MI:SS') AcctColumnDef acctstatustype,Acct-Status-Type AcctColumnDef acctdelaytime,Acct-Delay-Time,integer AcctColumnDef acctinputoctets,Acct-Input-Octets,integer AcctColumnDef acctoutputoctets,Acct-Output-Octets,integer AcctColumnDef acctsessionid,Acct-Session-Id AcctColumnDef acctsessiontime,Acct-Session-Time,integer AcctColumnDef acctterminatecause,Acct-Terminate-Cause AcctColumnDef nasidentifier,NAS-Identifier AcctColumnDef nasport,NAS-Port,integer AcctColumnDef frameipaddress,Framed-IP-Address AcctColumnDef userrequest,User-Request AcctFailedLogFileName %D/missedaccounting ...
Message when a call received :
Thu Dec 18 16:44:16 2003: DEBUG: Handling request with Handler 'Realm=DEFAULT'
Thu Dec 18 16:44:16 2003: DEBUG: Rewrote user name to user_a
Thu Dec 18 16:44:16 2003: DEBUG: Adding session for dedenph, 202.80.208.4, 10
Thu Dec 18 16:44:16 2003: DEBUG: Handling with Radius::AuthSQL
Thu Dec 18 16:44:16 2003: DEBUG: Handling accounting with Radius::AuthSQL
Thu Dec 18 16:44:16 2003: DEBUG: do query is: 'insert into accounting (acctdelaytime,acctsessionid,acctstatustype,frameipaddress,nasport,time_stamp,username) values (0,'030000B7','Start','202.80.208.37',10,to_date ('18 12 2003 16:44:16', 'DD MM YYYY HH:MI:SS'),'user_a')':
Problem :
Content in database for time stamp showing that the time is : '18 12 2003 00:00:00'
So, it's not really put the real time.
What could be wrong ???
TIA
Warmest regards
ddn
_________________________________________________________________
Tired of spam? Get advanced junk mail protection with MSN 8. http://join.msn.com/?page=features/junkmail
=== Archive at http://www.open.com.au/archives/radiator/ Announcements on [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.