Re: [SR-Users] Dispatcher error with rtpptoxy

2020-02-12 Thread Voip support
 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  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:  [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  *On Behalf Of *Gaurav
> Bmotra
> *Sent:* Saturday, January 11, 2020 2:31 PM
> *To:* Kamailio (SER) - Users Mailing List 
> *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..} 
> [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..}  [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:  [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..} 

Re: [SR-Users] Dispatcher error with rtpptoxy

2020-01-23 Thread Henning Westerholt
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:  [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  On Behalf Of Gaurav Bmotra
Sent: Saturday, January 11, 2020 2:31 PM
To: Kamailio (SER) - Users Mailing List 
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..}  [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..}  [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:  [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..} 

[SR-Users] Dispatcher error with rtpptoxy

2020-01-11 Thread Gaurav Bmotra
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..} 
[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..}  [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:  [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..}