Re: (RADIATOR) Accounting Table Problem

2000-03-07 Thread Hugh Irvine


Hello Okan -

On Tue, 07 Mar 2000, OKAN ARISU wrote:
> Hi everbody,
> We use Cisco 5300 and Radiator 2.14.1. Users are able to authenticate. Radiator also 
>writes the accounting information to Radonline table. But i have a problem  
> with ACCOUNTING table, radiator is not send to any insert information statement. And 
>i can't see any accounting information in the accounting table. Should i do 
> some change on the .cfg file or someting else?
> 
> 
> **
> Foreground
> LogStdout
> Trace  4
> LogDir  /software/Radiator-2.14.1/Logfiles/
> LogFile  %L/%d-%m-%Y-logfile
> DbDir  .
> 
> 
>  Secret mysecret
> # Her bir RAS client icin baska bir havuz yapilabilir
>  FramedGroupBaseAddress xx.xx.xx.xx
>  FramedGroupBaseAddress xx.xx.xx.xx
> 
> NasType Cisco
> DupInterval 2
> 
> 
> 
> 
>  DBSource dbi:Oracle:basari.world
>  DBUsername gizli
>  DBAuth  gizli123
> 
> 
> 
>  DBSource dbi:Oracle:basari.world
>  DBUsername
>  DBAuth
> 
> 
> 
> 
> PasswordLogFileName %L/%d-%m-%Y-password.log
>AuthByPolicy ContinueWhileReject
> 
> 
>   FramedGroup 0
>  Filename ./userlistbasar
>   DefaultSimultaneousUse 3
> 
> 
> 
>  AddToReply Service-Type = Framed-User,
>  DefaultSimultaneousUse 1
>  FramedGroup 0
> 
>  # Adjust DBSource, DBUsername, DBAuth to suit your DB
>  DBSource dbi:Oracle:basari.world
>  DBUsername
>  DBAuth
>  # You may want to tailor these for your ACCOUNTING table
>  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
> 
> 

The reason this is happening is because the AuthBy FILE accepts the accounting
request so the AuthBy SQL never sees it. Try changing to this:

AuthByPolicy ContinueAlways

hth

Hugh


-- 
Radiator: the most portable, flexible and configurable RADIUS server 
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald, 
Platypus, Freeside, Interbiller, TACACS+, PAM, external, etc, etc.
Available on Unix, Linux, FreeBSD, Windows 95/98/2000, NT, MacOS X.



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



(RADIATOR) Accounting Table Problem

2000-03-07 Thread OKAN ARISU

Hi everbody,
We use Cisco 5300 and Radiator 2.14.1. Users are able to authenticate. Radiator also 
writes the accounting information to Radonline table. But i have a problem  
with ACCOUNTING table, radiator is not send to any insert information statement. And i 
can't see any accounting information in the accounting table. Should i do 
some change on the .cfg file or someting else?

Thanks a lot...

Okan Arisu
Basari Telekom-Turkey
Network Specialist


**
Foreground
LogStdout
Trace  4
LogDir  /software/Radiator-2.14.1/Logfiles/
LogFile  %L/%d-%m-%Y-logfile
DbDir  .


 Secret mysecret
# Her bir RAS client icin baska bir havuz yapilabilir
 FramedGroupBaseAddress xx.xx.xx.xx
 FramedGroupBaseAddress xx.xx.xx.xx

NasType Cisco
DupInterval 2




 DBSource dbi:Oracle:basari.world
 DBUsername gizli
 DBAuth  gizli123



 DBSource dbi:Oracle:basari.world
 DBUsername
 DBAuth




PasswordLogFileName %L/%d-%m-%Y-password.log
   AuthByPolicy ContinueWhileReject


  FramedGroup 0
 Filename ./userlistbasar
  DefaultSimultaneousUse 3



 AddToReply Service-Type = Framed-User,
 DefaultSimultaneousUse 1
 FramedGroup 0

 # Adjust DBSource, DBUsername, DBAuth to suit your DB
 DBSource dbi:Oracle:basari.world
 DBUsername
 DBAuth
 # You may want to tailor these for your ACCOUNTING table
 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



*





ΓΏ
Archive at http://www.starport.net/~radiator/
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.