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 .
>
> <Client xx.xx.xx.xx>
> 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
> </Client>
>
>
> <ClientListSQL>
> DBSource dbi:Oracle:basari.world
> DBUsername gizli
> DBAuth gizli123
> </ClientListSQL>
>
> <SessionDatabase SQL>
> DBSource dbi:Oracle:basari.world
> DBUsername
> DBAuth
> </SessionDatabase>
>
>
> <Realm>
> PasswordLogFileName %L/%d-%m-%Y-password.log
> AuthByPolicy ContinueWhileReject
>
> <AuthBy FILE>
> FramedGroup 0
> Filename ./userlistbasar
> DefaultSimultaneousUse 3
> </AuthBy>
>
> <AuthBy SQL>
> 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
> </AuthBy >
> </Realm>
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.
