Re: (RADIATOR) Accounting to SQL w/out authenticating via SQL

1999-07-01 Thread Mike McCauley

Hi,

On Jul 1,  9:27pm, postmaster wrote:
 Subject: Re: (RADIATOR) Accounting to SQL w/out authenticating via SQL

 Mike,

 Will the same scenario work for 'AuthBy File' but do the SQL Accounting ?

Yes, no problem.



 Thanks.
 [EMAIL PROTECTED]

 On Fri, 2 Jul 1999, Mike McCauley wrote:

 Date: Fri, 2 Jul 1999 09:37:19 -0500
 From: Mike McCauley [EMAIL PROTECTED]
 To: John Coy [EMAIL PROTECTED], [EMAIL PROTECTED]
 Subject: Re: (RADIATOR) Accounting to SQL w/out authenticating via SQL
 
 Hello John,
 
 On Jul 1, 11:50am, John Coy wrote:
  Subject: (RADIATOR) Accounting to SQL w/out authenticating via SQL
  Is there a way to configure Radiator to log accounting
  records to SQL without requiring authentication to
  occur via SQL?  I have radiator configured for Proxy
  for several realms, but I'd like to capture the accounting
  records for those realms into an SQL (Oracle) database.
 
  The manual for AuthBy SQL is unclear if you can just
  use that for accounting.
 
 Yes, no problem. If you define AuthSelect to be empty, then SQL will not do
 authentication at all (it will REJECT), eg:
 
 Realm whatever
  AuthByPolicy ContinueAlways
  AuthBy SQL
  # Disable authentication
  AuthSelect
 
  # But do accounting
  AccountingTable ACCOUTNING
  AcctColumnDef   USERNAME,User-Name
  TIME_STAMP,Timestamp,integer
  .
  /AuthBy
 
  AuthBy RADIUS
  Host xx
  ...
  /AuthBy
 /Realm
 
 Hope that helps.
 
 Cheers.
 
 
 
 --
 Mike McCauley   [EMAIL PROTECTED]
 Open System Consultants Pty. LtdUnix, 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.
 


-- End of excerpt from postmaster



-- 
Mike McCauley   [EMAIL PROTECTED]
Open System Consultants Pty. LtdUnix, 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.



Re: (RADIATOR) Accounting to SQL w/out authenticating via SQL

1999-07-01 Thread postmaster


Mike,

Will the same scenario work for 'AuthBy File' but do the SQL Accounting ?


Thanks.
[EMAIL PROTECTED]

On Fri, 2 Jul 1999, Mike McCauley wrote:

Date: Fri, 2 Jul 1999 09:37:19 -0500
From: Mike McCauley [EMAIL PROTECTED]
To: John Coy [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: Re: (RADIATOR) Accounting to SQL w/out authenticating via SQL

Hello John,

On Jul 1, 11:50am, John Coy wrote:
 Subject: (RADIATOR) Accounting to SQL w/out authenticating via SQL
 Is there a way to configure Radiator to log accounting
 records to SQL without requiring authentication to
 occur via SQL?  I have radiator configured for Proxy
 for several realms, but I'd like to capture the accounting
 records for those realms into an SQL (Oracle) database.

 The manual for AuthBy SQL is unclear if you can just
 use that for accounting.

Yes, no problem. If you define AuthSelect to be empty, then SQL will not do
authentication at all (it will REJECT), eg:

Realm whatever
   AuthByPolicy ContinueAlways
   AuthBy SQL
   # Disable authentication
   AuthSelect

   # But do accounting
   AccountingTable ACCOUTNING
   AcctColumnDef   USERNAME,User-Name
   TIME_STAMP,Timestamp,integer
   .
   /AuthBy

   AuthBy RADIUS
   Host xx
   ...
   /AuthBy
/Realm

Hope that helps.

Cheers.



-- 
Mike McCauley   [EMAIL PROTECTED]
Open System Consultants Pty. LtdUnix, 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.



===
Archive at http://www.thesite.com.au/~radiator/
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.