Hi Razvan,
are you sure this new support of provisioning via DB is supported by tools "opensipctldb create", because new table "rtpengine" does not exist when I create a new database from scratch. thanks https://github.com/OpenSIPS/opensips/commit/094c850dd91286ff75bf3463dafbf83a398aaf8f Le 12/07/2018 11:58, « Users au nom de Alain Bieuzent » <[email protected] au nom de [email protected]> a écrit : 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 » <[email protected] au nom de [email protected]> 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 » <[email protected] au nom de [email protected]> 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 » <[email protected] au nom de [email protected]> 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 <[email protected]> au nom de Alain Bieuzent > > > > > > > <[email protected]> > > > > > > > *Répondre à : *OpenSIPS users mailling list <[email protected]> > > > > > > > *Date : *vendredi 6 juillet 2018 à 14:06 > > > > > > > *À : *Pasan Meemaduma <[email protected]>, OpenSIPS users mailling list > > > > > > > <[email protected]> > > > > > > > *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 <[email protected]> au nom de Pasan > > > > > > > Meemaduma via Users <[email protected]> > > > > > > > *Répondre à : *Pasan Meemaduma <[email protected]>, OpenSIPS users > > > > > > > mailling list <[email protected]> > > > > > > > *Date : *vendredi 6 juillet 2018 à 12:23 > > > > > > > *À : *OpenSIPS users mailling list <[email protected]> > > > > > > > *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 > > > > > > > <[email protected]> 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 > > > > > > > [email protected] <mailto:[email protected]> > > > > > > > http://lists.opensips.org/cgi-bin/mailman/listinfo/users > > > > > > > > > > > > > > _______________________________________________ Users mailing list > > > > > > > [email protected] > > > > > > > http://lists.opensips.org/cgi-bin/mailman/listinfo/users > > > > > > > > > > > > > > _______________________________________________ Users mailing list > > > > > > > [email protected] > > > > > > > http://lists.opensips.org/cgi-bin/mailman/listinfo/users > > > > > > > > > > > > > > > > > > > > > > > > > > > > _______________________________________________ > > > > > > > Users mailing list > > > > > > > [email protected] > > > > > > > http://lists.opensips.org/cgi-bin/mailman/listinfo/users > > > > > > > > > > > > > > > > > > > -- > > > > > > Răzvan Crainea > > > > > > OpenSIPS Core Developer > > > > > > http://www.opensips-solutions.com > > > > > > > > > > > > _______________________________________________ > > > > > > Users mailing list > > > > > > [email protected] > > > > > > http://lists.opensips.org/cgi-bin/mailman/listinfo/users > > > > > > > > > > > > > > > > > > > > > _______________________________________________ > > > Users mailing list > > > [email protected] > > > http://lists.opensips.org/cgi-bin/mailman/listinfo/users > > > > > > > -- > > Răzvan Crainea > > OpenSIPS Core Developer > > http://www.opensips-solutions.com > > > > _______________________________________________ > > Users mailing list > > [email protected] > > http://lists.opensips.org/cgi-bin/mailman/listinfo/users > > > > > > > _______________________________________________ > Users mailing list > [email protected] > http://lists.opensips.org/cgi-bin/mailman/listinfo/users > -- Răzvan Crainea OpenSIPS Core Developer http://www.opensips-solutions.com _______________________________________________ Users mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/users _______________________________________________ Users mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/users _______________________________________________ Users mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/users
