Fwd: (RADIATOR) Mode secure in radacct.cgi

[Henrique Pais]

Hi Mike,

On 06-Feb-2002 Mike McCauley wrote:
> Hello Henrique,
> 
> Is radacct configured to use file or SQL?

I'm using mysql for accounting.

----

I have another question!

I have a NAS (cisco) sending every hour an update for every adsl
session to radiator - perfect - but this update are absolute values
since the session is up - no incremental values.


Is there any way, that radiator can query the Accounting table, get the last
update and make a diff and only then insert into the Accounting table?

------------------------------

<Handler Acct-Status-Type=/Checkpoint/,Class=/Volumina/,Realm=abc.ch>
 
        # Stripps the realm from the User-Name before accounting it
        RewriteUsername        s/^([^@]+).*/$1/
 
        <AuthBy SQL>
 
                # Connect to MySQL database named 'radius'
                DBSource        dbi:mysql:radius:xxx.xxx.xxx.xxx
                DBUsername      xxxxxxxx
                DBAuth          xxxxxxxx
 
                # Update ACCTVOLUMINA
                AcctSQLStatement insert into ACCTVOLUMINA (USERNAME,
                TIME_STAMP, ACCTSTATUSTYPE, ACCTDELAYTIME, ACCTINPUTOCTETS,
                ACCTOUTPUTOCTETS, ACCTSESSIONID, ACCTSESSIONTIME,
                ACCTTERMINATECAUSE, NASIDENTIFIER, NASPORT,
                FRAMEDIPADDRESS,CALLERID) VALUES ('%{User-Name}',
                '%{Timestamp}', 'Update','%{Acct-Delay-Time}',
                '%{Acct-Input-Octets}', '%{Acct-Output-Octets}',
                '%{Acct-Session-Id}', '%{Acct-Session-Time}', '',
                '%{NAS-Identifier}', '%{NAS-Port}', '%{Framed-Address}', '')

                ... 
        </AuthBy>

 </Handler>


-----------------------------


I know that this is not a radiator problem, but could be that you have already
eared something like.


thx

henrique

> Cheers.
> 
>>
>> ----------  Forwarded Message  ----------
>>
>> Subject: (RADIATOR) Mode secure in radacct.cgi
>> Date: Tue, 05 Feb 2002 16:52:17 +0100 (CET)
>> From: Henrique Pais <h.pais at cybernet.ch>
>> To: radiator at open.com.au
>>
>> Hi
>>
>> I have enable secure in radacct.cgi, but any user that is previous auth by
>> radiator (using Apache-AuthenRadius) can still see all the others
>> (sessions).
>>
>> I have search for this topic in mailing list but without much success.
>>
>> The Radiator version is 2.16.1
>>
>>
>> best regards,
>>
>> pais
>> ===
>> 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.
>>
>> -------------------------------------------------------
> 
> -- 
> Mike McCauley                               mikem at open.com.au
> Open System Consultants Pty. Ltd            Unix, 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, Active Directory etc etc 
> on Unix, Win95/8, 2000, NT, MacOS 9, MacOS X

Henrique Pais
Network Operations
----------------------------------
Cybernet (Schweiz) AG
Schaffhauserstr. 560
CH-8050 Zürich
----------------------------------
E-Mail: Henrique Pais <h.pais at cybernet.ch>
Phone: +41 1 306 92 52
Fax: +41 1 306 95 95
Date: 07-Feb-2002
Time: 10:58:27
===
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.