[OpenSER-Users] OPenser+mediaproxy

[David Villasmil]

>
>
>> > 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20080617/e8721f6a/attachment.htm>