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 » <users-bounces at lists.opensips.org au nom de alain.bieuzent at free.fr> 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 » <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
_______________________________________________
Users mailing list
Users at lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users