<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body>
<span style="font-family: Aptos, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0); text-transform: none;">Hi,</span>
<div style="direction: ltr; text-align: left; text-indent: 0px; text-transform: none; font-family: Aptos, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="direction: ltr; text-align: left; text-indent: 0px; text-transform: none; font-family: Aptos, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
I've nearly completed the process of upgrading our ancient v1.7 deployment to v3.7. The new deployment is installed on Ubuntu 24.04 from the OpenSIPS repos. These servers are our inbound hand-off from our upstream supplier, they take a call, inspect the called
number element against the database, and then pass it on to the target system with the internal reference or decline the call.</div>
<div style="direction: ltr; text-align: left; text-indent: 0px; text-transform: none; font-family: Aptos, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="direction: ltr; text-align: left; text-indent: 0px; text-transform: none; font-family: Aptos, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
I've never been a programmer and am much more familiar with Asterisk, having inherited the platform & 'maintained' these hosts for about ten years I'm far from fluent in the configuration syntax but also much less terrified than I was when I first opened the
opensips.cfg file. Having said that, I've updated most of the configuration and database backend to successfully accept, process & pass on a call to our core voice platform with 2-way audio.</div>
<div style="direction: ltr; text-align: left; text-indent: 0px; text-transform: none; font-family: Aptos, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="direction: ltr; text-align: left; text-indent: 0px; text-transform: none; font-family: Aptos, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Unfortunately, when a call is terminated by either the called or calling party the BYE signal is not passed to the other party leaving the call hanging until they also hang up or an intermediate system decides the call is in a stale state & drops it.</div>
<div style="direction: ltr; text-align: left; text-indent: 0px; text-transform: none; font-family: Aptos, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="direction: ltr; text-align: left; text-indent: 0px; text-transform: none; font-family: Aptos, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
From what I can tell, this is the v1.7 code which would capture the session related traffic and associate a BYE with a particular call.</div>
<div style="direction: ltr; text-align: left; text-indent: 0px; text-transform: none; font-family: Aptos, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="direction: ltr; text-align: left; text-indent: 0px; text-transform: none; font-family: Aptos, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
I think the problem is related to my attempt to convert the depreciated allow_source_address_group() function:</div>
<div style="direction: ltr; text-align: left; text-indent: 0px; text-transform: none; font-family: Aptos, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="direction: ltr; text-align: left; text-indent: 0px; text-transform: none; font-family: Aptos, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
--- v1.7 code ---</div>
<div style="direction: ltr; text-align: left; text-indent: 0px; text-transform: none; font-family: "Courier New", Arial, Helvetica, sans-serif; font-size: 10pt; color: rgb(0, 0, 0);">
if(is_method("INVITE")) {</div>
<div style="text-align: left; text-indent: 0px; text-transform: none; font-family: "Courier New", Arial, Helvetica, sans-serif; font-size: 10pt; color: rgb(0, 0, 0);">
setflag("1");</div>
<div style="text-align: left; text-indent: 0px; text-transform: none; font-family: "Courier New", Arial, Helvetica, sans-serif; font-size: 10pt; color: rgb(0, 0, 0);">
setflag("2");</div>
<div style="direction: ltr; text-align: left; text-indent: 0px; text-transform: none; font-family: "Courier New", Arial, Helvetica, sans-serif; font-size: 10pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="text-align: left; text-indent: 0px; text-transform: none; font-family: "Courier New", Arial, Helvetica, sans-serif; font-size: 10pt; color: rgb(0, 0, 0);">
>> $var(group) = allow_source_address_group();</div>
<div style="direction: ltr; text-align: left; text-indent: 0px; text-transform: none; font-family: "Courier New", Arial, Helvetica, sans-serif; font-size: 10pt; color: rgb(0, 0, 0);">
xlog("L_ERR", "LOG: The value of var(group) = [$var(group)]");</div>
<div style="direction: ltr; text-align: left; text-indent: 0px; text-transform: none; font-family: "Courier New", Arial, Helvetica, sans-serif; font-size: 10pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="direction: ltr; text-align: left; text-indent: 0px; text-transform: none; font-family: "Courier New", Arial, Helvetica, sans-serif; font-size: 10pt; color: rgb(0, 0, 0);">
if ($var(group) != -1) {</div>
<div style="direction: ltr; text-align: left; text-indent: 0px; text-transform: none; font-family: "Courier New", Arial, Helvetica, sans-serif; font-size: 10pt; color: rgb(0, 0, 0);">
</div>
<div style="direction: ltr; text-align: left; text-indent: 0px; text-transform: none; font-family: "Courier New", Arial, Helvetica, sans-serif; font-size: 10pt; color: rgb(0, 0, 0);">
if(!alias_db_lookup("dbaliases")) {</div>
<div style="direction: ltr; text-align: left; text-indent: 0px; text-transform: none; font-family: "Courier New", Arial, Helvetica, sans-serif; font-size: 10pt; color: rgb(0, 0, 0);">
xlog("L_ERR", "LOG: Alias not found time=[$Ts] from uri=[$fu] to uri=[$ru]");</div>
<div style="direction: ltr; text-align: left; text-indent: 0px; text-transform: none; font-family: "Courier New", Arial, Helvetica, sans-serif; font-size: 10pt; color: rgb(0, 0, 0);">
sl_send_reply("404", "Not Found");</div>
<div style="text-align: left; text-indent: 0px; text-transform: none; font-family: "Courier New", Arial, Helvetica, sans-serif; font-size: 10pt; color: rgb(0, 0, 0);">
};</div>
<div style="direction: ltr; text-align: left; text-indent: 0px; text-transform: none; font-family: "Courier New", Arial, Helvetica, sans-serif; font-size: 10pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="direction: ltr; text-align: left; text-indent: 0px; text-transform: none; font-family: "Courier New", Arial, Helvetica, sans-serif; font-size: 10pt; color: rgb(0, 0, 0);">
$avp(s:site)=$(ruri.user{s.substr,0,5});</div>
<div style="text-align: left; text-indent: 0px; text-transform: none; font-family: "Courier New", Arial, Helvetica, sans-serif; font-size: 10pt; color: rgb(0, 0, 0);">
route(3);</div>
<div style="text-align: left; text-indent: 0px; text-transform: none; font-family: "Courier New", Arial, Helvetica, sans-serif; font-size: 10pt; color: rgb(0, 0, 0);">
exit;</div>
<div style="text-align: left; text-indent: 0px; text-transform: none; font-family: "Courier New", Arial, Helvetica, sans-serif; font-size: 10pt; color: rgb(0, 0, 0);">
}</div>
<div style="direction: ltr; text-align: left; text-indent: 0px; text-transform: none; font-family: "Courier New", Arial, Helvetica, sans-serif; font-size: 10pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="text-align: left; text-indent: 0px; text-transform: none; font-family: "Courier New", Arial, Helvetica, sans-serif; font-size: 10pt; color: rgb(0, 0, 0);">
else if ($var(group) == -1) {</div>
<div style="text-align: left; text-indent: 0px; text-transform: none; font-family: "Courier New", Arial, Helvetica, sans-serif; font-size: 10pt; color: rgb(0, 0, 0);">
log(1, "Permissions RECORD FAIL\n");</div>
<div style="text-align: left; text-indent: 0px; text-transform: none; font-family: "Courier New", Arial, Helvetica, sans-serif; font-size: 10pt; color: rgb(0, 0, 0);">
sl_send_reply("403", "Forbidden");</div>
<div style="text-align: left; text-indent: 0px; text-transform: none; font-family: "Courier New", Arial, Helvetica, sans-serif; font-size: 10pt; color: rgb(0, 0, 0);">
exit;</div>
<div style="text-align: left; text-indent: 0px; text-transform: none; font-family: "Courier New", Arial, Helvetica, sans-serif; font-size: 10pt; color: rgb(0, 0, 0);">
};</div>
<div style="text-align: left; text-indent: 0px; text-transform: none; font-family: "Courier New", Arial, Helvetica, sans-serif; font-size: 10pt; color: rgb(0, 0, 0);">
};</div>
<div style="direction: ltr; text-align: left; text-indent: 0px; text-transform: none; font-family: Aptos, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="direction: ltr; text-align: left; text-indent: 0px; text-transform: none; font-family: Aptos, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="direction: ltr; text-align: left; text-indent: 0px; text-transform: none; font-family: Aptos, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="direction: ltr; text-align: left; text-indent: 0px; text-transform: none; font-family: Aptos, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
--- v3.7 code ---</div>
<div style="direction: ltr; text-align: left; text-indent: 0px; text-transform: none; font-family: Aptos, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="direction: ltr; text-align: left; text-indent: 0px; text-transform: none; font-family: "Courier New", Arial, Helvetica, sans-serif; font-size: 10pt; color: rgb(0, 0, 0);">
if (is_method("INVITE")) { </div>
<div style="text-align: left; text-indent: 0px; text-transform: none; font-family: "Courier New", Arial, Helvetica, sans-serif; font-size: 10pt; color: rgb(0, 0, 0);">
$acc_extra(si) = $si;</div>
<div style="text-align: left; text-indent: 0px; text-transform: none; font-family: "Courier New", Arial, Helvetica, sans-serif; font-size: 10pt; color: rgb(0, 0, 0);">
$acc_extra(fU) = $fU;</div>
<div style="text-align: left; text-indent: 0px; text-transform: none; font-family: "Courier New", Arial, Helvetica, sans-serif; font-size: 10pt; color: rgb(0, 0, 0);">
$acc_extra(fd) = $fd;</div>
<div style="text-align: left; text-indent: 0px; text-transform: none; font-family: "Courier New", Arial, Helvetica, sans-serif; font-size: 10pt; color: rgb(0, 0, 0);">
$acc_extra(rU) = $rU;</div>
<div style="text-align: left; text-indent: 0px; text-transform: none; font-family: "Courier New", Arial, Helvetica, sans-serif; font-size: 10pt; color: rgb(0, 0, 0);">
$acc_extra(rd) = $rd;</div>
<div style="direction: ltr; text-align: left; text-indent: 0px; text-transform: none; font-family: "Courier New", Arial, Helvetica, sans-serif; font-size: 10pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="text-align: left; text-indent: 0px; text-transform: none; font-family: "Courier New", Arial, Helvetica, sans-serif; font-size: 10pt; color: rgb(0, 0, 0);">
do_accounting("log|db","cdr|missed");</div>
<div style="direction: ltr; text-align: left; text-indent: 0px; text-transform: none; font-family: "Courier New", Arial, Helvetica, sans-serif; font-size: 10pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="direction: ltr; text-align: left; text-indent: 0px; text-transform: none; font-family: "Courier New", Arial, Helvetica, sans-serif; font-size: 10pt; color: rgb(0, 0, 0);">
xlog("L_ERR", "LOG: The value of si = [$si]");</div>
<div style="direction: ltr; text-align: left; text-indent: 0px; text-transform: none; font-family: "Courier New", Arial, Helvetica, sans-serif; font-size: 10pt; color: rgb(0, 0, 0);">
>> $var(srcgrp) = get_source_group($si);</div>
<div style="direction: ltr; text-align: left; text-indent: 0px; text-transform: none; font-family: "Courier New", Arial, Helvetica, sans-serif; font-size: 10pt; color: rgb(0, 0, 0);">
xlog("L_ERR", "LOG: The value of var(srcgrp) = [$var(srcgrp)]");</div>
<div style="text-align: left; text-indent: 0px; text-transform: none; font-family: "Courier New", Arial, Helvetica, sans-serif; font-size: 10pt; color: rgb(0, 0, 0);">
>> $var(group) = check_source_address($var(srcgrp));</div>
<div style="direction: ltr; text-align: left; text-indent: 0px; text-transform: none; font-family: "Courier New", Arial, Helvetica, sans-serif; font-size: 10pt; color: rgb(0, 0, 0);">
xlog("L_ERR", "LOG: The value of var(group) = [$var(group)]");</div>
<div style="direction: ltr; text-align: left; text-indent: 0px; text-transform: none; font-family: "Courier New", Arial, Helvetica, sans-serif; font-size: 10pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="direction: ltr; text-align: left; text-indent: 0px; text-transform: none; font-family: "Courier New", Arial, Helvetica, sans-serif; font-size: 10pt; color: rgb(0, 0, 0);">
if ($var(group) != -1) {</div>
<div style="direction: ltr; text-align: left; text-indent: 0px; text-transform: none; font-family: "Courier New", Arial, Helvetica, sans-serif; font-size: 10pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="text-align: left; text-indent: 0px; text-transform: none; font-family: "Courier New", Arial, Helvetica, sans-serif; font-size: 10pt; color: rgb(0, 0, 0);">
if (!alias_db_lookup("dbaliases")) {</div>
<div style="direction: ltr; text-align: left; text-indent: 0px; text-transform: none; font-family: "Courier New", Arial, Helvetica, sans-serif; font-size: 10pt; color: rgb(0, 0, 0);">
xlog("L_ERR", "LOG: DDI Alias not found, time=[$Ts] from uri=[$fu] to uri=[$ru]");</div>
<div style="direction: ltr; text-align: left; text-indent: 0px; text-transform: none; font-family: "Courier New", Arial, Helvetica, sans-serif; font-size: 10pt; color: rgb(0, 0, 0);">
sl_send_reply(404, "Not Found");</div>
<div style="text-align: left; text-indent: 0px; text-transform: none; font-family: "Courier New", Arial, Helvetica, sans-serif; font-size: 10pt; color: rgb(0, 0, 0);">
};</div>
<div style="direction: ltr; text-align: left; text-indent: 0px; text-transform: none; font-family: "Courier New", Arial, Helvetica, sans-serif; font-size: 10pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="text-align: left; text-indent: 0px; text-transform: none; font-family: "Courier New", Arial, Helvetica, sans-serif; font-size: 10pt; color: rgb(0, 0, 0);">
$avp(site)=$(ruri.user{s.substr,0,5});</div>
<div style="text-align: left; text-indent: 0px; text-transform: none; font-family: "Courier New", Arial, Helvetica, sans-serif; font-size: 10pt; color: rgb(0, 0, 0);">
route(ALLOW);</div>
<div style="text-align: left; text-indent: 0px; text-transform: none; font-family: "Courier New", Arial, Helvetica, sans-serif; font-size: 10pt; color: rgb(0, 0, 0);">
exit; </div>
<div style="text-align: left; text-indent: 0px; text-transform: none; font-family: "Courier New", Arial, Helvetica, sans-serif; font-size: 10pt; color: rgb(0, 0, 0);">
}</div>
<div style="direction: ltr; text-align: left; text-indent: 0px; text-transform: none; font-family: "Courier New", Arial, Helvetica, sans-serif; font-size: 10pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="direction: ltr; text-align: left; text-indent: 0px; text-transform: none; font-family: "Courier New", Arial, Helvetica, sans-serif; font-size: 10pt; color: rgb(0, 0, 0);">
else if ($var(group) == -1) {</div>
<div style="text-align: left; text-indent: 0px; text-transform: none; font-family: "Courier New", Arial, Helvetica, sans-serif; font-size: 10pt; color: rgb(0, 0, 0);">
log(1, "Permissions RECORD FAIL\n");</div>
<div style="text-align: left; text-indent: 0px; text-transform: none; font-family: "Courier New", Arial, Helvetica, sans-serif; font-size: 10pt; color: rgb(0, 0, 0);">
sl_send_reply(403, "Forbidden");</div>
<div style="text-align: left; text-indent: 0px; text-transform: none; font-family: "Courier New", Arial, Helvetica, sans-serif; font-size: 10pt; color: rgb(0, 0, 0);">
exit;</div>
<div style="text-align: left; text-indent: 0px; text-transform: none; font-family: "Courier New", Arial, Helvetica, sans-serif; font-size: 10pt; color: rgb(0, 0, 0);">
};</div>
<div style="text-align: left; text-indent: 0px; text-transform: none; font-family: "Courier New", Arial, Helvetica, sans-serif; font-size: 10pt; color: rgb(0, 0, 0);">
};</div>
<div style="direction: ltr; text-align: left; text-indent: 0px; text-transform: none; font-family: Aptos, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="direction: ltr; text-align: left; text-indent: 0px; text-transform: none; font-family: Aptos, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
The logging on the hosts indicates that my substitution isn't working.</div>
<div style="direction: ltr; text-align: left; text-indent: 0px; text-transform: none; font-family: Aptos, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="direction: ltr; text-align: left; text-indent: 0px; text-transform: none; font-family: Aptos, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
--- v1.7 log ---</div>
<div style="direction: ltr; text-align: left; text-indent: 0px; text-transform: none; font-family: Aptos, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="direction: ltr; text-align: left; text-indent: 0px; text-transform: none; font-family: Aptos, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Jan 26 17:28:28 routing-1 /../opensips[1956]: --== SIP message body - INVITE ==-- v=0#015#012o=Sonus_UAC 828539 387688 IN IP4 <UPSTREAM_PEER>#015#012s=SIP Media Capabilities#015#012c=IN IP4 141.170.50.21#015#012t=0 0#015#012m=audio 25014 RTP/AVP 8 98#015#012a=rtpmap:8
PCMA/8000#015#012a=rtpmap:98 telephone-event/8000#015#012a=fmtp:98 0-15#015#012a=sendrecv#015#012a=maxptime:20#015</div>
<div style="direction: ltr; text-align: left; text-indent: 0px; text-transform: none; font-family: Aptos, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Jan 26 17:28:28 routing-1 /../opensips[1956]: DBG:permissions:allow_source_address_group: looking for <8460ef6d, 5060> in address table</div>
<div style="text-align: left; text-indent: 0px; text-transform: none; font-family: Aptos, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Jan 26 17:28:28 routing-1 /../opensips[1956]: DBG:permissions:allow_source_address_group: Found <-1></div>
<div style="text-align: left; text-indent: 0px; text-transform: none; font-family: Aptos, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Jan 26 17:28:28 routing-1 /../opensips[1956]: DBG:permissions:allow_source_address_group: looking for <8460ef6d, 5060> in subnet table</div>
<div style="text-align: left; text-indent: 0px; text-transform: none; font-family: Aptos, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Jan 26 17:28:28 routing-1 /../opensips[1956]: DBG:permissions:allow_source_address_group: Found <1></div>
<div style="direction: ltr; text-align: left; text-indent: 0px; text-transform: none; font-family: Aptos, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="text-align: left; text-indent: 0px; text-transform: none; font-family: Aptos, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Jan 26 17:28:28 routing-1 /../opensips[1956]: LOG: The value of var(group) = [1]</div>
<div style="text-align: left; text-indent: 0px; text-transform: none; font-family: Aptos, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Jan 26 17:28:28 routing-1 /../opensips[1956]: DBG:core:comp_scriptvar: int 29 : 1 / -1</div>
<div style="direction: ltr; text-align: left; text-indent: 0px; text-transform: none; font-family: Aptos, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="direction: ltr; text-align: left; text-indent: 0px; text-transform: none; font-family: Aptos, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Jan 26 17:28:28 routing-1 /../opensips[1956]: DBG:db_mysql:has_stmt_ctx: ctx found for dbaliases</div>
<div style="text-align: left; text-indent: 0px; text-transform: none; font-family: Aptos, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Jan 26 17:28:28 routing-1 /../opensips[1956]: DBG:db_mysql:db_mysql_do_prepared_query: conn=0x787e70 (tail=7895720) MC=0x786208</div>
<div style="text-align: left; text-indent: 0px; text-transform: none; font-family: Aptos, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Jan 26 17:28:28 routing-1 /../opensips[1956]: DBG:db_mysql:db_mysql_do_prepared_query: set values for the statement run</div>
<div style="text-align: left; text-indent: 0px; text-transform: none; font-family: Aptos, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Jan 26 17:28:28 routing-1 /../opensips[1956]: DBG:db_mysql:db_mysql_val2bind: added val (0): len=12; type=254; is_null=0</div>
<div style="text-align: left; text-indent: 0px; text-transform: none; font-family: Aptos, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Jan 26 17:28:28 routing-1 /../opensips[1956]: DBG:db_mysql:db_mysql_do_prepared_query: doing BIND_PARAM in...</div>
<div style="direction: ltr; text-align: left; text-indent: 0px; text-transform: none; font-family: Aptos, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Jan 26 17:28:28 routing-1 /../opensips[1956]: DBG:db_mysql:db_mysql_do_prepared_query: prepared statement has 2 columns in result</div>
<div style="text-align: left; text-indent: 0px; text-transform: none; font-family: Aptos, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Jan 26 17:28:28 routing-1 /../opensips[1956]: DBG:core:db_new_result: allocate 48 bytes for result set at 0x789bf0</div>
<div style="text-align: left; text-indent: 0px; text-transform: none; font-family: Aptos, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Jan 26 17:28:28 routing-1 /../opensips[1956]: DBG:db_mysql:db_mysql_get_columns: 2 columns returned from the query</div>
<div style="text-align: left; text-indent: 0px; text-transform: none; font-family: Aptos, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Jan 26 17:28:28 routing-1 /../opensips[1956]: DBG:core:db_allocate_columns: allocate 56 bytes for result columns at 0x789618</div>
<div style="direction: ltr; text-align: left; text-indent: 0px; text-transform: none; font-family: Aptos, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="direction: ltr; text-align: left; text-indent: 0px; text-transform: none; font-family: Aptos, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="direction: ltr; text-align: left; text-indent: 0px; text-transform: none; font-family: Aptos, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
--- v 3.7 log ---</div>
<div style="direction: ltr; text-align: left; text-indent: 0px; text-transform: none; font-family: Aptos, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="direction: ltr; text-align: left; text-indent: 0px; text-transform: none; font-family: Aptos, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
01-26 17:43:30.891281 a /../opensips[4010750]: ERROR:--== SIP message body - INVITE ==-- v=0#015#012o=Sonus_UAC 565884 3698 IN IP4 <UPSTREAM_PEER>#015#012s=SIP Media Capabilities#015#012c=IN IP4 <UPSTREAM_PEER>#015#012t=0 0#015#012m=audio 27052 RTP/AVP 8 96#015#012a=rtpmap:8
PCMA/8000#015#012a=rtpmap:96 telephone-event/8000#015#012a=fmtp:96 0-15#015#012a=sendrecv#015#012a=maxptime:20#015</div>
<div style="text-align: left; text-indent: 0px; text-transform: none; font-family: Aptos, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
01-26 17:43:30.891298 a /../opensips[4010750]: DBG:core:parse_to_param: tag=gK085d4ab6</div>
<div style="text-align: left; text-indent: 0px; text-transform: none; font-family: Aptos, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
01-26 17:43:30.891313 a /../opensips[4010750]: DBG:core:parse_to_param: end of header reached, state=11</div>
<div style="text-align: left; text-indent: 0px; text-transform: none; font-family: Aptos, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
01-26 17:43:30.891327 a /../opensips[4010750]: DBG:core:_parse_to: end of header reached, state=29</div>
<div style="text-align: left; text-indent: 0px; text-transform: none; font-family: Aptos, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
01-26 17:43:30.891342 a /../opensips[4010750]: DBG:core:_parse_to: display={}, ruri={sip:<CALLER_DDI>@<UPSTREAM_PEER>;user=phone}</div>
<div style="text-align: left; text-indent: 0px; text-transform: none; font-family: Aptos, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
01-26 17:43:30.891425 a /../opensips[4010750]: DBG:core:parse_headers_aux: flags=78</div>
<div style="text-align: left; text-indent: 0px; text-transform: none; font-family: Aptos, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
01-26 17:43:30.891441 a /../opensips[4010750]: DBG:core:has_totag: no totag</div>
<div style="text-align: left; text-indent: 0px; text-transform: none; font-family: Aptos, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
01-26 17:43:30.891459 a /../opensips[4010750]: DBG:dialog:build_new_dlg: new dialog 0x71cbfe3b64b0 (c=352862312_66830718@<UPSTREAM_PEER>,f=sip:<CALLER_DDI>@<UPSTREAM_PEER>;user=phone,t=sip:<OUR_DDI>@<UPSTREAM_PEER>;user=phone,ft=gK085d4ab6) on hash 3981</div>
<div style="text-align: left; text-indent: 0px; text-transform: none; font-family: Aptos, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
01-26 17:43:30.891481 a /../opensips[4010750]: DBG:core:parse_headers_aux: flags=ffffffffffffffff</div>
<div style="text-align: left; text-indent: 0px; text-transform: none; font-family: Aptos, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
01-26 17:43:30.891502 a /../opensips[4010750]: DBG:core:print_rr_body: current rr is <sip:<UPSTREAM_PEER>;lr;ftag=gK085d4ab6;did=d8f.40748994></div>
<div style="text-align: left; text-indent: 0px; text-transform: none; font-family: Aptos, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
01-26 17:43:30.891517 a /../opensips[4010750]: DBG:core:print_rr_body: skipping 0 route records</div>
<div style="text-align: left; text-indent: 0px; text-transform: none; font-family: Aptos, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
01-26 17:43:30.891533 a /../opensips[4010750]: DBG:core:print_rr_body: out rr [<sip:<UPSTREAM_PEER>;lr;ftag=gK085d4ab6;did=d8f.40748994>]</div>
<div style="text-align: left; text-indent: 0px; text-transform: none; font-family: Aptos, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
01-26 17:43:30.891546 a /../opensips[4010750]: DBG:core:print_rr_body: we have 1 records</div>
<div style="text-align: left; text-indent: 0px; text-transform: none; font-family: Aptos, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
01-26 17:43:30.891562 a /../opensips[4010750]: DBG:dialog:update_leg_info: route_set <sip:<UPSTREAM_PEER>;lr;ftag=gK085d4ab6;did=d8f.40748994>, contact sip:<CALLER_DDI>@<UPSTREAM_PEER>:5060, cseq 494280 and bind_addr udp:<THIS_HOST>:5060</div>
<div style="text-align: left; text-indent: 0px; text-transform: none; font-family: Aptos, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
01-26 17:43:30.891582 a /../opensips[4010750]: DBG:core:parse_headers_aux: flags=ffffffffffffffff</div>
<div style="text-align: left; text-indent: 0px; text-transform: none; font-family: Aptos, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
01-26 17:43:30.891594 a /../opensips[4010750]: DBG:dialog:dlg_update_leg_info: set leg 0 for 0x71cbfe3b64b0: tag=<gK085d4ab6> rcseq=<0></div>
<div style="text-align: left; text-indent: 0px; text-transform: none; font-family: Aptos, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
01-26 17:43:30.891610 a /../opensips[4010750]: DBG:dialog:link_dlg: ref dlg 0x71cbfe3b64b0 with 3 -> 3 in h_entry 0x71cbfe377c08 - 3981 </div>
<div style="text-align: left; text-indent: 0px; text-transform: none; font-family: Aptos, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
01-26 17:43:30.891627 a /../opensips[4010750]: DBG:rr:add_rr_param: adding (;did=d8f.57669b46)</div>
<div style="text-align: left; text-indent: 0px; text-transform: none; font-family: Aptos, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
01-26 17:43:30.891643 a /../opensips[4010750]: DBG:rr:add_rr_param: second RR lump found</div>
<div style="text-align: left; text-indent: 0px; text-transform: none; font-family: Aptos, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
01-26 17:43:30.891660 a /../opensips[4010750]: DBG:rr:add_rr_param: second RR lump found</div>
<div style="direction: ltr; text-align: left; text-indent: 0px; text-transform: none; font-family: Aptos, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="text-align: left; text-indent: 0px; text-transform: none; font-family: Aptos, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
01-26 17:43:30.891772 a /../opensips[4010750]: ERROR:LOG: The value of si = [<UPSTREAM_PEER>]</div>
<div style="direction: ltr; text-align: left; text-indent: 0px; text-transform: none; font-family: Aptos, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
01-26 17:43:30.891784 a /../opensips[4010750]: DBG:permissions:get_source_group: Looking for <<UPSTREAM_PEER>, 5060> in address table</div>
<div style="text-align: left; text-indent: 0px; text-transform: none; font-family: Aptos, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
01-26 17:43:30.891799 a /../opensips[4010750]: DBG:permissions:get_source_group: Found <1></div>
<div style="direction: ltr; text-align: left; text-indent: 0px; text-transform: none; font-family: Aptos, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
>> 01-26 17:43:30.891814 a /../opensips[4010750]: ERROR:core:pv_set_value: bad parameters</div>
<div style="text-align: left; text-indent: 0px; text-transform: none; font-family: Aptos, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
>> 01-26 17:43:30.891832 a /../opensips[4010750]: ERROR:permissions:get_source_group: setting of pvar failed</div>
<div style="direction: ltr; text-align: left; text-indent: 0px; text-transform: none; font-family: Aptos, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
01-26 17:43:30.891849 a /../opensips[4010750]: ERROR:LOG: The value of var(srcgrp) = [-1]</div>
<div style="text-align: left; text-indent: 0px; text-transform: none; font-family: Aptos, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
01-26 17:43:30.891861 a /../opensips[4010750]: DBG:permissions:check_src_addr: Looking for : <default:-1, <UPSTREAM_PEER>, 1, 5060, ></div>
<div style="text-align: left; text-indent: 0px; text-transform: none; font-family: Aptos, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
01-26 17:43:30.891879 a /../opensips[4010750]: DBG:permissions:pm_hash_match: specified group '4294967295' does not exist in hash table</div>
<div style="text-align: left; text-indent: 0px; text-transform: none; font-family: Aptos, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
01-26 17:43:30.891895 a /../opensips[4010750]: ERROR:LOG: The value of var(group) = [-2]</div>
<div style="text-align: left; text-indent: 0px; text-transform: none; font-family: Aptos, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
01-26 17:43:30.891907 a /../opensips[4010750]: DBG:core:comp_scriptvar: int 29: -2 / -1</div>
<div style="direction: ltr; text-align: left; text-indent: 0px; text-transform: none; font-family: Aptos, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="direction: ltr; text-align: left; text-indent: 0px; text-transform: none; font-family: Aptos, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
01-26 17:43:30.893310 a /../opensips[4010750]: DBG:db_mysql:mysql_raise_event: MySQL status has not changed: connected</div>
<div style="text-align: left; text-indent: 0px; text-transform: none; font-family: Aptos, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
01-26 17:43:30.893349 a /../opensips[4010750]: DBG:core:db_new_result: allocate 48 bytes for result set at 0x71cc020e4730</div>
<div style="text-align: left; text-indent: 0px; text-transform: none; font-family: Aptos, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
01-26 17:43:30.893367 a /../opensips[4010750]: DBG:db_mysql:db_mysql_get_columns: 2 columns returned from the query</div>
<div style="text-align: left; text-indent: 0px; text-transform: none; font-family: Aptos, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
01-26 17:43:30.893382 a /../opensips[4010750]: DBG:core:db_allocate_columns: allocate 56 bytes for result columns at 0x71cc020e4798</div>
<div style="direction: ltr; text-align: left; text-indent: 0px; text-transform: none; font-family: Aptos, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="direction: ltr; text-align: left; text-indent: 0px; text-transform: none; font-family: Aptos, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="direction: ltr; text-align: left; text-indent: 0px; text-transform: none; font-family: Aptos, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
As I've been looking through the logs I've noticed that following the OK reply once a call is answered the v3.7 host does some accounting to the database & then sends OK messages related to the INVITE, after four packets the transaction is destroyed. Seven
more OK messages are sent with tm logging that 'no matching transaction exists' before it gives up.</div>
<div style="direction: ltr; text-align: left; text-indent: 0px; text-transform: none; font-family: Aptos, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="direction: ltr; text-align: left; text-indent: 0px; text-transform: none; font-family: Aptos, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Any help would be gratefully received.</div>
<div style="direction: ltr; text-align: left; text-indent: 0px; text-transform: none; font-family: Aptos, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="direction: ltr; text-align: left; text-indent: 0px; text-transform: none; font-family: Aptos, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Many thanks,</div>
<div style="font-family: Aptos, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<span style="text-transform: none;">Al Cleminson.</span></div>
<div style="direction: ltr; font-family: Aptos, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style="direction: ltr; font-family: Aptos, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
</body>
</html>