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.