Hi:
I am sure this has been answered before on this list and I have tried the basic answers I got from Google without any luck. Any suggests would be great.
The Kamailio host is running Oracle Linux 6.7 (64 bit) and is fully patched as of today. The Kamailio version is:
Server:: kamailio (4.3.4 (x86_64/linux)) Build:: mi_core.c compiled on 14:25:16 Nov 25 2015 with gcc 4.4.7
I have two major issues:
I am seeing this on my Kamailio log:
Mar 14 21:55:33 sipserver /usr/sbin/kamailio[24005]: ERROR: rtpproxy [rtpproxy.c:1681]: send_rtpp_command(): can't send command to a RTP proxy Mar 14 21:55:33 sipserver /usr/sbin/kamailio[24005]: ERROR: rtpproxy [rtpproxy.c:1716]: send_rtpp_command(): proxy udp:127.0.0.1:7722 does not respond, disable it Mar 14 21:55:33 sipserver /usr/sbin/kamailio[24005]: WARNING: rtpproxy [rtpproxy.c:1573]: rtpp_test(): can't get version of the RTP proxy Mar 14 21:55:33 sipserver /usr/sbin/kamailio[24005]: WARNING: rtpproxy [rtpproxy.c:1610]: rtpp_test(): support for RTP proxy udp:127.0.0.1:7722 has been disabled temporarily
So the initial thought is that the proxy is not running, however I can see the proxy is alive:
[root@sipserver boot]# ps -All | grep rtpproxy 5 S 498 2843 1 1 80 0 - 32524 hrtime ? 01:29:06 rtpproxy
When I do "netstat -a", I can see 24 established connections. This is a small sample:
udp 0 0 localhost:47937 localhost:rtpproxy ESTABLISHED udp 0 0 localhost:38746 localhost:rtpproxy ESTABLISHED udp 0 0 localhost:33660 localhost:rtpproxy ESTABLISHED
So I am not sure what is going on.
The second problem:
I see this in the Kamailio log:
Mar 14 22:05:33 sipserver /usr/sbin/kamailio[24000]: ERROR: db_mysql [km_dbase.c:124]: db_mysql_submit_query(): driver error on query: PROCEDURE kamailio.kamailio_rating does not exist (1305) Mar 14 22:05:33 sipserver /usr/sbin/kamailio[24000]: ERROR: <core> [db_query.c:181]: db_do_raw_query(): error while submitting query Mar 14 22:05:33 sipserver /usr/sbin/kamailio[24000]: ERROR: sqlops [sql_api.c:265]: sql_do_query(): cannot do the query [call kamailio_rating('default')]
When I tried to create the database originally, the script that was part of the package would not work. I therefore manually created the database so I am thinking that something got left out. I have been over the schema and I am not sure what is missing. The database is MySQL (5.5) running in a separate host.
Does anyone have an idea where to look what is missing? I was told that there is some sort of script that can "repair" the Kamailio schema in the database but I have not been able to find this magical script.
Thanks.
Kevin
Hello,
if rtpproxy is listening on udp:127.0.0.1:7722, then you may have some limits in place regarding sockets/traffic -- if you have selinux enabled, try without it. Also, you can try by lowering the value for children parameter.
Regarding the SQL errors, it seems you run the config from Siremis, but you haven't created the stored procedures required there.
Cheers, Daniel
On 14/03/16 23:17, Kevin Greene wrote:
Hi:
I am sure this has been answered before on this list and I have tried the basic answers I got from Google without any luck. Any suggests would be great.
The Kamailio host is running Oracle Linux 6.7 (64 bit) and is fully patched as of today. The Kamailio version is:
Server:: kamailio (4.3.4 (x86_64/linux)) Build:: mi_core.c compiled on 14:25:16 Nov 25 2015 with gcc 4.4.7
I have two major issues:
I am seeing this on my Kamailio log:
Mar 14 21:55:33 sipserver /usr/sbin/kamailio[24005]: ERROR: rtpproxy [rtpproxy.c:1681]: send_rtpp_command(): can't send command to a RTP proxy Mar 14 21:55:33 sipserver /usr/sbin/kamailio[24005]: ERROR: rtpproxy [rtpproxy.c:1716]: send_rtpp_command(): proxy udp:127.0.0.1:7722 does not respond, disable it Mar 14 21:55:33 sipserver /usr/sbin/kamailio[24005]: WARNING: rtpproxy [rtpproxy.c:1573]: rtpp_test(): can't get version of the RTP proxy Mar 14 21:55:33 sipserver /usr/sbin/kamailio[24005]: WARNING: rtpproxy [rtpproxy.c:1610]: rtpp_test(): support for RTP proxy udp:127.0.0.1:7722 has been disabled temporarily
So the initial thought is that the proxy is not running, however I can see the proxy is alive:
[root@sipserver boot]# ps -All | grep rtpproxy 5 S 498 2843 1 1 80 0 - 32524 hrtime ? 01:29:06 rtpproxy
When I do "netstat -a", I can see 24 established connections. This is a small sample:
udp 0 0 localhost:47937 localhost:rtpproxy ESTABLISHED udp 0 0 localhost:38746 localhost:rtpproxy ESTABLISHED udp 0 0 localhost:33660 localhost:rtpproxy ESTABLISHED
So I am not sure what is going on.
The second problem:
I see this in the Kamailio log:
Mar 14 22:05:33 sipserver /usr/sbin/kamailio[24000]: ERROR: db_mysql [km_dbase.c:124]: db_mysql_submit_query(): driver error on query: PROCEDURE kamailio.kamailio_rating does not exist (1305) Mar 14 22:05:33 sipserver /usr/sbin/kamailio[24000]: ERROR: <core> [db_query.c:181]: db_do_raw_query(): error while submitting query Mar 14 22:05:33 sipserver /usr/sbin/kamailio[24000]: ERROR: sqlops [sql_api.c:265]: sql_do_query(): cannot do the query [call kamailio_rating('default')]
When I tried to create the database originally, the script that was part of the package would not work. I therefore manually created the database so I am thinking that something got left out. I have been over the schema and I am not sure what is missing. The database is MySQL (5.5) running in a separate host.
Does anyone have an idea where to look what is missing? I was told that there is some sort of script that can "repair" the Kamailio schema in the database but I have not been able to find this magical script.
Thanks.
Kevin
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list sr-users@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
-
Daniel-Constantin Mierla -
Kevin Greene