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 <[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. 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 <[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.