<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
Again Alan, read between the lines. I've been scanning these emails
from this group for about year through google searches.<br>
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.<br>
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.<br>
<br>
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.<br>
<br>
And the whole thing sailed right over your arrogant head. Read this
exchange, and I rest my case right there.<br>
<pre wrap="">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. :)
</pre>
<blockquote cite="mid:5115A312.3030903@deployingradius.com"
type="cite">
<pre wrap="">
That is completely the wrong approach. You are misleading everyone
else by suggesting that method.
Stop it.
</pre>
<blockquote type="cite">
<pre wrap="">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
</pre>
</blockquote>
<pre wrap="">
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.</pre>
</blockquote>
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. :) <br>
<br>
<br>
Now for the useful stuff. <br>
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:<br>
<br>
[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<br>
rlm_sqlcounter: Check item is greater than query result<br>
rlm_sqlcounter: Authorized user cgitest, check_item=2592000,
counter=231238<br>
rlm_sqlcounter: Sent Reply-Item for user cgitest, Type=<big><b>Session-Timeout,
value=2360762</b></big><br>
++[accessperiod] returns ok<br>
<br>
So, there's something fishy with the rlm_sqlcounter module. Looks
like the place to start.<br>
<br>
Stay tuned, film at 11.<br>
</body>
</html>