[OpenSER-Users] OPenser+mediaproxy

[Iñaki Baz Castillo]

El Martes, 17 de Junio de 2008, 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.


-- 
Iñaki Baz Castillo