RTPPROXY error message - sr-users

15 Mar 2016

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