[SR-Users] RTPPROXY error message

[Daniel-Constantin Mierla]

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 at 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 at lists.sip-router.org
> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

-- 
Daniel-Constantin Mierla
http://www.asipto.com
http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda
Kamailio World Conference, Berlin, May 18-20, 2016 - http://www.kamailioworld.com