(RADIATOR) Problem with DateTime in Calls-table

[Herman verschooten]

Hi,
 
I seem to have a little problem.  I notice in my Calls-table that all
records have a DateTime with 0 seconds.  Is this a config-issue? most
likely, but where?
 
I have included my config.
 
Tx,
 
Herman
 
 
 
# Radius.cfg
#
# N E T 4 A L L
#
 
Foreground
LogStdout
LogDir          d:/radius/log
DbDir  c:/Program Files/Radiator
 
BindAddress     N.N.N.20
AuthPort        1812,1645
AcctPort        1813,1646
 
LogFile  %L/log%Y%m%d.log
 
Trace 4
 
SnmpgetProg c:/Program Files/Radiator/net-snmp/snmpget.exe
 
#Strip realm
RewriteUsername s/^([^@]+).*/$1/
 
# Allow only these chars in the username
#UsernameCharset a-zA-Z0-9\.-_@
 
# You will probably want to change this to suit your site.
<Client N.N.N.4>
 # Cisco 5300
 Identifier   DIALUP
 Secret   
 DupInterval  10
 NasType      Cisco
 SNMPCommunity   
</Client>
<Client N.N.2.141>
 # Belgacom ADSL
 Identifier TURBOLINE
 Secret 
 DupInterval 10
 IdenticalClients N.N.2.142
 IdenticalClients N.N.2.143
 IdenticalClients N.N.1.152
 IdenticalClients N.N.20.2
 IdenticalClients N.N.20.6
 IdenticalClients N.N.20.10
 IdenticalClients N.N.20.14
 IdenticalClients N.N.20.130
 IdenticalClients N.N.20.134
 IdenticalClients N.N.20.138
 IdenticalClients N.N.20.142
</Client>
<Client N.N.34.3>
 # Versatel DSL
 Identifier VERSADSL
 Secret 
 DupInterval 10
 IdenticalClients N.N.34.51
 IdenticalClients N.N.32.3
</Client>
<Client N.N.101.249>
 # Scarlet DSL
 Identifier 2UDSL
 Secret 
 DupInterval 10
 IdenticalClients N.N.101.241
</Client>
 
<Client 127.0.0.1>
 Secret 
 DupInterval 0
 IdenticalClients N.N.N.9
 Identifier LOCALHOST
</Client>
 
<Realm DEFAULT>
 AcctLogFileName %L/%Y%m%d.log
 AuthByPolicy  ContinueWhileAccept
 <AuthBy SQL>
  DBSource dbi:ODBC:Radiator
  DBUsername 
  DBAuth  
  AuthSelect select PASSWORD,CHECKATTR, REPLYATTR From SUBSCRIBERS where
USERNAME=%0
  DefaultSimultaneousUse 1
#  Accounting
  AccountingTable Calls
  AcctColumnDef NASIdentifier,NAS-Identifier
  AcctColumnDef NASIdentifier,NAS-IP-Address
  AcctColumnDef NASPort,NAS-Port,integer
  AcctColumnDef AcctSessionId,Acct-Session-Id
  AcctColumnDef AcctStatusType,Acct-Status-Type,integer
  AcctColumnDef CallDate,Timestamp,integer-date
  AcctColumnDef UserName,User-Name
  AcctColumnDef AcctDelayTime,Acct-Delay-Time,integer
  AcctColumnDef AcctSessionTime,Acct-Session-Time,integer
  AcctColumnDef FramedAddress,Framed-IP-Address
  AcctColumnDef AcctTerminateCause,Acct-Terminate-Cause,integer
  AcctColumnDef ConnectInfo,Connect-Info,string
  AcctColumnDef CallerID,Calling-Station-Id,string
  AcctColumnDef AcctInputOctets,Acct-Input-Octets,integer
  AcctColumnDef AcctOutputOctets,Acct-Output-Octets,integer
  AcctColumnDef AcctInputOctets,RB-Acct-Input-Octets-64,integer
  AcctColumnDef AcctOutputOctets,RB-Acct-Output-Octets-64,integer
 </AuthBy>
 <AuthBy FILE>
  Filename %D/Profile.cfg
  StripFromReply Profile
 </AuthBy>
 <AuthLog REMOTESYSLOG>
                SysLogHost N.N.60.8
  LogSuccess 1
  LogFailure 1
 </AuthLog>
 <AuthLog SQL>
  DBSource dbi:ODBC:Radiator
  DBUsername 
  DBAuth  
  LogSuccess 1
  LogFailure  1
    </AuthLog>
</Realm>
 

<Log REMOTESYSLOG>
        SysLogHost N.N.60.8
 Trace 3
</Log>
<Log SQL>
 DBSource dbi:ODBC:Radiator
 DBUsername 
 DBAuth  
 Trace  3 
<Monitor>
 Username 
 Password 
</Monitor>
<SessionDatabase SQL>
 DBSource dbi:ODBC:Radiator
 DBUsername 
 DBAuth  
</SessionDatabase>
 
Herman verschooten
 
 
WebVisie bvba
Een klare kijk op interne en externe communicatie
_______________________________________________
Oudaan 15 / 33        2000 Antwerpen       http://www.webvisie.net
<http://www.webvisie.net/> 
tel 03/206.72.70       fax 03/234.93.82      h.verschooten at webvisie.net
<mailto:h.verschooten at webvisie.net>    
 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.open.com.au/pipermail/radiator/attachments/20030617/45d32053/attachment.html>