Did this ever get solved? I need help with:
WARNING: Attempt to use unknown xlat function or attribute in string %{sqlcca3:
as in the original message below.
Ed
==== original message From Mon, 23 Dec 2002 03:33:47 -0800 ===== i need help table radgroupcheck: mysql> select * from radgroupcheck where GroupName='35Horas'; +----+-----------+---------------------+----+--------+ | id | GroupName | Attribute | op | Value | +----+-----------+---------------------+----+--------+ | 15 | 35horas | Max-Monthly-Session | := | 126000 | +----+-----------+---------------------+----+--------+ 1 row in set (0.00 sec)
mysql> SELECT SUM(AcctSessionTime - GREATEST((1038708000 - UNIX_TIMESTAMP(AcctStartTime)), 0)) FROM radacct WHERE UserName='santos' AND UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime > '1038708000';
+----------------------------------------------------------------------------------+
| SUM(AcctSessionTime - GREATEST((1038708000 - UNIX_TIMESTAMP(AcctStartTime)), 0)) |
+----------------------------------------------------------------------------------+
| 232305 |
+----------------------------------------------------------------------------------+
1 row in set (0.00 sec)
radius -X
rlm_sqlcounter: Entering module authorize code rlm_sqlcounter: Could not find Check item value pair modcall[authorize]: module "noresetcounter" returns noop rlm_sqlcounter: Entering module authorize code rlm_sqlcounter: Could not find Check item value pair modcall[authorize]: module "dailycounter" returns noop rlm_sqlcounter: Entering module authorize code
sqlcounter_expand: 'SELECT SUM(AcctSessionTime - GREATEST((1038708000 - UNIX_TIMESTAMP(AcctStartTime)), 0)) FROM radacct WHERE UserName='%{User-Name}' AND UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime > '1038708000''
radius_xlat: 'SELECT SUM(AcctSessionTime - GREATEST((1038708000 - UNIX_TIMESTAMP(AcctStartTime)), 0)) FROM radacct WHERE UserName='santos' AND UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime > '1038708000''
sqlcounter_expand: '%{sqlcca3:SELECT SUM(AcctSessionTime - GREATEST((1038708000 - UNIX_TIMESTAMP(AcctStartTime)), 0)) FROM radacct WHERE UserName='santos' AND UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime > '1038708000'}'
WARNING: Attempt to use unknown xlat function or attribute in string %{sqlcca3:SELECT SUM(AcctSessionTime - GREATEST((1038708000 - UNIX_TIMESTAMP(AcctStartTime)), 0)) FROM radacct WHERE UserName='santos' AND UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime > '1038708000'}
radius_xlat: ''
rlm_sqlcounter: (Check item - counter) is greater than zero
rlm_sqlcounter: Authorized user santos, check_item=126000, counter=0
rlm_sqlcounter: Sent Reply-Item for user santos, Type=Session-Timeout, value=126000
modcall[authorize]: module "monthlycounter" returns ok
modcall: group authorize returns ok
Why not work ? =====end of original message From Mon, 23 Dec 2002 03:33:47 -0800 =====
_________________________________________________________________
Add photos to your e-mail with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
