[OpenSIPS-Users] RTPengine provisioning by db

Alain Bieuzent alain.bieuzent at free.fr
Thu Jul 12 05:56:57 EDT 2018


Hi all,



I just created a new database and version of table rtpproxy_sockets is 0, so i think there is a mismatch somewhere because opensips 2.4.1 expected 1.



Is there somewhere the mysql schema of 2.4 version?



thanks



Le 11/07/2018 18:02, « Users au nom de Răzvan Crainea » <users-bounces at lists.opensips.org au nom de razvan at opensips.org> a écrit :



    No problem, thanks for sharing the initial cause!

    

    Best regards,

    Răzvan

    

    On 07/11/2018 06:59 PM, Alain Bieuzent wrote:

    > never forgot to check the logs.....

    > 

    > yes, you are right opensips didn't start with this error:

    > 

    > 

    > 

    > Jul 11 17:52:21 opensips-test opensips[20625]: ERROR:core:db_check_table_version: invalid version 0 for table rtpproxy_sockets found, expected 1

    > 

    > Jul 11 17:52:21 opensips-test opensips[20625]: ERROR:rtpengine:mod_init: error during table version check

    > 

    > Jul 11 17:52:21 opensips-test opensips[20625]: ERROR:core:init_mod: failed to initialize module rtpengine

    > 

    > Jul 11 17:52:21 opensips-test opensips[20625]: ERROR:core:main: error while initializing modules

    > 

    > 

    > 

    > My fault sorry for the noise.

    > 

    > 

    > 

    > Thanks, Razvan.

    > 

    > 

    > 

    > Le 11/07/2018 17:48, « Users au nom de Răzvan Crainea » <users-bounces at lists.opensips.org au nom de razvan at opensips.org> a écrit :

    > 

    > 

    > 

    >      Hello!

    > 

    >      

    > 

    >      After you comment the first line, can you make sure opensips actually

    > 

    >      starts (ps aux | grep opensips). After that, can you check that the

    > 

    >      /tmp/opensips_fifo file exists?

    > 

    >      

    > 

    >      Best regards,

    > 

    >      Răzvan

    > 

    >      

    > 

    >      On 07/11/2018 06:37 PM, Alain Bieuzent wrote:

    > 

    >      > Hi, Rasvan!

    > 

    >      >

    > 

    >      >

    > 

    >      >

    > 

    >      > I double check and the typo with the "i" is not the cause.

    > 

    >      >

    > 

    >      >

    > 

    >      >

    > 

    >      > I used these parameters:

    > 

    >      >

    > 

    >      > ######################################################################

    > 

    >      >

    > 

    >      > #### RTPENGINE module

    > 

    >      >

    > 

    >      > ######################################################################

    > 

    >      >

    > 

    >      > modparam("rtpengine", "rtpengine_sock", "udp:10.207.201.19:2223 udp:10.207.201.20:2223")

    > 

    >      >

    > 

    >      >

    > 

    >      >

    > 

    >      > modparam("rtpengine", "db_url", "mysql://opensips:XXXX@ZZZ/opensips_lb_did_2_4")

    > 

    >      >

    > 

    >      > modparam("rtpengine", "db_table", "rtpproxy_sockets")

    > 

    >      >

    > 

    >      > modparam("rtpengine", "socket_column", "rtpproxy_sock")

    > 

    >      >

    > 

    >      > modparam("rtpengine", "set_column", "set_id")

    > 

    >      >

    > 

    >      >

    > 

    >      >

    > 

    >      > If i comment the 4 last line to do not use db, opensips start i can use opensipsctl fifo ds_list (so no issue with fifo file)

    > 

    >      >

    > 

    >      > If i comment only the first line to use db, opensipsctl produce the error about fifo file.

    > 

    >      >

    > 

    >      > I don't change anything else except comment the first or the last 4 line.

    > 

    >      >

    > 

    >      >

    > 

    >      >

    > 

    >      > I don't know where to look ..

    > 

    >      >

    > 

    >      >

    > 

    >      >

    > 

    >      > thanks for your help

    > 

    >      >

    > 

    >      >

    > 

    >      >

    > 

    >      >

    > 

    >      >

    > 

    >      > Le 11/07/2018 16:24, « Users au nom de Răzvan Crainea » <users-bounces at lists.opensips.org au nom de razvan at opensips.org> a écrit :

    > 

    >      >

    > 

    >      >

    > 

    >      >

    > 

    >      >      Hi, Alain!

    > 

    >      >

    > 

    >      >

    > 

    >      >

    > 

    >      >      I think Pasan is right, you are either using a different

    > 

    >      >

    > 

    >      >      /tmp/opensips_fifo modparam, or you can't access that file with the user

    > 

    >      >

    > 

    >      >      you are trying to run. Or, perhaps you have a syntax error in your

    > 

    >      >

    > 

    >      >      configuration file, and OpenSIPS doesn't start at all, that's why

    > 

    >      >

    > 

    >      >      opensipsctl reports it cannot find the fifo file.

    > 

    >      >

    > 

    >      >      If I am looking better at the snippet you posted, I see an "i" before a

    > 

    >      >

    > 

    >      >      comment there:

    > 

    >      >

    > 

    >      >        i#modparam("rtpengine", "rtpengine_sock", "udp:10.207.201.20:2223")

    > 

    >      >

    > 

    >      >

    > 

    >      >

    > 

    >      >      That could be a parsing error which might prevent opensips from

    > 

    >      >

    > 

    >      >      starting, thus creating the fifo file.

    > 

    >      >

    > 

    >      >

    > 

    >      >

    > 

    >      >      Did you check if the file is actually there after you get the

    > 

    >      >

    > 

    >      >      opensipsctl error?

    > 

    >      >

    > 

    >      >

    > 

    >      >

    > 

    >      >      Best regards,

    > 

    >      >

    > 

    >      >      Răzvan

    > 

    >      >

    > 

    >      >

    > 

    >      >

    > 

    >      >      On 07/11/2018 03:55 PM, Alain Bieuzent wrote:

    > 

    >      >

    > 

    >      >      > Hi all,

    > 

    >      >

    > 

    >      >      >

    > 

    >      >

    > 

    >      >      > nobody has any other idea?

    > 

    >      >

    > 

    >      >      >

    > 

    >      >

    > 

    >      >      > Thanks

    > 

    >      >

    > 

    >      >      >

    > 

    >      >

    > 

    >      >      > *De : *Users <users-bounces at lists.opensips.org> au nom de Alain Bieuzent

    > 

    >      >

    > 

    >      >      > <alain.bieuzent at free.fr>

    > 

    >      >

    > 

    >      >      > *Répondre à : *OpenSIPS users mailling list <users at lists.opensips.org>

    > 

    >      >

    > 

    >      >      > *Date : *vendredi 6 juillet 2018 à 14:06

    > 

    >      >

    > 

    >      >      > *À : *Pasan Meemaduma <pasandev at ymail.com>, OpenSIPS users mailling list

    > 

    >      >

    > 

    >      >      > <users at lists.opensips.org>

    > 

    >      >

    > 

    >      >      > *Objet : *Re: [OpenSIPS-Users] RTPengine provisioning by db

    > 

    >      >

    > 

    >      >      >

    > 

    >      >

    > 

    >      >      > Hi Pasan,

    > 

    >      >

    > 

    >      >      >

    > 

    >      >

    > 

    >      >      > Thanks for the reply but yes of course I have mi_fifo module load and

    > 

    >      >

    > 

    >      >      > configure.

    > 

    >      >

    > 

    >      >      >

    > 

    >      >

    > 

    >      >      > I’m using also dispatcher with a db provisioning and without the db

    > 

    >      >

    > 

    >      >      > parameters for the rtpengine module I can manage the dispatcher entry

    > 

    >      >

    > 

    >      >      > via opensipsctl fi ds_XXXX

    > 

    >      >

    > 

    >      >      >

    > 

    >      >

    > 

    >      >      > with the the db parameters for the rtpengine module, command opensipsctl

    > 

    >      >

    > 

    >      >      > fifo ds_list provide the same error about mi_fifo.

    > 

    >      >

    > 

    >      >      >

    > 

    >      >

    > 

    >      >      > thanks

    > 

    >      >

    > 

    >      >      >

    > 

    >      >

    > 

    >      >      > *De : *Users <users-bounces at lists.opensips.org> au nom de Pasan

    > 

    >      >

    > 

    >      >      > Meemaduma via Users <users at lists.opensips.org>

    > 

    >      >

    > 

    >      >      > *Répondre à : *Pasan Meemaduma <pasandev at ymail.com>, OpenSIPS users

    > 

    >      >

    > 

    >      >      > mailling list <users at lists.opensips.org>

    > 

    >      >

    > 

    >      >      > *Date : *vendredi 6 juillet 2018 à 12:23

    > 

    >      >

    > 

    >      >      > *À : *OpenSIPS users mailling list <users at lists.opensips.org>

    > 

    >      >

    > 

    >      >      > *Objet : *Re: [OpenSIPS-Users] RTPengine provisioning by db

    > 

    >      >

    > 

    >      >      >

    > 

    >      >

    > 

    >      >      > Hi Alain,

    > 

    >      >

    > 

    >      >      >

    > 

    >      >

    > 

    >      >      > do you have following config lines in your opensips.cfg file which

    > 

    >      >

    > 

    >      >      > enables the fifo management interface ?

    > 

    >      >

    > 

    >      >      >

    > 

    >      >

    > 

    >      >      > loadmodule "mi_fifo.so"

    > 

    >      >

    > 

    >      >      >

    > 

    >      >

    > 

    >      >      >

    > 

    >      >

    > 

    >      >      > # ----- mi_fifo params -----

    > 

    >      >

    > 

    >      >      > modparam("mi_fifo", "fifo_name", "/tmp/opensips_fifo")

    > 

    >      >

    > 

    >      >      >

    > 

    >      >

    > 

    >      >      > According to the error you got it doesn't seems to exists.

    > 

    >      >

    > 

    >      >      >

    > 

    >      >

    > 

    >      >      > On Friday, 6 July 2018, 3:27:51 PM GMT+5:30, Alain Bieuzent

    > 

    >      >

    > 

    >      >      > <alain.bieuzent at free.fr> wrote:

    > 

    >      >

    > 

    >      >      >

    > 

    >      >

    > 

    >      >      > Hi all,

    > 

    >      >

    > 

    >      >      >

    > 

    >      >

    > 

    >      >      > I’m trying to provionning rtpengine via mysql db, but i can’t add a new

    > 

    >      >

    > 

    >      >      > proxy via opensipctl

    > 

    >      >

    > 

    >      >      >

    > 

    >      >

    > 

    >      >      > My parameters are :

    > 

    >      >

    > 

    >      >      >

    > 

    >      >

    > 

    >      >      > ######################################################################

    > 

    >      >

    > 

    >      >      >

    > 

    >      >

    > 

    >      >      > #### RTPENGINE module

    > 

    >      >

    > 

    >      >      >

    > 

    >      >

    > 

    >      >      > ######################################################################

    > 

    >      >

    > 

    >      >      >

    > 

    >      >

    > 

    >      >      > #modparam("rtpengine", "rtpengine_sock", "udp:10.207.201.19:2223

    > 

    >      >

    > 

    >      >      > udp:10.207.201.20:2223")

    > 

    >      >

    > 

    >      >      >

    > 

    >      >

    > 

    >      >      > i#modparam("rtpengine", "rtpengine_sock", "udp:10.207.201.20:2223")

    > 

    >      >

    > 

    >      >      >

    > 

    >      >

    > 

    >      >      > modparam("rtpengine", "db_url",

    > 

    >      >

    > 

    >      >      > "mysql://opensips:XXXXXXXX@ZZZZZZZZZZZ/opensips_lb_did_2_4")

    > 

    >      >

    > 

    >      >      >

    > 

    >      >

    > 

    >      >      > modparam("rtpengine", "db_table", "rtpproxy_sockets")

    > 

    >      >

    > 

    >      >      >

    > 

    >      >

    > 

    >      >      > modparam("rtpengine", "socket_column", "rtpproxy_sock")

    > 

    >      >

    > 

    >      >      >

    > 

    >      >

    > 

    >      >      > modparam("rtpengine", "set_column", "set_id")

    > 

    >      >

    > 

    >      >      >

    > 

    >      >

    > 

    >      >      > when i run : opensipsctl fifo rtpengine_show

    > 

    >      >

    > 

    >      >      >

    > 

    >      >

    > 

    >      >      > i received this error :

    > 

    >      >

    > 

    >      >      >

    > 

    >      >

    > 

    >      >      > ERROR: /tmp/opensips_fifo does not exist

    > 

    >      >

    > 

    >      >      >

    > 

    >      >

    > 

    >      >      > ERROR: Make sure you have the line 'modparam("mi_fifo", "fifo_name",

    > 

    >      >

    > 

    >      >      > "/tmp/opensips_fifo")' in your config

    > 

    >      >

    > 

    >      >      >

    > 

    >      >

    > 

    >      >      > ERROR: and also have loaded the mi_fifo module.

    > 

    >      >

    > 

    >      >      >

    > 

    >      >

    > 

    >      >      > When i use « rtpengine_sock », it works

    > 

    >      >

    > 

    >      >      >

    > 

    >      >

    > 

    >      >      > version: opensips 2.4.1 (x86_64/linux)

    > 

    >      >

    > 

    >      >      >

    > 

    >      >

    > 

    >      >      > flags: STATS: On, DISABLE_NAGLE, USE_MCAST, SHM_MMAP, PKG_MALLOC,

    > 

    >      >

    > 

    >      >      > F_MALLOC, FAST_LOCK-ADAPTIVE_WAIT

    > 

    >      >

    > 

    >      >      >

    > 

    >      >

    > 

    >      >      > ADAPTIVE_WAIT_LOOPS=1024, MAX_RECV_BUFFER_SIZE 262144, MAX_LISTEN 16,

    > 

    >      >

    > 

    >      >      > MAX_URI_SIZE 1024, BUF_SIZE 65535

    > 

    >      >

    > 

    >      >      >

    > 

    >      >

    > 

    >      >      > poll method support: poll, epoll, sigio_rt, select.

    > 

    >      >

    > 

    >      >      >

    > 

    >      >

    > 

    >      >      > git revision: 5d042cffc

    > 

    >      >

    > 

    >      >      >

    > 

    >      >

    > 

    >      >      > main.c compiled on 09:17:20 Jul  6 2018 with gcc 4.7

    > 

    >      >

    > 

    >      >      >

    > 

    >      >

    > 

    >      >      > Someone can help me ?

    > 

    >      >

    > 

    >      >      >

    > 

    >      >

    > 

    >      >      > thanks

    > 

    >      >

    > 

    >      >      >

    > 

    >      >

    > 

    >      >      > _______________________________________________

    > 

    >      >

    > 

    >      >      > Users mailing list

    > 

    >      >

    > 

    >      >      > Users at lists.opensips.org <mailto:Users at lists.opensips.org>

    > 

    >      >

    > 

    >      >      > http://lists.opensips.org/cgi-bin/mailman/listinfo/users

    > 

    >      >

    > 

    >      >      >

    > 

    >      >

    > 

    >      >      > _______________________________________________ Users mailing list

    > 

    >      >

    > 

    >      >      > Users at lists.opensips.org

    > 

    >      >

    > 

    >      >      > http://lists.opensips.org/cgi-bin/mailman/listinfo/users

    > 

    >      >

    > 

    >      >      >

    > 

    >      >

    > 

    >      >      > _______________________________________________ Users mailing list

    > 

    >      >

    > 

    >      >      > Users at lists.opensips.org

    > 

    >      >

    > 

    >      >      > http://lists.opensips.org/cgi-bin/mailman/listinfo/users

    > 

    >      >

    > 

    >      >      >

    > 

    >      >

    > 

    >      >      >

    > 

    >      >

    > 

    >      >      >

    > 

    >      >

    > 

    >      >      > _______________________________________________

    > 

    >      >

    > 

    >      >      > Users mailing list

    > 

    >      >

    > 

    >      >      > Users at lists.opensips.org

    > 

    >      >

    > 

    >      >      > http://lists.opensips.org/cgi-bin/mailman/listinfo/users

    > 

    >      >

    > 

    >      >      >

    > 

    >      >

    > 

    >      >

    > 

    >      >

    > 

    >      >      --

    > 

    >      >

    > 

    >      >      Răzvan Crainea

    > 

    >      >

    > 

    >      >      OpenSIPS Core Developer

    > 

    >      >

    > 

    >      >         http://www.opensips-solutions.com

    > 

    >      >

    > 

    >      >

    > 

    >      >

    > 

    >      >      _______________________________________________

    > 

    >      >

    > 

    >      >      Users mailing list

    > 

    >      >

    > 

    >      >      Users at lists.opensips.org

    > 

    >      >

    > 

    >      >      http://lists.opensips.org/cgi-bin/mailman/listinfo/users

    > 

    >      >

    > 

    >      >

    > 

    >      >

    > 

    >      >

    > 

    >      >

    > 

    >      >

    > 

    >      > _______________________________________________

    > 

    >      > Users mailing list

    > 

    >      > Users at lists.opensips.org

    > 

    >      > http://lists.opensips.org/cgi-bin/mailman/listinfo/users

    > 

    >      >

    > 

    >      

    > 

    >      --

    > 

    >      Răzvan Crainea

    > 

    >      OpenSIPS Core Developer

    > 

    >         http://www.opensips-solutions.com

    > 

    >      

    > 

    >      _______________________________________________

    > 

    >      Users mailing list

    > 

    >      Users at lists.opensips.org

    > 

    >      http://lists.opensips.org/cgi-bin/mailman/listinfo/users

    > 

    >      

    > 

    > 

    > 

    > 

    > _______________________________________________

    > Users mailing list

    > Users at lists.opensips.org

    > http://lists.opensips.org/cgi-bin/mailman/listinfo/users

    > 

    

    -- 

    Răzvan Crainea

    OpenSIPS Core Developer

       http://www.opensips-solutions.com

    

    _______________________________________________

    Users mailing list

    Users at lists.opensips.org

    http://lists.opensips.org/cgi-bin/mailman/listinfo/users

    






More information about the Users mailing list