Re: [OpenSIPS-Users] udp send fail randomly

[Govindaraj, Rajesh]

Is this simultaneous sending the cause for the issue? Just thinking aloud. It 
is happening at only one installation and never in lab systems, which makes me 
think if it is a timing issue.

From: Govindaraj, Rajesh
Sent: Saturday, May 05, 2018 8:17 PM
To: 'users@lists.opensips.org' 
Cc: 'pasan...@ymail.com' 
Subject: Re: [OpenSIPS-Users] udp send fail randomly

Thanks Pasan,

The message is sent to standard port 5060.

Two messages are sent simultaneously to the same destination. The first one 
succeeds and second one fails. I will check on connection tracking. You have 
asked me if it is off? It should be off for the problem to not occur right.

Thanks,

Rajeshkumar Govindaraj
Software Engineer
777 Commerce Drive,
Fairfield, CT-06825
T +1 201 253 7803   *   M +1 475 439 9918  *   E 
rajesh.govinda...@ipc.com
Follow us on twitter: @ipc_Systems_Incwww.ipc.com

[cid:image006.jpg@01D1940F.3E021840]




DISCLAIMER: This e-mail may contain information that is confidential, 
privileged or otherwise protected from disclosure. 
If you are not an intended recipient of this e-mail, do not duplicate or 
redistribute it by any means. 
Please delete it and any attachments and notify the sender that you have 
received it in error. 
Unintended recipients are prohibited from taking action on the basis of 
information in this e-mail. 
E-mail messages may contain computer viruses or other defects, may not be 
accurately replicated on other systems, or may be intercepted, 
deleted or interfered with without the knowledge of the sender or the intended 
recipient. 
If you are not comfortable with the risks associated with e-mail messages, 
you may decide not to use e-mail to communicate with IPC. IPC reserves the 
right, 
to the extent and under circumstances permitted by applicable law, 
to retain, monitor and intercept e-mail messages to and from its systems.
___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

Re: [OpenSIPS-Users] udp send fail randomly

[Govindaraj, Rajesh]

Thanks Pasan,

The message is sent to standard port 5060.

Two messages are sent simultaneously to the same destination. The first one 
succeeds and second one fails. I will check on connection tracking. You have 
asked me if it is off? It should be off for the problem to not occur right.

Thanks,

Rajeshkumar Govindaraj
Software Engineer
777 Commerce Drive,
Fairfield, CT-06825
T +1 201 253 7803   *   M +1 475 439 9918  *   E 
rajesh.govinda...@ipc.com
Follow us on twitter: @ipc_Systems_Incwww.ipc.com

[cid:image006.jpg@01D1940F.3E021840]




DISCLAIMER: This e-mail may contain information that is confidential, 
privileged or otherwise protected from disclosure. 
If you are not an intended recipient of this e-mail, do not duplicate or 
redistribute it by any means. 
Please delete it and any attachments and notify the sender that you have 
received it in error. 
Unintended recipients are prohibited from taking action on the basis of 
information in this e-mail. 
E-mail messages may contain computer viruses or other defects, may not be 
accurately replicated on other systems, or may be intercepted, 
deleted or interfered with without the knowledge of the sender or the intended 
recipient. 
If you are not comfortable with the risks associated with e-mail messages, 
you may decide not to use e-mail to communicate with IPC. IPC reserves the 
right, 
to the extent and under circumstances permitted by applicable law, 
to retain, monitor and intercept e-mail messages to and from its systems.
___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

Re: [OpenSIPS-Users] libmariadbclient crashes opensips 2.4

[Schneur Rosenberg]

Bogdan, I downloaded the latest copy from gihub as you suggested, but
I'm still getting the same segfault.


Scot

On Sat, May 5, 2018 at 11:53 AM, Schneur Rosenberg
 wrote:
> Opensips keeps on crashing with the following error
>
> kernel: [64912.190539] opensips[3377]: segfault at 4 ip
> 7fdb8054f2ae sp 7ffc78fd45f0 error 4 in
> libmariadbclient.so.18.0.0[7fdb80524000+37c000]
>
> Below is a bt from the dump file
>
> [New LWP 3377]
> [Thread debugging using libthread_db enabled]
> Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1".
> Core was generated by `/usr/local/sbin/opensips -P
> /var/run/opensips/opensips.pid -m 128 -M 4 -u opens'.
> Program terminated with signal SIGSEGV, Segmentation fault.
> #0  0x7fdb8054f2ae in ?? () from
> /usr/lib/x86_64-linux-gnu/libmariadbclient.so.18
> #0  0x7fdb8054f2ae in ?? () from
> /usr/lib/x86_64-linux-gnu/libmariadbclient.so.18
> No symbol table info available.
> #1  0x7fdb805512ba in mysql_stmt_execute () from
> /usr/lib/x86_64-linux-gnu/libmariadbclient.so.18
> No symbol table info available.
> #2  0x7fdb80b30b59 in wrapper_single_mysql_stmt_execute
> (conn=0x7fdb89247990, stmt=0x55f7f23e6778) at dbase.c:148
> code = 
> error = 
> #3  db_mysql_do_prepared_query (conn=conn@entry=0x7fdb89247990,
> v=v@entry=0x7ffc78fd4990, n=n@entry=1, uv=uv@entry=0x0, un=un@entry=0,
> query=0x7fdb80d4e5e0  i = 
> j = 
> pq_ptr = 0x7fdb89247c90
> ctx = 0x7fdb89247bf0
> mysql_bind = 0x7fdb89247cd0
> start = {tv_sec = 94523385831424, tv_usec = 140580733817260}
> buffered_rows = 0x0
> #4  0x7fdb80b37cd8 in db_mysql_delete (_h=0x7fdb89247990,
> _k=0x7ffc78fd48a0, _o=0x7ffc78fd4890, _v=0x7ffc78fd4990, _n=1) at
> dbase.c:1316
> ret = 
> #5  0x7fdb7ad459c3 in update_db_subs (db=0x7fdb89247990,
> dbf=dbf@entry=0x7fdb7af7bbe0 , hash_table=,
> htable_size=, no_lock=no$
> my_ps_delete = 0x7fdb89247c90
> my_ps_update = 0x0
> my_ps_insert = 0x0
> query_cols = {0x7fdb7af7ae60 ,
> 0x7fdb7af7af20 , 0x7fdb7af7af30 ,
> 0x7fdb7af7af40 , 0x7$
> update_cols = {0x7fdb7af7aed0 ,
> 0x7fdb7af7aec0 , 0x7fdb7af7aeb0 ,
> 0x7fdb7af7af00 , 0x7fdb$
> query_vals = {{type = DB_STR, nul = 0, free = 65448, val =
> {int_val = 2063050128, bigint_val = 140580637615504, double_val =
> 6.9456063516278221e-310, time_val $
> update_vals = {{type = DB_INT, nul = 0, free = -230745857, val
> = {int_val = 1525508903, bigint_val = 140580100074279, double_val =
> 6.9455797935625725e-310, tim$
> update_ops = {0x7fdb7ad6e0d1 "<"}
> del_s = 
> i = 
> s = 
> prev_s = 
> n_query_cols = 20
> n_update_cols = 7
> buffered_rows = 0x0
> #4  0x7fdb80b37cd8 in db_mysql_delete (_h=0x7fdb89247990,
> _k=0x7ffc78fd48a0, _o=0x7ffc78fd4890, _v=0x7ffc78fd4990, _n=1) at
> dbase.c:1316
> ret = 
> #5  0x7fdb7ad459c3 in update_db_subs (db=0x7fdb89247990,
> dbf=dbf@entry=0x7fdb7af7bbe0 , hash_table=,
> htable_size=, no_lock=no$
> my_ps_delete = 0x7fdb89247c90
> my_ps_update = 0x0
> my_ps_insert = 0x0
> query_cols = {0x7fdb7af7ae60 ,
> 0x7fdb7af7af20 , 0x7fdb7af7af30 ,
> 0x7fdb7af7af40 , 0x7$
> update_cols = {0x7fdb7af7aed0 ,
> 0x7fdb7af7aec0 , 0x7fdb7af7aeb0 ,
> 0x7fdb7af7af00 , 0x7fdb$
> query_vals = {{type = DB_STR, nul = 0, free = 65448, val =
> {int_val = 2063050128, bigint_val = 140580637615504, double_val =
> 6.9456063516278221e-310, time_val $
> update_vals = {{type = DB_INT, nul = 0, free = -230745857, val
> = {int_val = 1525508903, bigint_val = 140580100074279, double_val =
> 6.9455797935625725e-310, tim$
> update_ops = {0x7fdb7ad6e0d1 "<"}
> del_s = 
> i = 
> s = 
> prev_s = 
> n_query_cols = 20
> n_update_cols = 7
> __FUNCTION__ = "update_db_subs"
> #6  0x7fdb7ad46337 in timer_db_update (ticks=,
> param=) at subscribe.c:1341
> no_lock = 
> __FUNCTION__ = "timer_db_update"
> #7  0x55f7f094093c in handle_timer_job () at timer.c:730
> t = 0x7fdb81531488
> l = 
> __FUNCTION__ = "handle_timer_job"
> #8  0x55f7f0a72d03 in handle_io (idx=,
> event_type=, fm=) at net/net_udp.c:265
> n = 
> read = -1
> #9  io_wait_loop_epoll (h=, t=,
> repeat=) at net/../io_wait_loop.h:284
> ep_event = {events = 4040413608, data = {ptr =
> 0xf093fa5f55f7, fd = 22007, u32 = 22007, u64 =
> 17335474676608030199}}
> ret = 
> n = 1
> r = 3
> e = 0x7fdb8923a428
> fd = 
> i = 
> #10 udp_start_processes (chd_rank=,
> startup_done=) at net/net_udp.c:389
>
> no_lock = 
> __FUNCTION__ = "timer_db_update"
> #7  0x55f7f094093c in handle_timer_job () at timer.c:730
> t = 0x7fdb81531488
> l = 
>

Re: [OpenSIPS-Users] udp send fail randomly

[Pasan Meemaduma via Users]

Hi Rajesh,

The error does seems to return from os level when your opensips try to open the 
udp socket for an outgoing connection as it being not allowed for either for 
user or something else . are you using the standard port and do you have 
connection tracking on your iptables off for sip port ? I had a similar error 
due to iptables being blocking the port.
 

On Saturday, 5 May 2018, 12:59:11 AM GMT+5:30, Govindaraj, Rajesh 
 wrote:  
 
  
Hi,
 
  
 
In of our production environment, the below error is seen once every day. There 
is no firewall rule changes in the system.
 
This issue never occurred in lab systems.
 
  
 
2018-05-03T14:20:02.000+08:00 [local2] [err] msgct2-ccm-05a.apac.nsroot.net 
/usr/sbin/opensipsInternal[7527]: ERROR:core:udp_send: 
sendto(sock,0x7f3d6312d058,735,0,0x7ffdc8e38770,16): Operation not permitted(1)
 
2018-05-03T14:20:02.000+08:00 [local2] [err] msgct2-ccm-05a.apac.nsroot.net 
/usr/sbin/opensipsInternal[7527]: ERROR:core:msg_send: udp_send failed  
 
  
 
Opensips version:
 
  
 
version: opensips 1.11.5-tls
 
  
 
Thanks,
 
  
 
Rajeshkumar Govindaraj
 
Software Engineer
777 Commerce Drive,
Fairfield, CT-06825
T +1 201 253 7803  |  M +1 475 439 9918  |  E rajesh.govinda...@ipc.com
 
Follow us on twitter:@ipc_Systems_Inc   www.ipc.com
 
  
 

 
  
 


DISCLAIMER:This e-mail may contain information that is confidential, privileged 
or otherwise protected from disclosure. If you are not an intended recipient of 
this e-mail, do not duplicate or redistribute it by any means. Please delete it 
and any attachments and notify the sender that you have received it in error. 
Unintended recipients are prohibited from taking action on the basis of 
information in this e-mail. E-mail messages may contain computer viruses or 
other defects, may not be accurately replicated on other systems, or may be 
intercepted, deleted or interfered with without the knowledge of the sender or 
the intended recipient. If you are not comfortable with the risks associated 
with e-mail messages, you may decide not to use e-mail to communicate with IPC. 
IPC reserves the right, to the extent and under circumstances permitted by 
applicable law, to retain, monitor and intercept e-mail messages to and from 
its systems.

___
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] What would be the best way to get CDRs from opensips considering opensips handles heavy traffic load

[Abdul Basit]

You can use cgrates for CDR parsing from flat file system

On Sat, 5 May 2018 11:54 pm Ben Newlin,  wrote:

> We use the db_flatstore module to have Opensips write the CDRs from the
> ACC module directly to a file. We have a second application which reads the
> file and processes the CDRs separately.
>
>
>
> Thanks,
>
> Ben Newlin
>
>
>
> *From: *Users  on behalf of Aqs Younas <
> aqsyou...@gmail.com>
> *Reply-To: *OpenSIPS users mailling list 
> *Date: *Saturday, May 5, 2018 at 3:32 AM
> *To: *OpenSIPS users mailling list 
> *Subject: *Re: [OpenSIPS-Users] What would be the best way to get CDRs
> from opensips considering opensips handles heavy traffic load
>
>
>
> Thanks for reply. Opensips handles around 2000 concurrent calls with cps
> of 40 at the peak time. I see when opensips writes in ACC and my portal
> runs queries on the same table, opensips process almost comes to halt and a
> restart is always needed to make it alive.
>
>
>
> I want opensips to do something like just write CDRS in file/post
> somewhere or put in rabbitmq queue and do continue with processing sip
> traffic. Also, i would prefer to have something built-in instead of
> building my own CDRs.
>
>
>
> Best Regards,
>
>
>
> Aqs Younas
>
>
>
>
>
> On Sat, 5 May 2018 at 5:46 AM, Jon Abrams  wrote:
>
> If you don't need them immediately, you can use the old fashion write CDRS
> to syslog. Rotate the log file every so often to process the CDRs. Journald
> is too slow for this though - you must use rsyslog or syslog-ng.
>
> If you use the builtin OpenSIPS accounting and need results more
> real-time, then I'd look at RADIUS accounting. If you generate your own
> CDRs, then there are the event datagram and rabbitmq modules that provide
> opportunities.
>
> Out of curiosity, what do you consider heavy traffic?
>
> - Jon
>
>
>
> On Fri, May 4, 2018 at 4:32 PM, Aqs Younas  wrote:
>
> Greeting list,
>
>
>
> I would like to ask expert option,  how they are getting CDRs from
> opensips which handles heavy traffic.
>
>
>
> Actually I don't want to have opensips mantain database connections and
> write records in a single table acc.
>
>
>
> Best Regards,
>
>
>
> Aqs Younas
>
>
>
> ___
> 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
>
> ___
> 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] What would be the best way to get CDRs from opensips considering opensips handles heavy traffic load

[Ben Newlin]

We use the db_flatstore module to have Opensips write the CDRs from the ACC 
module directly to a file. We have a second application which reads the file 
and processes the CDRs separately.

Thanks,
Ben Newlin

From: Users  on behalf of Aqs Younas 

Reply-To: OpenSIPS users mailling list 
Date: Saturday, May 5, 2018 at 3:32 AM
To: OpenSIPS users mailling list 
Subject: Re: [OpenSIPS-Users] What would be the best way to get CDRs from 
opensips considering opensips handles heavy traffic load

Thanks for reply. Opensips handles around 2000 concurrent calls with cps of 40 
at the peak time. I see when opensips writes in ACC and my portal runs queries 
on the same table, opensips process almost comes to halt and a restart is 
always needed to make it alive.

I want opensips to do something like just write CDRS in file/post somewhere or 
put in rabbitmq queue and do continue with processing sip traffic. Also, i 
would prefer to have something built-in instead of building my own CDRs.

Best Regards,

Aqs Younas


On Sat, 5 May 2018 at 5:46 AM, Jon Abrams 
> wrote:
If you don't need them immediately, you can use the old fashion write CDRS to 
syslog. Rotate the log file every so often to process the CDRs. Journald is too 
slow for this though - you must use rsyslog or syslog-ng.

If you use the builtin OpenSIPS accounting and need results more real-time, 
then I'd look at RADIUS accounting. If you generate your own CDRs, then there 
are the event datagram and rabbitmq modules that provide opportunities.
Out of curiosity, what do you consider heavy traffic?
- Jon

On Fri, May 4, 2018 at 4:32 PM, Aqs Younas 
> wrote:
Greeting list,

I would like to ask expert option,  how they are getting CDRs from opensips 
which handles heavy traffic.

Actually I don't want to have opensips mantain database connections and write 
records in a single table acc.

Best Regards,

Aqs Younas

___
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
___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

Re: [OpenSIPS-Users] udp send fail randomly

[Govindaraj, Rajesh]

Hi Opensips forum members,

This is very hot issue in our production. Please share any inputs that help to 
resolve the same.
Tried all the items listed on internet search like,


-  Check for nf_ct_sip module is present and any syslog error logs. It 
was not the case.

-  So many active sip sessions with remote end is fine with keep alive 
going on. So can rule out firewall configs as well. Just this random error 
atleast one per day.

Thanks,

From: Govindaraj, Rajesh
Sent: Friday, May 04, 2018 3:28 PM
To: 'users@lists.opensips.org' 
Subject: udp send fail randomly

Hi,

In of our production environment, the below error is seen once every day. There 
is no firewall rule changes in the system.
This issue never occurred in lab systems.

2018-05-03T14:20:02.000+08:00 [local2] [err] msgct2-ccm-05a.apac.nsroot.net 
/usr/sbin/opensipsInternal[7527]: ERROR:core:udp_send: 
sendto(sock,0x7f3d6312d058,735,0,0x7ffdc8e38770,16): Operation not permitted(1)
2018-05-03T14:20:02.000+08:00 [local2] [err] msgct2-ccm-05a.apac.nsroot.net 
/usr/sbin/opensipsInternal[7527]: ERROR:core:msg_send: udp_send failed

Opensips version:

version: opensips 1.11.5-tls

Thanks,

Rajeshkumar Govindaraj
Software Engineer
777 Commerce Drive,
Fairfield, CT-06825
T +1 201 253 7803   *   M +1 475 439 9918  *   E 
rajesh.govinda...@ipc.com
Follow us on twitter: @ipc_Systems_Incwww.ipc.com

[cid:image006.jpg@01D1940F.3E021840]




DISCLAIMER: This e-mail may contain information that is confidential, 
privileged or otherwise protected from disclosure. 
If you are not an intended recipient of this e-mail, do not duplicate or 
redistribute it by any means. 
Please delete it and any attachments and notify the sender that you have 
received it in error. 
Unintended recipients are prohibited from taking action on the basis of 
information in this e-mail. 
E-mail messages may contain computer viruses or other defects, may not be 
accurately replicated on other systems, or may be intercepted, 
deleted or interfered with without the knowledge of the sender or the intended 
recipient. 
If you are not comfortable with the risks associated with e-mail messages, 
you may decide not to use e-mail to communicate with IPC. IPC reserves the 
right, 
to the extent and under circumstances permitted by applicable law, 
to retain, monitor and intercept e-mail messages to and from its systems.
___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

[OpenSIPS-Users] libmariadbclient crashes opensips 2.4

[Schneur Rosenberg]

Opensips keeps on crashing with the following error

kernel: [64912.190539] opensips[3377]: segfault at 4 ip
7fdb8054f2ae sp 7ffc78fd45f0 error 4 in
libmariadbclient.so.18.0.0[7fdb80524000+37c000]

Below is a bt from the dump file

[New LWP 3377]
[Thread debugging using libthread_db enabled]
Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1".
Core was generated by `/usr/local/sbin/opensips -P
/var/run/opensips/opensips.pid -m 128 -M 4 -u opens'.
Program terminated with signal SIGSEGV, Segmentation fault.
#0  0x7fdb8054f2ae in ?? () from
/usr/lib/x86_64-linux-gnu/libmariadbclient.so.18
#0  0x7fdb8054f2ae in ?? () from
/usr/lib/x86_64-linux-gnu/libmariadbclient.so.18
No symbol table info available.
#1  0x7fdb805512ba in mysql_stmt_execute () from
/usr/lib/x86_64-linux-gnu/libmariadbclient.so.18
No symbol table info available.
#2  0x7fdb80b30b59 in wrapper_single_mysql_stmt_execute
(conn=0x7fdb89247990, stmt=0x55f7f23e6778) at dbase.c:148
code = 
error = 
#3  db_mysql_do_prepared_query (conn=conn@entry=0x7fdb89247990,
v=v@entry=0x7ffc78fd4990, n=n@entry=1, uv=uv@entry=0x0, un=un@entry=0,
query=0x7fdb80d4e5e0 

Re: [OpenSIPS-Users] What would be the best way to get CDRs from opensips considering opensips handles heavy traffic load

[Aqs Younas]

Thanks for reply. Opensips handles around 2000 concurrent calls with cps of
40 at the peak time. I see when opensips writes in ACC and my portal runs
queries on the same table, opensips process almost comes to halt and a
restart is always needed to make it alive.

I want opensips to do something like just write CDRS in file/post somewhere
or put in rabbitmq queue and do continue with processing sip traffic. Also,
i would prefer to have something built-in instead of building my own CDRs.

Best Regards,

Aqs Younas


On Sat, 5 May 2018 at 5:46 AM, Jon Abrams  wrote:

> If you don't need them immediately, you can use the old fashion write CDRS
> to syslog. Rotate the log file every so often to process the CDRs. Journald
> is too slow for this though - you must use rsyslog or syslog-ng.
>
> If you use the builtin OpenSIPS accounting and need results more
> real-time, then I'd look at RADIUS accounting. If you generate your own
> CDRs, then there are the event datagram and rabbitmq modules that provide
> opportunities.
>
> Out of curiosity, what do you consider heavy traffic?
>
> - Jon
>
> On Fri, May 4, 2018 at 4:32 PM, Aqs Younas  wrote:
>
>> Greeting list,
>>
>> I would like to ask expert option,  how they are getting CDRs from
>> opensips which handles heavy traffic.
>>
>> Actually I don't want to have opensips mantain database connections and
>> write records in a single table acc.
>>
>> Best Regards,
>>
>> Aqs Younas
>>
>> ___
>> 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
>
___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users