On Mon, 9 Sep 2002, Mehdi Roomi wrote:
> >>sqlcounter m5 {
> >> counter-name = m5
> >> check-name = Max-M5-Session
> >> sqlmod-inst = sql
> >> key = User-Name
> >> query = "SELECT SUM(IF(HOUR(AcctStartTime)>='02:00:00' AND
> >>HOUR(AcctStopTime)<='06:00:00',5
> >>* AcctSessionTime,0) +IF(HOUR(AcctStartTime)>='07:00:00' AND
> >>HOUR(AcctStopTime)<='13:00:00',2
> >>* AcctSessionTime,0) +IF(HOUR(AcctStartTime)>='14:00:00' AND
> >>HOUR(AcctStopTime)<='23:00:00',3*AcctSessionTime,0))
> >>FROM radacct WHERE UserName='%{%k}'"
>
>
> >Do a cvs update. It should work now.
>
> I did an update to freeradius-snapshot-20020909.tar.gz. but I get
> 'Segmention fault' instead of the previous error.
>
> radiusd -X started with no problem but then the users of this group try to
> login, radiusd KILLs and I get the following:
>
> ....
> rlm_sql: Released sql socket id: 4
> modcall[authorize]: module "sql" returns ok
> rlm_sqlcounter: Entering module authorize code
>
> sqlcounter_expand: 'SELECT SUM(IF(HOUR(AcctStopTime)>='02:00:00' AND
> HOUR(AcctStopTime)<='06:00:00',5*AcctSessionTime,0)
>
>+IF(HOUR(AcctStartTime)>='07:00:00',2*AcctSessionTime,0)+IF(HOUR(AcctStartTime)>='14:00:00',AcctSessionTime,0)+IF(HOUR(AcctStartTime)>='23:00:00',
> AcctSessionTime,0) ) FROM radacct WHERE UserName='%{User-Name}''
>
> radius_xlat: 'SELECT SUM(IF(HOUR(AcctStopTime)>='02:00:00' AND
> HOUR(AcctStopTime)<='06:00:00',5*AcctSessionTime,0)
>
>+IF(HOUR(AcctStartTime)>='07:00:00',2*AcctSessionTime,0)+IF(HOUR(AcctStartTime)>='14:00:00',AcctSessionTime,0)+IF(HOUR(AcctStartTime)>='23:00:00',
> AcctSessionTime,0) ) FROM radacct WHERE UserName='saber''
>
> sqlcounter_expand: '%{sql:SELECT SUM(IF(HOUR(AcctStopTime)>='02:00:00' AND
> HOUR(AcctStopTime)<='06:00:00',5*AcctSessionTime,0)
>
>+IF(HOUR(AcctStartTime)>='07:00:00',2*AcctSessionTime,0)+IF(HOUR(AcctStartTime)>='14:00:00',AcctSessionTime,0)+IF(HOUR(AcctStartTime)>='23:00:00',
> AcctSessionTime,0) ) FROM radacct WHERE UserName='saber'}'
> Segmentation fault
>
> when I try with a smaller query no error appears.
>
> p.s. lastest freeradius + redhat linux7.3
>
>
> Regards,
> M. Roomi
Try to find a core dump and do a backtrace on it.
gdb <path_to_radiusd>/radiusd core
bt
--
Kostas Kalevras Network Operations Center
[EMAIL PROTECTED] National Technical University of Athens, Greece
Work Phone: +30 10 7721861
'Go back to the shadow' Gandalf
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
