Re: [OpenSIPS-Users] Errors in OpenSIPS

2012-11-08 Thread Jorge Ortea
Hello Vlad, You are right, I had searched for ERROR, but before each Error message I got this: Nov 5 10:24:19 hgt-tero45 /usr/local/opensips/sbin/opensips[12562]: CRITICAL:db_mysql:wrapper_single_mysql_stmt_execute: driver error (1048): Column 'callee_contact' cannot be null Nov 5 10:24:19

[OpenSIPS-Users] opensips.cfg has error log with call-control and mediaproxy

2012-11-08 Thread ????se??
hi: sometimes I got log like this: ??Sep 4 20:21:16 c call-control[1212]: error: Call id BF1369E8-F4D011E1-802DB0A4-86F82AF1@A.B.C.D exists in users table but not in calls table ??Oct 15 10:36:27 opensips-1 /sbin/opensips[12894]: ERROR:mediaproxy:use_media_proxy: insufficient ports

[OpenSIPS-Users] 404 Not Found error with Sipp UAC

2012-11-08 Thread Steve Mitchell
Hi, I'm trying to get a simple scenario working to generate CDRs in bulk and am using a basic configuration (generated with osipconfig) with the sipp UAC. However, I continue to get a 404 Not Found response to the INVITE. My config and UAC file are below. Any thoughts? Thanks much! Steve # # $

Re: [OpenSIPS-Users] OpenXCAP - Can't connect to MySQL server when mysql port is defined

2012-11-08 Thread Saúl Ibarra Corretgé
On Nov 8, 2012, at 11:13 PM, Duane Larson wrote: > Saul, > > Did the following > > apt-get source openxcap > edit dbutil.py to include "kwargs.setdefault('port', int(port or '3306'))" > apt-get build-dep openxcap-2.0.1 > dpkg-buildpackage -us -uc > dpkg -i openxcap_2.0.1_all.deb > > Looks like

Re: [OpenSIPS-Users] CDRTool - opensips.radacct201211 doesn't exist

2012-11-08 Thread Duane Larson
Ugh. Looked harder at what you said Adrian and the version of MySQL on the Managed service is 5.1.42 and my old MySQL server was 5.5.23-2. Not much I can do with upgrading the Managed MySQL since I have no control. I tried to do ahead and install mysql-server on the CDRTool server itself but sin

Re: [OpenSIPS-Users] OpenXCAP - Can't connect to MySQL server when mysql port is defined

2012-11-08 Thread Duane Larson
Saul, Did the following apt-get source openxcap edit dbutil.py to include "kwargs.setdefault('port', int(port or '3306'))" apt-get build-dep openxcap-2.0.1 dpkg-buildpackage -us -uc dpkg -i openxcap_2.0.1_all.deb Looks like I am now able to connect to the database on a port other than 3306. Tha

Re: [OpenSIPS-Users] CDRtool loading data from Asterisk and multiple profiles

2012-11-08 Thread Adrià Vidal
2012/11/8 Adrian Georgescu > I tried to understand what you ask but I could not. > > Nevertheless, the rating logic is described here in detail if you care > about reading: > > > http://cdrtool.ag-projects.com/projects/cdrtool/repository/entry/doc/RATING.txt > > Adrian > > Yes i've read it caref

Re: [OpenSIPS-Users] CDRTool - opensips.radacct201211 doesn't exist

2012-11-08 Thread Adrian Georgescu
Just a wild guess. An incompatibility between the php mysql client library and the mysql server could cause this. On Nov 8, 2012, at 10:34 PM, Duane Larson wrote: > I'm at a loss. I upgraded everything on the server, php and all, and that > didn't really help. I no longer get the "MySQL erro

Re: [OpenSIPS-Users] CDRTool - opensips.radacct201211 doesn't exist

2012-11-08 Thread Duane Larson
I'm at a loss. I upgraded everything on the server, php and all, and that didn't really help. I no longer get the "MySQL error: 1146 (Table 'opensips.active_sessions' doesn't exist) Session halted" error when I log in but if I do a search I still get "MySQL error: 1146 (Table 'opensips.radacct201

Re: [OpenSIPS-Users] CDRtool loading data from Asterisk and multiple profiles

2012-11-08 Thread Adrian Georgescu
I tried to understand what you ask but I could not. Nevertheless, the rating logic is described here in detail if you care about reading: http://cdrtool.ag-projects.com/projects/cdrtool/repository/entry/doc/RATING.txt Adrian On Nov 8, 2012, at 10:18 AM, Adria Vidal wrote: > I'm performing som

Re: [OpenSIPS-Users] CDRTool - opensips.radacct201211 doesn't exist

2012-11-08 Thread Adrian Georgescu
I recall seeing this myself once. Then it was caused by a broken or mismatched with the server version PHP mysql client library. Upgrading it solve the issue at that time. Adrian On Nov 7, 2012, at 5:27 AM, Duane Larson wrote: > I have been running CDRTool for a long time (about 2 or 3 years)

Re: [OpenSIPS-Users] Feature request for OpenSIPS 1.9: support for macro definitions

2012-11-08 Thread Ali Pey
Thank you Bogdan... On Thu, Nov 8, 2012 at 12:14 PM, Bogdan-Andrei Iancu wrote: > ** > Hi Ali, > > Added on the list http://www.opensips.org/Main/Ver190#toc9 with a quite > high priority ;). > > Regards, > > Bogdan-Andrei Iancu > OpenSIPS Founder and Developerhttp://www.opensips-solutions.com >

Re: [OpenSIPS-Users] TCP connections for relaying calls

2012-11-08 Thread Bogdan-Andrei Iancu
Yes, multiple listeners (same ip, different ports) on receiver (let's say OS2) and using dispatcher on OS1 to do round-robin (or so) over all listeners on OS2. force_send_socket() is to control the interface the message will go out - what you actually have to do is to choose different destinat

Re: [OpenSIPS-Users] textops and Variable

2012-11-08 Thread Bogdan-Andrei Iancu
Hi Marco, Your approach is (1) buggy as you do not delete the eventual rtpmap line and (2) will work only once (as you cannot change twice the same part of a message). What I suggest is to try to use the dedicated functions for codec manipulation from the sipmsgops module: http://ww

Re: [OpenSIPS-Users] Errors in OpenSIPS

2012-11-08 Thread Vlad Paiu
Hello Jorge, Do you see any other errors from the DB level in the OpenSIPS logs ? What DB backend are you using ? It seems that for some reason, the dialog DB inserts are failing, but more ERROR messages should appear in such a case from the db_mysql module.. Regards, Vlad Paiu OpenSIPS Deve

Re: [OpenSIPS-Users] TCP connections for relaying calls

2012-11-08 Thread Mariana Arduini
Hi Bogdan, Thanks for the suggestions! So this means we´ll need new "listen" lines, right? Plus, we´d need some mechanism to round-robin through the destinations sockets - like dispatcher? We´re also using force_send_socket(). Will we need to round-robin through the many ports we´re listening as

Re: [OpenSIPS-Users] Feature request for OpenSIPS 1.9: support for macro definitions

2012-11-08 Thread Bogdan-Andrei Iancu
Hi Ali, Added on the list http://www.opensips.org/Main/Ver190#toc9 with a quite high priority ;). Regards, Bogdan-Andrei Iancu OpenSIPS Founder and Developer http://www.opensips-solutions.com On 11/08/2012 07:06 PM, Ali Pey wrote: I second this as well. Named flags would make debugging and

Re: [OpenSIPS-Users] Errors in OpenSIPS

2012-11-08 Thread Ali Pey
I think it's telling you it can't add another dialog to db. I am almost certain that's what's happening. Regards, Ali Pey On Thu, Nov 8, 2012 at 4:22 AM, Jorge Ortea wrote: > Hi all, > > I am getting the following errors: > > > Nov 7 11:47:19 hgt-tero45 /usr/local/opensips/sbin/opensips[1258

Re: [OpenSIPS-Users] CDRTool - opensips.radacct201211 doesn't exist

2012-11-08 Thread Duane Larson
Tijmen, For the new MySQL server I am not able to log into it and do any iptables redirects since it is a "managed" mysql solution. But with my old server I configured mysql to work off of port 19994 and pointed CDRTools global.inc to port 19994 on the old server and everything works fine. So so

Re: [OpenSIPS-Users] Feature request for OpenSIPS 1.9: support for macro definitions

2012-11-08 Thread Ali Pey
I second this as well. Named flags would make debugging and scripting quite simpler. Regards, Ali On Thu, Nov 8, 2012 at 11:23 AM, Bogdan-Andrei Iancu wrote: > Hi Michael, > > You can already use names for the route, not only numerical IDs (without > the need of defining). > > For flags, you c

Re: [OpenSIPS-Users] Dialplan with # or *

2012-11-08 Thread Binan AL Halabi
Hi Jorge, In your config use dp_translate() function which searches the dialplan table to find a pattern and apply the translations needed. Also You can assign attribute to avp depending on the match. There is a dialplan example in chapter 7 of the book (Building Telephony Systems with OpenSIP

Re: [OpenSIPS-Users] Feature request for OpenSIPS 1.9: support for macro definitions

2012-11-08 Thread Bogdan-Andrei Iancu
Hi Michael, You can already use names for the route, not only numerical IDs (without the need of defining). For flags, you can use only numbers, indeed - usually I use M4 as text preprocessor to do different complex ops over the script (like defines, ifdefs, etc). But maybe a built in suppor

Re: [OpenSIPS-Users] TCP connections for relaying calls

2012-11-08 Thread Bogdan-Andrei Iancu
Hi Mariana, Because of the TCP conn reusage, between 2 SIP entities preserving their IP and port, you will have only 1 TCP conn (per direction). This will lead to a "tunneling" effect between 2 proxies - all traffic will be pushed via a single connection. To avoid this, use multiple TCP inte

Re: [OpenSIPS-Users] Distributed SIP clusters with OpenSIPS

2012-11-08 Thread Vlad Paiu
Hello, Yes, work on Redis cluster seems to be still ongoing. I guess that yes, you could already use Couchbase via the memcached interface, but will be limited by the key-value stuff. Another improvement we are planning for 1.9 is to be able to run raw queries in each NoSQL back-end, in the l

Re: [OpenSIPS-Users] Distributed SIP clusters with OpenSIPS

2012-11-08 Thread Vlad Paiu
Hello, This will not work since, even in a db_mode=1 setup, the profiles are served from memory only. Regards, Vlad Paiu OpenSIPS Developer http://www.opensips-solutions.com On 11/07/2012 05:39 PM, Jeff Pyle wrote: Vlad, Can one achieve the same dialog profile sharing behavior between mu

Re: [OpenSIPS-Users] set_count in opensips 1.8.2

2012-11-08 Thread Vlad Paiu
Hello, There was a bug in the set_count function, and only fix what to slightly change the prototype of the function. If the counted pvar had 0 elements, the function would return 0, which would lead to stopping the script. The new prototype is described at http://www.opensips.org/html/docs/

[OpenSIPS-Users] set_count in opensips 1.8.2

2012-11-08 Thread Jayesh Nambiar
Hi All, Just upgraded to opensips 1.8.2 and it wont start since I have used set_count function in the script. It gives an error: unknown command , missing loadmodule? I have the module cfgutils loaded. Guess it is a problem in 1.8.2. --- Jayesh ___ User

Re: [OpenSIPS-Users] CDRTool - opensips.radacct201211 doesn't exist

2012-11-08 Thread Tijmen de Mes
Hi, I am unable to reproduce it. Just as a quick test can you insert an iptables rule on the mysql server to divert requests on port 3306 from the cdr machine to 19994? That way we can check if CDRTool tries to use that port even though you specified an other and rule. You can even put the co

[OpenSIPS-Users] TCP connections for relaying calls

2012-11-08 Thread Mariana Arduini
Hello all, We are using 2 OpenSIPS servers and TCP between them: tcp ---> OSIPS1 <--- tcp ---> OPSIPS2 <--- tcp OSIPS2 has a bunch of children processes running, but we can only see few of them actually being used. When we use SIPp scripts instead of OPSIPS1 and set it to use 1 TCP connection pe

[OpenSIPS-Users] Feature request for OpenSIPS 1.9: support for macro definitions

2012-11-08 Thread Michael Renzmann
Hi all. I'm relatively new to OpenSIPS and still am at the very beginning of learning how to tame this wonderful beast ;-). One thing that I, personally, find pretty uncomfortable is that in various places in the opensips.cfg one needs to use plain numbers to define or modify the behaviour. That

[OpenSIPS-Users] [OpenSIPS 1.9] Winter cleanup: XCAP

2012-11-08 Thread Saúl Ibarra Corretgé
Hi all, I've been working for quite a while now in adding external references to RLS and pres-rules documents following IETF and OMA specifications respectively. And it works! \o/ In the process I noticed there is common behavior that can be factored out of rls and presence_xml modules. So, my

Re: [OpenSIPS-Users] textops and Variable

2012-11-08 Thread spady
Hi, i really suppose you should use REGEX. As per manual: 1.3.8. replace_body_all(re, txt) Replaces all occurrence of re in the body of the message with txt. Matching is done on a per-line basis. Meaning of the parameters is as follows: *re - Regular expression.* txt - String. Regards -

Re: [OpenSIPS-Users] Help: Understanding ACK loop

2012-11-08 Thread spady
SOLVED!!! Thanks Bogdan for your hint ;-) That was the problem. PBX was sending a Contact header NOT compliant to RFC!!! Just to help someone else, I added this snippet of code: *if ((status=="200") && (src_ip == IP_PBX)) { replace("Contact: sip:x.x.x.x.","Contact: .");

[OpenSIPS-Users] textops and Variable

2012-11-08 Thread Marco Colombo
Hi All, i'm trying with Textops to do codec substitution in a call with re-invite. I'm trying to do this, with this command : replace_body_all("m=audio 7078 RTP/AVP 8 18 0 2 100 99", "m=audio 7078 RTP/AVP 8 18 101"); but when this line "m=audio 7078 RTP/AVP 8 18 0 2 100 99" does not match perf

[OpenSIPS-Users] Errors in OpenSIPS

2012-11-08 Thread Jorge Ortea
Hi all, I am getting the following errors: Nov 7 11:47:19 hgt-tero45 /usr/local/opensips/sbin/opensips[12582]: ERROR:dialog:update_dialog_dbinfo: could not add another dialog to db Nov 7 11:47:19 hgt-tero45 /usr/local/opensips/sbin/opensips[12548]: ERROR:dialog:update_dialog_dbinfo: could n

[OpenSIPS-Users] CDRtool loading data from Asterisk and multiple profiles

2012-11-08 Thread Adria Vidal
I'm performing some CDR rating with CDRtool, and would like to have multiple ratings depending on domain or customer. customers table id reseller_id gateway domain subscriber profile_name1 profile_name1_alt profile_name2 profile_name2_alt timezone increment min_duration 11 0 domainA.net domainA_d

Re: [OpenSIPS-Users] OpenXCAP - Can't connect to MySQL server when mysql port is defined

2012-11-08 Thread Saúl Ibarra Corretgé
Hi Duane, On Nov 7, 2012, at 6:22 PM, Duane Larson wrote: > I just moved over to a new mysql server and the port I need to connect to is > no longer the default 3306 that mysql uses. I now need to connect to port > 19994 on the new mysql server. With OpenXCAP are you able to connet to > defi

Re: [OpenSIPS-Users] Help: Understanding ACK loop

2012-11-08 Thread Schneur Rosenberg
I had a similar problem happen behind a certain router it was the routers sip alg, try to do a wireshark behind the router if it has proper invite try disabling sip alg, if not possible change router On Nov 7, 2012 8:16 PM, "Bogdan-Andrei Iancu" wrote: > Hi, > > See in the logs: > > Nov 7 08:58