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.