[OpenSER-Users] OPenser+mediaproxy

[David Villasmil]

This is obvioulsy the problem, if I go and set MediaInfo to NULL by hand, the call get rated!
  ----- Original Message ----- 
  From: David Villasmil 
  To: openser users 
  Sent: Tuesday, June 17, 2008 2:42 PM
  Subject: Re: [OpenSER-Users] OPenser+mediaproxy


  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')),                 trim(leading 'sip:' from trim(leading 'sips:' from 'sip:915568911 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20080617/fa0ce82f/attachment.htm>