Fwd: (RADIATOR) Mode secure in radacct.cgi

[Hugh Irvine]

Hello Henrique -

You could do what you describe, but it is usually better to keep the original 
accounting records and post-process the data. This is because it is possible 
to get duplicate accounting records, and it is preferable to keep the 
processing load inside Radiator to a minimum.

regards

Hugh


On Thu, 7 Feb 2002 21:28, Henrique Pais wrote:
> 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.

-- 
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.
===
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.