Hello Michael,
Friday, April 9, 2004, 11:11:43 PM, you wrote:
>> rlm_ldap: Adding radiusTrafficLimit as Rad-Traffic-Limit, value 314572800 & op=11
>>
>> radius_xlat: '-192684935'
>>
>> Traffic-Limit := 0
>> Rad-Traffic-Limit = 314572800
>>
>> I don't understand it... Rad-Traffic-Limit have value but that value
>> don't make sense for %{expr} block. Why?
MG> I'm going to step out on a limb here and assume that you have defined
MG> Traffic-Limit and Rad-Traffic-Limit in a custom dictionary.
Yes, that's right.
MG> I'm not
MG> personally familiar with these attributes and cannot find them in the
MG> dictionaries that come with the server. I'm going to assume you've
MG> defined them as integers.
Yes.
MG> According to RFC2865, integers are 32 bit
MG> *unsigned* values, so a negative number won't come across. I haven't
MG> looked at the source to confirm this, but my guess is it's just
MG> converting the negative value to 0.
Well, that's okay, let them convert to anything, but why
_positive_ value of Rad-Traffic-Limit not appearing in
%{expr:...}? Look:
rlm_ldap: Adding radiusTrafficLimit as Rad-Traffic-Limit, value 314572800 & op=11
The positive value.
radius_xlat: Running registered xlat function of module expr for string '
%{Rad-Traffic-limit} -
%{sql:SELECT sum(AcctInputOctets)+sum(AcctOutputOctets)
FROM radacct WHERE UserName = '%u' AND Month(AcctStopTime)=Month(NOW()) AND
Year(AcctStopTime) = Year(NOW())}'
radius_xlat: Running registered xlat function of module sql for string 'SELECT
sum(AcctInputOctets)+
sum(AcctOutputOctets) FROM radacct WHERE UserName = '%u' AND Month(AcctStopTime)
=Month(NOW()) AND
Year(AcctStopTime) = Year(NOW())'
Here from the positive value of Rad-Traffic-Limit must be substracted sql query
result.
So:
rlm_sql (sql): - sql_xlat finished
rlm_sql (sql): Released sql socket id: 3
radius_xlat: ' - 192684935'
"192684935" is a sql query result. But before minus there
must be Rad-Traffic-Limit, am i right? Where is it go to?
--
Best regards,
Alexander mailto:[EMAIL PROTECTED]
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
