Re: Re: Simultaneous-Use problem with Mikrotik NAS clients

2010-02-12 Thread Fojtán Balázs István
Hello, >Yes, > >Simulaneous-Use is a check item, not a reply. Ok, I did this mistake, sorry. Now I've deleted the Simultaneous-Use := 1 record from radgroupreply (now this is empty), and inserted it into the radgroupcheck. mysql> select * from radgroupcheck; ++---+--+

Re: Re: Simultaneous-Use problem with Mikrotik NAS clients

2010-02-12 Thread Chris Knipe
Yes, Simulaneous-Use is a check item, not a reply. 2010/2/12 Fojtán Balázs István > Hello Fajar, > > >> mysql> select * from radgroupreply; > >> ++---+--++---+ > >> | id | GroupName | Attribute ? ? ? ?| op | Value | > >> ++---+--+-

Re: Re: Simultaneous-Use problem with Mikrotik NAS clients

2010-02-12 Thread Fojtán Balázs István
Hello Fajar, >> mysql> select * from radgroupreply; >> ++---+--++---+ >> | id | GroupName | Attribute ? ? ? ?| op | Value | >> ++---+--++---+ >> | ?1 | HZ ? ? ? ?| Simultaneous-Use | := | 1 ? ? | >> ++---+-

Re: Simultaneous-Use problem with Mikrotik NAS clients

2010-02-11 Thread Marinko Tarlac
Yes. Fajar A. Nugraha wrote: 2010/2/11 Fojtán Balázs István : mysql> select * from radgroupreply; ++---+--++---+ | id | GroupName | Attribute| op | Value | ++---+--++---+ | 1 | HZ| Simultaneous-Use | :=

Re: Simultaneous-Use problem with Mikrotik NAS clients

2010-02-11 Thread Fajar A. Nugraha
2010/2/11 Fojtán Balázs István : > mysql> select * from radgroupreply; > ++---+--++---+ > | id | GroupName | Attribute        | op | Value | > ++---+--++---+ > |  1 | HZ        | Simultaneous-Use | := | 1     | > ++

Re: Re: Simultaneous-Use problem with Mikrotik NAS clients

2010-02-11 Thread Fojtán Balázs István
Hello Fajar, thanks for your rapid response! >> simul_count_query = "SELECT COUNT(*) \ >> FROM ${acct_table1} \ >> WHERE username = '%{SQL-User-Name}' \ >> AND acctstoptime IS NULL" > >it uses ${acct_table1} (should be radacct by default). Have you >enabled accounting? > Yes, the accounting is w

Re: Simultaneous-Use problem with Mikrotik NAS clients

2010-02-11 Thread Fajar A. Nugraha
2010/2/11 Fojtán Balázs István : > simul_count_query = "SELECT COUNT(*) \ > FROM ${acct_table1} \ > WHERE username = '%{SQL-User-Name}' \ > AND acctstoptime IS NULL" it uses ${acct_table1} (should be radacct by default). Have you enabled accounting? > mysql> select * from radcheck; > ++--

RE: Simultaneous-Use problem.

2007-06-25 Thread Josh Howlett
> On Monday 25 June 2007 11:42:08 Josh Howlett wrote: > > I have a feeling that the answer is blindingly obvious, but I can't > > figure it out... > > > > The 'users' file consists of: > > > > DEFAULT Auth-Type = Accept > > Simultaneous-Use := 1 > > Because Simultaneous-Use is in t

Re: Simultaneous-Use problem.

2007-06-25 Thread Kevin Bonner
On Monday 25 June 2007 11:42:08 Josh Howlett wrote: > I have a feeling that the answer is blindingly obvious, but I can't > figure it out... > > The 'users' file consists of: > > DEFAULT Auth-Type = Accept > Simultaneous-Use := 1 Simultaneous-Use is a check item, not a reply it

Re: User never get disconnected (was Re: Simultaneous-Use problem)

2007-04-12 Thread tnt
There is a line in (my)sql.conf: # Remove stale session if checkrad does not see a double login deletestalesessions = yes that enables it. I don't know if there is such an entry in mssql.conf. Ivan Kalik Kalik Informatika ISP Dana 12/4/2007, "satish patel" <[EMAIL PROTECTED]> piše:

Re: User never get disconnected (was Re: Simultaneous-Use problem)

2007-04-12 Thread tnt
No. Idle-Timeout will work if NAS doesn't realize that user is not online any more. It doesn't help if stop packets are lost. Only checkrad or such routines that check user status with NAS will help there. Ivan Kalik Kalik Informatika ISP Dana 12/4/2007, "satish patel" <[EMAIL PROTECTED]> piše:

Re: User never get disconnected (was Re: Simultaneous-Use problem)

2007-04-12 Thread Jacob Jarick
for a temp fix I would make your perl script ping said ip before checking for idle (perhaps a sleep timer) or you could simply have each supposed active ip pinged every 1 - 2 minutes by a seperate perl script. Would you mind posting your checkrad.pl script, Im a perl hacker myself :) On 4/12/07,

Re: User never get disconnected (was Re: Simultaneous-Use problem)

2007-04-12 Thread satish patel
checkrad work only for simultaneous detection not fix my stop time entry in sql it is possible to modify checkrad to fix sql stop time in radacct table ? [EMAIL PROTECTED] wrote: If you are happy with reliability then fix checkrad and it will clean these random drops. That is the utility that r

Re: User never get disconnected (was Re: Simultaneous-Use problem)

2007-04-12 Thread satish patel
I have faceing same problem when some time NAS send ACCT-STOP packet and packet would be lost then user session would be open and next time whne user try to login he/she got error multilogin so that i have implement checkrad.pl script and check simultaneouse users through SNMP and it is working

User never get disconnected (was Re: Simultaneous-Use problem)

2007-04-12 Thread tnt
If you are happy with reliability then fix checkrad and it will clean these random drops. That is the utility that radiusd calls to check stale entries and in sql.conf you can enable deletion of such entries. Just make sure that such users are not listed as active by the hotspot. If NAS thinks they

Re: User never get disconnected (was Re: Simultaneous-Use problem)

2007-04-12 Thread PD
On 4/12/2007, "Milan Holub" <[EMAIL PROTECTED]> wrote: >==> is Accounting-STOP reaching your radius? >you can find out by running in debug mode: freeradius -X > >==> is the correct query run on your database? check accounting_ queries in >your sql/mysql-dialup.conf >* check your DB log files: eg.

User never get disconnected (was Re: Simultaneous-Use problem)

2007-04-12 Thread PD
On 4/12/2007, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote: >+ what cause of this problem ? >Either NAS thinks that users are still connected or your RADIUS server is >not receiving Stop packages. If NAS (NAS not radacct table) shows users >as connected you can add Idle-Timeout of about 5 minutes

User never get disconnected (was Re: Simultaneous-Use problem)

2007-04-12 Thread tnt
Dana 12/4/2007, "PD" <[EMAIL PROTECTED]> piše: >snip + what cause of this problem ? >snip Either NAS thinks that users are still connected or your RADIUS server is not receiving Stop packages. If NAS (NAS not radacct table) shows users as connected you can add Idle-Timeout of about 5 minutes in u

Re: Simultaneous-Use problem

2007-04-12 Thread tnt
Operator should be :=. Check first that you have sql checking enabled in radiusd.conf: # Session database, used for checking Simultaneous-Use. Either the radutmp # or rlm_sql module can handle this. # The rlm_sql module is *much* faster session { # radutmp # # See "Simul

Re: User never get disconnected (was Re: Simultaneous-Use problem)

2007-04-12 Thread Milan Holub
On Thu, Apr 12, 2007 at 07:42:16AM +, PD wrote: > I still have another problem... > many of radacct table records are incompleted. > We know the user already disconnected (even by click logout botton or > just shut his/her computer down), but the information did not saved. > > At Radacct table

User never get disconnected (was Re: Simultaneous-Use problem)

2007-04-12 Thread PD
On 4/12/2007, "Milan Holub" <[EMAIL PROTECTED]> wrote: .cut... >==> I believe you have a typo in the tables: >radgroupcheck: groupname=POSTPAID >usergroup: groupname=POSPAID I still have another problem... many of radacct table records are incompleted. We know the user already disconnected (even b

Re: Simultaneous-Use problem

2007-04-12 Thread PD
On 4/12/2007, "Milan Holub" <[EMAIL PROTECTED]> wrote: >Hi, > >On Thu, Apr 12, 2007 at 07:14:48AM +, PD wrote: >> Dear all, >> >> We has the problem regarding the above subject... >> mysql> select * from radgroupcheck; >> ++---+--++---+ >> | id | GroupName |

Re: Simultaneous-Use problem

2007-04-12 Thread Milan Holub
Hi, On Thu, Apr 12, 2007 at 07:14:48AM +, PD wrote: > Dear all, > > We has the problem regarding the above subject... > mysql> select * from radgroupcheck; > ++---+--++---+ > | id | GroupName | Attribute| op | Value | > ++---+---

Re: Simultaneous-Use Problem

2005-07-29 Thread Alan DeKok
"Jeremy Kenney" <[EMAIL PROTECTED]> wrote: > Yes but what I want is for the radius server to check the accounting logs > for a session already in progress and send a access reject if its already > there I responded to this yesterday. Do you read the list? Read doc/Simultaneous-Use Alan De

RE: Simultaneous-Use Problem

2005-07-29 Thread Jeremy Kenney
: freeradius-users@lists.freeradius.org Subject: Re: Simultaneous-Use Problem On 7/28/05, Jeremy Kenney <[EMAIL PROTECTED]> wrote: > I have posted this twice now I was wondering if someone would be kind enough > to possibly answer it > > Hello, > > I am a very frustrated

Re: Simultaneous-Use Problem

2005-07-29 Thread Noah Dain
On 7/28/05, Jeremy Kenney <[EMAIL PROTECTED]> wrote: > I have posted this twice now I was wondering if someone would be kind enough > to possibly answer it > > Hello, > > I am a very frustrated free radius user at this point. It's most likely my > brain not working right but here is my problem >