[OpenSIPS-Users] Load Balancer Issue

2012-10-21 Thread Nilanjan Banerjee
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

2012-10-21 Thread Bogdan-Andrei Iancu

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

2012-10-21 Thread Bogdan-Andrei Iancu

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?

2012-10-21 Thread Bogdan-Andrei Iancu

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

2012-10-21 Thread Bogdan-Andrei Iancu

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

2012-10-21 Thread Bogdan-Andrei Iancu

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