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
----- 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