<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.6000.16674" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face="Courier New" size=2>Looking at mysql's log, this is what I
see:</FONT></DIV>
<DIV> </DIV><FONT face="Courier New" size=2>
<DIV><BR>---> BY OPENSER_:</DIV>
<DIV> </DIV>
<DIV> 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('', <A
href="mailto:'@',-1">'@',-1</A>),
'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
''))
)</DIV>
<DIV> </DIV>
<DIV>-------------------------------------------------------------------------------------------------------------------------------------------------</DIV>
<DIV> </DIV>
<DIV>---> THE CALL DROPS, THE BY MEDIAPROXY:</DIV>
<DIV> </DIV>
<DIV><BR> 29 Connect <A
href="mailto:openser@localhost">openser@localhost</A> on
radius<BR>
29 Query SET NAMES
latin1<BR>
29 Query
UPDATE<BR>
radacct<BR>
SET<BR>
AcctSessionTime = AcctSessionTime + IF(ConnectInfo_stop IS NULL, 53,
0),<BR>
AcctStopTime = DATE_ADD(AcctStartTime, INTERVAL AcctSessionTime
SECOND),<BR>
AcctInputOctets = AcctInputOctets +
77488,<BR>
AcctOutputOctets = AcctOutputOctets +
152760,<BR>
SipUserAgents = 'eyeBeam release 1014c stamp 46090 +
unknown-agent',<BR>
SipCodecs =
'G729',<BR>
SipApplicationType =
'Audio',<BR>
MediaInfo =
'',
<------------------ LOOK AT THIS! ITS AN EMPTY
STRING!!<BR>
Normalized = '0'<BR>
WHERE<BR>
AcctSessionId = 'OWNhNDAwMmIyOTM5NDU3MjQ4MGJjMTk2YWIwZmE0NGE.' AND SipFromTag =
'34794a17' AND SipToTag = '17062708081947605004610377'</DIV>
<DIV> </DIV>
<DIV>-------------------------------------------------------------------------------------------------------------------------------------------------</DIV>
<DIV> </DIV>
<DIV>---> THEN BY CDRTOOL, GETTING CDRs TO RATE:</DIV>
<DIV> </DIV>
<DIV>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 != '')
<------------- CDRTOOL DOESN'T WANT AN EMPTY STRING!!<BR>
<BR>-------------------------------------------------------------------------------------------------------------------------------------------------<BR></DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV>this of course will never work, I wonder whether it is a configuration
problem or a cdrtool/mediaproxy bug...</DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV>Any thoughts?</DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV>David</DIV>
<DIV></FONT> </DIV>
<BLOCKQUOTE dir=ltr
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=david.villasmil.work@gmail.com
href="mailto:david.villasmil.work@gmail.com">David Villasmil</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=users@lists.openser.org
href="mailto:users@lists.openser.org">openser users</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Tuesday, June 17, 2008 1:38
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Re: [OpenSER-Users]
OPenser+mediaproxy</DIV>
<DIV><BR></DIV>
<DIV class=gmail_quote>
<BLOCKQUOTE class=gmail_quote
style="PADDING-LEFT: 1ex; MARGIN: 0pt 0pt 0pt 0.8ex; BORDER-LEFT: rgb(204,204,204) 1px solid">
<DIV>
<DIV class=Wj3C7c>
<DIV class=gmail_quote>
<BLOCKQUOTE class=gmail_quote
style="PADDING-LEFT: 1ex; MARGIN: 0pt 0pt 0pt 0.8ex; BORDER-LEFT: rgb(204,204,204) 1px solid">
<DIV><BR>> select *, UNIX_TIMESTAMP(AcctStartTime) as timestamp from
radacct where<BR>> (1=1) and Normalized = '0' and
AcctStopTime != '0000-00-00 00:00:00' and<BR>> (ConnectInfo_stop
is not NULL or MediaInfo is NULL or MediaInfo !=
'')<BR>><BR>><BR>> MediaInfo (after update from mediaproxy) is
NOT null... the rest of the<BR>> fields are ok.<BR><BR></DIV>Look again
at the SQL query of above:<BR>
<DIV><BR> MediaInfo is NULL or MediaInfo != ''<BR><BR></DIV>It's not
needed that MediaInfo is NULL, it can be any value except NULL or<BR>empty
string.<BR><FONT
color=#888888></FONT></BLOCKQUOTE></DIV></DIV></DIV></BLOCKQUOTE>
<DIV><BR>That's it, it IS an empry string, so it will never rate
it<BR> </DIV></DIV></BLOCKQUOTE></BODY></HTML>