[OpenSIPS-Users] Load Balancer Issue
Hello, I am trying to build the following setup using OpenSIPS load balancer and the proxy functionality: Client 1 (sipp) OpenSIPS Load Balancer OpenSIPS Proxy Client 2 (sipp) At the client ends I am using the following commands: Client 1: sipp -sn uac -rsa [Load Balancer Address] [Client 2 Address] Client 2: sipp -sn uas The Load Balancer is configured with a destination as the OpenSIPS Proxy and the Proxy is configured to simply forward the SIP messages based on IP address (using only forward(); in the routing block). Now everything (INVITE, OK and ACK messages) works fine except the BYE messages that are getting forwarded by the Load Balancer directly to Client 2 unlike the INVITE, OK and ACK messages that traverse the Proxy. Client 2 however, sends the OK to the BYE to the OpenSIPS Proxy. Since the BYE messages do not traverse the Proxy, the OK to the BYE messages are getting retransmitted repeatedly by Client 2 and the sessions are not getting terminated properly. How do I make the BYE messages to go through the Proxy or the OK message sent directly to the Load Balancer so that the retransmissions do not happen and the sessions get terminated properly? [NB: When the Load Balancer is taken out of the loop and the Proxy configuration is kept the same, all the SIP messages traverses the Proxy and everything works fine i.e., the BYE and the OKs to the BYEs are handled properly and sessions get terminated properly.] Would greatly appreciate any help in this matter. Thanks in advance. Nil. ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Re: [OpenSIPS-Users] Manage usr_preferences by OCP
Hi, Use the TViewer tool to be able to manage that table - the TViewer (Table Viewer) is a tool for operating on generic tables. Regards, Bogdan-Andrei Iancu OpenSIPS Founder and Developer http://www.opensips-solutions.com On 10/20/2012 04:50 PM, Engineer voip wrote: Hello, Can we integrate usr_preferences table in OCP to manage it ? -- Best Regards. ___ 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] Load Balancer Issue
Hi Nil, I wild guess is you are not correctly do loose_route on the LB, so instead of following the Route (to OpenSIPS Proxy), it goes directly to end destination in RURI (Client 2). Of course, I assume that all parties (LB + Proxy) do record_route() for the call, right ? Regards, Bogdan-Andrei Iancu OpenSIPS Founder and Developer http://www.opensips-solutions.com On 10/21/2012 10:09 AM, Nilanjan Banerjee wrote: Hello, I am trying to build the following setup using OpenSIPS load balancer and the proxy functionality: Client 1 (sipp) OpenSIPS Load Balancer OpenSIPS Proxy Client 2 (sipp) At the client ends I am using the following commands: Client 1: sipp -sn uac -rsa [Load Balancer Address] [Client 2 Address] Client 2: sipp -sn uas The Load Balancer is configured with a destination as the OpenSIPS Proxy and the Proxy is configured to simply forward the SIP messages based on IP address (using only forward(); in the routing block). Now everything (INVITE, OK and ACK messages) works fine except the BYE messages that are getting forwarded by the Load Balancer directly to Client 2 unlike the INVITE, OK and ACK messages that traverse the Proxy. Client 2 however, sends the OK to the BYE to the OpenSIPS Proxy. Since the BYE messages do not traverse the Proxy, the OK to the BYE messages are getting retransmitted repeatedly by Client 2 and the sessions are not getting terminated properly. How do I make the BYE messages to go through the Proxy or the OK message sent directly to the Load Balancer so that the retransmissions do not happen and the sessions get terminated properly? [NB: When the Load Balancer is taken out of the loop and the Proxy configuration is kept the same, all the SIP messages traverses the Proxy and everything works fine i.e., the BYE and the OKs to the BYEs are handled properly and sessions get terminated properly.] Would greatly appreciate any help in this matter. Thanks in advance. Nil. ___ 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] how to set $var(name) in opensips.cfg?
Hi, Not sure I understand what you want to achieve here :(. Could you detail a bit... Regards, Bogdan-Andrei Iancu OpenSIPS Founder and Developer http://www.opensips-solutions.com On 10/19/2012 02:05 PM, spady wrote: Hi Bogdan, I am trying to do the same thing but what if in my script I have different destination uri? Ex. if ... route(2); if route(3); ... the pv $du could be only one, for instance, $du = $var(new_uri); and NOT *$du1 = $var(new_uri); $du2 = $var(new_uri);* Am I wrong? Regards -- View this message in context: http://opensips-open-sip-server.1449251.n2.nabble.com/how-to-set-var-name-in-opensips-cfg-tp4796408p7582396.html Sent from the OpenSIPS - Users mailing list archive at Nabble.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] Error Commands out of sync; you can't run this command now
Hi David, There were several fixes, mainly related to error handling. Now, considering that the DB connections are shared between modules (inside the same process), maybe the faulty module was not the presence, but in other module. Anyhow 1.4 is really ancient version and not officially supported at all, so I strongly suggest to move on with a newer version. Regards, Bogdan-Andrei Iancu OpenSIPS Founder and Developer http://www.opensips-solutions.com On 10/19/2012 07:36 AM, David Cunningham wrote: Hi Vlad, This was on OpenSIPS 1.4.5, so pretty old. It was a once-in-a-year event so I'm not sure if we're going to be able to do any useful debugging on this system unfortunately. Does 1.8 have a known fix for this error? Thank you. On 17 October 2012 22:36, Vlad Paiu vladp...@opensips.org mailto:vladp...@opensips.org wrote: Hello, What version of OpenSIPS are you using ? Can you please upgrade to 1.8 and see if the problem still appears ? Still, this seems like a recurring issue ( already being reported by multiple people ), so I'll send you a patch that will help in debugging such issues. Regards, Vlad Paiu OpenSIPS Developer http://www.opensips-solutions.com On 10/15/2012 02:46 AM, David Cunningham wrote: Hello, We recently experienced a database error Commands out of sync; you can't run this command now. I understand this is a known issue with presence. Can anyone advise what version it was fixed in? Thank you! Oct 12 10:34:01 myhost /sbin/opensips[10735]: ERROR:db_mysql:db_mysql_submit_query: driver error on query: Commands out of sync; you can't run this command now Oct 12 10:34:01 myhost /sbin/opensips[10735]: ERROR:core:db_do_query: error while submitting query Oct 12 10:34:01 myhost /sbin/opensips[10735]: ERROR:auth_db:get_ha1: failed to query database -- David Cunningham, Voisonics http://voisonics.com/ USA: +1 213 221 1092 tel:%2B1%20213%20221%201092 UK: +44 (0) 20 3298 1642 tel:%2B44%20%280%29%2020%203298%201642 Australia: +61 (0) 2 8063 9019 tel:%2B61%20%280%29%202%208063%209019 ___ Users mailing list Users@lists.opensips.org mailto:Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users ___ Users mailing list Users@lists.opensips.org mailto:Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users -- David Cunningham, Voisonics http://voisonics.com/ USA: +1 213 221 1092 UK: +44 (0) 20 3298 1642 Australia: +61 (0) 2 8063 9019 ___ 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] Problem with sip_trace
Salut Dragomir, This is because you set the user id AVP for tracing. If you look into DB, you will see that one record is without trace_user and one with trace_user. If you do not set the trace_user AVP, you will get a single record. Regards, Bogdan-Andrei Iancu OpenSIPS Founder and Developer http://www.opensips-solutions.com On 10/19/2012 12:10 AM, Dragomir Haralambiev wrote: Hello all, I see global problem when use sip_trace module. In sip_trace table is apear doble records. One traced_user is empty and otder traced_user=trace_number. Opensips: 1.8.1 Revision 9342 Here is opensips.cfg: modparam(siptrace, db_url, mysql://user:password@localhost/opensips) modparam(siptrace, trace_on, 1) modparam(siptrace, enable_ack_trace, 1) modparam(siptrace, traced_user_avp, $avp(trace_id)) .. if (is_method(INVITE)) { . receive $avp(trace_id) from radius_send_auth ... if ( $avp(trace_id) ) { xlog(L_ERR, Trace ON. Trace_id=$avp(trace_id)\n); sip_trace(); } . } Here is openlisp log: sbin/opensips[2191]: Trace ON. Trace_id=8 sbin/opensips[2191]: DBG:core:parse_headers: flags=40 sbin/opensips[2191]: *DBG:siptrace:sip_trace: sip_trace called* sbin/opensips[2191]: DBG:siptrace:save_siptrace: saving siptrace sbin/opensips[2191]: DBG:siptrace:insert_siptrace_flag: storing info 1... sbin/opensips[2191]: DBG:db_mysql:has_stmt_ctx: ctx found for sip_trace sbin/opensips[2191]: DBG:db_mysql:db_mysql_do_prepared_query: conn=0x7f277f5fc4b8 (tail=139807617425128) MC=0x7f277f5f9f48 sbin/opensips[2191]: DBG:db_mysql:db_mysql_do_prepared_query: set values for the statement run sbin/opensips[2191]: DBG:db_mysql:db_mysql_val2bind: added val (0): len=905; type=252; is_null=0 sbin/opensips[2191]: DBG:db_mysql:db_mysql_val2bind: added val (1): len=44; type=254; is_null=0 sbin/opensips[2191]: DBG:db_mysql:db_mysql_val2bind: added val (2): len=6; type=254; is_null=0 sbin/opensips[2191]: DBG:db_mysql:db_mysql_val2bind: added val (3): len=0; type=254; is_null=0 sbin/opensips[2191]: DBG:db_mysql:db_mysql_val2bind: added val (4): len=23; type=254; is_null=0 sbin/opensips[2191]: DBG:db_mysql:db_mysql_val2bind: added val (5): len=23; type=254; is_null=0 sbin/opensips[2191]: DBG:db_mysql:db_mysql_val2bind: added val (6): len=40; type=12; is_null=0 sbin/opensips[2191]: DBG:db_mysql:db_mysql_val2bind: added val (7): len=2; type=254; is_null=0 sbin/opensips[2191]: DBG:db_mysql:db_mysql_val2bind: added val (8): len=8; type=254; is_null=0 sbin/opensips[2191]: DBG:db_mysql:db_mysql_val2bind: added val (9): len=0; type=254; is_null=0 sbin/opensips[2191]: DBG:db_mysql:db_mysql_do_prepared_query: doing BIND_PARAM in... sbin/opensips[2191]: DBG:siptrace:insert_siptrace_avp: int val [8] sbin/opensips[2191]: DBG:siptrace:insert_siptrace_avp: storing info 14... sbin/opensips[2191]: DBG:db_mysql:has_stmt_ctx: ctx found for sip_trace sbin/opensips[2191]: DBG:db_mysql:db_mysql_do_prepared_query: conn=0x7f277f5fc4b8 (tail=139807617425128) MC=0x7f277f5f9f48 sbin/opensips[2191]: DBG:db_mysql:db_mysql_do_prepared_query: set values for the statement run sbin/opensips[2191]: DBG:db_mysql:db_mysql_val2bind: added val (0): len=905; type=252; is_null=0 sbin/opensips[2191]: DBG:db_mysql:db_mysql_val2bind: added val (1): len=44; type=254; is_null=0 sbin/opensips[2191]: DBG:db_mysql:db_mysql_val2bind: added val (2): len=6; type=254; is_null=0 sbin/opensips[2191]: DBG:db_mysql:db_mysql_val2bind: added val (3): len=0; type=254; is_null=0 sbin/opensips[2191]: DBG:db_mysql:db_mysql_val2bind: added val (4): len=23; type=254; is_null=0 sbin/opensips[2191]: DBG:db_mysql:db_mysql_val2bind: added val (5): len=23; type=254; is_null=0 sbin/opensips[2191]: DBG:db_mysql:db_mysql_val2bind: added val (6): len=40; type=12; is_null=0 sbin/opensips[2191]: DBG:db_mysql:db_mysql_val2bind: added val (7): len=2; type=254; is_null=0 sbin/opensips[2191]: DBG:db_mysql:db_mysql_val2bind: added val (8): len=8; type=254; is_null=0 sbin/opensips[2191]: DBG:db_mysql:db_mysql_val2bind: added val (9): len=1; type=254; is_null=0 Best regards, PlayMen ___ 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