Dear Hugh,
This is my radiusd.cfg, i put mu client in CLIENLISTSQL
Background
LogStdout
LogDir /var/log/radiator
LogFile %L/%Y-%m.log
DbDir /usr/local/etc/raddb
DictionaryFile %D/dictionary
RewriteUsername tr/A-Z/a-z/
AuthPort 1645
AcctPort 1646
<Log SQL>
DBSource dbi:Oracle:host=localhost;sid=...
DBUsername smi
DBAuth smi
Table RADLOG
Trace 3
</Log SQL>
<ClientListSQL>
DBSource dbi:Oracle:host=localhost;sid=...
DBUsername smi
DBAuth smi
</ClientListSQL>
<Realm>
<AuthBy SQL>
Identifier Oracle
DBSource dbi:Oracle:host=localhost;sid=ORCL
DBUsername smi
DBAuth smi
AuthSelect select PASSWORD, CHECKATTR, REPLYATTR from
SUBSCRIBERS where USERNAME='%n'
AccountingTable ACCOUNTING
AcctColumnDef USERNAME,User-Name
AcctColumnDef TIME_STAMP,Timestamp,formatted-date,to_date('%e %m %Y
%H:%M:%S', 'DD MM YYYY HH24: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
</AuthBy>
</Realm>
<Log FILE>
Filename /var/log/radiator/mylog
Trace 4
</Log>
and this is from my log with trace level 4
Fri Oct 8 20:35:35 1999: DEBUG: Radius::AuthSQL looks for match with
mikem
Fri Oct 8 20:35:35 1999: DEBUG: Radius::AuthSQL ACCEPT:
Fri Oct 8 20:35:35 1999: DEBUG: Access accepted for mikem
Fri Oct 8 20:35:35 1999: DEBUG: Rewrote user name to mikem
Fri Oct 8 20:35:35 1999: DEBUG: Handling request with Handler 'Realm='
Fri Oct 8 20:35:35 1999: DEBUG: Adding session for mikem, 203.63.154.1,
1234
Fri Oct 8 20:35:35 1999: DEBUG: Handling with Radius::AuthSQL
Fri Oct 8 20:35:35 1999: DEBUG: Handling accounting with Radius::AuthSQL
Fri Oct 8 20:35(USERNAME, TIME_STAMP, ACCTSTATUSTYPE, ACCTSESSIONID,
NASPORT)
('mikem', to_date(' 8 10 1999 20:35:35', 'DD MM YYYY
HH24:MI:SS'
Fri Oct 8 20:35:36 1999: DEBUG: Rewrote user name to mikem
Fri Oct 8 20:35:36 1999: DEBUG: Handling request with Handler 'Realm='
Fri Oct 8 20:35:36 1999: DEBUG: Deleting session for mikem, 203.63.154.1,
1234
Fri Oct 8 20:35:36 1999: DEBUG: Handling with Radius::AuthSQL
Fri Oct 8 20:35:36 1999: DEBUG: Handling accounting with Radius::AuthSQL
Fri Oct 8 20:35:36 1999: DEBUG: do query is: insert into ACCOUNTING
(USERNAME, TIME_STAMP, ACCTSTATUSTYPE, ACCTDELAYTIME,
ACCTINPUTO
CTETS, ACCTOUTPUTOCTETS, ACCTSESSIONID, ACCTSESSIONTIME, NASPORT)
values
('mikem', to_date(' 8 10 1999 20:35:36', 'DD MM YYYY
HH24:MI:SS'
), 'Stop', 0, 20000, 30000, '00001234', 1000, 1234)
Fri Oct 8 20:35:36 1999: DEBUG: Accounting accepted
Thank you in advance for your help.
> Could you please send a copy of your configuration file (no secrets) and a more
> lengthy extract from your log file? It will be much easier to help you.
>
> Also have a look at the packet dump at trace level 4, as the accounting packet
> may not contain all the fields that you are trying to log.
>
> thanks
>
> Hugh
>
> --
> Radiator: the most portable, flexible and configurable RADIUS server
> anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald,
> Platypus, Freeside, TACACS+, PAM, external, etc etc on Unix, Win95/8,
> NT, Rhapsody
>
Josafat Timotius - Technical Coordinator
---------------------------------------------
bergabunglah dengan kami membentuk masyarakat
online global yang peduli dan selalu belajar
http://www.mitra.net.id
---------------------------------------------
===
Archive at http://www.thesite.com.au/~radiator/
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.