[OpenSIPS-Devel] [opensips] Efficient way to match db query without building it every time a function is triggered (#468)
The problem here is: can opensips query efficiently match another query, without really building it? If so, per table contexts can be held, and in some cases a prepared statement can be used in order to bind to it query values --- Reply to this email directly or view it on GitHub: https://github.com/OpenSIPS/opensips/issues/468___ Devel mailing list Devel@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/devel
Re: [OpenSIPS-Devel] [opensips] Efficient way to match db query without building it every time a function is triggered (#468)
Not sure if you mean attempting to cache query results in the event of another identical query? If so, you would just need to key the results to say, the MD5 hash of the SQL query --- Reply to this email directly or view it on GitHub: https://github.com/OpenSIPS/opensips/issues/468#issuecomment-93938861___ Devel mailing list Devel@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/devel
[OpenSIPS-Devel] [opensips] Message format error for rtpproxy timeout notification (#469)
Having configured the rtpproxy module based on the instructions (here: http://opensips.com.br/wiki/index.php?title=Oopensips_Nat_script_with_RTPPROXY_-_English) with the addition of a unix socket for timeout notification When a timeout occurs, the notification is sent to opensips which results a format error. ``` Apr 17 13:51:50 sip2 rtpproxy[7194]: INFO:process_rtp:0lwTwepnRcMCQaFcHCR5Qn1YwTAO0jKx: session timeout Apr 17 13:51:50 sip2 /usr/sbin/opensips[7359]: DBG:rtpproxy:timeout_listener_process: Timeout detected on call [1#012] Apr 17 13:51:50 sip2 /usr/sbin/opensips[7359]: ERROR:rtpproxy:timeout_listener_process: Wrong formated message received from rtpproxy [1] Apr 17 13:51:50 sip2 rtpproxy[7194]: INFO:remove_session:0lwTwepnRcMCQaFcHCR5Qn1YwTAO0jKx: RTP stats: 918 in from callee, 1428 in from caller, 2346 relayed, 0 dropped Apr 17 13:51:50 sip2 rtpproxy[7194]: INFO:remove_session:0lwTwepnRcMCQaFcHCR5Qn1YwTAO0jKx: RTCP stats: 4 in from callee, 8 in from caller, 12 relayed, 0 dropped Apr 17 13:51:50 sip2 rtpproxy[7194]: INFO:remove_session:0lwTwepnRcMCQaFcHCR5Qn1YwTAO0jKx: session on ports 12154/16986 is cleaned up ``` This has been tested with opensips 1.11.3 (LTS) and opensips 2.0rc1 each against rtpproxy 1.2 and rtpproxy 2.0.0, all built from source. rtpproxy command line: ``` rtpproxy -i -T 10 -s 'unix:/var/run/opensips/rtpproxy.sock' -n 'unix:/var/run/opensips/rtpproxy_notify.sock' -l server public ip -m 1 -M 2 -d 'DBUG' -u opensips:opensips ``` opensips config section: ``` loadmodule nathelper.so loadmodule dialog.so loadmodule rtpproxy.so modparam(nathelper, natping_interval, 10) modparam(nathelper, ping_nated_only, 1) modparam(nathelper, received_avp, $avp(received_nh)) modparam(rtpproxy, rtpproxy_sock, unix:/var/run/opensips/rtpproxy.sock) modparam(nathelper,force_socket, unix:/var/run/opensips/rtpproxy.sock) modparam(rtpproxy, rtpp_notify_socket, unix:/var/run/opensips/rtpproxy_notify.sock) ``` --- Reply to this email directly or view it on GitHub: https://github.com/OpenSIPS/opensips/issues/469___ Devel mailing list Devel@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/devel
[OpenSIPS-Devel] [OpenSIPS/opensips] bfde3a: Updated control scripts to include considerations ...
Branch: refs/heads/master Home: https://github.com/OpenSIPS/opensips Commit: bfde3a3504b46aac93b31651ee92029adad339e2 https://github.com/OpenSIPS/opensips/commit/bfde3a3504b46aac93b31651ee92029adad339e2 Author: Jarrod Baumann jar...@unixc.org Date: 2015-04-16 (Thu, 16 Apr 2015) Changed paths: M Makefile M scripts/opensipsctl M scripts/opensipsctl.sqlite M scripts/opensipsctlrc M scripts/opensipsdbctl.sqlite M scripts/osipsconsolerc Log Message: --- Updated control scripts to include considerations for the new db_sqlite Commit: 5b557d081cf11cebf4fe87938be140c07e5af44e https://github.com/OpenSIPS/opensips/commit/5b557d081cf11cebf4fe87938be140c07e5af44e Author: Jarrod Baumann jar...@unixc.org Date: 2015-04-16 (Thu, 16 Apr 2015) Changed paths: M scripts/osipsconsolerc Log Message: --- updated osipsconsolerc to match the opensipsctlrc header for the DBENGINE definition Commit: 060643557e7699354fd4fea3ee72735ee72c1b0b https://github.com/OpenSIPS/opensips/commit/060643557e7699354fd4fea3ee72735ee72c1b0b Author: Jarrod Baumann jar...@unixc.org Date: 2015-04-16 (Thu, 16 Apr 2015) Changed paths: M Makefile Log Message: --- Fixed Makefile script sqlite references that move the database related files into the library path Commit: 40308f9be1c5984ad032ab9681b6ed5dfd06196e https://github.com/OpenSIPS/opensips/commit/40308f9be1c5984ad032ab9681b6ed5dfd06196e Author: Jarrod Baumann jar...@unixc.org Date: 2015-04-16 (Thu, 16 Apr 2015) Changed paths: M scripts/opensipsctl Log Message: --- Reset default /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin references back to original script (had copied from an already installed file) Commit: a97d3573bef58c0f15874ed1213297531587adb2 https://github.com/OpenSIPS/opensips/commit/a97d3573bef58c0f15874ed1213297531587adb2 Author: ionutrazvanionita ionution...@opensips.org Date: 2015-04-17 (Fri, 17 Apr 2015) Changed paths: M scripts/opensipsdbctl Log Message: --- modified and tested sqlite opensipsdbctl create, drop, reinit backup, restore, copy Commit: a32b92a7c44c594a40ffc707f59a4cd3c5bb7505 https://github.com/OpenSIPS/opensips/commit/a32b92a7c44c594a40ffc707f59a4cd3c5bb7505 Author: ionutrazvanionita ionution...@opensips.org Date: 2015-04-17 (Fri, 17 Apr 2015) Changed paths: M Makefile M scripts/opensipsctl M scripts/opensipsctl.sqlite M scripts/opensipsctlrc M scripts/opensipsdbctl M scripts/opensipsdbctl.sqlite M scripts/osipsconsolerc Log Message: --- Merge branch 'jarrodb-sqlite' Compare: https://github.com/OpenSIPS/opensips/compare/24341a06cd18...a32b92a7c44c___ Devel mailing list Devel@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/devel
Re: [OpenSIPS-Devel] [opensips] sqlite opensipsctl and opensipsdbctl additions (#467)
Merged #467. --- Reply to this email directly or view it on GitHub: https://github.com/OpenSIPS/opensips/pull/467#event-283815577___ Devel mailing list Devel@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/devel
Re: [OpenSIPS-Devel] [opensips] Efficient way to match db query without building it every time a function is triggered (#468)
@rgagnon24 It's not about the results. It's about matching ,somehow, efficiently, the keys and values which you receive to build a query, to match something like a list of prepared statement queries, so you won't need to build a new one. --- Reply to this email directly or view it on GitHub: https://github.com/OpenSIPS/opensips/issues/468#issuecomment-93961116___ Devel mailing list Devel@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/devel
[OpenSIPS-Devel] [opensips] ERROR:proto_tls:_tls_read: SYSCALL error - (0) Success (#470)
Using master from commit 24341a06cd18ed32f4d818729122e154e7db520f I am getting odd error logs from the TLS module. Apr 17 11:04:08 alpha /usr/local/sbin/opensips[18512]: ERROR:proto_tls:_tls_read: SYSCALL error - (0) Success Apr 17 11:04:08 alpha /usr/local/sbin/opensips[18512]: ERROR:proto_tls:_tls_read: TLS connection to 50.198.204.238:42846 read failed Apr 17 11:04:08 alpha /usr/local/sbin/opensips[18512]: ERROR:proto_tls:_tls_read: TLS read error: 5 --- Reply to this email directly or view it on GitHub: https://github.com/OpenSIPS/opensips/issues/470___ Devel mailing list Devel@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/devel