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
RewriteUsernames/^([^@]+).*/$1/
AuthBy SQL
# Connect to MySQL database named 'radius'
DBSourcedbi:mysql:radius:xxx.xxx.xxx.xxx
DBUsername
DBAuth
# 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 [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
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 [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
---
--
Mike McCauley [EMAIL PROTECTED]
Open System Consultants Pty. LtdUnix, 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 [EMAIL PROTECTED]
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 [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.