11 Jan
2020
11 Jan
'20
2:31 p.m.
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-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
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 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
23 Jan
23 Jan
6:23 p.m.
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(a)lists.kamailio.org> On Behalf Of Gaurav Bmotra
Sent: Saturday, January 11, 2020 2:31 PM
To: Kamailio (SER) - Users Mailing List <sr-users(a)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-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
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
12 Feb
12 Feb
1:04 p.m.
incorrect port 0 in reply from rtp proxy
This problem is related to rtpproxy listener ip not set to an interface ip
available on the rtpproxy host.
For ex. in ifconfig you have address 10.0.0.10 and in rtpproxy service you
start with public ip -l 201.234.22.11 - it should be set to -l 10.0.0.10 in
such case.
czw., 23 sty 2020 o 18:25 Henning Westerholt <hw(a)skalatan.de> napisał(a):
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
*From:* sr-users <sr-users-bounces(a)lists.kamailio.org> *On Behalf Of *Gaurav
Bmotra
*Sent:* Saturday, January 11, 2020 2:31 PM
*To:* Kamailio (SER) - Users Mailing List <sr-users(a)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-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
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 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
_______________________________________________
Kamailio (SER) - Users Mailing List
sr-users(a)lists.kamailio.org
https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
1537
days inactive
1569
days old
2 comments
3 participants
participants (3)
-
Gaurav Bmotra -
Henning Westerholt -
Voip support