This is obvioulsy the problem, if I go and set MediaInfo to NULL by hand, the call get rated!

----- Original Message -----

Sent: Tuesday, June 17, 2008 2:42 PM

Subject: Re: [OpenSER-Users] OPenser+mediaproxy

Looking at mysql's log, this is what I see:

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@1.2.3.4')), trim(leading 'sip:' from trim(leading 'sips:' from 'sip:915568911@1.2.3.4')), '200', 'Sip-Session', '', '', '0', '0', '200', 'Invite', trim(leading 'sip:' from trim(leading 'sips:' from 'sip:13058883456@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@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...