Session-Timeout anomalies

[Bill Isaacs]

Again Alan, read between the lines.  I've been scanning these emails 
from this group for about year through google searches.
What I've learned from this mailing list is that you routinely castigate 
people who ask questions on here.  That's rude.  Your tone is arrogant.  
And that's rude.
Yes, I'm being condescending but it's in order to point out your 
rudeness -- hopefully in an entertaining way.  You're apparently a 
hopeless case where that's concerned.

What it seems to me that this thread needs is a set of discussions that 
don't include a staple diet of questioner-castigation, as you've done 
here to me. OF course I expected it, even counted on it, to make the 
point I'm making here.  No one is being led down the wrong path.  You 
just need to lighten up and be a little less arrogant.  A little nicer.  
A human being.

And the whole thing sailed right over your arrogant head.  Read this 
exchange, and I rest my case right there.

I'm trying to make this fun, and be worthwhile as a
thread.  So caaalm down.  ok?  I'll post the debug output along with
what it reveals as soon as I've worked it all out thoroughly.  Trust me.  :)

>    That is completely the wrong approach.  You are misleading everyone
> else by suggesting that method.
>
>    Stop it.
>
>> Now *there* is a wholly useful piece of information.  Bravo!  Sooner or
>> later, we'll clear out enough of the rants to expose goodies, no?  :D
>    I figured that it was hopeless to get you to follow the existing
> documentation.  So maybe if I spoon-fed it to you in pieces you might
> think about it, and follow instructions.
By the way Alan, I didn't need that spoon fed to me.  I'm drawing out 
information for the benefit of others and frankly, just seeing if you 
have anything in your repertoire that doesn't include trying to belittle 
people who are asking for help.  Jury is still out on that one, but 
wearing a frown as they deliberate.  :)


Now for the useful stuff.
Here is the telling part of the freeradius -X output that I ran earlier 
this morning and printed out to use as a reference in my inquiries:

[accessperiod]     expand: %{sql:SELECT 
IF(COUNT(radacctid>=1),(UNIX_TIMESTAMP() - 
IFNULL(UNIX_TIMESTAMP(AcctStartTime),0)),0) FROM radacct WHERE UserName 
= 'cgitest' AND AcctSessionTime >= 1 ORDER BY AcctStartTime LIMIT 1} -> 
231238
rlm_sqlcounter: Check item is greater than query result
rlm_sqlcounter: Authorized user cgitest, check_item=2592000, counter=231238
rlm_sqlcounter: Sent Reply-Item for user cgitest, Type=*Session-Timeout, 
value=2360762*
++[accessperiod] returns ok

So, there's something fishy with the rlm_sqlcounter module.  Looks like 
the place to start.

Stay tuned, film at 11.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20130208/65658e33/attachment-0001.html>