Iñaki,<br><br>That did the trick, thought i'd love to read the changelog, I can't find it anywhere.<br><br><br>thanks a lot !<br><br><div class="gmail_quote">On Tue, Jun 17, 2008 at 6:08 PM, David Villasmil <<a href="mailto:david.villasmil.work@gmail.com">david.villasmil.work@gmail.com</a>> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">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.<div>
<div></div><div class="Wj3C7c"><br><br><br><br><div class="gmail_quote">
On Tue, Jun 17, 2008 at 3:39 PM, Iñaki Baz Castillo <<a href="mailto:ibc@in.ilimit.es" target="_blank">ibc@in.ilimit.es</a>> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
El Tuesday 17 June 2008 14:42:29 David Villasmil escribió:<br>
<div><div></div><div>> Looking at mysql's log, this is what I see:<br>
><br>
><br>
> ---> BY OPENSER_:<br>
><br>
> 24 Query INSERT INTO radacct (RadAcctId, AcctSessionId,<br>
> AcctUniqueId, UserName, Realm, NASIPAddress, NASPortId, AcctStartTime,<br>
> AcctStopTime, AcctSessionTime, AcctInputOctets,<br>
> AcctOutputOctets, CalledStationId, CallingStationId, AcctTerminateCause,<br>
> ServiceType, ENUMtld, FramedIPAddress, AcctStartDelay,<br>
> AcctStopDelay, SipResponseCode, SipMethod, SipTranslatedRequestURI,<br>
> SipToTag, SipFromTag, SipRPID, SourceIP, SourcePort,<br>
> CanonicalURI) VALUES (NULL,<br>
> 'OWNhNDAwMmIyOTM5NDU3MjQ4MGJjMTk2YWIwZmE0NGE.', 'd986b295f8a55559', '',<br>
> SUBSTRING_INDEX('', '@',-1), '<a href="http://1.2.3.4" target="_blank">1.2.3.4</a>', '5060', '2008-06-17<br>
> 08:27:52', '0', '0', '0', '0', trim(leading 'sip:' from<br>
> trim(leading 'sips:' from '<a href="mailto:sip%3A0013058883456@1.2.3.4" target="_blank">sip:0013058883456@1.2.3.4</a>')),<br>
> trim(leading 'sip:' from trim(leading 'sips:' from<br>
> '<a href="mailto:sip%3A915568911@1.2.3.4" target="_blank">sip:915568911@1.2.3.4</a>')), '200', 'Sip-Session', '', '',<br>
> '0', '0', '200', 'Invite', trim(leading<br>
> 'sip:' from trim(leading 'sips:' from<br>
> 'sip:13058883456@5.6.7.8:5060=3Btransport=3Dudp')),<br>
> '17062708081947605004610377', '34794a17', '', '<a href="http://9.8.7.6" target="_blank">9.8.7.6</a>',<br>
> '27374', trim(leading 'sip:' from trim(leading 'sips:' from<br>
> '')) )<br>
><br>
> ---------------------------------------------------------------------------<br>
>----------------------------------------------------------------------<br>
><br>
> ---> THE CALL DROPS, THE BY MEDIAPROXY:<br>
><br>
><br>
> 29 Connect openser@localhost on radius<br>
> 29 Query SET NAMES latin1<br>
> 29 Query UPDATE<br>
> radacct<br>
> SET<br>
> AcctSessionTime = AcctSessionTime + IF(ConnectInfo_stop IS<br>
> NULL, 53, 0), AcctStopTime = DATE_ADD(AcctStartTime, INTERVAL<br>
> AcctSessionTime SECOND), AcctInputOctets = AcctInputOctets + 77488,<br>
> AcctOutputOctets = AcctOutputOctets + 152760,<br>
> SipUserAgents = 'eyeBeam release 1014c stamp 46090 +<br>
> unknown-agent', SipCodecs = 'G729',<br>
> SipApplicationType = 'Audio',<br>
> MediaInfo = '', <------------------ LOOK AT<br>
> THIS! ITS AN EMPTY STRING!! Normalized = '0'<br>
> WHERE<br>
> AcctSessionId = 'OWNhNDAwMmIyOTM5NDU3MjQ4MGJjMTk2YWIwZmE0NGE.'<br>
> AND SipFromTag = '34794a17' AND SipToTag = '17062708081947605004610377'<br>
><br>
> ---------------------------------------------------------------------------<br>
>----------------------------------------------------------------------<br>
><br>
> ---> THEN BY CDRTOOL, GETTING CDRs TO RATE:<br>
><br>
> select *, UNIX_TIMESTAMP(AcctStartTime) as timestamp<br>
> from radacct<br>
> where<br>
> (1=1) and<br>
> Normalized = '0' and<br>
> AcctStopTime != '0000-00-00 00:00:00' and<br>
> (ConnectInfo_stop is not NULL or MediaInfo is NULL or MediaInfo != '')<br>
> <------------- CDRTOOL DOESN'T WANT AN EMPTY STRING!!<br>
><br>
> ---------------------------------------------------------------------------<br>
>----------------------------------------------------------------------<br>
><br>
><br>
><br>
><br>
><br>
> this of course will never work, I wonder whether it is a configuration<br>
> problem or a cdrtool/mediaproxy bug...<br>
><br>
><br>
><br>
><br>
> Any thoughts?<br>
><br>
><br>
> David<br>
><br>
> ----- Original Message -----<br>
> From: David Villasmil<br>
> To: openser users<br>
> Sent: Tuesday, June 17, 2008 1:38 PM<br>
> Subject: Re: [OpenSER-Users] OPenser+mediaproxy<br>
><br>
> > select *, UNIX_TIMESTAMP(AcctStartTime) as timestamp from radacct<br>
> > where (1=1) and Normalized = '0' and AcctStopTime != '0000-00-00<br>
> > 00:00:00' and (ConnectInfo_stop is not NULL or MediaInfo is NULL<br>
> > or MediaInfo != '')<br>
> ><br>
> ><br>
> > MediaInfo (after update from mediaproxy) is NOT null... the rest of<br>
> > the fields are ok.<br>
><br>
> Look again at the SQL query of above:<br>
><br>
><br>
> MediaInfo is NULL or MediaInfo != ''<br>
><br>
><br>
> It's not needed that MediaInfo is NULL, it can be any value except<br>
> NULL or empty string.<br>
><br>
><br>
> That's it, it IS an empry string, so it will never rate it<br>
<br>
</div></div>The UPDATE query MUST be:<br>
<br>
WHERE \<br>
AcctSessionId = '%{Acct-Session-Id}' \<br>
AND SipToTag = '%{Sip-To-Tag}' AND SipFromTag<br>
= '%{Sip-From-Tag}' \<br>
AND (MediaInfo IS NULL OR MediaInfo != 'timeout')"<br>
<br>
Look at the MediaProxy changelog, there are two updates in this issue.<br>
<div><div></div><div><br>
--<br>
Iñaki Baz Castillo<br>
<a href="mailto:ibc@in.ilimit.es" target="_blank">ibc@in.ilimit.es</a><br>
<br>
_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@lists.openser.org" target="_blank">Users@lists.openser.org</a><br>
<a href="http://lists.openser.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.openser.org/cgi-bin/mailman/listinfo/users</a><br>
</div></div></blockquote></div><br>
</div></div></blockquote></div><br>