Re: [OpenSIPS-Users] OpenSIPS-CP and cdrviewer

2009-06-11 Thread Gavin Henry
2009/6/11 Gavin Henry gavin.he...@gmail.com: 2009/6/11 Gavin Henry gavin.he...@gmail.com: 2009/6/11 Iulia Bublea iu...@opensips.org: Hi, Try changing the type of cdr_id field from varchar to int(11) not null default 0 That fixed it, thanks. It is strange though, because caller and

Re: [OpenSIPS-Users] Opensips CP trunk postgres db implementation

2009-06-05 Thread Gavin Henry
Excellent, I'll be testing the Pg parts. On 03/06/2009, Iulia Bublea iu...@opensips.org wrote: Hi, The trunk of Opensips CP comes with 2 new features: 1. In what my concern the configurations files, there is one global config file in config/db.in.php. And there are the config files for each

[OpenSIPS-Users] openSIPS-CP

2009-05-29 Thread Michael Ciupka
Hello, which URL i need in the web browser to open the webinterface with the logon site from openSIPS-CP? Regards Michael ___ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users

[OpenSIPS-Users] OpenSIPS-CP

2009-05-29 Thread Michael Ciupka
Hello, i have resolf my problem... now i want to configure the siptrace in the opensips.cfg: modparam(siptrace, db_url, mysql://opensips:opensip...@localhost/opensips) modparam(siptrace, trace_flag, 22) modparam(siptrace, trace_on, 1) modparam(siptrace, enable_ack_trace, 1) modparam(siptrace,

Re: [OpenSIPS-Users] OpenSIPS-CP

2009-05-29 Thread Iñaki Baz Castillo
2009/5/29 Michael Ciupka opens...@michael-ciupka.de: Hello, i have resolf my problem... now i want to configure the siptrace in the opensips.cfg: And why is OpenSIPS-CP the subject of this mail when it has nothing to di with it? modparam(siptrace, db_url,

Re: [OpenSIPS-Users] OpenSIPS-CP

2009-05-29 Thread Bogdan-Andrei Iancu
Hi Michael, have you load the siptrace module (loadmodule directive) ?? Regards, Bogdan Michael Ciupka wrote: Hello, i have resolf my problem... now i want to configure the siptrace in the opensips.cfg: modparam(siptrace, db_url, mysql://opensips:opensip...@localhost/opensips)

Re: [OpenSIPS-Users] OpenSIPS-CP for admin, what for user provisioning?

2009-05-28 Thread Dan Pascu
On Wednesday 27 May 2009, Gavin Henry wrote: Thanks Dan. I have done, read all the lists and figured this part out myself ;-) Does it use conntrack_sip? No. Why would it? It relays media not signaling. It uses generic conntrack rules with both SNAT and DNAT elements. -- Dan

Re: [OpenSIPS-Users] OpenSIPS-CP for admin, what for user provisioning?

2009-05-27 Thread Gavin Henry
2009/5/26 Bogdan-Andrei Iancu bog...@voice-system.ro: Hi Gavin, Gavin Henry wrote: 2009/5/25 Bogdan-Andrei Iancu bog...@voice-system.ro: Hi Gavin, Gavin Henry wrote: Hi, Couple of questions as I'm setting up OpenSIPS for a charity and need to pick some off the shelf tools: 1.

Re: [OpenSIPS-Users] OpenSIPS-CP for admin, what for user provisioning?

2009-05-26 Thread Dan Pascu
On Tuesday 26 May 2009, Gavin Henry wrote: 95% yes..some things improved, but the lines are still good. OK, great. Read a lot about rtpproxy and mediaproxy, but I guess it just depends on what you need (billing fixes). I don't think that the information in the book still applies to

Re: [OpenSIPS-Users] OpenSIPS-CP for admin, what for user provisioning?

2009-05-25 Thread Bogdan-Andrei Iancu
Hi Gavin, Gavin Henry wrote: Hi, Couple of questions as I'm setting up OpenSIPS for a charity and need to pick some off the shelf tools: 1. I've watched most of the great new vids for the cp and actually installed it, but looks like only rtpproxy is supported? (will double check) what

Re: [OpenSIPS-Users] OpenSIPS-CP for admin, what for user provisioning?

2009-05-25 Thread Gavin Henry
2009/5/25 Bogdan-Andrei Iancu bog...@voice-system.ro: Hi Gavin, Gavin Henry wrote: Hi, Couple of questions as I'm setting up OpenSIPS for a charity and need to pick some off the shelf tools: 1. I've watched most of the great new vids for the cp and actually installed it, but looks like

[OpenSIPS-Users] OpenSIPS-CP for admin, what for user provisioning?

2009-05-23 Thread Gavin Henry
Hi, Couple of questions as I'm setting up OpenSIPS for a charity and need to pick some off the shelf tools: 1. I've watched most of the great new vids for the cp and actually installed it, but looks like only rtpproxy is supported? (will double check) 2. What is the minimum opensips.cfg you

Re: [OpenSIPS-Users] opensips-cp CDR correlation

2009-04-30 Thread Iñaki Baz Castillo
2009/4/30 Dan Pascu d...@ag-projects.com: I'm sure there is this kind (and unfortunately not in short supply), but you do realize that if some employee has a expertise to hack a SIP device to send abnormal BYE requests that attempt to fake the closing of the SIP session while preventing the

Re: [OpenSIPS-Users] opensips-cp CDR correlation

2009-04-30 Thread Bogdan-Andrei Iancu
Hi Inaki, Some inline notes :) : Iñaki Baz Castillo wrote: 2009/4/30 Dan Pascu d...@ag-projects.com: I'm sure there is this kind (and unfortunately not in short supply), but you do realize that if some employee has a expertise to hack a SIP device to send abnormal BYE requests that

Re: [OpenSIPS-Users] opensips-cp CDR correlation

2009-04-30 Thread Iñaki Baz Castillo
2009/4/30 Bogdan-Andrei Iancu bog...@voice-system.ro: Yes, I agree on it. However I just wanted to mean that using a media-proxy is not the best solution for all the cases, specially when clients are behind same NAT (an office for example) from the open internet, you cannot tell (100% sure)

Re: [OpenSIPS-Users] opensips-cp CDR correlation

2009-04-30 Thread Adrian Georgescu
On Apr 30, 2009, at 12:28 PM, Iñaki Baz Castillo wrote: 2009/4/30 Adrian Georgescu a...@ag-projects.com: The more load you have at some moment in time you need to add more servers. The curent design allows MP2 to handle several thousands of simultaneous sessions. Anyway, far from trying to

Re: [OpenSIPS-Users] opensips-cp CDR correlation

2009-04-30 Thread Iñaki Baz Castillo
2009/4/30 Adrian Georgescu a...@ag-projects.com: The more load you have at some moment in time you need to add more servers. The curent design allows MP2 to handle several thousands of simultaneous sessions. Anyway, far from trying to advocate its load capabilities the question we all try to

Re: [OpenSIPS-Users] opensips-cp CDR correlation

2009-04-30 Thread Iñaki Baz Castillo
2009/4/30 Adrian Georgescu a...@ag-projects.com: You can use the dialog module to do the same and generate your own correct BYEs instead of relaying them, couldn't you? You have full control over the reply route and can do all you describe in the proxy, can't you? What can a B2BUA detect

Re: [OpenSIPS-Users] opensips-cp CDR correlation

2009-04-30 Thread Dan Pascu
On Thursday 30 April 2009, Iñaki Baz Castillo wrote: Yes, I agree on it. However I just wanted to mean that using a media-proxy is not the best solution for all the cases, specially when clients are behind same NAT (an office for example) and the PBX/Proxy is hosted in some datacenter. There

Re: [OpenSIPS-Users] opensips-cp CDR correlation

2009-04-30 Thread Adrian Georgescu
On Apr 30, 2009, at 1:49 PM, Iñaki Baz Castillo wrote: 2009/4/30 Adrian Georgescu a...@ag-projects.com: You can use the dialog module to do the same and generate your own correct BYEs instead of relaying them, couldn't you? You have full control over the reply route and can do all you

Re: [OpenSIPS-Users] opensips-cp CDR correlation

2009-04-30 Thread Iñaki Baz Castillo
2009/4/30 Dan Pascu d...@ag-projects.com: I don't think you would. Mediaproxy will most likely max out your network capacity before needing another server (at least with the right hardware). Also you seem to forget that your cheaper solution still needs an extra box as well (the B2BUA).

Re: [OpenSIPS-Users] opensips-cp CDR correlation

2009-04-30 Thread Dan Pascu
On Thursday 30 April 2009, Iñaki Baz Castillo wrote: No, a proxy is fully vulnerable to a spoofed BYE, why? because the proxy MUST route the BYE according to RURI, Route headers..., while a B2BUA doesn't route it, just eats it and generate a new one in leg B. I think we already agreed that it

Re: [OpenSIPS-Users] opensips-cp CDR correlation

2009-04-30 Thread Iñaki Baz Castillo
2009/4/30 Dan Pascu d...@ag-projects.com: Continuing to debate this in pointless. I already showed you that a solution based on a media relay can be made as cheap as the B2BUA based solution that you promote, while being much more accurate. 1 media-proxy = 100 RTP sessions (100 calls) X

Re: [OpenSIPS-Users] opensips-cp CDR correlation

2009-04-30 Thread kokoska rokoska
Iñaki Baz Castillo napsal(a): 2009/4/30 Dan Pascu d...@ag-projects.com: Continuing to debate this in pointless. I already showed you that a solution based on a media relay can be made as cheap as the B2BUA based solution that you promote, while being much more accurate. 1 media-proxy =

Re: [OpenSIPS-Users] opensips-cp CDR correlation

2009-04-30 Thread Iñaki Baz Castillo
2009/4/30 kokoska rokoska kokoska.roko...@post.cz: FYI - we are relaying more than 1000 RTP sessions with one server (2x QuadCore) using RTPproxy (packets goes to user space) without visible load on the server. It is almost idle. So I expect kernel (i.e. media-proxy) could go even far-far away

Re: [OpenSIPS-Users] opensips-cp CDR correlation

2009-04-30 Thread Dan Pascu
On Thursday 30 April 2009, Iñaki Baz Castillo wrote: Dan, I'm not trying to say which option is better. I just mean that doing media-relaying is not the *only* or better solution for all the cases. Nobody ever claimed such a thing. I thought the point was to offer alternatives and let the

Re: [OpenSIPS-Users] opensips-cp CDR correlation

2009-04-30 Thread Dan Pascu
On Thursday 30 April 2009, Iñaki Baz Castillo wrote: 2009/4/30 Dan Pascu d...@ag-projects.com: Continuing to debate this in pointless. I already showed you that a solution based on a media relay can be made as cheap as the B2BUA based solution that you promote, while being much more

Re: [OpenSIPS-Users] opensips-cp CDR correlation

2009-04-30 Thread Iñaki Baz Castillo
2009/4/30 Dan Pascu d...@ag-projects.com: The B2BUA based solution: 1. It generates the same amount of media traffic from the network. Just in the case of calls to a PSTN gw (ok, this is what we are speaking about). 2. It needs a specialized B2BUA box with custom logic. Why couldn't it be

Re: [OpenSIPS-Users] opensips-cp CDR correlation

2009-04-30 Thread Iñaki Baz Castillo
2009/4/30 Dan Pascu d...@ag-projects.com: On Thursday 30 April 2009, Iñaki Baz Castillo wrote: 2009/4/30 kokoska rokoska kokoska.roko...@post.cz: FYI - we are relaying more than 1000 RTP sessions with one server (2x QuadCore) using RTPproxy (packets goes to user space) without visible load

Re: [OpenSIPS-Users] opensips-cp CDR correlation

2009-04-30 Thread Dan Pascu
On Thursday 30 April 2009, Iñaki Baz Castillo wrote: 2009/4/30 Dan Pascu d...@ag-projects.com: With 20 media relays I expect to drive 6+ simultaneous sessions. Why do you estimate you need that many, when I can drive thousands of sessions with a single machine and max out the

Re: [OpenSIPS-Users] opensips-cp CDR correlation

2009-04-30 Thread Dan Pascu
On Thursday 30 April 2009, Iñaki Baz Castillo wrote: 2. It needs a specialized B2BUA box with custom logic. Why couldn't it be integrated in the same proxy box? or why couldn't it replace the proxy? It could. But can it support the same load as the proxy, so it can be used as a

Re: [OpenSIPS-Users] opensips-cp CDR correlation

2009-04-29 Thread Dan Pascu
On Wednesday 29 April 2009, Iñaki Baz Castillo wrote: Always I hear billing in a proxy I must to show an example attack: Phone1Proxy Phone2 INVITE CSeq:1 - --- --- 200 OK ACK CSeq:1 --- RTP

Re: [OpenSIPS-Users] opensips-cp CDR correlation

2009-04-29 Thread Brett Nemeroff
On Wed, Apr 29, 2009 at 3:06 AM, Bogdan-Andrei Iancu bog...@voice-system.ro wrote: So a proxy may account several BYEs, but the CDR generator has the duty in picking the right one - like searching for the first 200OK BYE, if not, picking the first non-200OK with a reply code that does not

Re: [OpenSIPS-Users] opensips-cp CDR correlation

2009-04-29 Thread Iñaki Baz Castillo
2009/4/29 Dan Pascu d...@ag-projects.com: You can always put a media relay in the media path, which means that when a BYE is received the media path is interrupted, making any Route/RURI scheme pointless. Sure, but forcing the media through a media proxy is not the magic solution for all the

Re: [OpenSIPS-Users] opensips-cp CDR correlation

2009-04-29 Thread Bogdan-Andrei Iancu
I think (even if I do not like it) it ismore or less the media flow is the only continuously flowing traffic that may indicate if a call is still going through or not. Signalling traffic is sporadic and non-continuous, so not good for testing the state of the call. Not only it is accurate,

Re: [OpenSIPS-Users] opensips-cp CDR correlation

2009-04-29 Thread Brett Nemeroff
Don't I basically just want to know if the last reply for method='BYE' is 200? ie: if the BYE gets replied with a 200, but THEN a 408 or.. well any =400 code arrives, then disregard the BYE ? Tricky... Is it not possible to have the dialog module trigger an ACC event when the dialog is

Re: [OpenSIPS-Users] opensips-cp CDR correlation

2009-04-29 Thread Bogdan-Andrei Iancu
Which may be or not - your query does not cover the not case :) Regards, Bogdan Brett Nemeroff wrote: Don't I basically just want to know if the last reply for method='BYE' is 200? ie: if the BYE gets replied with a 200, but THEN a 408 or.. well any =400 code arrives, then disregard the

Re: [OpenSIPS-Users] opensips-cp CDR correlation

2009-04-29 Thread Iñaki Baz Castillo
El Miércoles, 29 de Abril de 2009, Dan Pascu escribió: You realize that a B2BUA completely separates the 2 call legs, which includes audio. I mean SIP transparent B2BUA which doesn't handle media and doesn't touch the SDP at all. If you only attempt to split the signaling path, but leave

Re: [OpenSIPS-Users] opensips-cp CDR correlation

2009-04-29 Thread Dan Pascu
On Wednesday 29 April 2009, Iñaki Baz Castillo wrote: LAN traffic is cheap? perhaps I should describe again the scenario I described: A company using a *hosted* virtual proxy/PBX service. The provider (the proxy/B2BUA is in some datacenter while the phones are in the company office

Re: [OpenSIPS-Users] opensips-cp CDR correlation

2009-04-29 Thread Iñaki Baz Castillo
El Miércoles, 29 de Abril de 2009, Dan Pascu escribió: My bad. I was under the impression that we are discussing ways to prevent a user from hacking a system and getting calls which are free of charge. In my (limited) knowledge, this only applies to PSTN calls (which have a fee). Maybe you

[OpenSIPS-Users] opensips-cp CDR correlation

2009-04-28 Thread Brett Nemeroff
At Bogdan's request, I checked out the stored proc for CDR Correlation in the opensips-cp project. I see the Invite cursor declared as: DECLARE inv_cursor CURSOR FOR SELECT time, callid, from_tag, to_tag FROM opensips.acc where method='INVITE' and cdr_id='0'; This seems like a problem to me..

[OpenSIPS-Users] Opensips-cp: Sip Trace Tool

2008-12-09 Thread mmarzuola
Hi. In the table of the Sip Trace tool the Date Time column is blank for each sip message stored and if I try to do a search by date, I get the error: Unknown column 'date' in 'where clause' In the sip_trace table the values in the time_stamp column are present. There is a problem of mismatch

[OpenSIPS-Users] Opensips-CP Domains Tool

2008-12-04 Thread mmarzuola
Hi all.I have a doubt about using the Domains tool. In the opensips.cfg I set to zero the db_mode parameter of the domain module (non-caching mode). Then, in the Domains tool, I added the domain and effectively in the domain table of the database the record is present. But when I click the

Re: [OpenSIPS-Users] Opensips-CP Domains Tool

2008-12-04 Thread Dragos Oancea
Hi add these lines into opensips-cp/config/tools/domains/local.inc.php : $config-reply_fifo_filename=webfifo_.rand(); $config-reply_fifo_path=/tmp/.$config-reply_fifo_filename; almost same problem like the MI tool one... Cheers, Dragos [EMAIL PROTECTED] wrote: Hi all. I have a doubt about

[OpenSIPS-Users] Opensips-cp Sip_trace

2008-12-04 Thread Grygoriy Dobrovolskyy
On the admin interface of sip trace module i am allways getting sorry -- cannot connect to xmlrpc server 111 - Connection refused i have xmlrpc module installed, i dont understand what credentials xmlrcp does not accept ?? thank you for info i am sure about the dbpassword (mysql)

Re: [OpenSIPS-Users] Opensips-CP Statistic Monitor

2008-12-03 Thread Dragos Oancea
Hi Matteo, try to add: $boxes[$box_id]['smonitor']['charts']=1; in boxes.global.inc.php for the box you wish to monitor. Cheers, Dragos [EMAIL PROTECTED] wrote: Hi all. I'm using Opensips-CP to monitor my SIP Server. The Statistic Monitor tool can show me the realtime statistics, as

[OpenSIPS-Users] Opensips-CP Statistic Monitor

2008-12-01 Thread mmarzuola
Hi all.I'm using Opensips-CP to monitor my SIP Server.The Statistic Monitor tool can show me the realtime statistics, as location users and location contacts, but if I see the charts as usrloc:location contacts or location users, these are all empty.I have checked the monitoring_stats table and

[OpenSIPS-Users] opensips-cp

2008-11-27 Thread Tseveendorj Ochirlantuu
Hello, I'm installing opensips-cp on debian. There is any *generate-cdrs.sh* file in cron_jobs folder.* *Where can I find that script? Thank you. Tseveen.* * ___ Users mailing list Users@lists.opensips.org

Re: [OpenSIPS-Users] opensips-cp

2008-11-27 Thread Dragos Oancea
Hi http://sourceforge.net/forum/forum.php?thread_id=2410178forum_id=857853 Dragos Tseveendorj Ochirlantuu wrote: Hello, I'm installing opensips-cp on debian. There is any *generate-cdrs.sh* file in cron_jobs folder.* *Where can I find that script? Thank you. Tseveen.* *

Re: [OpenSIPS-Users] opensips-cp CDRs tips

2008-11-27 Thread Dragos Oancea
Gustavo Mistrinelli wrote: Dragos, I'm using opensips web interface.. and I love it, but let me suggest you some tips to help users with first setup: Glad you love it. However I cannot say I made OCP from the scratch , I'm only maintaining it and improving it. So its not `my code`. I

[OpenSIPS-Users] opensips-cp: Expiration session error

2008-11-27 Thread Gustavo Mistrinelli
Hi Dragos, when session gone expired I got a redirect error. My installation dir is /var/www/opensips-cp/ I found in config/session.php: echo('script language=JavaScriptwindow.open(*/cp/* index.php?err=2,_parent)/script'); I changed: echo('script language=JavaScriptwindow.open(*../../*i

[OpenSIPS-Users] opensips-cp cdrviewer

2008-11-26 Thread Andrew Yager
Hi, I'm working with opensips-cp and trying to get the cdrviewer to work. The acc table has the following structure: CREATE TABLE acc ( id INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL, method VARCHAR(16) DEFAULT '' NOT NULL, from_tag VARCHAR(64) DEFAULT '' NOT NULL,

<    1   2   3