(RADIATOR) Newbie setup question

[Hugh Irvine]

Hello Graham -

The AuthBy SQL clause will write all accounting records to the  
database, including Start, Stop, Alive, Accounting-On, etc.

You can alter this behaviour by configuring the AuthBy SQL clause  
appropriately, using the HandleAcctStatusTypes parameter.

See section 6.29.10 in the Radiator 3.11 reference manual  
("doc/ref.html").

regards

Hugh


On 14 Feb 2005, at 11:00, Graham Farrow wrote:

> Hi All,
>
> We are in the process of changing over from ICRADIUS to Radiator  
> (getting the eval to work fully first though).  I have a quick  
> question though.
>
> With ICRADIUS upon receiving the STOP request, it would update the  
> accounting table accordingly.  Ie there would only be one record for  
> the entire session.  With my initial testing I am getting an entry for  
> the start and the stop in the accounting table.
>
> Is this correct or perhaps do I have an error in my test config.    
> (config is below for reference….any help is most appreciated).
>
> *********************************************************************** 
> **********
>
> LogDir          /var/log/radius
>
> # Use a low trace level in production systems. Increase
>  # it to 4 or 5 for debugging, or use the -trace flag to radiusd
>  Trace           5
>
> # You will probably want to add other Clients to suit your site,
>  # one for each NAS you want to work with
>
> DictionaryFile /etc/radiator/dictionary
>
> <ClientListSQL>
>         DBSource        dbi:mysql:radiator:<ipaddress>:radiator
>         DBUsername      <dbusername>
>         DBAuth          <dbpass>
>
> </ClientListSQL>
>
> <SessionDatabase SQL>
>          Identifier      SDB1
>          DBSource        dbi:mysql:radiator:<ipaddress>:radiator
>         DBUsername      <dbusername>
>         DBAuth          <dbpass>
>
> </SessionDatabase>
>
> <Realm DEFAULT>
>          <AuthBy SQL>
>                  DBSource         
> dbi:mysql:radiator:<ipaddress>:radiator
>                 DBUsername      <dbusername>
>                 DBAuth          <dbpass>
>
>                 AuthSelect      select PASSWORD, G.CHECKATTR,  
> G.REPLYATTR \
>                                  from SUBSCRIBERS S, GROUPS G,  
> GROUPMEMBERS GM \
>                                  where GM.USERNAME = S.USERNAME \
>                                  and G.ID = GM.GID \
>                                  and S.USERNAME=%0
>                                 and S.SUSPENDED = 0
>                  AuthColumnDef   0, User-Password, check
>                  AuthColumnDef   1, GENERIC, check
>                  AuthColumnDef   2, GENERIC, reply
>
>                 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>
>
> </Realm>
>

NB:

Have you read the reference manual ("doc/ref.html")?
Have you searched the mailing list archive  
(www.open.com.au/archives/radiator)?
Have you had a quick look on Google (www.google.com)?
Have you included a copy of your configuration file (no secrets),
together with a trace 4 debug showing what is happening?

-- 
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. Available on *NIX, *BSD, Windows, MacOS X.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.
-
CATool: Private Certificate Authority for Unix and Unix-like systems.

--
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.