[prev in list] [next in list] [prev in thread] [next in thread]
List: serusers
Subject: Re: [SR-Users] Dispatcher error with rtpptoxy
From: Henning Westerholt <hw () skalatan ! de>
Date: 2020-01-23 17:23:26
Message-ID: VI1PR05MB45903787ABA3C67B96D9B918C50F0 () VI1PR05MB4590 ! eurprd05 ! prod ! outlook ! com
[Download RAW message or body]
[Attachment #2 (text/plain)]
Hello Guarav,
I did not get your problem completely from the e-mail. From the logs:
9(21) ERROR: db_mysql [km_dbase.c:126]: db_mysql_submit_query(): driver error on \
query: Unknown column 'src_user' in 'field list' (1054) 9(21) ERROR: <core> \
[db_query.c:243]: db_do_insert_cmd(): error while submitting query 9(21) ERROR: acc \
[acc.c:477]: acc_db_request(): failed to insert into database
I think you are missing some database columns for accounting in your DB. Have a look \
to the default cfg (top) to see the alter table cmds.
2(14) ERROR: {1 2 INVITE EQEiv5Mjs-eV1OCGv6Potw..} rtpproxy [rtpproxy.c:2586]: \
force_rtp_proxy(): incorrect port 0 in reply from rtp proxy
I would suggest to do a SIP trace to debug this more.
Cheers,
Henning
--
Henning Westerholt – https://skalatan.de/blog/
Kamailio services – https://gilawa.com<https://gilawa.com/>
From: sr-users <sr-users-bounces@lists.kamailio.org> On Behalf Of Gaurav Bmotra
Sent: Saturday, January 11, 2020 2:31 PM
To: Kamailio (SER) - Users Mailing List <sr-users@lists.kamailio.org>
Subject: [SR-Users] Dispatcher error with rtpptoxy
hi
i m using kamailio 5.2.1 in Kubernetese on Host network
it was working file but now the following issue i n getting
call connecting but audio both way issue
here is the logs that got
--------------------------------
2(14) ERROR: {1 2 INVITE EQEiv5Mjs-eV1OCGv6Potw..} rtpproxy [rtpproxy.c:2586]: \
force_rtp_proxy(): incorrect port 0 in reply from rtp proxy 4(16) ERROR: {2 2 INVITE \
EQEiv5Mjs-eV1OCGv6Potw..} rtpproxy [rtpproxy.c:2586]: force_rtp_proxy(): incorrect \
port 0 in reply from rtp proxy 4(16) NOTICE: {2 2 INVITE EQEiv5Mjs-eV1OCGv6Potw..} \
acc [acc.c:279]: acc_log_request(): ACC: transaction answered: \
timestamp=1578636040;method=INVITE;from_tag=88c92018;to_tag=2c3c0a16;call_id=EQEiv5Mjs \
-eV1OCGv6Potw..;code=200;reason=OK;src_user=200;src_domain=testcalls.aone.one;src_ip=157.39.9.195;dst_ouser=300;dst_user=300;dst_domain=106.78.70.57
4(16) ERROR: {2 2 INVITE EQEiv5Mjs-eV1OCGv6Potw..} db_mysql [km_dbase.c:126]: \
db_mysql_submit_query(): driver error on query: Unknown column 'src_user' in 'field \
list' (1054) 4(16) ERROR: {2 2 INVITE EQEiv5Mjs-eV1OCGv6Potw..} <core> \
[db_query.c:243]: db_do_insert_cmd(): error while submitting query 4(16) ERROR: {2 2 \
INVITE EQEiv5Mjs-eV1OCGv6Potw..} acc [acc.c:477]: acc_db_request(): failed to insert \
into database 6(18) ERROR: {2 2 INVITE EQEiv5Mjs-eV1OCGv6Potw..} rtpproxy \
[rtpproxy.c:2586]: force_rtp_proxy(): incorrect port 0 in reply from rtp proxy 8(20) \
NOTICE: {2 3 BYE EQEiv5Mjs-eV1OCGv6Potw..} acc [acc.c:279]: acc_log_request(): ACC: \
transaction answered: \
timestamp=1578636041;method=BYE;from_tag=88c92018;to_tag=2c3c0a16;call_id=EQEiv5Mjs-eV \
1OCGv6Potw..;code=200;reason=OK;src_user=200;src_domain=testcalls.aone.one;src_ip=157.39.9.195;dst_ouser=300;dst_user=300;dst_domain=106.78.70.57
8(20) ERROR: {2 3 BYE EQEiv5Mjs-eV1OCGv6Potw..} db_mysql [km_dbase.c:126]: \
db_mysql_submit_query(): driver error on query: Unknown column 'src_user' in 'field \
list' (1054) 8(20) ERROR: {2 3 BYE EQEiv5Mjs-eV1OCGv6Potw..} <core> \
[db_query.c:243]: db_do_insert_cmd(): error while submitting query 8(20) ERROR: {2 3 \
BYE EQEiv5Mjs-eV1OCGv6Potw..} acc [acc.c:477]: acc_db_request(): failed to insert \
into database 3(15) ERROR: {1 2 INVITE LH6sikNzpP9rXXMJvH20wQ..} rtpproxy \
[rtpproxy.c:2586]: force_rtp_proxy(): incorrect port 0 in reply from rtp proxy 9(21) \
NOTICE: acc [acc.c:279]: acc_log_request(): ACC: call missed: \
timestamp=1578636141;method=INVITE;from_tag=6b032a77;to_tag=;call_id=LH6sikNzpP9rXXMJvH20wQ..;code=408;reason=Request \
Timeout;src_user=200;src_domain=testcalls.aone.one;src_ip=157.39.9.195;dst_ouser=300;dst_user=300;dst_domain=106.78.70.57
9(21) ERROR: db_mysql [km_dbase.c:126]: db_mysql_submit_query(): driver error on \
query: Unknown column 'src_user' in 'field list' (1054) 9(21) ERROR: <core> \
[db_query.c:243]: db_do_insert_cmd(): error while submitting query 9(21) ERROR: acc \
[acc.c:477]: acc_db_request(): failed to insert into database 9(21) NOTICE: {1 2 \
INVITE LH6sikNzpP9rXXMJvH20wQ..} <script>: RTF_DISPATCH: INVITE 300 \
[LH6sikNzpP9rXXMJvH20wQ..] 9(21) NOTICE: {1 2 INVITE LH6sikNzpP9rXXMJvH20wQ..} \
<script>: RTF_DISPATCH: WARNING sip:49.14.97.169:63353<http://49.14.97.169:63353> is \
broken and marked as inactive 3(15) ERROR: {1 2 INVITE 2gY1N8nGCT02Ut7iAEpKWg..} \
rtpproxy [rtpproxy.c:2586]: force_rtp_proxy(): incorrect port 0 in reply from rtp \
proxy 8(20) ERROR: {2 2 INVITE 2gY1N8nGCT02Ut7iAEpKWg..} rtpproxy [rtpproxy.c:2586]: \
force_rtp_proxy(): incorrect port 0 in reply from rtp proxy 8(20) NOTICE: {2 2 \
INVITE 2gY1N8nGCT02Ut7iAEpKWg..} acc [acc.c:279]: acc_log_request(): ACC: transaction \
answered: timestamp=1578638074;method=INVITE;from_tag=b9979f2a;to_tag=c2952a71;call_id \
=2gY1N8nGCT02Ut7iAEpKWg..;code=200;reason=OK;src_user=200;src_domain=testcalls.aone.one;src_ip=157.39.9.195;dst_ouser=300;dst_user=300;dst_domain=106.78.71.32
8(20) ERROR: {2 2 INVITE 2gY1N8nGCT02Ut7iAEpKWg..} db_mysql [km_dbase.c:126]: \
db_mysql_submit_query(): driver error on query: Unknown column 'src_user' in 'field \
list' (1054)
-------------------------------
plz help me
thank you
--
Regards:
Gaurav Kumar
[Attachment #3 (text/html)]
<html xmlns:v="urn:schemas-microsoft-com:vml" \
xmlns:o="urn:schemas-microsoft-com:office:office" \
xmlns:w="urn:schemas-microsoft-com:office:word" \
xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" \
xmlns="http://www.w3.org/TR/REC-html40"> <head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
span.E-MailFormatvorlage18
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 70.85pt 2.0cm 70.85pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="DE" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span style="mso-fareast-language:EN-US">Hello \
Guarav,<o:p></o:p></span></p> <p class="MsoNormal"><span \
style="mso-fareast-language:EN-US"> &nb \
sp;   \
; & \
nbsp; &nb \
sp; \
<o:p></o:p></span></p> <p class="MsoNormal"><span lang="EN-GB" \
style="mso-fareast-language:EN-US">I did not get your problem completely from the \
e-mail. From the logs:<o:p></o:p></span></p> <p class="MsoNormal"><span lang="EN-GB" \
style="mso-fareast-language:EN-US"><o:p> </o:p></span></p> <p \
class="MsoNormal"><span lang="EN-GB"> 9(21) ERROR: db_mysql [km_dbase.c:126]: \
db_mysql_submit_query(): driver error on query: Unknown column 'src_user' in 'field \
list' (1054)<br> 9(21) ERROR: <core> [db_query.c:243]: \
db_do_insert_cmd(): error while submitting query<br> 9(21) ERROR: acc \
[acc.c:477]: acc_db_request(): failed to insert into database<o:p></o:p></span></p> \
<p class="MsoNormal"><span lang="EN-GB"><o:p> </o:p></span></p> <p \
class="MsoNormal"><span lang="EN-GB">I think you are missing some database columns \
for accounting in your DB. Have a look to the default cfg (top) to see the alter \
table cmds.<o:p></o:p></span></p> <p class="MsoNormal"><span \
lang="EN-GB"><o:p> </o:p></span></p> <p class="MsoNormal"><span \
lang="EN-GB">2(14) ERROR: {1 2 INVITE EQEiv5Mjs-eV1OCGv6Potw..} rtpproxy \
[rtpproxy.c:2586]: force_rtp_proxy(): incorrect port 0 in reply from rtp \
proxy<o:p></o:p></span></p> <p class="MsoNormal"><span \
lang="EN-GB"><o:p> </o:p></span></p> <p class="MsoNormal"><span lang="EN-GB">I \
would suggest to do a SIP trace to debug this more.<o:p></o:p></span></p> <p \
class="MsoNormal"><span lang="EN-GB"><o:p> </o:p></span></p> <p \
class="MsoNormal"><span lang="EN-GB">Cheers,<o:p></o:p></span></p> <p \
class="MsoNormal"><span lang="EN-GB"><o:p> </o:p></span></p> <p \
class="MsoNormal"><span lang="EN-GB">Henning<o:p></o:p></span></p> <p \
class="MsoNormal"><span lang="EN-GB" \
style="mso-fareast-language:EN-US"><o:p> </o:p></span></p> <p \
class="MsoNormal"><span lang="EN-GB" style="mso-fareast-language:EN-US">-- <o:p> \
</o:p></span></p> <p class="MsoNormal"><span lang="EN-GB" \
style="mso-fareast-language:EN-US">Henning Westerholt – </span><span \
style="mso-fareast-language:EN-US"><a href="https://skalatan.de/blog/"><span \
lang="EN-GB" style="color:#0563C1">https://skalatan.de/blog/</span></a></span><span \
lang="EN-GB" style="mso-fareast-language:EN-US"><o:p></o:p></span></p> <p \
class="MsoNormal"><span lang="EN-GB" style="mso-fareast-language:EN-US">Kamailio \
services – </span><span style="mso-fareast-language:EN-US"><a \
href="https://gilawa.com/"><span lang="EN-GB" \
style="color:#0563C1">https://gilawa.com</span></a></span><span \
style="mso-fareast-language:EN-US"> <span lang="EN-GB"><o:p></o:p></span></span></p>
<p class="MsoNormal"><span lang="EN-GB" \
style="mso-fareast-language:EN-US"><o:p> </o:p></span></p> <p class="MsoNormal" \
style="margin-left:35.4pt"><b>From:</b> sr-users \
<sr-users-bounces@lists.kamailio.org> <b>On Behalf Of </b>Gaurav Bmotra<br>
<b>Sent:</b> Saturday, January 11, 2020 2:31 PM<br>
<b>To:</b> Kamailio (SER) - Users Mailing List \
<sr-users@lists.kamailio.org><br> <b>Subject:</b> [SR-Users] Dispatcher error \
with rtpptoxy<o:p></o:p></p> <p class="MsoNormal" \
style="margin-left:35.4pt"><o:p> </o:p></p> <div>
<p class="MsoNormal" style="margin-left:35.4pt">hi <o:p></o:p></p>
<div>
<p class="MsoNormal" style="margin-left:35.4pt">i m using kamailio 5.2.1 in \
Kubernetese on Host network <br> it was working file but now the following issue \
i n getting<o:p></o:p></p> </div>
<div>
<p class="MsoNormal" style="margin-left:35.4pt"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:35.4pt">call connecting but audio both way \
issue <o:p></o:p></p> </div>
<div>
<p class="MsoNormal" style="margin-left:35.4pt">here is the logs that \
got <o:p></o:p></p> </div>
<div>
<p class="MsoNormal" style="margin-left:35.4pt"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal" \
style="margin-left:35.4pt">--------------------------------<o:p></o:p></p> </div>
<div>
<p class="MsoNormal" style="margin-left:35.4pt">2(14) ERROR: {1 2 INVITE \
EQEiv5Mjs-eV1OCGv6Potw..} rtpproxy [rtpproxy.c:2586]: force_rtp_proxy(): incorrect \
port 0 in reply from rtp proxy<br> 4(16) ERROR: {2 2 INVITE \
EQEiv5Mjs-eV1OCGv6Potw..} rtpproxy [rtpproxy.c:2586]: force_rtp_proxy(): incorrect \
port 0 in reply from rtp proxy<br> 4(16) NOTICE: {2 2 INVITE \
EQEiv5Mjs-eV1OCGv6Potw..} acc [acc.c:279]: acc_log_request(): ACC: transaction \
answered: timestamp=1578636040;method=INVITE;from_tag=88c92018;to_tag=2c3c0a16;call_id \
=EQEiv5Mjs-eV1OCGv6Potw..;code=200;reason=OK;src_user=200;src_domain=testcalls.aone.one;src_ip=157.39.9.195;dst_ouser=300;dst_user=300;dst_domain=106.78.70.57<br>
4(16) ERROR: {2 2 INVITE EQEiv5Mjs-eV1OCGv6Potw..} db_mysql [km_dbase.c:126]: \
db_mysql_submit_query(): driver error on query: Unknown column 'src_user' in 'field \
list' (1054)<br> 4(16) ERROR: {2 2 INVITE EQEiv5Mjs-eV1OCGv6Potw..} \
<core> [db_query.c:243]: db_do_insert_cmd(): error while submitting query<br> \
4(16) ERROR: {2 2 INVITE EQEiv5Mjs-eV1OCGv6Potw..} acc [acc.c:477]: \
acc_db_request(): failed to insert into database<br> 6(18) ERROR: {2 2 INVITE \
EQEiv5Mjs-eV1OCGv6Potw..} rtpproxy [rtpproxy.c:2586]: force_rtp_proxy(): incorrect \
port 0 in reply from rtp proxy<br> 8(20) NOTICE: {2 3 BYE \
EQEiv5Mjs-eV1OCGv6Potw..} acc [acc.c:279]: acc_log_request(): ACC: transaction \
answered: timestamp=1578636041;method=BYE;from_tag=88c92018;to_tag=2c3c0a16;call_id=EQ \
Eiv5Mjs-eV1OCGv6Potw..;code=200;reason=OK;src_user=200;src_domain=testcalls.aone.one;src_ip=157.39.9.195;dst_ouser=300;dst_user=300;dst_domain=106.78.70.57<br>
8(20) ERROR: {2 3 BYE EQEiv5Mjs-eV1OCGv6Potw..} db_mysql [km_dbase.c:126]: \
db_mysql_submit_query(): driver error on query: Unknown column 'src_user' in 'field \
list' (1054)<br> 8(20) ERROR: {2 3 BYE EQEiv5Mjs-eV1OCGv6Potw..} <core> \
[db_query.c:243]: db_do_insert_cmd(): error while submitting query<br> 8(20) \
ERROR: {2 3 BYE EQEiv5Mjs-eV1OCGv6Potw..} acc [acc.c:477]: acc_db_request(): failed \
to insert into database<br> 3(15) ERROR: {1 2 INVITE LH6sikNzpP9rXXMJvH20wQ..} \
rtpproxy [rtpproxy.c:2586]: force_rtp_proxy(): incorrect port 0 in reply from rtp \
proxy<br> 9(21) NOTICE: acc [acc.c:279]: acc_log_request(): ACC: call missed: \
timestamp=1578636141;method=INVITE;from_tag=6b032a77;to_tag=;call_id=LH6sikNzpP9rXXMJvH20wQ..;code=408;reason=Request \
Timeout;src_user=200;src_domain=testcalls.aone.one;src_ip=157.39.9.195;dst_ouser=300;dst_user=300;dst_domain=106.78.70.57<br>
9(21) ERROR: db_mysql [km_dbase.c:126]: db_mysql_submit_query(): driver error \
on query: Unknown column 'src_user' in 'field list' (1054)<br> 9(21) ERROR: \
<core> [db_query.c:243]: db_do_insert_cmd(): error while submitting query<br> \
9(21) ERROR: acc [acc.c:477]: acc_db_request(): failed to insert into \
database<br> 9(21) NOTICE: {1 2 INVITE LH6sikNzpP9rXXMJvH20wQ..} \
<script>: RTF_DISPATCH: INVITE 300 [LH6sikNzpP9rXXMJvH20wQ..] 9(21) NOTICE: {1 \
2 INVITE LH6sikNzpP9rXXMJvH20wQ..} <script>: RTF_DISPATCH: WARNING sip:<a \
href="http://49.14.97.169:63353">49.14.97.169:63353</a> is broken and marked as \
inactive 3(15) ERROR: {1 2 INVITE 2gY1N8nGCT02Ut7iAEpKWg..} rtpproxy \
[rtpproxy.c:2586]: force_rtp_proxy(): incorrect port 0 in reply from rtp proxy<br> \
8(20) ERROR: {2 2 INVITE 2gY1N8nGCT02Ut7iAEpKWg..} rtpproxy [rtpproxy.c:2586]: \
force_rtp_proxy(): incorrect port 0 in reply from rtp proxy<br> 8(20) NOTICE: \
{2 2 INVITE 2gY1N8nGCT02Ut7iAEpKWg..} acc [acc.c:279]: acc_log_request(): ACC: \
transaction answered: \
timestamp=1578638074;method=INVITE;from_tag=b9979f2a;to_tag=c2952a71;call_id=2gY1N8nGC \
T02Ut7iAEpKWg..;code=200;reason=OK;src_user=200;src_domain=testcalls.aone.one;src_ip=157.39.9.195;dst_ouser=300;dst_user=300;dst_domain=106.78.71.32<br>
8(20) ERROR: {2 2 INVITE 2gY1N8nGCT02Ut7iAEpKWg..} db_mysql [km_dbase.c:126]: \
db_mysql_submit_query(): driver error on query: Unknown column 'src_user' in 'field \
list' (1054)<o:p></o:p></p> </div>
<div>
<p class="MsoNormal" style="margin-left:35.4pt"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:35.4pt"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal" \
style="margin-left:35.4pt">-------------------------------<o:p></o:p></p> </div>
<div>
<p class="MsoNormal" style="margin-left:35.4pt"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:35.4pt">plz help me <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:35.4pt"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:35.4pt">thank you <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal" style="margin-left:35.4pt"> <br clear="all">
<o:p></o:p></p>
<div>
<p class="MsoNormal" style="margin-left:35.4pt"><o:p> </o:p></p>
</div>
<p class="MsoNormal" style="margin-left:35.4pt">-- <o:p></o:p></p>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<p class="MsoNormal" style="margin-left:35.4pt"><br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<b><span style="color:#999999">Regards:</span></b><span style="color:#999999"><br>
Gaurav Kumar</span><o:p></o:p></p>
</div>
</div>
<div>
<p class="MsoNormal" style="margin-left:35.4pt"><o:p> </o:p></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</body>
</html>
[Attachment #4 (unknown)]
_______________________________________________
Kamailio (SER) - Users Mailing List
sr-users@lists.kamailio.org
https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic