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
