Re: Re: 1.1.7 and rlm_sql_mysql duplicated query

2008-02-18 Thread Georgi Alexandrov
Santiago Balaguer Garc#237;a wrote: The answer is not totally correct. Because a microcuts in the connectibity of hotspot cause that hotspot re-sends the acct request. No, because then the Acct-Session-Id would remain the same. In that case, you have to desactivate: -

1.1.7 and rlm_sql_mysql duplicated query

2008-02-17 Thread Georgi Alexandrov
Hello, I'm seeing duplicated queries made to the database when any (linux/pppoe) user logs in through freeradius 1.1.7. Log from mysql logger: 646 Query INSERT INTO radacct (AcctSessionId,AcctUniqueId, UserName, Realm,

Re: Stale sessions problem

2006-02-25 Thread Georgi Alexandrov
Alan DeKok wrote: Georgi Alexandrov [EMAIL PROTECTED] wrote: If a user that somehow failed network connectivity and failed to tell the server account stop tries to reconnect back it won't let him because his previous session is stalled. I need a mechanism that will do a check upon connection

Re: Stale sessions problem

2006-02-25 Thread Georgi Alexandrov
Alan DeKok wrote: Georgi Alexandrov [EMAIL PROTECTED] wrote: how could one know from the database (radacct i suppose) if a user session i stalled or he's actually online? The SQL module is supposed to do this by calling checkrad. Have you listed sql in the session section? Alan

Re: Stale sessions problem

2006-02-25 Thread Georgi Alexandrov
for the customer, and it will have a start time, but the stop time will be blank. This only is valid if the device they are connecting to supplies stop and start records when they logon and off or timeout. it's rp-pppoe linux server on the same machine. -- regards, Georgi Alexandrov Key Server = http

Re: Stale sessions problem

2006-02-20 Thread Georgi Alexandrov
On 2/17/06, Georgi Alexandrov [EMAIL PROTECTED] wrote: Hello,I'm running freeradius 1.1.0 + mysql + dialupadmin on a linux 2.6 boxwith a pppoe-server runing on the same machine as nas.It works great ;-)But i have a problem with stalled sessions.I have set simultaneous use :=1. I have set sql

Stale sessions problem

2006-02-17 Thread Georgi Alexandrov
a given pool range. I need to be sure that it will return an ip to the pool if there's a stalled session detected by the needed mechanism. At the moment radwho and rlm_ippool_tool show about twice or more entries than the number actually used. Please advice ;-) -- regards, Georgi Alexandrov

sqlcounter and dialup admin issue

2006-02-07 Thread Georgi Alexandrov
entry in the database for request from user [het] 2. Tue Feb 7 10:47:14 2006 : Auth: Login incorrect: [het/het] (from client pppoe-as port 0 cli 00:0A:EB:40:9F:FD) if i don't specify maxmonthlysession the user logs fine. any idea? -- regards, Georgi Alexandrov Key Server = http

Re: grouping rlm_ippool's

2006-02-07 Thread Georgi Alexandrov
://www.freeradius.org/list/users.html Mike, repost succcess if any, i will do the same ;-) -- regards, Georgi Alexandrov Key Server = http://pgp.mit.edu/ :: KeyID = 37B4B3EE Key Fingerprint = E429 BF93 FA67 44E9 B7D4 F89E F990 01C1 37B4 B3EE signature.asc Description: OpenPGP digital signature - List info

Multiple ippools with a singe group problem

2006-02-06 Thread Georgi Alexandrov
} } and putting user in pool all doesn't work, freeradius says invalid module group. So i generally need all the pools to be accessible like one pool name ;-) Thanks in advance -- regards, Georgi Alexandrov Key Server = http://pgp.mit.edu/ :: KeyID = 37B4B3EE Key Fingerprint = E429 BF93 FA67