Re: Another possibility to reconcile?

2008-05-16 Thread Alan DeKok
Tuc at T-B-O-H.NET wrote:
   I'm looking to implement the Simultaneous-User Value in radcheck.
 (FR 2.0.3) I'm having the issue that, for whatever reason (I'd blame the 
 network in a heartbeat, not FR at all), the accounting for a logged in user 
 never gets from a NULL acctstoptime to one filled in. 

  Is the server getting accounting stop messages?

  Alan DeKok.
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


Re: Another possibility to reconcile?

2008-05-16 Thread Ivan Kalik
OK, you have 90 sessions open in radacct. How many users does Chillispot
see as current? If there is a big difference than you are not getting
all accounting Stop packets. You should run a script that removes stale
entries (those open for longer than x hours) from radacct.

Ivan Kalik
Kalik Informatika ISP


Dana 16/5/2008, Tuc at T-B-O-H.NET [EMAIL PROTECTED] piše:

Hi,

   I'm looking to implement the Simultaneous-User Value in radcheck.
(FR 2.0.3) I'm having the issue that, for whatever reason (I'd blame the
network in a heartbeat, not FR at all), the accounting for a logged in user
never gets from a NULL acctstoptime to one filled in.

   At the current time, radwho on the server shows approximately
22 active users. In reality I think it'd be more like 1/2 of that. A
SELECT count( * ) FROM radacct WHERE acctstoptime IS NULL ; shows 91
records.

   Due to the version of the NAS we are running (DD-WRT with Chillispot),
we can't get checkrad to help true up the information.

   Is there another way to help keep everything in sync, so we don't have
users who pay for a single ID, doing things like :

lobnic14   00-13-02-25-8C-   shell S1   Thu 17:3  192.168.7 192.168.182.3
lobnic14   00-1B-77-11-F4-   shell S2   Thu 22:1  192.168.7 192.168.182.4
damrap600-0E-35-C0-16-   shell S1   Thu 22:1  192.168.5 192.168.182.5
damrap600-11-24-8F-27-   shell S3   Thu 20:2  192.168.5 192.168.182.10
damrap600-1B-77-06-2F-   shell S4   Thu 20:2  192.168.5 192.168.182.11

   Thanks, Tuc
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html



-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


Re: Another possibility to reconcile?

2008-05-16 Thread Tuc at T-B-O-H.NET
Hi Ivan,

We have many Chillispot systems, but as I mentioned before,
combined, at the time it was approximately 14.

I was hoping that there would be some way to have checkrad do
that for us, but since DD-WRT runs Chillispot and not Coova, we don't have
access to a great utility Coova implemented which would be able to tell us
what sessions it has active at the time. 

Since I wrote the email, I've learned more. It seems that the
DD-WRT units reboot daily as their version of Garbage Collection. It
also seems that unlike Coova, the old Chilli did not send Accounting_On
when it booted, and Accounting_Off when it was shutting down. I have
to do some more log and file investigation, but I'm thinking that the
combination of those 2 issues is whats causing all the dirty sessions.

Since all the units send output to syslog, I'm thinking about
having syslog output to a perl program that parses all the lines and if
it sees the beginning of a DD-WRT reboot, it will forge an Accounting_On
packet (If that is possible. I'm not sure if I'll run into the same issue
I did with trying to run a radtest from the radius server with the IP
and secret for a remote unit).

I'll also see, but I'm sure it'll be pretty difficult, if I
can convince the DD-WRT people to port the Accounting_On/Off function,
and hopefully Coova itself!

Thanks, Tuc
 
 OK, you have 90 sessions open in radacct. How many users does Chillispot
 see as current? If there is a big difference than you are not getting
 all accounting Stop packets. You should run a script that removes stale
 entries (those open for longer than x hours) from radacct.
 
 Ivan Kalik
 Kalik Informatika ISP
 
 
 Dana 16/5/2008, Tuc at T-B-O-H.NET [EMAIL PROTECTED] pi?e:
 
 Hi,
 
  I'm looking to implement the Simultaneous-User Value in radcheck.
 (FR 2.0.3) I'm having the issue that, for whatever reason (I'd blame the
 network in a heartbeat, not FR at all), the accounting for a logged in user
 never gets from a NULL acctstoptime to one filled in.
 
  At the current time, radwho on the server shows approximately
 22 active users. In reality I think it'd be more like 1/2 of that. A
 SELECT count( * ) FROM radacct WHERE acctstoptime IS NULL ; shows 91
 records.
 
  Due to the version of the NAS we are running (DD-WRT with Chillispot),
 we can't get checkrad to help true up the information.
 
  Is there another way to help keep everything in sync, so we don't have
 users who pay for a single ID, doing things like :
 
 lobnic14   00-13-02-25-8C-   shell S1   Thu 17:3  192.168.7 192.168.182.3
 lobnic14   00-1B-77-11-F4-   shell S2   Thu 22:1  192.168.7 192.168.182.4
 damrap600-0E-35-C0-16-   shell S1   Thu 22:1  192.168.5 192.168.182.5
 damrap600-11-24-8F-27-   shell S3   Thu 20:2  192.168.5 192.168.182.10
 damrap600-1B-77-06-2F-   shell S4   Thu 20:2  192.168.5 192.168.182.11
 
  Thanks, Tuc
 -
 List info/subscribe/unsubscribe? See 
 http://www.freeradius.org/list/users.html
 
 
 
 -
 List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
 
 

-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: Another possibility to reconcile?

2008-05-16 Thread Ivan Kalik
Try this instead of DD-WRT:

http://www.polarcloud.com/tomato

Ivan Kalik
Kalik Informatika ISP


Dana 16/5/2008, Tuc at T-B-O-H.NET [EMAIL PROTECTED] piše:

Hi Ivan,

   We have many Chillispot systems, but as I mentioned before,
combined, at the time it was approximately 14.

   I was hoping that there would be some way to have checkrad do
that for us, but since DD-WRT runs Chillispot and not Coova, we don't have
access to a great utility Coova implemented which would be able to tell us
what sessions it has active at the time.

   Since I wrote the email, I've learned more. It seems that the
DD-WRT units reboot daily as their version of Garbage Collection. It
also seems that unlike Coova, the old Chilli did not send Accounting_On
when it booted, and Accounting_Off when it was shutting down. I have
to do some more log and file investigation, but I'm thinking that the
combination of those 2 issues is whats causing all the dirty sessions.

   Since all the units send output to syslog, I'm thinking about
having syslog output to a perl program that parses all the lines and if
it sees the beginning of a DD-WRT reboot, it will forge an Accounting_On
packet (If that is possible. I'm not sure if I'll run into the same issue
I did with trying to run a radtest from the radius server with the IP
and secret for a remote unit).

   I'll also see, but I'm sure it'll be pretty difficult, if I
can convince the DD-WRT people to port the Accounting_On/Off function,
and hopefully Coova itself!

   Thanks, Tuc

 OK, you have 90 sessions open in radacct. How many users does Chillispot
 see as current? If there is a big difference than you are not getting
 all accounting Stop packets. You should run a script that removes stale
 entries (those open for longer than x hours) from radacct.

 Ivan Kalik
 Kalik Informatika ISP


 Dana 16/5/2008, Tuc at T-B-O-H.NET [EMAIL PROTECTED] piše:

 Hi,
 
 I'm looking to implement the Simultaneous-User Value in radcheck.
 (FR 2.0.3) I'm having the issue that, for whatever reason (I'd blame the
 network in a heartbeat, not FR at all), the accounting for a logged in user
 never gets from a NULL acctstoptime to one filled in.
 
 At the current time, radwho on the server shows approximately
 22 active users. In reality I think it'd be more like 1/2 of that. A
 SELECT count( * ) FROM radacct WHERE acctstoptime IS NULL ; shows 91
 records.
 
 Due to the version of the NAS we are running (DD-WRT with Chillispot),
 we can't get checkrad to help true up the information.
 
 Is there another way to help keep everything in sync, so we don't have
 users who pay for a single ID, doing things like :
 
 lobnic14   00-13-02-25-8C-   shell S1   Thu 17:3  192.168.7 192.168.182.3
 lobnic14   00-1B-77-11-F4-   shell S2   Thu 22:1  192.168.7 192.168.182.4
 damrap600-0E-35-C0-16-   shell S1   Thu 22:1  192.168.5 192.168.182.5
 damrap600-11-24-8F-27-   shell S3   Thu 20:2  192.168.5 192.168.182.10
 damrap600-1B-77-06-2F-   shell S4   Thu 20:2  192.168.5 192.168.182.11
 
 Thanks, Tuc
 -
 List info/subscribe/unsubscribe? See 
 http://www.freeradius.org/list/usershtml
 
 

 -
 List info/subscribe/unsubscribe? See 
 http://www.freeradius.org/list/users.html






-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


Re: Another possibility to reconcile?

2008-05-16 Thread Tuc at T-B-O-H.NET
Hi Ivan,

Thanks. Heard alot about it, but it doesn't run Chilli or Coova
native in the distribution. Client wouldn't allow me to piecemeal a
solution.

Thanks, Tuc

 
 Try this instead of DD-WRT:
 
 http://www.polarcloud.com/tomato
 
 Ivan Kalik
 Kalik Informatika ISP
 
 
 Dana 16/5/2008, Tuc at T-B-O-H.NET [EMAIL PROTECTED] pi?e:
 
 Hi Ivan,
 
  We have many Chillispot systems, but as I mentioned before,
 combined, at the time it was approximately 14.
 
  I was hoping that there would be some way to have checkrad do
 that for us, but since DD-WRT runs Chillispot and not Coova, we don't have
 access to a great utility Coova implemented which would be able to tell us
 what sessions it has active at the time.
 
  Since I wrote the email, I've learned more. It seems that the
 DD-WRT units reboot daily as their version of Garbage Collection. It
 also seems that unlike Coova, the old Chilli did not send Accounting_On
 when it booted, and Accounting_Off when it was shutting down. I have
 to do some more log and file investigation, but I'm thinking that the
 combination of those 2 issues is whats causing all the dirty sessions.
 
  Since all the units send output to syslog, I'm thinking about
 having syslog output to a perl program that parses all the lines and if
 it sees the beginning of a DD-WRT reboot, it will forge an Accounting_On
 packet (If that is possible. I'm not sure if I'll run into the same issue
 I did with trying to run a radtest from the radius server with the IP
 and secret for a remote unit).
 
  I'll also see, but I'm sure it'll be pretty difficult, if I
 can convince the DD-WRT people to port the Accounting_On/Off function,
 and hopefully Coova itself!
 
  Thanks, Tuc
 
  OK, you have 90 sessions open in radacct. How many users does Chillispot
  see as current? If there is a big difference than you are not getting
  all accounting Stop packets. You should run a script that removes stale
  entries (those open for longer than x hours) from radacct.
 
  Ivan Kalik
  Kalik Informatika ISP
 
 
  Dana 16/5/2008, Tuc at T-B-O-H.NET [EMAIL PROTECTED] pi?e:
 
  Hi,
  
I'm looking to implement the Simultaneous-User Value in radcheck.
  (FR 2.0.3) I'm having the issue that, for whatever reason (I'd blame the
  network in a heartbeat, not FR at all), the accounting for a logged in 
  user
  never gets from a NULL acctstoptime to one filled in.
  
At the current time, radwho on the server shows approximately
  22 active users. In reality I think it'd be more like 1/2 of that. A
  SELECT count( * ) FROM radacct WHERE acctstoptime IS NULL ; shows 91
  records.
  
Due to the version of the NAS we are running (DD-WRT with Chillispot),
  we can't get checkrad to help true up the information.
  
Is there another way to help keep everything in sync, so we don't have
  users who pay for a single ID, doing things like :
  
  lobnic14   00-13-02-25-8C-   shell S1   Thu 17:3  192.168.7 192.168.182.3
  lobnic14   00-1B-77-11-F4-   shell S2   Thu 22:1  192.168.7 192.168.182.4
  damrap600-0E-35-C0-16-   shell S1   Thu 22:1  192.168.5 192.168.182.5
  damrap600-11-24-8F-27-   shell S3   Thu 20:2  192.168.5 192.168.182.10
  damrap600-1B-77-06-2F-   shell S4   Thu 20:2  192.168.5 192.168.182.11
  
Thanks, Tuc

-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Another possibility to reconcile?

2008-05-15 Thread Tuc at T-B-O-H.NET
Hi,

I'm looking to implement the Simultaneous-User Value in radcheck.
(FR 2.0.3) I'm having the issue that, for whatever reason (I'd blame the 
network in a heartbeat, not FR at all), the accounting for a logged in user 
never gets from a NULL acctstoptime to one filled in. 

At the current time, radwho on the server shows approximately
22 active users. In reality I think it'd be more like 1/2 of that. A
SELECT count( * ) FROM radacct WHERE acctstoptime IS NULL ; shows 91
records.

Due to the version of the NAS we are running (DD-WRT with Chillispot),
we can't get checkrad to help true up the information. 

Is there another way to help keep everything in sync, so we don't have
users who pay for a single ID, doing things like :

lobnic14   00-13-02-25-8C-   shell S1   Thu 17:3  192.168.7 192.168.182.3
lobnic14   00-1B-77-11-F4-   shell S2   Thu 22:1  192.168.7 192.168.182.4
damrap600-0E-35-C0-16-   shell S1   Thu 22:1  192.168.5 192.168.182.5
damrap600-11-24-8F-27-   shell S3   Thu 20:2  192.168.5 192.168.182.10
damrap600-1B-77-06-2F-   shell S4   Thu 20:2  192.168.5 192.168.182.11

Thanks, Tuc
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html