"Gunther" <[EMAIL PROTECTED]> wrote:
> Tue Oct 4 00:53:46 2005 : Debug: rlm_sql_mysql: query: SELECT
> phs_radgroupreply.radgroupreply_id,phs_radgroupreply.radgroupreply_groupname
> ,phs_radgroupreply.radgroupreply_attribute,phs_radgroupreply.radgroupreply_v
> alue,phs_radgroupreply.radgroupreply_op FROM
> phs_radgroupreply,phs_usergroup WHERE phs_usergroup.usergroup_username =
> 'gunther' AND phs_usergroup.usergroup_groupname =
> phs_radgroupreply.radgroupreply_groupname ORDER BY
> phs_radgroupreply.radgroupreply_id
> Tue Oct 4 00:53:46 2005 : Debug: radius_xlat: '='
That last line doesn't look right.
> Tue Oct 4 01:00:33 2005 : Debug: radius_xlat: Running registered xlat
> function of module expr for string ' %{sql:SELECT IF(NOW() <= user_stoptime,
> TIME_TO_SEC(TIMEDIFF(user_stoptime, IF(NOW() >= user_starttime, now(),
> DATE_SUB(user_stoptime, INTERVAL 1 SECOND)))), 1) FROM phs_user WHERE
> user_username='%{User-Name}'}'
The *only* text in that string is the SQL query. There isn't any
additional math in it. If the string *passed* to 'expr' contains the
math and this string doesn't, that looks like a bug.
> Tue Oct 4 01:00:33 2005 : Debug: rlm_sql (sql): Released sql socket id: 1
> Tue Oct 4 01:00:33 2005 : Debug: radius_xlat: ' 601167'
> Tue Oct 4 01:00:33 2005 : Debug: radius_xlat: '601167'
The SQL query is running OK, but no math is being done because no
math was in the input string.
It looks like the radius_xlat code needs more debugging output.
I'm not sure what to suggest at this time, other than source code
mods to try to track down what's going on.
Alan DeKok.
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
