[OpenSER-Users] OPenser+mediaproxy

[David Villasmil]

I'm sorry to bother you some more... but where can I find the changelog? the
only change log I found is /mediaproxy/debian/changelog and there's nothing
referring to that there.



On Tue, Jun 17, 2008 at 3:39 PM, Iñaki Baz Castillo <ibc at in.ilimit.es>
wrote:

> El Tuesday 17 June 2008 14:42:29 David Villasmil escribió:
> > Looking at mysql's log, this is what I see:
> >
> >
> > ---> BY OPENSER_:
> >
> >    24 Query       INSERT INTO radacct (RadAcctId, AcctSessionId,
> > AcctUniqueId, UserName, Realm, NASIPAddress, NASPortId, AcctStartTime,
> > AcctStopTime, AcctSessionTime,                 AcctInputOctets,
> > AcctOutputOctets, CalledStationId, CallingStationId, AcctTerminateCause,
> > ServiceType, ENUMtld,                 FramedIPAddress, AcctStartDelay,
> > AcctStopDelay, SipResponseCode, SipMethod, SipTranslatedRequestURI,
> > SipToTag, SipFromTag,                 SipRPID, SourceIP, SourcePort,
> > CanonicalURI)           VALUES                 (NULL,
> > 'OWNhNDAwMmIyOTM5NDU3MjQ4MGJjMTk2YWIwZmE0NGE.', 'd986b295f8a55559', '',
> > SUBSTRING_INDEX('', '@',-1),                 '1.2.3.4', '5060',
> '2008-06-17
> > 08:27:52', '0', '0', '0', '0',                 trim(leading 'sip:' from
> > trim(leading 'sips:' from 'sip:0013058883456 at 1.2.3.4<sip%3A0013058883456 at 1.2.3.4>
> ')),
> > trim(leading 'sip:' from trim(leading 'sips:' from
> > 'sip:915568911 at 1.2.3.4 <sip%3A915568911 at 1.2.3.4>')),
> '200', 'Sip-Session', '', '',
> > '0', '0',                 '200', 'Invite',                 trim(leading
> > 'sip:' from trim(leading 'sips:' from
> > 'sip:13058883456 at 5.6.7.8:5060=3Btransport=3Dudp')),
> > '17062708081947605004610377', '34794a17', '',                 '9.8.7.6',
> > '27374',                 trim(leading 'sip:' from trim(leading 'sips:'
> from
> > ''))                 )
> >
> >
> ---------------------------------------------------------------------------
> >----------------------------------------------------------------------
> >
> > ---> THE CALL DROPS, THE BY MEDIAPROXY:
> >
> >
> >    29 Connect     openser at localhost on radius
> >                      29 Query       SET NAMES latin1
> >                      29 Query       UPDATE
> >             radacct
> >         SET
> >             AcctSessionTime = AcctSessionTime + IF(ConnectInfo_stop IS
> > NULL, 53, 0), AcctStopTime = DATE_ADD(AcctStartTime, INTERVAL
> > AcctSessionTime SECOND), AcctInputOctets = AcctInputOctets + 77488,
> >             AcctOutputOctets = AcctOutputOctets + 152760,
> >             SipUserAgents = 'eyeBeam release 1014c stamp 46090 +
> > unknown-agent', SipCodecs = 'G729',
> >             SipApplicationType = 'Audio',
> >             MediaInfo = '',                 <------------------  LOOK AT
> > THIS! ITS AN EMPTY STRING!! Normalized = '0'
> >         WHERE
> >             AcctSessionId =
> 'OWNhNDAwMmIyOTM5NDU3MjQ4MGJjMTk2YWIwZmE0NGE.'
> > AND SipFromTag = '34794a17' AND SipToTag = '17062708081947605004610377'
> >
> >
> ---------------------------------------------------------------------------
> >----------------------------------------------------------------------
> >
> > ---> THEN BY CDRTOOL, GETTING CDRs TO RATE:
> >
> > 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 !=
> '')
> >     <------------- CDRTOOL DOESN'T WANT AN EMPTY STRING!!
> >
> >
> ---------------------------------------------------------------------------
> >----------------------------------------------------------------------
> >
> >
> >
> >
> >
> > this of course will never work, I wonder whether it is a configuration
> > problem or a cdrtool/mediaproxy bug...
> >
> >
> >
> >
> > Any thoughts?
> >
> >
> > David
> >
> >   ----- Original Message -----
> >   From: David Villasmil
> >   To: openser users
> >   Sent: Tuesday, June 17, 2008 1:38 PM
> >   Subject: Re: [OpenSER-Users] OPenser+mediaproxy
> >
> >       > 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
>
> The UPDATE query MUST be:
>
> WHERE \
>                AcctSessionId = '%{Acct-Session-Id}' \
>                AND SipToTag = '%{Sip-To-Tag}' AND SipFromTag
> = '%{Sip-From-Tag}' \
>                AND (MediaInfo IS NULL OR MediaInfo != 'timeout')"
>
> Look at the MediaProxy changelog, there are two updates in this issue.
>
> --
> Iñaki Baz Castillo
> ibc at in.ilimit.es
>
> _______________________________________________
> Users mailing list
> Users at lists.openser.org
> http://lists.openser.org/cgi-bin/mailman/listinfo/users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.kamailio.org/pipermail/users/attachments/20080617/f9a11c66/attachment.htm