(RADIATOR) Accounting in sql and local file authentication

[Barrett (Barry) W Clark]

Luis,

I am doing what you describe but with PostgreSQL.  I have included my 
config.  Hope it helps.

~~snip~~
<AuthBy SQL>
         Identifier      SQLAccounting
         DBSource        dbi:Pg:dbname=[DataBaseName];host=[SQLServerIPAddress]
         DBUsername      [DatabaseUsername]
         DBAuth  [DatabasePassword]

         # Just accounting, no auth

         IgnoreAuthentication
         AuthSelect

         AccountingTable RadiatorAccounting
         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-IP-Address
         AcctColumnDef   NASPORT,NAS-Port,integer
         AcctColumnDef   NASPORTTYPE,NAS-Port-Type
         AcctColumnDef   FRAMEDIPADDRESS,Framed-IP-Address
         AcctColumnDef   CALLEDSTATIONID,Called-Station-Id
         AcctColumnDef   CALLINGSTATIONID,Calling-Station-Id

</AuthBy>

<AuthBy FILE>
         Identifier      CheckFile
         Filename        %D/users
</AuthBy>

<AuthBy GROUP>
         Identifier CheckUser
         AuthByPolicy ContinueUntilAccept
         AuthBy CheckFile
</AuthBy>

<Realm DEFAULT>
         AuthByPolicy ContinueAlways
         AuthBy SQLAccounting
         AuthBy CheckUser

         # Log accounting to a detail file
         AcctLogFileName %L/cd-%Y%m%d
</Realm>

bwc

At 11:38 AM 3/11/2004, Luis Marquez wrote:
>Hello everyone,
>
>I am trying to get radiator to authenticate users from a local users
>file and send accounting data to our Oracle 9i database. This config is
>currently on a non production test system. I have two authby clauses,
>one <AuthBy FILE> and one <AuthBySQL>. I have a handler set up that I
>think is supposed to send accounting data to the database while still
>authenticating against the local file. I can connect to the database,
>but I can't authenticate from the local file.
>
>Seems like radiator does not continue on to the AuthBy FILE clause. From
>what I read in another post, the AuthByPolicy ContinueAlways inside the
>handler is supposed to do this?
>
>Any advice would be greatly appreciated.
>
>Thanks,
>
>Luis
>
>Here are the relevant parts of my config:
>
>#Default Realm
><Realm DEFAULT>
>         <AuthBy FILE>
>                 AutoMPPEKeys yes
>                 Filename %D/static/users
>         </Authby>
>
>         AcctLogFileName %L/detail
></Realm>
>
><Realm blahblah.com>
>         RewriteUsername tr/A-Za-z0-9_.+&-@//cd
>
>         <AuthBy SQL>
>                 Identifier Remote-SQL
>                 DBSource dbi:Oracle:dbname
>                 DBUsername username
>                 DBAuth pword
>                 # Disable authentication
>                 AuthSelect
>
>                 # But do accounting
>                 AccountingTable ACCOUNTING
>                 AcctColumnDef   USERNAME,User-Name
>TIME_STAMP,Timestamp,interger
>         </AuthBy>
>
>         <AuthBy FILE>
>                 Identifier Local-File
>                 Filename %D/users
>                 # Generate MPPE keys to encrypt pptp vpns
>                 AutoMPPEKeys Yes
>         </AuthBy>
>
>         <Handler Request-Type = Accounting-Request>
>                 AuthByPolicy ContinueAlways
>                 AuthBy Remote-SQL
>                 AuthBy Local-File
>         </Handler>
>
># Log accounting to the detail file in LogDir
>         AcctLogFileName %L/detail
>
></Realm>
>
>
>
>--
>Archive at http://www.open.com.au/archives/radiator/
>Announcements on radiator-announce at open.com.au
>To unsubscribe, email 'majordomo at open.com.au' with
>'unsubscribe radiator' in the body of the message.


--
Archive at http://www.open.com.au/archives/radiator/
Announcements on radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.