17 Jun
2008
17 Jun
'08
8:48 a.m.
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@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...
Any thoughts?
David