[OpenSER-Users] OPenser+mediaproxy

Iñaki Baz Castillo ibc at in.ilimit.es
Tue Jun 17 14:31:53 CEST 2008


El Tuesday 17 June 2008 13:38:31 David Villasmil escribió:
> >> > select *, UNIX_TIMESTAMP(AcctStartTime) as timestamp from radacct
> >> > where (1=1)  and  Normalized = '0' and AcctStopTime != '0000-00-00
> >> > 00:00:00'
> >>
> >>  and
> >>
> >> > (ConnectInfo_stop is not NULL or MediaInfo is NULL or MediaInfo != '')
> >> >
> >> >
> >> > MediaInfo (after update from mediaproxy) is NOT null... the rest of
> >> > the fields are ok.
> >>
> >> Look again at the SQL query of above:
> >>
> >>  MediaInfo is NULL or MediaInfo != ''
> >>
> >> It's not needed that MediaInfo is NULL, it can be any value except NULL
> >> or empty string.
>
> That's it, it IS an empry string, so it will never rate it

But you are above SQL query is a SELECT, so? Forget it, the important queries 
are those for START, UPDATE and STOP action of FreeRadius. These SQL's are 
INSERT or UPDATE.

-- 
Iñaki Baz Castillo
ibc at in.ilimit.es




More information about the Users mailing list