(RADIATOR) Problem with DateTime in Calls-table

[Hugh Irvine]

Hello Herman -

Could you please send me a trace 4 debug showing what is happening?

And how have you defined the column in the database?

regards

Hugh


On Tuesday, Jun 17, 2003, at 18:31 Australia/Melbourne, Herman 
verschooten wrote:

> 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
> tel 03/206.72.70       fax 
> 03/234.93.82      h.verschooten at webvisie.net  
>  
>

NB: have you included a copy of your configuration file (no secrets),
together with a trace 4 debug showing what is happening?

-- 
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.

-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: text/enriched
Size: 6189 bytes
Desc: not available
URL: <http://www.open.com.au/pipermail/radiator/attachments/20030617/bb4825c9/attachment.bin>