Hello Abdul,
This is probably close to what you want. You will have to replace sid with the
Oracle SID of your database, and username and passwrod with teh Oracle username
and password to access that database. The detail log file will go in %D/detail
(ie a file called detail in your DbDir)
<Realm DEFAULT>
AuthByPolicy ContinueUntilAccept
<AuthBy SQL>
DBSource dbi:Oracle:sid
DBUsername username
DBAuth password
# This disables authentication:
AuthSelect
AccountingTable ACCOUNTING
AcctColumnDef USERNAME,User-Name
AcctColumnDef TIME_STAMP,Timestamp,integer
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 FRAMEDIPADDRESS,Framed-IP-Address
</AuthBy>
<AuthBy UNIX>
Filename /etc/shadow
</AuthBy>
AcctLogFileName %D/detail
</Realm>
Hope that helps.
Cheers.
On Jun 10, 10:34am, Abdul Rehman Saeed wrote:
> Subject: (RADIATOR) sample radiator configuration file
> Hi,
>
> Plz. do a favor, I have following setup, according to this plz. send me
> a radius.cfg file
> so I just put and start.
>
> 1- I have installed radiator on solaris2.6(UNIX) x86 server, DBI and
> DBD for Oracle are installed, configured and tested.
>
> 2- Oracle8 installed on WindowsNt4.0 server, account radiator created on
> Oracle8.
> table accounting also created as
>
> create table ACCOUNTING (
> USERNAME varchar2(50), -- From User-Name
> TIME_STAMP int, -- Time this was received (since
> 1970)
> ACCTSTATUSTYPE varchar2(10),
> ACCTDELAYTIME int,
> ACCTINPUTOCTETS int,
> ACCTOUTPUTOCTETS int,
> ACCTSESSIONID varchar2(30),
> ACCTSESSIONTIME int, -- Length of the session in secs
>
> ACCTTERMINATECAUSE int,
> NASIDENTIFIER varchar2(50),
> NASPORT int
> );
>
> 3-I have created 30 test accounts on solaris.
>
> 4- I want to authenticate user from /etc/shadow file.
>
> 5- Accounting (billing) log should maintain on both Oracle table as well
> as flat file on solaris.
>
> Looking forward.
> Advance thanks.
>
>
> ===
> Archive at http://www.thesite.com.au/~radiator/
> To unsubscribe, email '[EMAIL PROTECTED]' with
> 'unsubscribe radiator' in the body of the message.
>-- End of excerpt from Abdul Rehman Saeed
--
Mike McCauley [EMAIL PROTECTED]
Open System Consultants Pty. Ltd Unix, Perl, Motif, C++, WWW
24 Bateman St Hampton, VIC 3188 Australia http://www.open.com.au
Phone +61 3 9598-0985 Fax +61 3 9598-0955
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
===
Archive at http://www.thesite.com.au/~radiator/
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.