Re: [OpenSIPS-Users] Integrating with Asterisk in the same box
Thanks for your reply. Since i am stuck in the integration of Opensips with Asterisk how do i proceed then? If i create a user to Opensips, do i have to create the same user to Asterisk as well? On Monday, April 22, 2019, Liviu Chircu wrote: > Hi all. I have an installation of opensips 2.4 with control panel, in a >> Debian 8 server. >> I would like to integrate my Opensips installation with an Asterisk 16. >> For the time being it has to be in the same box. So it would enhance with >> Incoming/outgoing Trunks, IVR, Voicemail, Conference,etc. >> The system at the moment has this setup >> https://www.powerpbx.org/content/opensips-v24-debian-v8-mariadb-apache-v1 >> and i have installed a simple asterisk (Chan_SIP) as simple as possible, >> without anything fancy. As an example of the Asterisk config i used the >> guide >> https://computingforgeeks.com/how-to-install-asterisk-16-lts >> -on-ubuntu-18-04-16-04-debian-9/. >> I have left the default 5060 port to Opensips and the port 5090 to >> Asterisk. >> > So far, so good. OpenSIPS in front, Asterisk in the back -- you're on the > right path. > >> I am looking what other config do i have to do, so i could create users >> in the Opensips control panel and created automatically in the Asterisk's >> database to read from. >> Also what other do i have to do to make them interact seamlessly, please? >> > Here is when it gets dicy -- there is no such software available yet. In > order to achieve this, one idea would be to fork the Control Panel and > start hacking away at extending it in order to also work with Asterisk > (additional GUI interactions? additional server-side PHP logic for the > Asterisk DB handling? > > ___ > Users mailing list > Users@lists.opensips.org > http://lists.opensips.org/cgi-bin/mailman/listinfo/users > ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] Integrating with Asterisk in the same box
On 22.04.2019 10:04, John Tuxies wrote: Thanks for your reply. Since i am stuck in the integration of Opensips with Asterisk how do i proceed then? If i create a user to Opensips, do i have to create the same user to Asterisk as well? It much depends on the setup that you want to achieve. For example, if you're just using OpenSIPS as a means to scale out, then you can keep it dumber and have users strictly reside on Asterisk, which will do all authentication. Liviu Chircu OpenSIPS Developer http://www.opensips-solutions.com ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] Integrating with Asterisk in the same box
i am looking to have a single box where asterisk and opensips live side by side, but in different ports. Opensips will be in port 5060 and everybody will register to Opensips, while Asterisk will be in a different port and have all the services. The available services on asterisk will be conference, voicemail, sip trunks, etc. This is what i am trying to do and i am lost with the configuration. On Mon, Apr 22, 2019 at 10:54 AM Liviu Chircu wrote: > On 22.04.2019 10:04, John Tuxies wrote: > > Thanks for your reply. Since i am stuck in the integration of Opensips > > with Asterisk how do i proceed then? > > If i create a user to Opensips, do i have to create the same user to > > Asterisk as well? > > It much depends on the setup that you want to achieve. For example, if > you're just using OpenSIPS as a means to scale out, then you can keep it > dumber and have users strictly reside on Asterisk, which will do all > authentication. > > Liviu Chircu > OpenSIPS Developer > http://www.opensips-solutions.com > > > ___ > Users mailing list > Users@lists.opensips.org > http://lists.opensips.org/cgi-bin/mailman/listinfo/users > ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] Integrating with Asterisk in the same box
Hello John, have you read this tutorial? https://www.opensips.org/Documentation/Tutorials-OpenSIPSAsteriskIntegration-1-8 I hope it has a plenty of information you need. --- BR, Alexey http://alexeyka.zantsev.com/ ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] Integrating with Asterisk in the same box
This is the first thing that i started with. Tried it in opensips 2.4 with asterisk 16 but it messed all the db schemas in Mysql. Updates on this page to newer versions it will help a lot On Monday, April 22, 2019, Alexey Kazantsev via Users < users@lists.opensips.org> wrote: > Hello John, > > have you read this tutorial? > https://www.opensips.org/Documentation/Tutorials- > OpenSIPSAsteriskIntegration-1-8 > > I hope it has a plenty of information you need. > > --- > BR, Alexey > http://alexeyka.zantsev.com/ > ___ > Users mailing list > Users@lists.opensips.org > http://lists.opensips.org/cgi-bin/mailman/listinfo/users > ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] Integrating with Asterisk in the same box
How can it mess up your dns? It’s supposed to be in its own DB. Did you put it all (asterisk and opensips) in the same dB schema? On Mon, 22 Apr 2019 at 12:08, John Tuxies wrote: > This is the first thing that i started with. Tried it in opensips 2.4 with > asterisk 16 but it messed all the db schemas in Mysql. Updates on this page > to newer versions it will help a lot > > > > On Monday, April 22, 2019, Alexey Kazantsev via Users < > users@lists.opensips.org> wrote: > >> Hello John, >> >> have you read this tutorial? >> >> https://www.opensips.org/Documentation/Tutorials-OpenSIPSAsteriskIntegration-1-8 >> >> I hope it has a plenty of information you need. >> >> --- >> BR, Alexey >> http://alexeyka.zantsev.com/ >> ___ >> Users mailing list >> Users@lists.opensips.org >> http://lists.opensips.org/cgi-bin/mailman/listinfo/users >> > ___ > Users mailing list > Users@lists.opensips.org > http://lists.opensips.org/cgi-bin/mailman/listinfo/users > -- Regards, David Villasmil email: david.villasmil.w...@gmail.com phone: +34669448337 ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] OpenSIPS 2.4.5 stops responding
I noticed also that these errors appear in log suddenly, maybe this is the cause of OpenSIPS restart? But I haven't examined SIP traffic yet. Just watch the logs. ERROR:core:forward_reply: no 2nd via found in reply --- BR, Alexey http://alexeyka.zantsev.com/ ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] OpenSIPS 2.4.5 stops responding
I noticed also that these errors appear in log suddenly, maybe this is the cause of OpenSIPS restart? But I haven't examined SIP traffic yet. Just watch the logs. ERROR:core:forward_reply: no 2nd via found in reply --- BR, Alexey http://alexeyka.zantsev.com/ ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] OpenSIPS 2.4.5 stops responding
Guys helped me to find, but still any ideas are welcome https://opensips.org/pipermail/users/2008-December/001872.html --- BR, Alexey http://alexeyka.zantsev.com/ ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] OpenSIPS 2.4.5 stops responding
And warnings related to memory... WARNING:core:init_reactor_size: shrinking reactor size from 262144 (autodetected via rlimit) to 13107 (limited by memory of 10% from 4Mb) WARNING:core:init_reactor_size: use 'open_files_limit' to enforce other limit or increase pkg memory --- BR, Alexey http://alexeyka.zantsev.com/ ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
[OpenSIPS-Users] opensips-cp 8.2.4 MI page and drop-down Servers
Hi people,Recently I did a git clone of cp for opensips 2.4.x and setup for just one server with MI conn via json. In order to be successfull in the connection my collegue Frederico helped me and did a workaround in ... mi/lib/functions.inc.php. In function show_boxes it was included before foreach statement:if ( empty( $_SESSION['mi_current_box'] ) ) echo '- select -';Maybe others have already passed into the same problem. I don't know if there's a better way to do it.Thanks and Best RegardsAlbary - Celepar ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] Working with a dataset larger than dialplan will load.
Thanks guys, I was moving down the path of using redis as an alternative to the dialplan module and it sounds like that is the right direction to go. Liviu, There were not any additional errors, I'll see if I saved a copy of the VM I was exploring using dialplan on and look at the MySQL side of things. On Sun, Apr 21, 2019 at 11:51 PM Liviu Chircu wrote: > I second this -- strictly discussing implementation, dialplan performs a > simple (and costly) iteration over up-to-all matching rules for each > lookup, while drouting builds an internal trie structure which will > dramatically improve lookup latencies. > > Still, regarding the original problem: are there no additional errors > which may be relevant? If yes, then you may have a MySQL server > configuration issue (notice how it's not able to return the data). Tuning > settings like "max_allowed_packet" might fix this. > > Liviu Chircu > OpenSIPS Developerhttp://www.opensips-solutions.com > > On 17.04.2019 15:59, Jon Abrams wrote: > > If that's the LCAD or LERG databases, I'd put the data in Redis and query > that. That will give you faster startup times, and won't add much of any > noticeable latency. > > Alternatively you could try to do something with the drouting module, > which is designed for very large data sets. > > - Jon Abrams > > On Mon, Apr 8, 2019 at 12:58 PM John Kiniston > wrote: > >> Good Morning, >> >> I am attempting to use dialplan to lookup rate centers on dialed calls to >> determine if a caller is dialing outside it's local area. >> >> If I attempt to use the full data set with 167424 rows opensips fails to >> start with a failure to query the database. >> >> When I use a smaller data set of only 500 rows I'm able to start opensips >> without errors. >> >> I'm not seeing the query time out, if I run the query by hand I get >> results back from MySQL? >> >> Is there a different module I should be attempting to do this with? I was >> planning to look up the NPANXX pairing for the source and destination of >> the call and check against the attrs column where I stored the ratecenter. >> >> >> pr 8 13:37:50 federated-sip /sbin/opensips[4666]: >> INFO:db_mysql:connect_with_retry: re-connected successful for >> 0x7f33bef25a18 >> Apr 8 13:37:50 federated-sip /sbin/opensips[4666]: >> DBG:db_mysql:mysql_raise_event: MySQL status has not changed: connected >> Apr 8 13:37:50 federated-sip /sbin/opensips[4666]: >> CRITICAL:db_mysql:db_mysql_submit_query: too many mysql server reconnection >> failures >> Apr 8 13:37:50 federated-sip /sbin/opensips[4666]: >> ERROR:core:db_do_query: error while submitting query - [select >> dpid,pr,match_op,match_exp,match_flags,subst_exp,repl_exp,attrs,timerec >> from dialplan where disabled=0 order by pr] >> Apr 8 13:37:50 federated-sip /sbin/opensips[4666]: >> ERROR:dialplan:dp_load_db: failed to query database! >> Apr 8 13:37:50 federated-sip /sbin/opensips[4666]: >> ERROR:dialplan:dp_load_all_db: unable to load dialplan table >> Apr 8 13:37:50 federated-sip /sbin/opensips[4666]: >> ERROR:dialplan:mi_reload_rules: failed to reload database >> Apr 8 13:39:44 federated-sip /sbin/opensips[4666]: >> DBG:mi_fifo:mi_parse_tree: adding node <> ; val <9> >> Apr 8 13:39:44 federated-sip /sbin/opensips[4666]: >> DBG:mi_fifo:mi_parse_node: end of input tree >> Apr 8 13:39:44 federated-sip /sbin/opensips[4666]: >> DBG:mi_fifo:mi_fifo_server: done parsing the mi tree >> Apr 8 13:39:57 federated-sip /sbin/opensips[4666]: >> DBG:mi_fifo:mi_parse_node: end of input tree >> Apr 8 13:39:57 federated-sip /sbin/opensips[4666]: >> DBG:mi_fifo:mi_fifo_server: done parsing the mi tree >> Apr 8 13:39:59 federated-sip /sbin/opensips[4666]: >> INFO:db_mysql:switch_state_to_disconnected: disconnect event for >> 0x7f33bef25a18 >> Apr 8 13:39:59 federated-sip /sbin/opensips[4666]: >> INFO:db_mysql:reset_all_statements: resetting all statements on >> connection: (0x7f33bef26538) 0x7f33bef25a18 >> Apr 8 13:39:59 federated-sip /sbin/opensips[4666]: >> DBG:db_mysql:db_mysql_connect: opening connection: mysql:// >> :@172.16.52.35/opensips >> Apr 8 13:39:59 federated-sip /sbin/opensips[4666]: >> DBG:db_mysql:db_mysql_connect: connection type is 172.16.52.35 via TCP/IP >> Apr 8 13:39:59 federated-sip /sbin/opensips[4666]: >> DBG:db_mysql:db_mysql_connect: protocol version is 10 >> Apr 8 13:39:59 federated-sip /sbin/opensips[4666]: >> DBG:db_mysql:db_mysql_connect: server version is 5.5.60-MariaDB >> Apr 8 13:39:59 federated-sip /sbin/opensips[4666]: >> INFO:db_mysql:connect_with_retry: re-connected successful for >> 0x7f33bef25a18 >> Apr 8 13:40:01 federated-sip /sbin/opensips[4666]: >> INFO:db_mysql:switch_state_to_disconnected: disconnect event for >> 0x7f33bef25a18 >> Apr 8 13:40:01 federated-sip /sbin/opensips[4666]: >> INFO:db_mysql:reset_all_statements: resetting all statements on >> connection: (0x7f33bef26538) 0x7f33bef25a18 >> Apr 8 13:40:01 federated-sip /sbin/opensips[4666]: >> DBG:db_mysql:db_mysql
Re: [OpenSIPS-Users] opensips-cp 8.2.4 MI page and drop-down Servers
Hello Albary, You if you have a single OpenSIPS box configured into boxes file, the drop-down in the MI tool does not work by default ? Regards, Bogdan-Andrei Iancu OpenSIPS Founder and Developer https://www.opensips-solutions.com OpenSIPS Summit 2019 https://www.opensips.org/events/Summit-2019Amsterdam/ On 04/22/2019 04:51 PM, Albary Franco Pimpao Junior wrote: Hi people, Recently I did a git clone of cp for opensips 2.4.x and setup for just one server with MI conn via json. In order to be successfull in the connection my collegue Frederico helped me and did a workaround in ... mi/lib/functions.inc.php. In function show_boxes it was included before foreach statement: if ( empty( $_SESSION['mi_current_box'] ) ) echo '- select -'; Maybe others have already passed into the same problem. I don't know if there's a better way to do it. Thanks and Best Regards Albary - Celepar ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users