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/^([EMAIL PROTECTED]).*/$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������[EMAIL PROTECTED]��
�
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.
