Timing out user after missed accounting updates

2003-11-14 Thread Alex French
Hi all, In brief, I'm looking for a way to assume users are logged out if their NAS missed x accounting updates (or alternatively, no update for y seconds). The use case is as follows: We have a number of wireless hotspots at the end of unreliable links. We use RADIUS accounting to bill

Re: accounting updates

2003-11-10 Thread Didi Rieder
Quoting Didi Rieder <[EMAIL PROTECTED]>: > Hi, > > the default accounting_update_query in sql.conf makes no update for input and > output octets and session-time. Is this correct, or shoud the query look more > like the following: > > accounting_update_query = "UPDATE ${acct_table1} > SET > Fr

accounting updates

2003-11-07 Thread Didi Rieder
Hi, the default accounting_update_query in sql.conf makes no update for input and output octets and session-time. Is this correct, or shoud the query look more like the following: accounting_update_query = "UPDATE ${acct_table1} SET FramedIPAddress = '%{Framed-IP-Address}', AcctSessionTime

accounting updates

2003-11-06 Thread Didi Rieder
Hi, the default accounting_update_query in sql.conf makes no update for input and output octets and session-time. Is this correct, or shoud the query look like the following: accounting_update_query = "UPDATE ${acct_table1} SET FramedIPAddress = '%{Framed-IP-Address}', AcctSessionTime = '%{

Re: Accounting updates losing username in sqltrace

2002-05-17 Thread freeradius-users
[EMAIL PROTECTED] wrote: >11.2 is really really old, wow. That predates even the 11.3 docs, which >was about the first release that was marginally functional for a NAS. Well, our 3640's have actually been like tanks for several years - reliable and solid. They only do basic Modem and ISDN dial-

Re: Accounting updates losing username in sqltrace

2002-05-17 Thread Chris Parker
At 07:15 PM 5/17/2002 +0100, freeradius-users wrote: >[EMAIL PROTECTED] wrote: > > >Read the docs. This is covered in the 'cisco' readme in the 'docs' > >directory. > >I did that before posting to the list... ;-). > > > >You need to add a config command to your cisco NAS that tells them not > >to

Re: Accounting updates losing username in sqltrace

2002-05-17 Thread freeradius-users
[EMAIL PROTECTED] wrote: >Read the docs. This is covered in the 'cisco' readme in the 'docs' >directory. I did that before posting to the list... ;-). >You need to add a config command to your cisco NAS that tells them not >to send the accounting packet until it has assigned the IP. The doc

Re: Accounting updates losing username in sqltrace

2002-05-17 Thread Chris Parker
At 06:43 PM 5/17/2002 +0100, freeradius-users wrote: >FreeRadius 0.5 snapshot 15-05-2002 on RedHat 7.1. >Using MySQL for authentication, authorisation and accouinting. >Cisco 3640 dial NAS, IOS 11.2 > > >I'm having a problem with accounting update information. The Cisco doesn't >send the Framed-I

Accounting updates losing username in sqltrace

2002-05-17 Thread freeradius-users
o the record. Thus, I can't see what IP addresses users have when looking at radacct. I've looked at the SQL statements in sql.conf, and the accounting updates appear to use the same phrasing for usernames as the accounting inserts "%{SQL_User_Name}". The accounting sto

Re: Interim Accounting updates question

2001-08-23 Thread aland
daniel malmkvist <[EMAIL PROTECTED]> wrote: > In a reqular acct-status-type = stop (2), everything works fine, looks > like this: ... > When sending the same attributes to the server except changing > acct-status-type= 3, i get the following: > > radius_xlat: 'UPDATE radacct SET FramedIPAddres

Interim Accounting updates question

2001-08-23 Thread daniel malmkvist
Hi, I have just set up freeradius and trying to get the accountingdata to be stored in MySQL. Now I have a problem with interim accountion updates, my SQL database doesn't update. In a reqular acct-status-type = stop (2), everything works fine, looks like this: radius_xlat: 'UPDATE radacct S