Re: [OpenSIPS-Users] CDRtool vs CGRATES for Opensips 2.2 +

[DanB]

Hi Jeff,


You can build packages for CentOS also, you can find more details here:

https://github.com/cgrates/cgrates/tree/master/packages

On the other hand, in order to avoid abusing OpenSIPS mailing list with 
CGRateS related questions, feel free to join our google group or IRC 
channel and come up with any additional questions.


Cheers,
DanB


On 08.03.2017 10:26, users-requ...@lists.opensips.org wrote:

Message: 1
Date: Tue, 7 Mar 2017 17:26:40 -0500
From: Jeff Wilkie
To: OpenSIPS users mailling list
Subject: Re: [OpenSIPS-Users] CDRtool vs CGRATES for Opensips 2.2 +
Message-ID:

Content-Type: text/plain; charset="utf-8"

DanB,

Thanks for the very useful information!

I'm reading that the preferred install OS for CGRATES is Debian.  Most of
our development happens on CENTOS 6.x.  Are there packages yet for CENT?
Or would we be required to install from source if we keep that OS?

Thanks

Jeff Wilkie


___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

Re: [OpenSIPS-Users] CDRtool vs CGRATES for Opensips 2.2 +

[Jeff Wilkie]

DanB,

Thanks for the very useful information!

I'm reading that the preferred install OS for CGRATES is Debian.  Most of
our development happens on CENTOS 6.x.  Are there packages yet for CENT?
Or would we be required to install from source if we keep that OS?

Thanks

Jeff Wilkie


On Sun, Mar 5, 2017 at 6:32 AM, DanB  wrote:

> Hi Jeff,
>
> Although it is a slippery ground, in order to have the question answered,
> I can claim having experience with both systems (we used to install CDRTool
> for customers and still have today installs running since like 8 years
> without issues).
>
> CDRTool (CDR rating system):
>
> * Written in php, works closely with db (eg: relies on it's query
> speed with some caching for parts of the rates)
>
> * Mature implementation, not much development changing the code over
> the years (other than bug fixes).
>
> * Simple rating definition and implementation.
>
> * Web interface for rates management as well as CDRs.
>
> * Designed around rating CDRs and maintaining account balance.
>
>
> CGRateS (OCS - online charging system):
>
> * Written in Go, caches almost all information in process, database
> agnostic (abstracts databases into interfaces), database speed does not
> influence the speed of calculations, built on micro-services with full
> asynchronous processing.
>
> * Still in Release Candidate when it comes to architecture, evolved a
> lot over the years, master should be always stable in terms of
> functionality since it runs in production environments (architecture part
> is not yet declared stable - you can expect it to still evolve).
>
> * Complex rating (rates voice calls, data streams, sms, etc) and
> accounting (unlimited number of balances/bundles and failover between them
> during a call).
>
> * API (JSON) driven management (full set) with no official web
> interface available yet.
>
> * Additional functionality: fraud detection with automatic mitigation
> (3 layers: accounts, CDR stats, resources usage), CDR logging with support
> for interim records, QoS LCR and LCR over bundels, real-time (complete in
> memory) call statistics with pattern monitoring and triggers/web hooks
> towards external systems, derive charging (session emulation -
> reseller/distributor scenarios, customer/supplier parallel calculations),
> performance optimized (one CGRateS instance should be able to handle 5k
> requests per second in terms of rating calculations), built-in high
> availability for Diameter setups.
>
>
> So these being said, it is all about the need vs price (time investment)
> you are ready to pay for it by using one system or another (considering
> both systems are opensource and you can extend yourself in one way or
> another). If you don't have complex rating requirements nor the need of
> increased CPS, I trust CDRTool will do the job just fine since it did it
> for us over the years (you get the advantage as said of simple management
> and architecture stability, quick learning curve). CGRateS on the other
> hand should be there if you decide you need more functionality/speed and
> you are also ready to offer it more time and efforts.
>
>
> I hope this helps someone!
>
> DanB
>
>
> ___
> 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] CDRtool vs CGRATES for Opensips 2.2 +

[Annus Fictus]

+1

Thank you

El 05/03/2017 a las 06:32, DanB escribió:

Hi Jeff,

Although it is a slippery ground, in order to have the question 
answered, I can claim having experience with both systems (we used to 
install CDRTool for customers and still have today installs running 
since like 8 years without issues).


CDRTool (CDR rating system):

* Written in php, works closely with db (eg: relies on it's query 
speed with some caching for parts of the rates)


* Mature implementation, not much development changing the code 
over the years (other than bug fixes).


* Simple rating definition and implementation.

* Web interface for rates management as well as CDRs.

* Designed around rating CDRs and maintaining account balance.


CGRateS (OCS - online charging system):

* Written in Go, caches almost all information in process, 
database agnostic (abstracts databases into interfaces), database 
speed does not influence the speed of calculations, built on 
micro-services with full asynchronous processing.


* Still in Release Candidate when it comes to architecture, 
evolved a lot over the years, master should be always stable in terms 
of functionality since it runs in production environments 
(architecture part is not yet declared stable - you can expect it to 
still evolve).


* Complex rating (rates voice calls, data streams, sms, etc) and 
accounting (unlimited number of balances/bundles and failover between 
them during a call).


* API (JSON) driven management (full set) with no official web 
interface available yet.


* Additional functionality: fraud detection with automatic 
mitigation (3 layers: accounts, CDR stats, resources usage), CDR 
logging with support for interim records, QoS LCR and LCR over 
bundels, real-time (complete in memory) call statistics with pattern 
monitoring and triggers/web hooks towards external systems, derive 
charging (session emulation - reseller/distributor scenarios, 
customer/supplier parallel calculations), performance optimized (one 
CGRateS instance should be able to handle 5k requests per second in 
terms of rating calculations), built-in high availability for Diameter 
setups.



So these being said, it is all about the need vs price (time 
investment) you are ready to pay for it by using one system or another 
(considering both systems are opensource and you can extend yourself 
in one way or another). If you don't have complex rating requirements 
nor the need of increased CPS, I trust CDRTool will do the job just 
fine since it did it for us over the years (you get the advantage as 
said of simple management and architecture stability, quick learning 
curve). CGRateS on the other hand should be there if you decide you 
need more functionality/speed and you are also ready to offer it more 
time and efforts.



I hope this helps someone!

DanB


___
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] CDRtool vs CGRATES for Opensips 2.2 +

[DanB]

Hi Jeff,

Although it is a slippery ground, in order to have the question 
answered, I can claim having experience with both systems (we used to 
install CDRTool for customers and still have today installs running 
since like 8 years without issues).


CDRTool (CDR rating system):

* Written in php, works closely with db (eg: relies on it's query 
speed with some caching for parts of the rates)


* Mature implementation, not much development changing the code 
over the years (other than bug fixes).


* Simple rating definition and implementation.

* Web interface for rates management as well as CDRs.

* Designed around rating CDRs and maintaining account balance.


CGRateS (OCS - online charging system):

* Written in Go, caches almost all information in process, database 
agnostic (abstracts databases into interfaces), database speed does not 
influence the speed of calculations, built on micro-services with full 
asynchronous processing.


* Still in Release Candidate when it comes to architecture, evolved 
a lot over the years, master should be always stable in terms of 
functionality since it runs in production environments (architecture 
part is not yet declared stable - you can expect it to still evolve).


* Complex rating (rates voice calls, data streams, sms, etc) and 
accounting (unlimited number of balances/bundles and failover between 
them during a call).


* API (JSON) driven management (full set) with no official web 
interface available yet.


* Additional functionality: fraud detection with automatic 
mitigation (3 layers: accounts, CDR stats, resources usage), CDR logging 
with support for interim records, QoS LCR and LCR over bundels, 
real-time (complete in memory) call statistics with pattern monitoring 
and triggers/web hooks towards external systems, derive charging 
(session emulation - reseller/distributor scenarios, customer/supplier 
parallel calculations), performance optimized (one CGRateS instance 
should be able to handle 5k requests per second in terms of rating 
calculations), built-in high availability for Diameter setups.



So these being said, it is all about the need vs price (time investment) 
you are ready to pay for it by using one system or another (considering 
both systems are opensource and you can extend yourself in one way or 
another). If you don't have complex rating requirements nor the need of 
increased CPS, I trust CDRTool will do the job just fine since it did it 
for us over the years (you get the advantage as said of simple 
management and architecture stability, quick learning curve). CGRateS on 
the other hand should be there if you decide you need more 
functionality/speed and you are also ready to offer it more time and 
efforts.



I hope this helps someone!

DanB


___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

[OpenSIPS-Users] CDRtool vs CGRATES for Opensips 2.2 +

[Jeff Wilkie]

Just pinging the general community on a pros/cons list between these two
systems for rating calls.  I would love to hear feedback on comparisons and
experiences. Finding it hard to see big differences from documentation
other than methods to produce the records and the graphical front end.

Thanks

Jeff Wilkie
___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

Re: [OpenSIPS-Users] CDRTool 9.4 + OpenSIPS 2.1.2 (trusted_peers table issue)

[Laszlo]

http://www.openser.org/pipermail/users/2009-December/009882.html

try creating this view

On Sun, Jan 31, 2016 at 8:02 PM, Eugene Romanenko  wrote:

> Hello there!
>
> I have an issue with installation CDRTools.
> When I try to start cdrtool via command:
> /etc/init.d/cdrtool start
>
> I see this issue:
> Jan 31 13:52:24 d2600 cdrtool[31249]: Database error: Invalid SQL: select
> * from trusted_peers
>
> ​in syslog
>
> Can anybody help me?​
>
>
> --
> Best regards,
> Eugene Romanenko.
> ServerClub support team.
>
> ___
> Users mailing list
> Users@lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>


-- 

--
Kind regards,
Laszlo Bekesi
http://voipfreak.net
___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

[OpenSIPS-Users] CDRTool 9.4 + OpenSIPS 2.1.2 (trusted_peers table issue)

[Eugene Romanenko]

Hello there!

I have an issue with installation CDRTools.
When I try to start cdrtool via command:
/etc/init.d/cdrtool start

I see this issue:
Jan 31 13:52:24 d2600 cdrtool[31249]: Database error: Invalid SQL: select *
from trusted_peers

​in syslog

Can anybody help me?​


-- 
Best regards,
Eugene Romanenko.
ServerClub support team.
___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

Re: [OpenSIPS-Users] CDRTool and OSIPS 2.1

[Laszlo]

On Tue, Jul 21, 2015 at 6:10 PM, Garry M. Paxinos  wrote:

> Greetings,
>
> I'm beginning to experiment with OSIPS 2.1 and CDRTool.   Is there any
> information available to help guide one in this endeavor?I've tried
> both the tarballs   and retrieving from dracs, but there seem to be several
> issues that need to be resolved.  The current one I'm looking at revolves
> around the 'trusted_peers' table from OSIPS 1.4.
>
> Any guidance or pointers are greatly appreciated.
>
> Thanks,
> Pax.
>
>
> --
> *Garry M. Paxinos*
>
> CTO
>
>
>
> *netTALK*.COM, INC. | *1080* NW 163rd Drive, Miami, FL 33169
>
> (E) p...@nettalk.com | (O) 305.621.1200, x210 | (C) 954.655.7453
>
>
>
>
> *ΓΝΩΘΙ ΣΑΥΤΟΝ*
>
> "The real voyage of discovery consists not in seeking new landscapes but
> in having new eyes." -Proust
>
> "Wherever you go, go with all of your heart" -
> Confucius
>
>
Old thing, but it should work:

http://www.openser.org/pipermail/users/2009-December/009882.html


--
Kind regards,
Laszlo Bekesi
http://voipfreak.net
___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

[OpenSIPS-Users] CDRTool and OSIPS 2.1

[Garry M. Paxinos]

Greetings,

I'm beginning to experiment with OSIPS 2.1 and CDRTool.   Is there any
information available to help guide one in this endeavor?I've tried
both the tarballs   and retrieving from dracs, but there seem to be several
issues that need to be resolved.  The current one I'm looking at revolves
around the 'trusted_peers' table from OSIPS 1.4.

Any guidance or pointers are greatly appreciated.

Thanks,
Pax.


-- 
*Garry M. Paxinos*

CTO



*netTALK*.COM, INC. | *1080* NW 163rd Drive, Miami, FL 33169

(E) p...@nettalk.com | (O) 305.621.1200, x210 | (C) 954.655.7453




*ΓΝΩΘΙ ΣΑΥΤΟΝ*

"The real voyage of discovery consists not in seeking new landscapes but in
having new eyes." -Proust

"Wherever you go, go with all of your heart" -
Confucius
___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

[OpenSIPS-Users] CDRTool / Freeradius / MySQL

[dotnetdub]

Hi,

sometime ago only myisam storage engine was supported. Is INNODb supported now?

Many thanks
Brian

___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

Re: [OpenSIPS-Users] CDRtool 9.3 web interface

[Adrià Vidal]

Yes it solves the problem, thanks!

2015-03-03 17:49 GMT+01:00 Tijmen de Mes :

> Hi,
>
> I see the problem now. I will send a patch to you private email which you
> can apply to CDRTool. Hopefully it will fix this problem.
>
> Best regards,
>
> Tijmen de Mes
> —
> AG Projects
>
>
> On 3 mrt. 2015, at 17:02, Adrià Vidal  wrote:
>
>
> 2015-03-03 11:30 GMT+01:00 Tijmen de Mes :
>
>> Hi,
>>
>> Clicking on the icons does not work. If you click on the input field you
>> should get a date picker.
>>
>> If you don’t get it please take a look at the webbrowsers console if get
>> any error or exception.
>>
>> Best regards,
>>
>> Tijmen de Mes
>>
>
> I see no input field to click on
>
>
> https://www.dropbox.com/s/w55ynwrc1kbps6d/Captura%20de%20pantalla%202015-03-03%2017.02.14.png?dl=0
>
>
>
>
> --
> --
> Adrià Vidal
>
> T. 93 150 31 80 | M 607 28 89 56
>
> @ ad...@gmail.com
>
> www www.xpreme.net | centralitaip.xpreme.net
>
> twitter xpreme_it 
>  ___
> 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
>
>


-- 
--
Adrià Vidal

T. 93 150 31 80 | M 607 28 89 56

@ ad...@gmail.com

www www.xpreme.net | centralitaip.xpreme.net

twitter xpreme_it 
___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

Re: [OpenSIPS-Users] CDRtool 9.3 web interface

[Tijmen de Mes]

Hi,

I see the problem now. I will send a patch to you private email which you can 
apply to CDRTool. Hopefully it will fix this problem.

Best regards,

Tijmen de Mes
—
AG Projects


> On 3 mrt. 2015, at 17:02, Adrià Vidal  wrote:
> 
> 
> 2015-03-03 11:30 GMT+01:00 Tijmen de Mes  >:
> Hi,
> 
> Clicking on the icons does not work. If you click on the input field you 
> should get a date picker.
> 
> If you don’t get it please take a look at the webbrowsers console if get any 
> error or exception.
> 
> Best regards,
> 
> Tijmen de Mes
> 
> I see no input field to click on
> 
> https://www.dropbox.com/s/w55ynwrc1kbps6d/Captura%20de%20pantalla%202015-03-03%2017.02.14.png?dl=0
>  
> 
> 
> 
> 
> 
> --
> --
> Adrià Vidal
> 
> T. 93 150 31 80 | M 607 28 89 56
> @ ad...@gmail.com 
> www www.xpreme.net  | centralitaip.xpreme.net 
> 
> twitter xpreme_it 
> ___
> Users mailing list
> Users@lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users



signature.asc
Description: Message signed with OpenPGP using GPGMail
___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

Re: [OpenSIPS-Users] CDRtool 9.3 web interface

[Adrià Vidal]

2015-03-03 11:30 GMT+01:00 Tijmen de Mes :

> Hi,
>
> Clicking on the icons does not work. If you click on the input field you
> should get a date picker.
>
> If you don’t get it please take a look at the webbrowsers console if get
> any error or exception.
>
> Best regards,
>
> Tijmen de Mes
>

I see no input field to click on

https://www.dropbox.com/s/w55ynwrc1kbps6d/Captura%20de%20pantalla%202015-03-03%2017.02.14.png?dl=0




-- 
--
Adrià Vidal

T. 93 150 31 80 | M 607 28 89 56

@ ad...@gmail.com

www www.xpreme.net | centralitaip.xpreme.net

twitter xpreme_it 
___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

Re: [OpenSIPS-Users] CDRtool 9.3 web interface

[Tijmen de Mes]

Hi,

Clicking on the icons does not work. If you click on the input field you should 
get a date picker.

If you don’t get it please take a look at the webbrowsers console if get any 
error or exception.

Best regards,

Tijmen de Mes
—
AG-Projects

> On 3 mrt. 2015, at 10:44, Adrià Vidal  wrote:
> 
> I'm facing a problem with CDRTool 9.3,
> on the web interface i can't select the date or time, i try to click the 
> icons but nothing happen.
> 
> I've located the problem at
> 
> cdr_generic.php
> 
> $f->show_element("begin_date","");
> 
> print "
> 
>  ";
> 
> p.d. I've tried with different browsers/systems too
> --
> --
> Adrià Vidal
> 
> 
> ___
> Users mailing list
> Users@lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users



signature.asc
Description: Message signed with OpenPGP using GPGMail
___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

[OpenSIPS-Users] CDRtool 9.3 web interface

[Adrià Vidal]

I'm facing a problem with CDRTool 9.3,
on the web interface i can't select the date or time, i try to click the
icons but nothing happen.

I've located the problem at

cdr_generic.php

$f->show_element("begin_date","");

print "

 ";

p.d. I've tried with different browsers/systems too
-- 
--
Adrià Vidal
___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

[OpenSIPS-Users] cdrtool and toll-free numbers

[Pavel Eremin]

Hi, all! can CDRTool rate ordinary call and call to Toll-Free numbers at
the same time?

I know that we can change field "Username" (BillingPartyId") but how to use
field "FROM"  for Toll-Free numbers and "Username" for ordinary calls.
___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

Re: [OpenSIPS-Users] cdrtool install

[Laszlo]

On Fri, Nov 14, 2014 at 7:51 AM, Tito Cumpen  wrote:

> hey group,
>
>
> I have tried installing ag projects cdrtool from the wheezy repo As
> stated in the install guide and I am having a couple of issues. The first
> of my issues was the following
> this happened when attempting to run
>
> /var/www/CDRTool/scripts/importRatingTables.php
> PHP Fatal error:  Call-time pass-by-reference has been removed in
> /var/www/CDRTool/phplib/session.inc on line 259
>
> Also is there anyway to check why the CDRtool page is not loading?
> Currently I am getting a blank page with no errors. PHp seems to be loading
> fine by the way. and I've changed my virtual hosts entry to the cdr tool
> root folder in /var/www .
> via
>
>
> Can cdr tool report on failure routes? Say a call went to another carrier?
>
>
> Thanks,
>
> ___
> Users mailing list
> Users@lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>

Try running it under PHP 5.3.x, or you can remove ampersands from 3-4 lines
if you know PHP well :)

-- 

--
Kind regards,
Laszlo Bekesi
http://voipfreak.net
___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

[OpenSIPS-Users] cdrtool install

[Tito Cumpen]

hey group,


I have tried installing ag projects cdrtool from the wheezy repo As
stated in the install guide and I am having a couple of issues. The first
of my issues was the following
this happened when attempting to run

/var/www/CDRTool/scripts/importRatingTables.php
PHP Fatal error:  Call-time pass-by-reference has been removed in
/var/www/CDRTool/phplib/session.inc on line 259

Also is there anyway to check why the CDRtool page is not loading?
Currently I am getting a blank page with no errors. PHp seems to be loading
fine by the way. and I've changed my virtual hosts entry to the cdr tool
root folder in /var/www .
via


Can cdr tool report on failure routes? Say a call went to another carrier?


Thanks,
___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

Re: [OpenSIPS-Users] CDRTool prepaid for big installation

[Satish Patel]

Great! I figured out, it was group module. 

--
Sent from my iPhone

> On Oct 14, 2014, at 1:17 PM, Adrian Georgescu  wrote:
> 
> 
>> On 14 Oct 2014, at 13:02, Satish Patel  wrote:
>> 
>> I am reading this document to implement Quota 
>> http://cdrtool.ag-projects.com/projects/cdrtool/repository/entry/doc/QuotaSystem.txt
>> 
>> In number  3. Configure OpenSIPS to deny sessions initiated by subscribers 
>> belonging to the quota group.
>> 
>> what that means? How do i configure opensips to deny session, is it part of 
>> callcontrol config?
> 
> 
> Check if the user belongs to that group and if yes don't let the call go 
> through. It has nothing to do with call control, is just a database query.
> 
> Adrian
> 
> 
> 
>> 
>> also it is saying belongs to the quota group, what is quota group? this is 
>> what i have in my subscriber table. Even after quota exceed it is not 
>> blocking call.  
>> 
>> +-+--+---+--+---+--+--+--+---+
>> | id  | username | domain| password | email_address | 
>> ha1  | ha1b | rpid | 
>> quota |
>> +-+--+---+--+---+--+--+--+---+
>> |   1 | 3003 | sip.example.com  | 3003 |   | 
>> 6fc4d74adfdedf25c72134154d3a9e1a | 3251dd8a5ef5a35d79a358bccb2c8179 | NULL | 
>> 1 |
>> 
>> 
>> 
>> 
>> 
>> 
>>> On Sun, Oct 12, 2014 at 7:30 PM, Adrian Georgescu  
>>> wrote:
>>> Quota works very simple. It is a mere cronjob that compares the total 
>>> amount of costs made in the current calendar month with the maximum 
>>> allowed. If the costs are higher than the quota, then the SIP account is 
>>> blocked. This will not cut the calls in progress but it works well 
>>> statistically speaking for postpaid customers. The documentation explains 
>>> the modus operandi in more detail.
>>> 
>>> Adrian
>>> 
 On 12 Oct 2014, at 11:14, Satish Patel  wrote:
 
 Thanks!! I think you got my point, we have very high density call ratio 
 that is why prepaid not going to be a solution, I think postpaid or quota 
 would be right one.  
 
 I have following question:
 
 Postpaid:
 
 Default it treat all calls as postpaid but in case i want to give number 
 of mins or time to my single customer then how do i achieve that  Example: 
  5000 mins or say $500 deposit in customer account then how i can do that 
 with postpaid? 
 
 
 Quota: I never  explore this feature so i just want to know how quota 
 system work with CDRTool? could you give me short explanation? Most of our 
 customer would be call center or high density call customer, how i can use 
 quota in that scenario?  
 
> On Sun, Oct 12, 2014 at 9:38 AM, Adrian Georgescu  
> wrote:
> 
>> On 12 Oct 2014, at 09:48, Satish Patel  wrote:
>> 
>> I have run sipp test and it only able to handle 30 calls and later all 
>> call failed,
> 
> Can you explain what exactly failed?
> 
>> I heard from other user post, CDRTool prepaid can't handle many 
>> simultaneous running calls.
> 
> You heard wrong. It cannot handle high density call attempts like calls 
> generated from call centers or transit peers like SIP trunks that push 
> lot of calls. The number of simultaneous calls is irrelevant. You can 
> have thousands of simultaneous calls with almost no performance penalty 
> if the traffic is generated by regular SIP user devices.
> 
>> In our case single account will make many simultaneous calls and we need 
>> to handle them via prepaid.. 
> 
> It all depends on the meaning of many. Whenever a new call is attempted, 
> the maximum remaining time of all ongoing calls of the same user must be 
> recalculated so that the balance cannot be exceeded for any of them. This 
> means that the more calls for the same user you have, the longer it takes 
> to calculated everything over and over again.
> 
> If you have many users with a few calls each like in a residential 
> scenario where a user makes one or perhaps two parallel calls, this would 
> have little impact as there is little to re-calculate.
> 
>> Some one suggested don't use prepaid because of limitation and 
>> performance, and suggested use Postpaid or Quota system..  is that true? 
>>  
> 
> It all depends on the traffic patterns. Concurrent or simultaneous calls 
> is one thing, high density calls/per second attempts is another. There is 
> no hard limitation but the number of database queries, distance to MySQL 
> database will affect how many calls you can handle because as I explained 
> before all concurrent calls

Re: [OpenSIPS-Users] CDRTool prepaid for big installation

[Adrian Georgescu]

On 14 Oct 2014, at 13:02, Satish Patel  wrote:

> I am reading this document to implement Quota 
> http://cdrtool.ag-projects.com/projects/cdrtool/repository/entry/doc/QuotaSystem.txt
> 
> In number  3. Configure OpenSIPS to deny sessions initiated by subscribers 
> belonging to the quota group.
> 
> what that means? How do i configure opensips to deny session, is it part of 
> callcontrol config? 


Check if the user belongs to that group and if yes don't let the call go 
through. It has nothing to do with call control, is just a database query.

Adrian



> 
> also it is saying belongs to the quota group, what is quota group? this is 
> what i have in my subscriber table. Even after quota exceed it is not 
> blocking call.  
> 
> +-+--+---+--+---+--+--+--+---+
> | id  | username | domain| password | email_address | ha1 
>  | ha1b | rpid | 
> quota |
> +-+--+---+--+---+--+--+--+---+
> |   1 | 3003 | sip.example.com  | 3003 |   | 
> 6fc4d74adfdedf25c72134154d3a9e1a | 3251dd8a5ef5a35d79a358bccb2c8179 | NULL |  
>1 |
> 
> 
> 
> 
> 
> 
> On Sun, Oct 12, 2014 at 7:30 PM, Adrian Georgescu  
> wrote:
> Quota works very simple. It is a mere cronjob that compares the total amount 
> of costs made in the current calendar month with the maximum allowed. If the 
> costs are higher than the quota, then the SIP account is blocked. This will 
> not cut the calls in progress but it works well statistically speaking for 
> postpaid customers. The documentation explains the modus operandi in more 
> detail.
> 
> Adrian
> 
> On 12 Oct 2014, at 11:14, Satish Patel  wrote:
> 
>> Thanks!! I think you got my point, we have very high density call ratio that 
>> is why prepaid not going to be a solution, I think postpaid or quota would 
>> be right one.  
>> 
>> I have following question:
>> 
>> Postpaid:
>> 
>> Default it treat all calls as postpaid but in case i want to give number of 
>> mins or time to my single customer then how do i achieve that  Example:  
>> 5000 mins or say $500 deposit in customer account then how i can do that 
>> with postpaid? 
>> 
>> 
>> Quota: I never  explore this feature so i just want to know how quota system 
>> work with CDRTool? could you give me short explanation? Most of our customer 
>> would be call center or high density call customer, how i can use quota in 
>> that scenario?  
>> 
>> On Sun, Oct 12, 2014 at 9:38 AM, Adrian Georgescu  
>> wrote:
>> 
>> On 12 Oct 2014, at 09:48, Satish Patel  wrote:
>> 
>>> I have run sipp test and it only able to handle 30 calls and later all call 
>>> failed,
>> 
>> Can you explain what exactly failed?
>> 
>>> I heard from other user post, CDRTool prepaid can't handle many 
>>> simultaneous running calls.
>> 
>> You heard wrong. It cannot handle high density call attempts like calls 
>> generated from call centers or transit peers like SIP trunks that push lot 
>> of calls. The number of simultaneous calls is irrelevant. You can have 
>> thousands of simultaneous calls with almost no performance penalty if the 
>> traffic is generated by regular SIP user devices.
>> 
>>> In our case single account will make many simultaneous calls and we need to 
>>> handle them via prepaid.. 
>> 
>> It all depends on the meaning of many. Whenever a new call is attempted, the 
>> maximum remaining time of all ongoing calls of the same user must be 
>> recalculated so that the balance cannot be exceeded for any of them. This 
>> means that the more calls for the same user you have, the longer it takes to 
>> calculated everything over and over again.
>> 
>> If you have many users with a few calls each like in a residential scenario 
>> where a user makes one or perhaps two parallel calls, this would have little 
>> impact as there is little to re-calculate.
>> 
>>> Some one suggested don't use prepaid because of limitation and performance, 
>>> and suggested use Postpaid or Quota system..  is that true?  
>> 
>> It all depends on the traffic patterns. Concurrent or simultaneous calls is 
>> one thing, high density calls/per second attempts is another. There is no 
>> hard limitation but the number of database queries, distance to MySQL 
>> database will affect how many calls you can handle because as I explained 
>> before all concurrent calls must be rerated in real time again for each new 
>> call attempt. If one SIP account generates 10K parallel calls the load is 
>> infinite while if you have 10K users with one call each the load is almost 
>> zero.
>> 
>> This is why a prepaid model is not practical for high density of calls and 
>> this has little to do with CDRTool, any other system would face the same 

Re: [OpenSIPS-Users] CDRTool prepaid for big installation

[Satish Patel]

I am reading this document to implement Quota
http://cdrtool.ag-projects.com/projects/cdrtool/repository/entry/doc/QuotaSystem.txt

In number  3. Configure OpenSIPS to deny sessions initiated by subscribers
belonging to the quota group.

what that means? How do i configure opensips to deny session, is it part of
callcontrol config?

also it is saying belongs to the quota group, what is quota group? this is
what i have in my subscriber table. Even after quota exceed it is not
blocking call.

+-+--+---+--+---+--+--+--+---+
| id  | username | domain| password | email_address |
ha1  | ha1b | rpid
| quota |
+-+--+---+--+---+--+--+--+---+
|   1 | 3003 | sip.example.com  | 3003 |   |
6fc4d74adfdedf25c72134154d3a9e1a | 3251dd8a5ef5a35d79a358bccb2c8179 | NULL
| 1 |






On Sun, Oct 12, 2014 at 7:30 PM, Adrian Georgescu 
wrote:

> Quota works very simple. It is a mere cronjob that compares the total
> amount of costs made in the current calendar month with the maximum
> allowed. If the costs are higher than the quota, then the SIP account is
> blocked. This will not cut the calls in progress but it works well
> statistically speaking for postpaid customers. The documentation explains
> the modus operandi in more detail.
>
> Adrian
>
> On 12 Oct 2014, at 11:14, Satish Patel  wrote:
>
> Thanks!! I think you got my point, we have very high density call ratio
> that is why prepaid not going to be a solution, I think postpaid or quota
> would be right one.
>
> I have following question:
>
> Postpaid:
>
> Default it treat all calls as postpaid but in case i want to give number
> of mins or time to my single customer then how do i achieve that  Example:
>  5000 mins or say $500 deposit in customer account then how i can do that
> with postpaid?
>
>
> Quota: I never  explore this feature so i just want to know how quota
> system work with CDRTool? could you give me short explanation? Most of our
> customer would be call center or high density call customer, how i can use
> quota in that scenario?
>
> On Sun, Oct 12, 2014 at 9:38 AM, Adrian Georgescu 
> wrote:
>
>>
>> On 12 Oct 2014, at 09:48, Satish Patel  wrote:
>>
>> I have run sipp test and it only able to handle 30 calls and later all
>> call failed,
>>
>>
>> Can you explain what exactly failed?
>>
>> I heard from other user post, CDRTool prepaid can't handle many
>> simultaneous running calls.
>>
>>
>> You heard wrong. It cannot handle high density call attempts like calls
>> generated from call centers or transit peers like SIP trunks that push lot
>> of calls. The number of simultaneous calls is irrelevant. You can have
>> thousands of simultaneous calls with almost no performance penalty if the
>> traffic is generated by regular SIP user devices.
>>
>> In our case single account will make many simultaneous calls and we need
>> to handle them via prepaid..
>>
>>
>> It all depends on the meaning of many. Whenever a new call is attempted,
>> the maximum remaining time of all ongoing calls of the same user must be
>> recalculated so that the balance cannot be exceeded for any of them. This
>> means that the more calls for the same user you have, the longer it takes
>> to calculated everything over and over again.
>>
>> If you have many users with a few calls each like in a residential
>> scenario where a user makes one or perhaps two parallel calls, this would
>> have little impact as there is little to re-calculate.
>>
>> Some one suggested don't use prepaid because of limitation and
>> performance, and suggested use Postpaid or Quota system..  is that true?
>>
>>
>> It all depends on the traffic patterns. Concurrent or simultaneous calls
>> is one thing, high density calls/per second attempts is another. There is
>> no hard limitation but the number of database queries, distance to MySQL
>> database will affect how many calls you can handle because as I explained
>> before all concurrent calls must be rerated in real time again for each new
>> call attempt. If one SIP account generates 10K parallel calls the load is
>> infinite while if you have 10K users with one call each the load is almost
>> zero.
>>
>> This is why a prepaid model is not practical for high density of calls
>> and this has little to do with CDRTool, any other system would face the
>> same problem, the load is compounded when adding more calls for same
>> account. A quota based system is more appropriate for entities that
>> generate large amount of calls as nothing has to be calculated on a per
>> call basis.
>>
>> Adrian
>>
>> On Thu, Oct 9, 2014 at 3:46 PM,  wrote:
>>
>>> Yes, it is capable.
>>>
>>> On 08 Oct 2014, at 15:42, Satish Patel 

Re: [OpenSIPS-Users] CDRTool prepaid for big installation

[Adrian Georgescu]

Quota works very simple. It is a mere cronjob that compares the total amount of 
costs made in the current calendar month with the maximum allowed. If the costs 
are higher than the quota, then the SIP account is blocked. This will not cut 
the calls in progress but it works well statistically speaking for postpaid 
customers. The documentation explains the modus operandi in more detail.

Adrian

On 12 Oct 2014, at 11:14, Satish Patel  wrote:

> Thanks!! I think you got my point, we have very high density call ratio that 
> is why prepaid not going to be a solution, I think postpaid or quota would be 
> right one.  
> 
> I have following question:
> 
> Postpaid:
> 
> Default it treat all calls as postpaid but in case i want to give number of 
> mins or time to my single customer then how do i achieve that  Example:  5000 
> mins or say $500 deposit in customer account then how i can do that with 
> postpaid? 
> 
> 
> Quota: I never  explore this feature so i just want to know how quota system 
> work with CDRTool? could you give me short explanation? Most of our customer 
> would be call center or high density call customer, how i can use quota in 
> that scenario?  
> 
> On Sun, Oct 12, 2014 at 9:38 AM, Adrian Georgescu  
> wrote:
> 
> On 12 Oct 2014, at 09:48, Satish Patel  wrote:
> 
>> I have run sipp test and it only able to handle 30 calls and later all call 
>> failed,
> 
> Can you explain what exactly failed?
> 
>> I heard from other user post, CDRTool prepaid can't handle many simultaneous 
>> running calls.
> 
> You heard wrong. It cannot handle high density call attempts like calls 
> generated from call centers or transit peers like SIP trunks that push lot of 
> calls. The number of simultaneous calls is irrelevant. You can have thousands 
> of simultaneous calls with almost no performance penalty if the traffic is 
> generated by regular SIP user devices.
> 
>> In our case single account will make many simultaneous calls and we need to 
>> handle them via prepaid.. 
> 
> It all depends on the meaning of many. Whenever a new call is attempted, the 
> maximum remaining time of all ongoing calls of the same user must be 
> recalculated so that the balance cannot be exceeded for any of them. This 
> means that the more calls for the same user you have, the longer it takes to 
> calculated everything over and over again.
> 
> If you have many users with a few calls each like in a residential scenario 
> where a user makes one or perhaps two parallel calls, this would have little 
> impact as there is little to re-calculate.
> 
>> Some one suggested don't use prepaid because of limitation and performance, 
>> and suggested use Postpaid or Quota system..  is that true?  
> 
> It all depends on the traffic patterns. Concurrent or simultaneous calls is 
> one thing, high density calls/per second attempts is another. There is no 
> hard limitation but the number of database queries, distance to MySQL 
> database will affect how many calls you can handle because as I explained 
> before all concurrent calls must be rerated in real time again for each new 
> call attempt. If one SIP account generates 10K parallel calls the load is 
> infinite while if you have 10K users with one call each the load is almost 
> zero.
> 
> This is why a prepaid model is not practical for high density of calls and 
> this has little to do with CDRTool, any other system would face the same 
> problem, the load is compounded when adding more calls for same account. A 
> quota based system is more appropriate for entities that generate large 
> amount of calls as nothing has to be calculated on a per call basis.
> 
> Adrian
> 
>> On Thu, Oct 9, 2014 at 3:46 PM,  wrote:
>> Yes, it is capable.
>> 
>> On 08 Oct 2014, at 15:42, Satish Patel  wrote:
>> 
>> > Hi,
>> >
>> > Just want to know does CDRTool prepaid capable of handling couple hundreds 
>> > of concurrent calls? I heard it can handle only 2/3 concurrent calls per 
>> > account?  what is the solution if we want to host big prepaid system with 
>> > thousands of 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
> 
> --
> Adrian
> 
> 
> 
> 
> ___
> 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

--
Adrian





signature.asc
Description: Message signed with OpenPGP 

Re: [OpenSIPS-Users] CDRTool prepaid for big installation

[Satish Patel]

Thanks!! I think you got my point, we have very high density call ratio
that is why prepaid not going to be a solution, I think postpaid or quota
would be right one.

I have following question:

Postpaid:

Default it treat all calls as postpaid but in case i want to give number of
mins or time to my single customer then how do i achieve that  Example:
 5000 mins or say $500 deposit in customer account then how i can do that
with postpaid?


Quota: I never  explore this feature so i just want to know how quota
system work with CDRTool? could you give me short explanation? Most of our
customer would be call center or high density call customer, how i can use
quota in that scenario?

On Sun, Oct 12, 2014 at 9:38 AM, Adrian Georgescu 
wrote:

>
> On 12 Oct 2014, at 09:48, Satish Patel  wrote:
>
> I have run sipp test and it only able to handle 30 calls and later all
> call failed,
>
>
> Can you explain what exactly failed?
>
> I heard from other user post, CDRTool prepaid can't handle many
> simultaneous running calls.
>
>
> You heard wrong. It cannot handle high density call attempts like calls
> generated from call centers or transit peers like SIP trunks that push lot
> of calls. The number of simultaneous calls is irrelevant. You can have
> thousands of simultaneous calls with almost no performance penalty if the
> traffic is generated by regular SIP user devices.
>
> In our case single account will make many simultaneous calls and we need
> to handle them via prepaid..
>
>
> It all depends on the meaning of many. Whenever a new call is attempted,
> the maximum remaining time of all ongoing calls of the same user must be
> recalculated so that the balance cannot be exceeded for any of them. This
> means that the more calls for the same user you have, the longer it takes
> to calculated everything over and over again.
>
> If you have many users with a few calls each like in a residential
> scenario where a user makes one or perhaps two parallel calls, this would
> have little impact as there is little to re-calculate.
>
> Some one suggested don't use prepaid because of limitation and
> performance, and suggested use Postpaid or Quota system..  is that true?
>
>
> It all depends on the traffic patterns. Concurrent or simultaneous calls
> is one thing, high density calls/per second attempts is another. There is
> no hard limitation but the number of database queries, distance to MySQL
> database will affect how many calls you can handle because as I explained
> before all concurrent calls must be rerated in real time again for each new
> call attempt. If one SIP account generates 10K parallel calls the load is
> infinite while if you have 10K users with one call each the load is almost
> zero.
>
> This is why a prepaid model is not practical for high density of calls and
> this has little to do with CDRTool, any other system would face the same
> problem, the load is compounded when adding more calls for same account. A
> quota based system is more appropriate for entities that generate large
> amount of calls as nothing has to be calculated on a per call basis.
>
> Adrian
>
> On Thu, Oct 9, 2014 at 3:46 PM,  wrote:
>
>> Yes, it is capable.
>>
>> On 08 Oct 2014, at 15:42, Satish Patel  wrote:
>>
>> > Hi,
>> >
>> > Just want to know does CDRTool prepaid capable of handling couple
>> hundreds of concurrent calls? I heard it can handle only 2/3 concurrent
>> calls per account?  what is the solution if we want to host big prepaid
>> system with thousands of 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
>
>
> --
> Adrian
>
>
>
>
> ___
> 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] CDRTool prepaid for big installation

[Adrian Georgescu]

On 12 Oct 2014, at 09:48, Satish Patel  wrote:

> I have run sipp test and it only able to handle 30 calls and later all call 
> failed,

Can you explain what exactly failed?

> I heard from other user post, CDRTool prepaid can't handle many simultaneous 
> running calls.

You heard wrong. It cannot handle high density call attempts like calls 
generated from call centers or transit peers like SIP trunks that push lot of 
calls. The number of simultaneous calls is irrelevant. You can have thousands 
of simultaneous calls with almost no performance penalty if the traffic is 
generated by regular SIP user devices.

> In our case single account will make many simultaneous calls and we need to 
> handle them via prepaid.. 

It all depends on the meaning of many. Whenever a new call is attempted, the 
maximum remaining time of all ongoing calls of the same user must be 
recalculated so that the balance cannot be exceeded for any of them. This means 
that the more calls for the same user you have, the longer it takes to 
calculated everything over and over again.

If you have many users with a few calls each like in a residential scenario 
where a user makes one or perhaps two parallel calls, this would have little 
impact as there is little to re-calculate.

> Some one suggested don't use prepaid because of limitation and performance, 
> and suggested use Postpaid or Quota system..  is that true?  

It all depends on the traffic patterns. Concurrent or simultaneous calls is one 
thing, high density calls/per second attempts is another. There is no hard 
limitation but the number of database queries, distance to MySQL database will 
affect how many calls you can handle because as I explained before all 
concurrent calls must be rerated in real time again for each new call attempt. 
If one SIP account generates 10K parallel calls the load is infinite while if 
you have 10K users with one call each the load is almost zero.

This is why a prepaid model is not practical for high density of calls and this 
has little to do with CDRTool, any other system would face the same problem, 
the load is compounded when adding more calls for same account. A quota based 
system is more appropriate for entities that generate large amount of calls as 
nothing has to be calculated on a per call basis.

Adrian

> On Thu, Oct 9, 2014 at 3:46 PM,  wrote:
> Yes, it is capable.
> 
> On 08 Oct 2014, at 15:42, Satish Patel  wrote:
> 
> > Hi,
> >
> > Just want to know does CDRTool prepaid capable of handling couple hundreds 
> > of concurrent calls? I heard it can handle only 2/3 concurrent calls per 
> > account?  what is the solution if we want to host big prepaid system with 
> > thousands of 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

--
Adrian





signature.asc
Description: Message signed with OpenPGP using GPGMail
___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

Re: [OpenSIPS-Users] CDRTool prepaid for big installation

[Satish Patel]

I have run sipp test and it only able to handle 30 calls and later all call
failed, I heard from other user post, CDRTool prepaid can't handle many
simultaneous running calls. In our case single account will make many
simultaneous calls and we need to handle them via prepaid..

Some one suggested don't use prepaid because of limitation and performance,
and suggested use Postpaid or Quota system..  is that true?

On Thu, Oct 9, 2014 at 3:46 PM,  wrote:

> Yes, it is capable.
>
> On 08 Oct 2014, at 15:42, Satish Patel  wrote:
>
> > Hi,
> >
> > Just want to know does CDRTool prepaid capable of handling couple
> hundreds of concurrent calls? I heard it can handle only 2/3 concurrent
> calls per account?  what is the solution if we want to host big prepaid
> system with thousands of 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] CDRTool prepaid for big installation

[ag]

Yes, it is capable.

On 08 Oct 2014, at 15:42, Satish Patel  wrote:

> Hi, 
> 
> Just want to know does CDRTool prepaid capable of handling couple hundreds of 
> concurrent calls? I heard it can handle only 2/3 concurrent calls per 
> account?  what is the solution if we want to host big prepaid system with 
> thousands of 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

[OpenSIPS-Users] CDRTool prepaid for big installation

[Satish Patel]

Hi,

Just want to know does CDRTool prepaid capable of handling couple hundreds
of concurrent calls? I heard it can handle only 2/3 concurrent calls per
account?  what is the solution if we want to host big prepaid system with
thousands of users?
___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

Re: [OpenSIPS-Users] CDRtool

[Pavel Eremin]

Thanks for explain some concepts. It is very usefull.
30.09.2014 20:33 пользователь "Adrian Georgescu" 
написал:

> Rating in real time involves many database and other operations depending
> on the complexity of the rating tables. Pushing 60 calls per second in a
> residential scenario will yield a lot of simultaneous calls. You can handle
> the traffic of many residential subscribers at 60 cps. I am personally
> surprised you were able to do this on one machine.
>
> You are trying to use the application in a high density trunking scenario
> and is no wonder you hit a limit, the application was not designed for
> being used in such scenario. The idea was to be able to handle 2/3 calls
> for discrete SIP devices belongs to one SIP account, where each SIP account
> corresponds to a SIP device like a cable modem used by residential
> subscribers. You are pushing it to do things beyond its design envelope.
>
> You should better use the quota system with postpaid rather than real time
> prepaid for what you describe as it makes little sense to have prepaid
> balance calculated in real time for high density trunks that generate lots
> of traffic and associated costs.
>
> Adrian
>
> On 30 Sep 2014, at 09:57, Pavel Eremin  wrote:
>
> Thanks, i read all of docs and have question about performance. (I Did
> describe it in another email to community)
> 30.09.2014 4:56 пользователь "Adrian Georgescu" 
> написал:
>
>> If you want to dive this deep into CDRTool, it would be a good start to
>> read the documentation, that is all *.txt files in docs/ folder.
>>
>> --
>> Adrian
>>
>>
>>
>>
>> ___
>> 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
>
>
> --
> Adrian
>
>
>
>
> ___
> 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] CDRtool

[Adrian Georgescu]

Rating in real time involves many database and other operations depending on 
the complexity of the rating tables. Pushing 60 calls per second in a 
residential scenario will yield a lot of simultaneous calls. You can handle the 
traffic of many residential subscribers at 60 cps. I am personally surprised 
you were able to do this on one machine. 

You are trying to use the application in a high density trunking scenario and 
is no wonder you hit a limit, the application was not designed for being used 
in such scenario. The idea was to be able to handle 2/3 calls for discrete SIP 
devices belongs to one SIP account, where each SIP account corresponds to a SIP 
device like a cable modem used by residential subscribers. You are pushing it 
to do things beyond its design envelope. 

You should better use the quota system with postpaid rather than real time 
prepaid for what you describe as it makes little sense to have prepaid balance 
calculated in real time for high density trunks that generate lots of traffic 
and associated costs.

Adrian

On 30 Sep 2014, at 09:57, Pavel Eremin  wrote:

> Thanks, i read all of docs and have question about performance. (I Did 
> describe it in another email to community)
> 
> 30.09.2014 4:56 пользователь "Adrian Georgescu"  
> написал:
> If you want to dive this deep into CDRTool, it would be a good start to read 
> the documentation, that is all *.txt files in docs/ folder.
> 
> --
> Adrian
> 
> 
> 
> 
> ___
> 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

--
Adrian





signature.asc
Description: Message signed with OpenPGP using GPGMail
___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

Re: [OpenSIPS-Users] CDRtool

[Pavel Eremin]

Thanks, i read all of docs and have question about performance. (I Did
describe it in another email to community)
30.09.2014 4:56 пользователь "Adrian Georgescu" 
написал:

> If you want to dive this deep into CDRTool, it would be a good start to
> read the documentation, that is all *.txt files in docs/ folder.
>
> --
> Adrian
>
>
>
>
> ___
> 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

[OpenSIPS-Users] CDRTool Performance

[Pavel Eremin]

I have tested CDTool with PREPAID and still have many failed calls.

Server are : Dell 2900 \ Rem - 8gb \ Hard Disk - 300GB 15k RPM \ Processor
- 2xQuad core

1. Mysql in HDD \ PREPAID is active \ Duration 3 sec
*after 9 calls per sec - have droped calls*
2. Mysql in Memory \ PREPAID is active \ Duration 3 sec
after 30 calls per sec - have droped calls

3. Mysql in HDD \ POSTPAID \ Duration 3 sec
after 60 calls per sec - have droped calls
4. Mysql in Memory \ POSTPAID \ Duration 3 sec
after 60 calls per sec - have droped calls

i am not sure but in documentation i read that prepaid does not affect on
performance when recalc online sessions. But i think it does.

Can i disable recalc active_sessions in CDRTools?
___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

Re: [OpenSIPS-Users] CDRtool

[Adrian Georgescu]

If you want to dive this deep into CDRTool, it would be a good start to read 
the documentation, that is all *.txt files in docs/ folder.

--
Adrian





signature.asc
Description: Message signed with OpenPGP using GPGMail
___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

Re: [OpenSIPS-Users] CDRtool

[Tijmen de Mes]

Hi,

At this point in the code the call is already prepaid since the account has 
been found with the query:

$query=sprintf("select * from %s where account = 
'%s'",addslashes($this->prepaid_table),addslashes($CDR->BillingPartyId));

Normally if the normalized number starts with a 0 it is routed to PSTN, what in 
most cases has a price. If a number resolves over ENUM, the Normalized URI 
would not start with a 0, but will be a sip account. 

This is just a convention we made and therefore you also should not have 
accounts starting with a 0

-- 
Tijmen de Mes
AG-Projects

From: Pavel Eremin 
Reply: OpenSIPS users mailling list >
Date: 29 september 2014 at 18:30:00
To: OpenSIPS users mailling list >
Subject:  Re: [OpenSIPS-Users] CDRtool  

This code in rating.php...

2014-09-29 22:18 GMT+06:00 Pavel Eremin :
Hi, All! Let's dance with CDRTool

I am trying to use it on heavy load system and get stack.

Why in this code author match canonical number with string started by 0?(in 
hard way) Because of this line all calls are postpaid...:(

            if (!preg_match("/^0[9-0]{1,}@/",$CDR->CanonicalURINormalized)) {
                $log=sprintf ("MaxSessionTime=unlimited Type=prepaid CallId=%s 
BillingParty=%s DestId=None",$NetFields['callid'],$CDR->BillingPartyId);
                syslog(LOG_NOTICE, $log);
                $this->logRuntime();
                $ret="none"."\n"."type=prepaid";
                return $ret;
            } else {
                if (!$CDR->DestinationId) {
                    $log = sprintf ("error: cannot figure out the destination 
id for %s",$CDR->CanonicalURI);
                    $this->logRuntime();
                    syslog(LOG_NOTICE, $log);
                    $ret=$log."\n"."type=prepaid";
                    return $ret;
                }
            }


___  
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] CDRtool

[Pavel Eremin]

This code in rating.php...

2014-09-29 22:18 GMT+06:00 Pavel Eremin :

> Hi, All! Let's dance with CDRTool
>
> I am trying to use it on heavy load system and get stack.
>
> Why in this code author match canonical number with string started by
> 0?(in hard way) Because of this line all calls are postpaid...:(
>
>* if
> (!preg_match("/^0[9-0]{1,}@/",$CDR->CanonicalURINormalized))* {
> $log=sprintf ("MaxSessionTime=unlimited Type=prepaid
> CallId=%s BillingParty=%s
> DestId=None",$NetFields['callid'],$CDR->BillingPartyId);
> syslog(LOG_NOTICE, $log);
> $this->logRuntime();
> $ret="none"."\n"."type=prepaid";
> return $ret;
> } else {
> if (!$CDR->DestinationId) {
> $log = sprintf ("error: cannot figure out the
> destination id for %s",$CDR->CanonicalURI);
> $this->logRuntime();
> syslog(LOG_NOTICE, $log);
> $ret=$log."\n"."type=prepaid";
> return $ret;
> }
> }
>
>
___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

[OpenSIPS-Users] CDRtool

[Pavel Eremin]

Hi, All! Let's dance with CDRTool

I am trying to use it on heavy load system and get stack.

Why in this code author match canonical number with string started by 0?(in
hard way) Because of this line all calls are postpaid...:(

   * if
(!preg_match("/^0[9-0]{1,}@/",$CDR->CanonicalURINormalized))* {
$log=sprintf ("MaxSessionTime=unlimited Type=prepaid
CallId=%s BillingParty=%s
DestId=None",$NetFields['callid'],$CDR->BillingPartyId);
syslog(LOG_NOTICE, $log);
$this->logRuntime();
$ret="none"."\n"."type=prepaid";
return $ret;
} else {
if (!$CDR->DestinationId) {
$log = sprintf ("error: cannot figure out the
destination id for %s",$CDR->CanonicalURI);
$this->logRuntime();
syslog(LOG_NOTICE, $log);
$ret=$log."\n"."type=prepaid";
return $ret;
}
}
___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

[OpenSIPS-Users] CDRtool and perfomance with short calls( 3 sec )

[Pavel Eremin]

Hi, All! I am using CDRTool with prepaid and when reached 15 calls per
second i have  low performance.

As I understood CDRtool engine gets ALL active session and recalc
MaxSessionTime for ALL calls when new call happens?

so if i have many short calls CDRTool has heavy load.

I don't want to recalc active session. (let negative balance be).

Can i do it without make a lot of changes in code? may be disable some
function in rating.php?

PS: I have read docs about PREPAID "This scheme provides a
fair balancing policy with small performance penalty on the servers."
___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

[OpenSIPS-Users] CDRTool IP Auth

[Pavel Eremin]

Hi people!

We need to implement some features in CDRTool and ready to work with
developer who can do it.

Core:
1. Prepaid based on IP Authorization.

Web:
For customer:
Add some pages and other things.

1. "Balance"  - default page with account information,
2. "Balance History" - recharge history(+balance, -balance),
3. Source IP in CDR lists,
4. "Rates" - rate list like in Admin part of portal,

Main aim is Core part.

All things above will be, a patch to CDRtool, so i will be available for
all community.
___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

[OpenSIPS-Users] CDRTool Allowing(Showing) Negative Balance??

[Venkatesh Macha]

Hello List,

 I am using CDRTool for prepaid engine with opensips. it is
working fine. but few(2 or 3) of my prepaid users are have Negative balance.
Why my users have Negative Balance ??? 
What are the possibilities for CDRTool to reach Negative balance???. Anyway
it is not allowing negative balance user to make new calls.

Thank you in Advance..

Venkatesh Macha,
Junior VOIP Engineer,
@ sillycodes4u   



--
View this message in context: 
http://opensips-open-sip-server.1449251.n2.nabble.com/CDRTool-Allowing-Showing-Negative-Balance-tp7593451.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

Re: [OpenSIPS-Users] CDRTool Prepaid Billing configuration question

[Mo Rajib]

Thanks Craig. That’s what I suspect.

 

From: users-boun...@lists.opensips.org 
[mailto:users-boun...@lists.opensips.org] On Behalf Of Craig Guy
Sent: Monday, August 25, 2014 5:31 AM
To: OpenSIPS users mailling list
Subject: Re: [OpenSIPS-Users] CDRTool Prepaid Billing configuration question

 

CDRTool will not work with PHP 5.4, you'll need to use PHP 5.3.

 

Craig

 

On 23 August 2014 21:41, Mo Rajib  wrote:

Satish,

When you installed CDRTool with opensips, what PHP version did you use? I am 
running PHP 4.4 and I suspect that CDRTool is not yet compatible with PHP 4.4. 

 

Thanks,

 

Mo


___
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] CDRTool Prepaid Billing configuration question

[Tijmen de Mes]

Hi,

The latest code from darcs should be compatible with 5.4. Soon there will be a 
release with this included.


-- 
Tijmen de Mes
AG-Projects

From: Craig Guy 
Reply: OpenSIPS users mailling list >
Date: 25 augustus 2014 at 06:31:20
To: OpenSIPS users mailling list >
Subject:  Re: [OpenSIPS-Users] CDRTool Prepaid Billing configuration question  

CDRTool will not work with PHP 5.4, you'll need to use PHP 5.3.

Craig


On 23 August 2014 21:41, Mo Rajib  wrote:
Satish,

When you installed CDRTool with opensips, what PHP version did you use? I am 
running PHP 4.4 and I suspect that CDRTool is not yet compatible with PHP 4.4.

 

Thanks,

 

Mo


___
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] CDRTool Prepaid Billing configuration question

[Craig Guy]

CDRTool will not work with PHP 5.4, you'll need to use PHP 5.3.

Craig


On 23 August 2014 21:41, Mo Rajib  wrote:

> Satish,
>
> When you installed CDRTool with opensips, what PHP version did you use? I
> am running PHP 4.4 and I suspect that CDRTool is not yet compatible with
> PHP 4.4.
>
>
>
> Thanks,
>
>
>
> Mo
>
> ___
> 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] CDRTool Prepaid Billing configuration question

[Mo Rajib]

Satish,

When you installed CDRTool with opensips, what PHP version did you use? I am
running PHP 4.4 and I suspect that CDRTool is not yet compatible with PHP
4.4. 

 

Thanks,

 

Mo

___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

Re: [OpenSIPS-Users] CDRTool E.164 number

[Satish Patel]

Thanks for reply Adrian,

I have one more question, Problem is my customer only want to dial
1  they don't like 001 idea, Now i want to set up something
in asterisk so when i dial 1 it will automatically append
00 prefix but i don't know how do i configure that part in Opensips.. do
you have any example or some kind of document?

I will appropriate your help


On Fri, Aug 22, 2014 at 7:38 PM, Adrian Georgescu 
wrote:

>
> On 22 Aug 2014, at 17:24, Satish Patel  wrote:
>
> CDRTool driving me crazy... I have setup CDR with Call_control module and
> now problem is international number..
>
> My first question how do i configure CDRTool for global word.. I don't
> just want to use Europe E.164 or US E.164 numbers... I want each and every
> country number.
>
>
> Those classes just define how people from Europe and US use to dial to
> "every country number". In Europe people use to dial 00, then country code,
> then the number.  In US is a bit different.
>
> People saying configure cdr_generic.php file to set E164_class but why i
> set that class, I want world wide numbers, anybody can dial anywhere..
>
>
> People told you the right thing, you can dial any number in any country.
> You just miss understood the meaning of it.
>
> I want to dial US number and i have configured destination_id = 1 and set
> same destination in rate table.. I can also test that using telnet to CDR
> port like following
>
>
> If you use European style dialing style, that is the Europe E.164 class,
> you must use 001 to match US numbers.
>
>
> ShowPrice From=sip:3...@sip.com To=sip:11646xxx...@sip.com
> Gateway=174.236.4.168 Duration=59
> 0.0500
> Increment: 6 s
>  Min duration: 6 s
> Duration: 60 s
>  App: audio
>  Destination: 1
> Customer: subscriber=3...@sip.com
>  Connect: 0.
>StartTime: 2014-08-22 22:07:46
> --
> Span: 1
> Duration: 60 s
>ProfileId: sip_profile / weekday
>   RateId: sip_profile / 0-24h
> Rate: 0.0500 / 60 s
>Price: 0.0500
>
>
> but when i dial that number i am getting following error from call
> control, why my DestId=None ??
>
> cdrtool[17524]: MaxSessionTime Duration=36000
> CallId=miN0QR-M_WeFgBrC94RpEw..-S From=sip:3...@sip.com
> Gateway=174.xxx.xxx.xxx To=sip:11646...@sip.com
> cdrtool[17524]: MaxSessionTime=unlimited Type=prepaid
> CallId=miN0QR-M_WeFgBrC94RpEw..-S BillingParty=3...@sip.com DestId=None
> ___
> Users mailing list
> Users@lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>
> --
> Adrian
>
>
>
>
> ___
> 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] CDRTool E.164 number

[Adrian Georgescu]

On 22 Aug 2014, at 17:24, Satish Patel  wrote:

> CDRTool driving me crazy... I have setup CDR with Call_control module and now 
> problem is international number.. 
> 
> My first question how do i configure CDRTool for global word.. I don't just 
> want to use Europe E.164 or US E.164 numbers... I want each and every country 
> number. 

Those classes just define how people from Europe and US use to dial to "every 
country number". In Europe people use to dial 00, then country code, then the 
number.  In US is a bit different. 

> People saying configure cdr_generic.php file to set E164_class but why i set 
> that class, I want world wide numbers, anybody can dial anywhere.. 

People told you the right thing, you can dial any number in any country. You 
just miss understood the meaning of it.

> I want to dial US number and i have configured destination_id = 1 and set 
> same destination in rate table.. I can also test that using telnet to CDR 
> port like following

If you use European style dialing style, that is the Europe E.164 class, you 
must use 001 to match US numbers. 

> 
> ShowPrice From=sip:3...@sip.com To=sip:11646xxx...@sip.com 
> Gateway=174.236.4.168 Duration=59
> 0.0500
> Increment: 6 s
>  Min duration: 6 s
> Duration: 60 s
>  App: audio
>  Destination: 1
> Customer: subscriber=3...@sip.com
>  Connect: 0.
>StartTime: 2014-08-22 22:07:46
> --
> Span: 1
> Duration: 60 s
>ProfileId: sip_profile / weekday
>   RateId: sip_profile / 0-24h
> Rate: 0.0500 / 60 s
>Price: 0.0500
> 
> 
> but when i dial that number i am getting following error from call control, 
> why my DestId=None ?? 
> 
> cdrtool[17524]: MaxSessionTime Duration=36000 
> CallId=miN0QR-M_WeFgBrC94RpEw..-S From=sip:3...@sip.com 
> Gateway=174.xxx.xxx.xxx To=sip:11646...@sip.com
> cdrtool[17524]: MaxSessionTime=unlimited Type=prepaid 
> CallId=miN0QR-M_WeFgBrC94RpEw..-S BillingParty=3...@sip.com DestId=None
> ___
> Users mailing list
> Users@lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users

--
Adrian





signature.asc
Description: Message signed with OpenPGP using GPGMail
___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

[OpenSIPS-Users] CDRTool E.164 number

[Satish Patel]

CDRTool driving me crazy... I have setup CDR with Call_control module and
now problem is international number..

My first question how do i configure CDRTool for global word.. I don't just
want to use Europe E.164 or US E.164 numbers... I want each and every
country number.

People saying configure cdr_generic.php file to set E164_class but why i
set that class, I want world wide numbers, anybody can dial anywhere..

I want to dial US number and i have configured destination_id = 1 and set
same destination in rate table.. I can also test that using telnet to CDR
port like following

ShowPrice From=sip:3...@sip.com To=sip:11646xxx...@sip.com
Gateway=174.236.4.168 Duration=59
0.0500
Increment: 6 s
 Min duration: 6 s
Duration: 60 s
 App: audio
 Destination: 1
Customer: subscriber=3...@sip.com
 Connect: 0.
   StartTime: 2014-08-22 22:07:46
--
Span: 1
Duration: 60 s
   ProfileId: sip_profile / weekday
  RateId: sip_profile / 0-24h
Rate: 0.0500 / 60 s
   Price: 0.0500


but when i dial that number i am getting following error from call control,
why my DestId=None ??

cdrtool[17524]: MaxSessionTime Duration=36000
CallId=miN0QR-M_WeFgBrC94RpEw..-S From=sip:3...@sip.com
Gateway=174.xxx.xxx.xxx To=sip:11646...@sip.com
cdrtool[17524]: MaxSessionTime=unlimited Type=prepaid
CallId=miN0QR-M_WeFgBrC94RpEw..-S BillingParty=3...@sip.com DestId=None
___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

Re: [OpenSIPS-Users] CDRTool Prepaid Billing configuration question

[pa...@eremina.net]

It's just numbers/1 in default.


2014-08-19 17:03 GMT+06:00 Satish Patel :

> I have solved my problem, I have created destination ID and put same
> destination ID in rate table and it works!
>
> I have a question, here we are talking about rates so what I rate is this
> money in $ or pound (uk) or just a number?
>
> Sent from my iPhone
>
> On Aug 18, 2014, at 2:03 AM, Venkatesh Macha 
> wrote:
>
> > Hi Sathish,
> >
> >   I hope you have CDRTool runnig on your server. you can
> > connect it by using */CDRTool*
> > you can add prepaid user by using *prepaid* section in CDRTool Web page.
> > <
> http://opensips-open-sip-server.1449251.n2.nabble.com/file/n7592939/CDRTool_Menu.png
> >
> >
> > Then you can add users like this
> >
> > <
> http://opensips-open-sip-server.1449251.n2.nabble.com/file/n7592939/prepaid_Account.png
> >
> >
> > here 1...@something.com is your prepaid user and 9. is prepaid User
> > Balance.
> >
> > Venkatesh Macha,
> > Junior Voip Engineer,
> > Learn Programming 
> >
> >
> >
> > --
> > View this message in context:
> http://opensips-open-sip-server.1449251.n2.nabble.com/CDRTool-Prepaid-Billing-configuration-question-tp7592935p7592939.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
>
___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

Re: [OpenSIPS-Users] CDRTool Prepaid Billing configuration question

[Satish Patel]

I have solved my problem, I have created destination ID and put same 
destination ID in rate table and it works!

I have a question, here we are talking about rates so what I rate is this money 
in $ or pound (uk) or just a number?  

Sent from my iPhone

On Aug 18, 2014, at 2:03 AM, Venkatesh Macha  wrote:

> Hi Sathish,
> 
>   I hope you have CDRTool runnig on your server. you can
> connect it by using */CDRTool* 
> you can add prepaid user by using *prepaid* section in CDRTool Web page.
> 
>  
> 
> Then you can add users like this
> 
> 
>  
> 
> here 1...@something.com is your prepaid user and 9. is prepaid User
> Balance.
> 
> Venkatesh Macha,
> Junior Voip Engineer,
> Learn Programming   
> 
> 
> 
> --
> View this message in context: 
> http://opensips-open-sip-server.1449251.n2.nabble.com/CDRTool-Prepaid-Billing-configuration-question-tp7592935p7592939.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] CDRTool Prepaid Billing configuration question

[Satish Patel]

I read that but kinda confused that why i ask, just tell me simple step how
to setup CDRTool and create profile, customer, rate and prepaid :(


On Sun, Aug 17, 2014 at 11:10 PM, pa...@eremina.net 
wrote:

> Hi, Satish! Did you read
> https://node10.mdns.sipthor.net/CDRTool/doc/RATING.txt
> and
> https://node10.mdns.sipthor.net/CDRTool/doc/PERPAID.txt
> ?
>
>
>
> 2014-08-18 1:12 GMT+06:00 Satish Patel :
>
>> Hi,
>>
>> I have setup CDRTool + Opensips + FreeRadius + CallControl, I am first
>> time working with any billing system so get little confused. I am not
>> seeing any document related CDRTool about how to add customer, how to
>> assign rates and add balance. Is there am i missing something? I google all
>> over the place but there isn't any detail documents about how to use web
>> GUI.
>>
>> 1. Can i configure two SIP phone in my LAB to test prepaid calling care?
>>
>> 2. How do i configure destination? I have load example rating csv file
>> which comes with CDRTool source and find many countries, but how it will
>> with calling? USA has 1 code but how Opensip understand after 1 whatever
>> you dial will be US number?
>>
>> 3. Some how i have created profile, and add destination but when i
>> calling it is saying you don't have balance, How do i add balance?
>>
>> ___
>> 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] CDRTool Prepaid Billing configuration question

[Satish Patel]

Thanks Venkatesh,

I have added users just like you told me, find attached screenshot, but
whenever i dial any SIP number internally i am getting
MaxCallDuration=unlimited and saying you have postpaid account.

I want to setup prepaid between two SIP phone internally so i can test all
scenario, is it possible we can setup with internal SIP or it require
International numbers or PSTN connection?

see logs, between two SIP device

Aug 16 22:40:45 sip cdrtool[16362]: MaxSessionTime Duration=36000
CallId=NDlkMjBlYzBiMjgzMjQzMGYxY2EyNjgzY2VkMGFmZmM From=
sip:6...@sip.example.com Gateway=172.16.0.1 To=sip:7...@sip.example.com
Aug 16 22:40:45 sip cdrtool[16362]: MaxSessionTime=unlimited Type=prepaid
CallId=NDlkMjBlYzBiMjgzMjQzMGYxY2EyNjgzY2VkMGFmZmM BillingParty=
6...@sip.example.com DestId=None
Aug 16 22:40:45 sip call-control[16421]: Call id
NDlkMjBlYzBiMjgzMjQzMGYxY2EyNjgzY2VkMGFmZmM of 6...@sip.example.com to
sip:7...@sip.example.com is postpaid not limited
Aug 16 22:40:45 sip /usr/sbin/opensips[17541]: new branch at
sip:7000@192.168.1.8:55186;rinstance=03c3ebf44b5b9d52




In google many folks saying you need to setup destination number and rates,
I have tried that i have added destination number of second SIP phone but
still it is saying you have unlimited Maxcallduration.

If i dial any number with 001XXX i am getting no enough credit in your
prepaid call, i don't know where that coming from..

Aug 16 22:42:18 sip cdrtool[16362]: MaxSessionTime Duration=36000
CallId=NmM5MGJmMmM0ZmFiMjEwZTliYWMwNWE4MzFhMWI0YjM From=
sip:6...@sip.example.com Gateway=172.16.0.1 To=sip:001414...@sip.example.com
Aug 16 22:42:18 sip cdrtool[16362]: Error: Cannot find rates for
callid=NmM5MGJmMmM0ZmFiMjEwZTliYWMwNWE4MzFhMWI0YjM, billing party=
6...@sip.example.com, customer subscriber=7...@sip.example.com,
gateway=172.16.0.1, destination=1, profile=My_profile, app=audio
Aug 16 22:42:18 sip cdrtool[16362]: Notice: maxduration of 0 is less then
min_duration (120)
Aug 16 22:42:18 sip call-control[16421]: Call id
NmM5MGJmMmM0ZmFiMjEwZTliYWMwNWE4MzFhMWI0YjM of 6...@sip.example.com to
sip:001414...@sip.example.com forbidden because credit is too low
Aug 16 22:42:18 sip /usr/sbin/opensips[17540]: Call control: not enough
credit for prepaid call




On Mon, Aug 18, 2014 at 2:03 AM, Venkatesh Macha 
wrote:

> Hi Sathish,
>
>I hope you have CDRTool runnig on your server. you can
> connect it by using */CDRTool*
> you can add prepaid user by using *prepaid* section in CDRTool Web page.
> <
> http://opensips-open-sip-server.1449251.n2.nabble.com/file/n7592939/CDRTool_Menu.png
> >
>
> Then you can add users like this
>
> <
> http://opensips-open-sip-server.1449251.n2.nabble.com/file/n7592939/prepaid_Account.png
> >
>
> here 1...@something.com is your prepaid user and 9. is prepaid User
> Balance.
>
> Venkatesh Macha,
> Junior Voip Engineer,
> Learn Programming 
>
>
>
> --
> View this message in context:
> http://opensips-open-sip-server.1449251.n2.nabble.com/CDRTool-Prepaid-Billing-configuration-question-tp7592935p7592939.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] CDRTool Prepaid Billing configuration question

[Venkatesh Macha]

Hi Sathish,

   I hope you have CDRTool runnig on your server. you can
connect it by using */CDRTool* 
you can add prepaid user by using *prepaid* section in CDRTool Web page.

 

Then you can add users like this


 

here 1...@something.com is your prepaid user and 9. is prepaid User
Balance.

Venkatesh Macha,
Junior Voip Engineer,
Learn Programming   



--
View this message in context: 
http://opensips-open-sip-server.1449251.n2.nabble.com/CDRTool-Prepaid-Billing-configuration-question-tp7592935p7592939.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

Re: [OpenSIPS-Users] CDRTool Prepaid Billing configuration question

[pa...@eremina.net]

Hi, Satish! Did you read
https://node10.mdns.sipthor.net/CDRTool/doc/RATING.txt
and
https://node10.mdns.sipthor.net/CDRTool/doc/PERPAID.txt
?



2014-08-18 1:12 GMT+06:00 Satish Patel :

> Hi,
>
> I have setup CDRTool + Opensips + FreeRadius + CallControl, I am first
> time working with any billing system so get little confused. I am not
> seeing any document related CDRTool about how to add customer, how to
> assign rates and add balance. Is there am i missing something? I google all
> over the place but there isn't any detail documents about how to use web
> GUI.
>
> 1. Can i configure two SIP phone in my LAB to test prepaid calling care?
>
> 2. How do i configure destination? I have load example rating csv file
> which comes with CDRTool source and find many countries, but how it will
> with calling? USA has 1 code but how Opensip understand after 1 whatever
> you dial will be US number?
>
> 3. Some how i have created profile, and add destination but when i calling
> it is saying you don't have balance, How do i add balance?
>
> ___
> 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

[OpenSIPS-Users] CDRTool Prepaid Billing configuration question

[Satish Patel]

Hi,

I have setup CDRTool + Opensips + FreeRadius + CallControl, I am first time
working with any billing system so get little confused. I am not seeing any
document related CDRTool about how to add customer, how to assign rates and
add balance. Is there am i missing something? I google all over the place
but there isn't any detail documents about how to use web GUI.

1. Can i configure two SIP phone in my LAB to test prepaid calling care?

2. How do i configure destination? I have load example rating csv file
which comes with CDRTool source and find many countries, but how it will
with calling? USA has 1 code but how Opensip understand after 1 whatever
you dial will be US number?

3. Some how i have created profile, and add destination but when i calling
it is saying you don't have balance, How do i add balance?
___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

Re: [OpenSIPS-Users] CDRTool - Rating Origination and Termination differently

[Duane Larson]

Great! Thanks

On Thursday, August 7, 2014, Tijmen de Mes  wrote:

> Hi,
>
> It is in CDRTool. Soon we will release a new version of call control which
> should be safe if OpenSIPS does not have support for this.
>
> --
> Tijmen de Mes
> AG-Projects
>
> On 7 augustus 2014 at 04:16:01, osiris123d (duane.lar...@gmail.com
> ) wrote:
>
> I fell off this for a while. Did this ever get officially put into
> CDRTool?
>
>
>
> --
> View this message in context:
> http://opensips-open-sip-server.1449251.n2.nabble.com/Re-CDRTool-Rating-Origination-and-Termination-differently-tp7589320p7592835.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
>
>

-- 
--
*--*--*--*--*--*
Duane
*--*--*--*--*--*
--
___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

Re: [OpenSIPS-Users] CDRTool - Rating Origination and Termination differently

[Tijmen de Mes]

Hi,

It is in CDRTool. Soon we will release a new version of call control which 
should be safe if OpenSIPS does not have support for this.

-- 
Tijmen de Mes
AG-Projects

On 7 augustus 2014 at 04:16:01, osiris123d (duane.lar...@gmail.com) wrote:

I fell off this for a while. Did this ever get officially put into CDRTool?  



--  
View this message in context: 
http://opensips-open-sip-server.1449251.n2.nabble.com/Re-CDRTool-Rating-Origination-and-Termination-differently-tp7589320p7592835.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] CDRTool - Rating Origination and Termination differently

[osiris123d]

I fell off this for a while.  Did this ever get officially put into CDRTool?



--
View this message in context: 
http://opensips-open-sip-server.1449251.n2.nabble.com/Re-CDRTool-Rating-Origination-and-Termination-differently-tp7589320p7592835.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

Re: [OpenSIPS-Users] CDRTool quota limit per domain

[ag]

With the current code is not possible, it would need to be modified to do that.

On 08 Mar 2014, at 17:49, Jurica Majeric  wrote:

> Hi all,
> 
> is it anyhow possible to set quota for a domain without setting it for a  
> specific username within a domain? I'm using opensips 1.9 and CDRTool 9.1.1.
> 
> Thnx,
> Ure
> ___
> Users mailing list
> Users@lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users



signature.asc
Description: Message signed with OpenPGP using GPGMail
___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

[OpenSIPS-Users] CDRTool quota limit per domain

[Jurica Majeric]

Hi all,

is it anyhow possible to set quota for a domain without setting it for a
specific username within a domain? I'm using opensips 1.9 and CDRTool 9.1.1.

Thnx,
Ure
___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

Re: [OpenSIPS-Users] CDRTool - Rating Origination and Termination differently

[David M. Lee]

I have an open pull request with OpenSIPS with this patch.

https://github.com/OpenSIPS/opensips/pull/170

-- 
David M. Lee
Digium, Inc. | Software Developer
445 Jan Davis Drive NW - Huntsville, AL 35806 - USA
Check us out at:  www.digium.com  & www.asterisk.org

On Feb 18, 2014, at 6:52 AM, Tijmen de Mes  wrote:

> Hi All,
> 
> Already sent it to David  in private, but will post it here to be complete.
> 
> We have trouble with the patch for call control. We get:
> 
> Feb 18 12:51:09 node04 call-control[19257]: error: 'Request' object has no 
> attribute ‘application'
> 
> I looked into in and the call_control module of OpenSIPS seems to be not 
> passing the application type. So is this module also patched ?  
> 
> -- 
> Tijmen de Mes
> AG-Projects
> 
> On 12 februari 2014 at 21:05:32, David M. Lee (d...@digium.com) wrote:
> 
>> For everyone following along at home:
>> 
>> I’ve updated my CDRTool patch (again) to fix MaxSessionTime and ShowPrice 
>> commands, and fix some minor issues that cropped up with DebitBalance.
>> 
>> CDRTool patch - https://gist.github.com/leedm777/8585690
>> 
>> I’ve also discovered that the call_control daemon also needs to be patched 
>> to pass through the SIP Application Type from the call_control module onto 
>> the CDRTool prepaid engine.
>> 
>> callcontrol patch - https://gist.github.com/leedm777/8926025
>> 
>> I’ll be sending both patches to de...@ag-projects.com. Feedback welcome on 
>> both!
>> 
>> -- 
>> David M. Lee
>> Digium, Inc. | Software Developer
>> 445 Jan Davis Drive NW - Huntsville, AL 35806 - USA
>> Check us out at:  www.digium.com  & www.asterisk.org
>> 
>> On Feb 6, 2014, at 9:29 AM, David M. Lee  wrote:
>> 
>>> I figured that out. I’ve updated the patch on my gist, and updated the 
>>> rating doc to include a description of how the subtypes work.
>>> 
>>> I’m sending the patch to de...@ag-projects.com now.
>>> 
>>> Thanks!
>>> -- 
>>> David M. Lee
>>> Digium, Inc. | Software Developer
>>> 445 Jan Davis Drive NW - Huntsville, AL 35806 - USA
>>> Check us out at:  www.digium.com  & www.asterisk.org
>>> 
>>> On Jan 28, 2014, at 6:12 AM, Tijmen de Mes  wrote:
>>> 
 Hi,
 
 I run into trouble and reversed the patch. In the rating engine (telnet) 
 DebitBalance function does not return anything anymore with the patch 
 applied, so something goes wrong.
 
 -- 
 Tijmen de Mes
 AG-Projects
 
 On 27 januari 2014 at 17:55:01, Tijmen de Mes (tij...@ag-projects.com) 
 wrote:
 
> Hi
> 
> I tested the patch and for now I don’t see any problem with it. Before 
> adding it to trunk, can you update the rating docs and record all changes 
> in 1 patch using darcs? After that I can apply it directly on trunk with 
> your credentials.
> 
> These instructions to submit the patch also apply on CDRTool:
> 
> http://sipsimpleclient.org/projects/sipsimpleclient/wiki/SipSupport
> 
> You don’t need to open a ticket however, just tell me after you send the 
> patch.
>  
> -- 
> Tijmen de Mes
> AG-Projects
> 
> On 26 januari 2014 at 02:08:50, Duane Larson (duane.lar...@gmail.com) 
> wrote:
> 
>> Ugh Nevermind.  My "Max Duration" was set to 6 on the Destinations 
>> rate setup.  I set it to zero and I think things are looking better now. 
>>  Think I'm done for the day.  Good work David!  Really appreciate the 
>> patch.
>> 
>> 
>> On Sat, Jan 25, 2014 at 6:56 PM, Duane Larson  
>> wrote:
>> Not sure my "price" is being calculated correctly.
>> 
>> My audio.outbound should be $0.005
>> My audio.inbound should be $0.0035
>> 
>> Here is an example of a call that lasted 2:06 minutes and is 
>> audio.outbound
>> Increment=6 MinDuration=6 MaxDuration=6 ConnectFee=0. 
>> CallId=dc1e32b1ba18ff91a3
>> 67aa8df81e8e3c@0:0:0:0:0:0:0:0 Span=1 Duration=6 DestId=1 default 
>> Profile=USA_Default Period=weekend Rate=USA_Default Interval=0-24 Cos
>> t=0.0050/60 Price=0.0005 PriceIn=0.
>> 
>> Here is an example of a call that lasted 1:33 minutes and is 
>> audio.inbound
>> Increment=6 MinDuration=6 MaxDuration=6 ConnectFee=0. 
>> CallId=2e0334513a34964e7c0
>> a18cd3be449dd@108.166.97.17:5060 Span=1 Duration=6 DestId=1 default 
>> Profile=USA_Default Period=weekend Rate=USA_Default Interval=0-24 C
>> ost=0.0035/60 Price=0.0003 PriceIn=0.
>> 
>> Looks like no matter what the duration is for the inbound calls it costs 
>> $0.0003 and the outbound calls all cost $0.0005.
>> 
>> 
>> 
>> 
>> On Sat, Jan 25, 2014 at 6:24 PM, Duane Larson  
>> wrote:
>> David/Tijmen/Adrian,
>> 
>> It is working for me too.  Both inbound and outbound are being 
>> recognized and the different rates are being applied.  I will keep 
>> looking at it while more calls are being made to make sure there are no 

Re: [OpenSIPS-Users] CDRTool - Rating Origination and Termination differently

[Tijmen de Mes]

Hi All,

Already sent it to David  in private, but will post it here to be complete.

We have trouble with the patch for call control. We get:

Feb 18 12:51:09 node04 call-control[19257]: error: 'Request' object has no 
attribute ‘application'

I looked into in and the call_control module of OpenSIPS seems to be not 
passing the application type. So is this module also patched ?  

-- 
Tijmen de Mes
AG-Projects

On 12 februari 2014 at 21:05:32, David M. Lee (d...@digium.com) wrote:

For everyone following along at home:

I’ve updated my CDRTool patch (again) to fix MaxSessionTime and ShowPrice 
commands, and fix some minor issues that cropped up with DebitBalance.

CDRTool patch - https://gist.github.com/leedm777/8585690

I’ve also discovered that the call_control daemon also needs to be patched to 
pass through the SIP Application Type from the call_control module onto the 
CDRTool prepaid engine.

callcontrol patch - https://gist.github.com/leedm777/8926025

I’ll be sending both patches to de...@ag-projects.com. Feedback welcome on both!

-- 
David M. Lee
Digium, Inc. | Software Developer
445 Jan Davis Drive NW - Huntsville, AL 35806 - USA
Check us out at:  www.digium.com  & www.asterisk.org

On Feb 6, 2014, at 9:29 AM, David M. Lee  wrote:

I figured that out. I’ve updated the patch on my gist, and updated the rating 
doc to include a description of how the subtypes work.

I’m sending the patch to de...@ag-projects.com now.

Thanks!
-- 
David M. Lee
Digium, Inc. | Software Developer
445 Jan Davis Drive NW - Huntsville, AL 35806 - USA
Check us out at:  www.digium.com  & www.asterisk.org

On Jan 28, 2014, at 6:12 AM, Tijmen de Mes  wrote:

Hi,

I run into trouble and reversed the patch. In the rating engine (telnet) 
DebitBalance function does not return anything anymore with the patch applied, 
so something goes wrong.

-- 
Tijmen de Mes
AG-Projects

On 27 januari 2014 at 17:55:01, Tijmen de Mes (tij...@ag-projects.com) wrote:

Hi

I tested the patch and for now I don’t see any problem with it. Before adding 
it to trunk, can you update the rating docs and record all changes in 1 patch 
using darcs? After that I can apply it directly on trunk with your credentials.

These instructions to submit the patch also apply on CDRTool:

http://sipsimpleclient.org/projects/sipsimpleclient/wiki/SipSupport

You don’t need to open a ticket however, just tell me after you send the patch.
 
-- 
Tijmen de Mes
AG-Projects

On 26 januari 2014 at 02:08:50, Duane Larson (duane.lar...@gmail.com) wrote:

Ugh Nevermind.  My "Max Duration" was set to 6 on the Destinations rate 
setup.  I set it to zero and I think things are looking better now.  Think I'm 
done for the day.  Good work David!  Really appreciate the patch.


On Sat, Jan 25, 2014 at 6:56 PM, Duane Larson  wrote:
Not sure my "price" is being calculated correctly.

My audio.outbound should be $0.005
My audio.inbound should be $0.0035

Here is an example of a call that lasted 2:06 minutes and is audio.outbound
Increment=6 MinDuration=6 MaxDuration=6 ConnectFee=0. 
CallId=dc1e32b1ba18ff91a3
67aa8df81e8e3c@0:0:0:0:0:0:0:0 Span=1 Duration=6 DestId=1 default 
Profile=USA_Default Period=weekend Rate=USA_Default Interval=0-24 Cos
t=0.0050/60 Price=0.0005 PriceIn=0.

Here is an example of a call that lasted 1:33 minutes and is audio.inbound
Increment=6 MinDuration=6 MaxDuration=6 ConnectFee=0. 
CallId=2e0334513a34964e7c0
a18cd3be449dd@108.166.97.17:5060 Span=1 Duration=6 DestId=1 default 
Profile=USA_Default Period=weekend Rate=USA_Default Interval=0-24 C
ost=0.0035/60 Price=0.0003 PriceIn=0.

Looks like no matter what the duration is for the inbound calls it costs 
$0.0003 and the outbound calls all cost $0.0005.




On Sat, Jan 25, 2014 at 6:24 PM, Duane Larson  wrote:
David/Tijmen/Adrian,

It is working for me too.  Both inbound and outbound are being recognized and 
the different rates are being applied.  I will keep looking at it while more 
calls are being made to make sure there are no unforeseen issues. 


On Fri, Jan 24, 2014 at 5:35 AM, Tijmen de Mes  wrote:
Hi David,

Thanks for the patch. If have some time Monday I will analyze it and give you 
some feedback so we include this in CDRTool.

Besides the rating, I’ve to check if the code that now sets the the ‘route’ for 
the CDRs and if there are no problems.

  
-- 
Tijmen de Mes
AG-Projects

On 23 januari 2014 at 21:21:26, David M. Lee (d...@digium.com) wrote:

I’ve got a first attempt at a patch:
https://gist.github.com/leedm777/8585690

To get this to work, your CDR’s will have to record the application
subtype. For me, I set $avp(s:call_class) = “audio.inbound” or
“audio.outbound” as appropriate in the routes, and added
Sip-Application-Type=$avp(s:call_class) to “radius_extra”.

Billing rates will be matched on the full application, allowing
different rates depending on the application subtype.

It works with the simple testing I’ve been able to do on my desktop.
Feedback, of course, is gr

[OpenSIPS-Users] cdrtool custom e164 class

[Aubrey Wells]

Hey all,
I'm trying to create a custom e164 class in cdrtool. I started out
with just uncommenting the default example one in global.inc that is
just a copy of the real E164_US class found in cdr_generic.php; it
looks like:

class E164_US_Custom extends E164 {
function E164_US($intAccessCode='011',
$natAccessCode='[1-9][0-9]{2}',$CountryCode='',$ENUMtldRegexp="([0-9]{7,})")
{
$this->regexp_international = "/^".$intAccessCode."([1-9][0-9]{5,})\$/";
$this->regexp_national  = "/^".$natAccessCode."([0-9]{3,})\$/";
$this->CountryCode  = trim($CountryCode);
$this->ENUMtldRegexp= trim($ENUMtldRegexp);

}
}

To my surprise, this prevents ratingEngine.php from running, and web
requests bomb out with:

PHP Fatal error:  Class 'E164' not found in /etc/cdrtool/global.inc on line 205

I tried placing it in phplib/local.inc instead, with similar results.

Is this a bug, or am I missing something really obvious?

TIA.

---
Aubrey

___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

Re: [OpenSIPS-Users] CDRTool - Rating Origination and Termination differently

[David M. Lee]

For everyone following along at home:

I’ve updated my CDRTool patch (again) to fix MaxSessionTime and ShowPrice 
commands, and fix some minor issues that cropped up with DebitBalance.

CDRTool patch - https://gist.github.com/leedm777/8585690

I’ve also discovered that the call_control daemon also needs to be patched to 
pass through the SIP Application Type from the call_control module onto the 
CDRTool prepaid engine.

callcontrol patch - https://gist.github.com/leedm777/8926025

I’ll be sending both patches to de...@ag-projects.com. Feedback welcome on both!

-- 
David M. Lee
Digium, Inc. | Software Developer
445 Jan Davis Drive NW - Huntsville, AL 35806 - USA
Check us out at:  www.digium.com  & www.asterisk.org

On Feb 6, 2014, at 9:29 AM, David M. Lee  wrote:

> I figured that out. I’ve updated the patch on my gist, and updated the rating 
> doc to include a description of how the subtypes work.
> 
> I’m sending the patch to de...@ag-projects.com now.
> 
> Thanks!
> -- 
> David M. Lee
> Digium, Inc. | Software Developer
> 445 Jan Davis Drive NW - Huntsville, AL 35806 - USA
> Check us out at:  www.digium.com  & www.asterisk.org
> 
> On Jan 28, 2014, at 6:12 AM, Tijmen de Mes  wrote:
> 
>> Hi,
>> 
>> I run into trouble and reversed the patch. In the rating engine (telnet) 
>> DebitBalance function does not return anything anymore with the patch 
>> applied, so something goes wrong.
>> 
>> -- 
>> Tijmen de Mes
>> AG-Projects
>> 
>> On 27 januari 2014 at 17:55:01, Tijmen de Mes (tij...@ag-projects.com) wrote:
>> 
>>> Hi
>>> 
>>> I tested the patch and for now I don’t see any problem with it. Before 
>>> adding it to trunk, can you update the rating docs and record all changes 
>>> in 1 patch using darcs? After that I can apply it directly on trunk with 
>>> your credentials.
>>> 
>>> These instructions to submit the patch also apply on CDRTool:
>>> 
>>> http://sipsimpleclient.org/projects/sipsimpleclient/wiki/SipSupport
>>> 
>>> You don’t need to open a ticket however, just tell me after you send the 
>>> patch.
>>>  
>>> -- 
>>> Tijmen de Mes
>>> AG-Projects
>>> 
>>> On 26 januari 2014 at 02:08:50, Duane Larson (duane.lar...@gmail.com) wrote:
>>> 
 Ugh Nevermind.  My "Max Duration" was set to 6 on the Destinations 
 rate setup.  I set it to zero and I think things are looking better now.  
 Think I'm done for the day.  Good work David!  Really appreciate the patch.
 
 
 On Sat, Jan 25, 2014 at 6:56 PM, Duane Larson  
 wrote:
 Not sure my "price" is being calculated correctly.
 
 My audio.outbound should be $0.005
 My audio.inbound should be $0.0035
 
 Here is an example of a call that lasted 2:06 minutes and is audio.outbound
 Increment=6 MinDuration=6 MaxDuration=6 ConnectFee=0. 
 CallId=dc1e32b1ba18ff91a3
 67aa8df81e8e3c@0:0:0:0:0:0:0:0 Span=1 Duration=6 DestId=1 default 
 Profile=USA_Default Period=weekend Rate=USA_Default Interval=0-24 Cos
 t=0.0050/60 Price=0.0005 PriceIn=0.
 
 Here is an example of a call that lasted 1:33 minutes and is audio.inbound
 Increment=6 MinDuration=6 MaxDuration=6 ConnectFee=0. 
 CallId=2e0334513a34964e7c0
 a18cd3be449dd@108.166.97.17:5060 Span=1 Duration=6 DestId=1 default 
 Profile=USA_Default Period=weekend Rate=USA_Default Interval=0-24 C
 ost=0.0035/60 Price=0.0003 PriceIn=0.
 
 Looks like no matter what the duration is for the inbound calls it costs 
 $0.0003 and the outbound calls all cost $0.0005.
 
 
 
 
 On Sat, Jan 25, 2014 at 6:24 PM, Duane Larson  
 wrote:
 David/Tijmen/Adrian,
 
 It is working for me too.  Both inbound and outbound are being recognized 
 and the different rates are being applied.  I will keep looking at it 
 while more calls are being made to make sure there are no unforeseen 
 issues. 
 
 
 On Fri, Jan 24, 2014 at 5:35 AM, Tijmen de Mes  
 wrote:
 Hi David,
 
 Thanks for the patch. If have some time Monday I will analyze it and give 
 you some feedback so we include this in CDRTool.
 
 Besides the rating, I’ve to check if the code that now sets the the 
 ‘route’ for the CDRs and if there are no problems.
 
   
 -- 
 Tijmen de Mes
 AG-Projects
 
 On 23 januari 2014 at 21:21:26, David M. Lee (d...@digium.com) wrote:
 
> I’ve got a first attempt at a patch:
> https://gist.github.com/leedm777/8585690
> 
> To get this to work, your CDR’s will have to record the application
> subtype. For me, I set $avp(s:call_class) = “audio.inbound” or
> “audio.outbound” as appropriate in the routes, and added
> Sip-Application-Type=$avp(s:call_class) to “radius_extra”.
> 
> Billing rates will be matched on the full application, allowing
> different rates depending on the application subtype.
> 
> It works with the simple testing I’ve been able to do on my deskto

Re: [OpenSIPS-Users] CDRTool - Rating Origination and Termination differently

[David M. Lee]

I figured that out. I’ve updated the patch on my gist, and updated the rating 
doc to include a description of how the subtypes work.

I’m sending the patch to de...@ag-projects.com now.

Thanks!
-- 
David M. Lee
Digium, Inc. | Software Developer
445 Jan Davis Drive NW - Huntsville, AL 35806 - USA
Check us out at:  www.digium.com  & www.asterisk.org

On Jan 28, 2014, at 6:12 AM, Tijmen de Mes  wrote:

> Hi,
> 
> I run into trouble and reversed the patch. In the rating engine (telnet) 
> DebitBalance function does not return anything anymore with the patch 
> applied, so something goes wrong.
> 
> -- 
> Tijmen de Mes
> AG-Projects
> 
> On 27 januari 2014 at 17:55:01, Tijmen de Mes (tij...@ag-projects.com) wrote:
> 
>> Hi
>> 
>> I tested the patch and for now I don’t see any problem with it. Before 
>> adding it to trunk, can you update the rating docs and record all changes in 
>> 1 patch using darcs? After that I can apply it directly on trunk with your 
>> credentials.
>> 
>> These instructions to submit the patch also apply on CDRTool:
>> 
>> http://sipsimpleclient.org/projects/sipsimpleclient/wiki/SipSupport
>> 
>> You don’t need to open a ticket however, just tell me after you send the 
>> patch.
>>  
>> -- 
>> Tijmen de Mes
>> AG-Projects
>> 
>> On 26 januari 2014 at 02:08:50, Duane Larson (duane.lar...@gmail.com) wrote:
>> 
>>> Ugh Nevermind.  My "Max Duration" was set to 6 on the Destinations rate 
>>> setup.  I set it to zero and I think things are looking better now.  Think 
>>> I'm done for the day.  Good work David!  Really appreciate the patch.
>>> 
>>> 
>>> On Sat, Jan 25, 2014 at 6:56 PM, Duane Larson  
>>> wrote:
>>> Not sure my "price" is being calculated correctly.
>>> 
>>> My audio.outbound should be $0.005
>>> My audio.inbound should be $0.0035
>>> 
>>> Here is an example of a call that lasted 2:06 minutes and is audio.outbound
>>> Increment=6 MinDuration=6 MaxDuration=6 ConnectFee=0. 
>>> CallId=dc1e32b1ba18ff91a3
>>> 67aa8df81e8e3c@0:0:0:0:0:0:0:0 Span=1 Duration=6 DestId=1 default 
>>> Profile=USA_Default Period=weekend Rate=USA_Default Interval=0-24 Cos
>>> t=0.0050/60 Price=0.0005 PriceIn=0.
>>> 
>>> Here is an example of a call that lasted 1:33 minutes and is audio.inbound
>>> Increment=6 MinDuration=6 MaxDuration=6 ConnectFee=0. 
>>> CallId=2e0334513a34964e7c0
>>> a18cd3be449dd@108.166.97.17:5060 Span=1 Duration=6 DestId=1 default 
>>> Profile=USA_Default Period=weekend Rate=USA_Default Interval=0-24 C
>>> ost=0.0035/60 Price=0.0003 PriceIn=0.
>>> 
>>> Looks like no matter what the duration is for the inbound calls it costs 
>>> $0.0003 and the outbound calls all cost $0.0005.
>>> 
>>> 
>>> 
>>> 
>>> On Sat, Jan 25, 2014 at 6:24 PM, Duane Larson  
>>> wrote:
>>> David/Tijmen/Adrian,
>>> 
>>> It is working for me too.  Both inbound and outbound are being recognized 
>>> and the different rates are being applied.  I will keep looking at it while 
>>> more calls are being made to make sure there are no unforeseen issues. 
>>> 
>>> 
>>> On Fri, Jan 24, 2014 at 5:35 AM, Tijmen de Mes  
>>> wrote:
>>> Hi David,
>>> 
>>> Thanks for the patch. If have some time Monday I will analyze it and give 
>>> you some feedback so we include this in CDRTool.
>>> 
>>> Besides the rating, I’ve to check if the code that now sets the the ‘route’ 
>>> for the CDRs and if there are no problems.
>>> 
>>>   
>>> -- 
>>> Tijmen de Mes
>>> AG-Projects
>>> 
>>> On 23 januari 2014 at 21:21:26, David M. Lee (d...@digium.com) wrote:
>>> 
 I’ve got a first attempt at a patch:
 https://gist.github.com/leedm777/8585690
 
 To get this to work, your CDR’s will have to record the application
 subtype. For me, I set $avp(s:call_class) = “audio.inbound” or
 “audio.outbound” as appropriate in the routes, and added
 Sip-Application-Type=$avp(s:call_class) to “radius_extra”.
 
 Billing rates will be matched on the full application, allowing
 different rates depending on the application subtype.
 
 It works with the simple testing I’ve been able to do on my desktop.
 Feedback, of course, is greatly appreciated.
 
 Duane - Does the patch work for you?
 
 Adrian - Any objections/concerns with this approach?
 
 If it looks good, I’ll work on updating the docs.
 
 Thanks!
 --
 David M. Lee
 Digium, Inc. | Software Developer
 445 Jan Davis Drive NW - Huntsville, AL 35806 - USA
 Check us out at: www.digium.com & www.asterisk.org
 
 On Jan 23, 2014, at 4:43 AM, Adrian Georgescu  wrote:
 
 > I think it would be a good idea.
 >
 > Adrian
 >
 > On 22 Jan 2014, at 16:58, David Lee (digium)  wrote:
 >
 >> Duane Larson wrote:
 >>> I have been playing with CDRTool for a while but I am not sure if it is
 >>> possible to rate Origination (Inbound) calls differently than 
 >>> Termination
 >>> (Outbound) calls from my SIP Provider. For Origination I pay 0.0035 and

Re: [OpenSIPS-Users] CDRTool - Rating Origination and Termination differently

[David M. Lee]

Sorry for the delayed response.

I’ll take a look and see if I can correct the patch.

Thanks!
-- 
David M. Lee
Digium, Inc. | Software Developer
445 Jan Davis Drive NW - Huntsville, AL 35806 - USA
Check us out at:  www.digium.com  & www.asterisk.org

On Jan 28, 2014, at 6:12 AM, Tijmen de Mes  wrote:

> Hi,
> 
> I run into trouble and reversed the patch. In the rating engine (telnet) 
> DebitBalance function does not return anything anymore with the patch 
> applied, so something goes wrong.
> 
> -- 
> Tijmen de Mes
> AG-Projects
> 
> On 27 januari 2014 at 17:55:01, Tijmen de Mes (tij...@ag-projects.com) wrote:
> 
>> Hi
>> 
>> I tested the patch and for now I don’t see any problem with it. Before 
>> adding it to trunk, can you update the rating docs and record all changes in 
>> 1 patch using darcs? After that I can apply it directly on trunk with your 
>> credentials.
>> 
>> These instructions to submit the patch also apply on CDRTool:
>> 
>> http://sipsimpleclient.org/projects/sipsimpleclient/wiki/SipSupport
>> 
>> You don’t need to open a ticket however, just tell me after you send the 
>> patch.
>>  
>> -- 
>> Tijmen de Mes
>> AG-Projects
>> 
>> On 26 januari 2014 at 02:08:50, Duane Larson (duane.lar...@gmail.com) wrote:
>> 
>>> Ugh Nevermind.  My "Max Duration" was set to 6 on the Destinations rate 
>>> setup.  I set it to zero and I think things are looking better now.  Think 
>>> I'm done for the day.  Good work David!  Really appreciate the patch.
>>> 
>>> 
>>> On Sat, Jan 25, 2014 at 6:56 PM, Duane Larson  
>>> wrote:
>>> Not sure my "price" is being calculated correctly.
>>> 
>>> My audio.outbound should be $0.005
>>> My audio.inbound should be $0.0035
>>> 
>>> Here is an example of a call that lasted 2:06 minutes and is audio.outbound
>>> Increment=6 MinDuration=6 MaxDuration=6 ConnectFee=0. 
>>> CallId=dc1e32b1ba18ff91a3
>>> 67aa8df81e8e3c@0:0:0:0:0:0:0:0 Span=1 Duration=6 DestId=1 default 
>>> Profile=USA_Default Period=weekend Rate=USA_Default Interval=0-24 Cos
>>> t=0.0050/60 Price=0.0005 PriceIn=0.
>>> 
>>> Here is an example of a call that lasted 1:33 minutes and is audio.inbound
>>> Increment=6 MinDuration=6 MaxDuration=6 ConnectFee=0. 
>>> CallId=2e0334513a34964e7c0
>>> a18cd3be449dd@108.166.97.17:5060 Span=1 Duration=6 DestId=1 default 
>>> Profile=USA_Default Period=weekend Rate=USA_Default Interval=0-24 C
>>> ost=0.0035/60 Price=0.0003 PriceIn=0.
>>> 
>>> Looks like no matter what the duration is for the inbound calls it costs 
>>> $0.0003 and the outbound calls all cost $0.0005.
>>> 
>>> 
>>> 
>>> 
>>> On Sat, Jan 25, 2014 at 6:24 PM, Duane Larson  
>>> wrote:
>>> David/Tijmen/Adrian,
>>> 
>>> It is working for me too.  Both inbound and outbound are being recognized 
>>> and the different rates are being applied.  I will keep looking at it while 
>>> more calls are being made to make sure there are no unforeseen issues. 
>>> 
>>> 
>>> On Fri, Jan 24, 2014 at 5:35 AM, Tijmen de Mes  
>>> wrote:
>>> Hi David,
>>> 
>>> Thanks for the patch. If have some time Monday I will analyze it and give 
>>> you some feedback so we include this in CDRTool.
>>> 
>>> Besides the rating, I’ve to check if the code that now sets the the ‘route’ 
>>> for the CDRs and if there are no problems.
>>> 
>>>   
>>> -- 
>>> Tijmen de Mes
>>> AG-Projects
>>> 
>>> On 23 januari 2014 at 21:21:26, David M. Lee (d...@digium.com) wrote:
>>> 
 I’ve got a first attempt at a patch:
 https://gist.github.com/leedm777/8585690
 
 To get this to work, your CDR’s will have to record the application
 subtype. For me, I set $avp(s:call_class) = “audio.inbound” or
 “audio.outbound” as appropriate in the routes, and added
 Sip-Application-Type=$avp(s:call_class) to “radius_extra”.
 
 Billing rates will be matched on the full application, allowing
 different rates depending on the application subtype.
 
 It works with the simple testing I’ve been able to do on my desktop.
 Feedback, of course, is greatly appreciated.
 
 Duane - Does the patch work for you?
 
 Adrian - Any objections/concerns with this approach?
 
 If it looks good, I’ll work on updating the docs.
 
 Thanks!
 --
 David M. Lee
 Digium, Inc. | Software Developer
 445 Jan Davis Drive NW - Huntsville, AL 35806 - USA
 Check us out at: www.digium.com & www.asterisk.org
 
 On Jan 23, 2014, at 4:43 AM, Adrian Georgescu  wrote:
 
 > I think it would be a good idea.
 >
 > Adrian
 >
 > On 22 Jan 2014, at 16:58, David Lee (digium)  wrote:
 >
 >> Duane Larson wrote:
 >>> I have been playing with CDRTool for a while but I am not sure if it is
 >>> possible to rate Origination (Inbound) calls differently than 
 >>> Termination
 >>> (Outbound) calls from my SIP Provider. For Origination I pay 0.0035 and
 >>> for Termination I pay 0.005. Keep in mind these costs are for 
 >>> destination
 >>>

Re: [OpenSIPS-Users] CDRTool - Rating Origination and Termination differently

[Tijmen de Mes]

Hi,

I run into trouble and reversed the patch. In the rating engine (telnet) 
DebitBalance function does not return anything anymore with the patch applied, 
so something goes wrong.

-- 
Tijmen de Mes
AG-Projects

On 27 januari 2014 at 17:55:01, Tijmen de Mes (tij...@ag-projects.com) wrote:

Hi

I tested the patch and for now I don’t see any problem with it. Before adding 
it to trunk, can you update the rating docs and record all changes in 1 patch 
using darcs? After that I can apply it directly on trunk with your credentials.

These instructions to submit the patch also apply on CDRTool:

http://sipsimpleclient.org/projects/sipsimpleclient/wiki/SipSupport

You don’t need to open a ticket however, just tell me after you send the patch.
 
-- 
Tijmen de Mes
AG-Projects

On 26 januari 2014 at 02:08:50, Duane Larson (duane.lar...@gmail.com) wrote:

Ugh Nevermind.  My "Max Duration" was set to 6 on the Destinations rate 
setup.  I set it to zero and I think things are looking better now.  Think I'm 
done for the day.  Good work David!  Really appreciate the patch.


On Sat, Jan 25, 2014 at 6:56 PM, Duane Larson  wrote:
Not sure my "price" is being calculated correctly.

My audio.outbound should be $0.005
My audio.inbound should be $0.0035

Here is an example of a call that lasted 2:06 minutes and is audio.outbound
Increment=6 MinDuration=6 MaxDuration=6 ConnectFee=0. 
CallId=dc1e32b1ba18ff91a3
67aa8df81e8e3c@0:0:0:0:0:0:0:0 Span=1 Duration=6 DestId=1 default 
Profile=USA_Default Period=weekend Rate=USA_Default Interval=0-24 Cos
t=0.0050/60 Price=0.0005 PriceIn=0.

Here is an example of a call that lasted 1:33 minutes and is audio.inbound
Increment=6 MinDuration=6 MaxDuration=6 ConnectFee=0. 
CallId=2e0334513a34964e7c0
a18cd3be449dd@108.166.97.17:5060 Span=1 Duration=6 DestId=1 default 
Profile=USA_Default Period=weekend Rate=USA_Default Interval=0-24 C
ost=0.0035/60 Price=0.0003 PriceIn=0.

Looks like no matter what the duration is for the inbound calls it costs 
$0.0003 and the outbound calls all cost $0.0005.




On Sat, Jan 25, 2014 at 6:24 PM, Duane Larson  wrote:
David/Tijmen/Adrian,

It is working for me too.  Both inbound and outbound are being recognized and 
the different rates are being applied.  I will keep looking at it while more 
calls are being made to make sure there are no unforeseen issues. 


On Fri, Jan 24, 2014 at 5:35 AM, Tijmen de Mes  wrote:
Hi David,

Thanks for the patch. If have some time Monday I will analyze it and give you 
some feedback so we include this in CDRTool.

Besides the rating, I’ve to check if the code that now sets the the ‘route’ for 
the CDRs and if there are no problems.

  
-- 
Tijmen de Mes
AG-Projects

On 23 januari 2014 at 21:21:26, David M. Lee (d...@digium.com) wrote:

I’ve got a first attempt at a patch:
https://gist.github.com/leedm777/8585690

To get this to work, your CDR’s will have to record the application
subtype. For me, I set $avp(s:call_class) = “audio.inbound” or
“audio.outbound” as appropriate in the routes, and added
Sip-Application-Type=$avp(s:call_class) to “radius_extra”.

Billing rates will be matched on the full application, allowing
different rates depending on the application subtype.

It works with the simple testing I’ve been able to do on my desktop.
Feedback, of course, is greatly appreciated.

Duane - Does the patch work for you?

Adrian - Any objections/concerns with this approach?

If it looks good, I’ll work on updating the docs.

Thanks!
--
David M. Lee
Digium, Inc. | Software Developer
445 Jan Davis Drive NW - Huntsville, AL 35806 - USA
Check us out at: www.digium.com & www.asterisk.org

On Jan 23, 2014, at 4:43 AM, Adrian Georgescu  wrote:

> I think it would be a good idea.
>
> Adrian
>
> On 22 Jan 2014, at 16:58, David Lee (digium)  wrote:
>
>> Duane Larson wrote:
>>> I have been playing with CDRTool for a while but I am not sure if it is
>>> possible to rate Origination (Inbound) calls differently than Termination
>>> (Outbound) calls from my SIP Provider. For Origination I pay 0.0035 and
>>> for Termination I pay 0.005. Keep in mind these costs are for destination
>>> "1”.
>>
>> I've recently run into nearly the same situation.
>>
>> I tried overloading the Sip-Application-Type field, but it's limited
>> by the supportedApplicationTypes array in cdr_generic.php. There also
>> seems to be hard coded logic for the different application types.
>>
>> I think I will patch CDRTool so that you can have subtypes of
>> application types (audio.inbound, audio.outbound, etc.). This would
>> allow the billing rates to be a bit more specific for these
>> situations.
>>
>> Thoughts?
>> --
>> David M. Lee
>> Digium, Inc. | Software Developer
>> 445 Jan Davis Drive NW - Huntsville, AL 35806 - USA
>> Check us out at: www.digium.com & www.asterisk.org
>> ___
>> Users mailing list
>> Users@lists.opensips.org
>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
> _

Re: [OpenSIPS-Users] CDRTool - Rating Origination and Termination differently

[Tijmen de Mes]

Hi

I tested the patch and for now I don’t see any problem with it. Before adding 
it to trunk, can you update the rating docs and record all changes in 1 patch 
using darcs? After that I can apply it directly on trunk with your credentials.

These instructions to submit the patch also apply on CDRTool:

http://sipsimpleclient.org/projects/sipsimpleclient/wiki/SipSupport

You don’t need to open a ticket however, just tell me after you send the patch.
 
-- 
Tijmen de Mes
AG-Projects

On 26 januari 2014 at 02:08:50, Duane Larson (duane.lar...@gmail.com) wrote:

Ugh Nevermind.  My "Max Duration" was set to 6 on the Destinations rate 
setup.  I set it to zero and I think things are looking better now.  Think I'm 
done for the day.  Good work David!  Really appreciate the patch.


On Sat, Jan 25, 2014 at 6:56 PM, Duane Larson  wrote:
Not sure my "price" is being calculated correctly.

My audio.outbound should be $0.005
My audio.inbound should be $0.0035

Here is an example of a call that lasted 2:06 minutes and is audio.outbound
Increment=6 MinDuration=6 MaxDuration=6 ConnectFee=0. 
CallId=dc1e32b1ba18ff91a3
67aa8df81e8e3c@0:0:0:0:0:0:0:0 Span=1 Duration=6 DestId=1 default 
Profile=USA_Default Period=weekend Rate=USA_Default Interval=0-24 Cos
t=0.0050/60 Price=0.0005 PriceIn=0.

Here is an example of a call that lasted 1:33 minutes and is audio.inbound
Increment=6 MinDuration=6 MaxDuration=6 ConnectFee=0. 
CallId=2e0334513a34964e7c0
a18cd3be449dd@108.166.97.17:5060 Span=1 Duration=6 DestId=1 default 
Profile=USA_Default Period=weekend Rate=USA_Default Interval=0-24 C
ost=0.0035/60 Price=0.0003 PriceIn=0.

Looks like no matter what the duration is for the inbound calls it costs 
$0.0003 and the outbound calls all cost $0.0005.




On Sat, Jan 25, 2014 at 6:24 PM, Duane Larson  wrote:
David/Tijmen/Adrian,

It is working for me too.  Both inbound and outbound are being recognized and 
the different rates are being applied.  I will keep looking at it while more 
calls are being made to make sure there are no unforeseen issues. 


On Fri, Jan 24, 2014 at 5:35 AM, Tijmen de Mes  wrote:
Hi David,

Thanks for the patch. If have some time Monday I will analyze it and give you 
some feedback so we include this in CDRTool.

Besides the rating, I’ve to check if the code that now sets the the ‘route’ for 
the CDRs and if there are no problems.

  
-- 
Tijmen de Mes
AG-Projects

On 23 januari 2014 at 21:21:26, David M. Lee (d...@digium.com) wrote:

I’ve got a first attempt at a patch:
https://gist.github.com/leedm777/8585690

To get this to work, your CDR’s will have to record the application
subtype. For me, I set $avp(s:call_class) = “audio.inbound” or
“audio.outbound” as appropriate in the routes, and added
Sip-Application-Type=$avp(s:call_class) to “radius_extra”.

Billing rates will be matched on the full application, allowing
different rates depending on the application subtype.

It works with the simple testing I’ve been able to do on my desktop.
Feedback, of course, is greatly appreciated.

Duane - Does the patch work for you?

Adrian - Any objections/concerns with this approach?

If it looks good, I’ll work on updating the docs.

Thanks!
--
David M. Lee
Digium, Inc. | Software Developer
445 Jan Davis Drive NW - Huntsville, AL 35806 - USA
Check us out at: www.digium.com & www.asterisk.org

On Jan 23, 2014, at 4:43 AM, Adrian Georgescu  wrote:

> I think it would be a good idea.
>
> Adrian
>
> On 22 Jan 2014, at 16:58, David Lee (digium)  wrote:
>
>> Duane Larson wrote:
>>> I have been playing with CDRTool for a while but I am not sure if it is
>>> possible to rate Origination (Inbound) calls differently than Termination
>>> (Outbound) calls from my SIP Provider. For Origination I pay 0.0035 and
>>> for Termination I pay 0.005. Keep in mind these costs are for destination
>>> "1”.
>>
>> I've recently run into nearly the same situation.
>>
>> I tried overloading the Sip-Application-Type field, but it's limited
>> by the supportedApplicationTypes array in cdr_generic.php. There also
>> seems to be hard coded logic for the different application types.
>>
>> I think I will patch CDRTool so that you can have subtypes of
>> application types (audio.inbound, audio.outbound, etc.). This would
>> allow the billing rates to be a bit more specific for these
>> situations.
>>
>> Thoughts?
>> --
>> David M. Lee
>> Digium, Inc. | Software Developer
>> 445 Jan Davis Drive NW - Huntsville, AL 35806 - USA
>> Check us out at: www.digium.com & www.asterisk.org
>> ___
>> 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/

Re: [OpenSIPS-Users] CDRTool - Rating Origination and Termination differently

[Duane Larson]

Ugh Nevermind.  My "Max Duration" was set to 6 on the Destinations rate
setup.  I set it to zero and I think things are looking better now.  Think
I'm done for the day.  Good work David!  Really appreciate the patch.


On Sat, Jan 25, 2014 at 6:56 PM, Duane Larson wrote:

> Not sure my "price" is being calculated correctly.
>
> My audio.outbound should be $0.005
> My audio.inbound should be $0.0035
>
> Here is an example of a call that lasted 2:06 minutes and is audio.outbound
> Increment=6 MinDuration=6 MaxDuration=6 ConnectFee=0.
> CallId=dc1e32b1ba18ff91a3
> 67aa8df81e8e3c@0:0:0:0:0:0:0:0 Span=1 Duration=6 DestId=1 default
> Profile=USA_Default Period=weekend Rate=USA_Default Interval=0-24 Cos
> t=0.0050/60 Price=0.0005 PriceIn=0.
>
> Here is an example of a call that lasted 1:33 minutes and is audio.inbound
> Increment=6 MinDuration=6 MaxDuration=6 ConnectFee=0.
> CallId=2e0334513a34964e7c0
> a18cd3be449dd@108.166.97.17:5060 Span=1 Duration=6 DestId=1 default
> Profile=USA_Default Period=weekend Rate=USA_Default Interval=0-24 C
> ost=0.0035/60 Price=0.0003 PriceIn=0.
>
> Looks like no matter what the duration is for the inbound calls it costs
> $0.0003 and the outbound calls all cost $0.0005.
>
>
>
>
> On Sat, Jan 25, 2014 at 6:24 PM, Duane Larson wrote:
>
>> David/Tijmen/Adrian,
>>
>> It is working for me too.  Both inbound and outbound are being recognized
>> and the different rates are being applied.  I will keep looking at it while
>> more calls are being made to make sure there are no unforeseen issues.
>>
>>
>> On Fri, Jan 24, 2014 at 5:35 AM, Tijmen de Mes wrote:
>>
>>> Hi David,
>>>
>>> Thanks for the patch. If have some time Monday I will analyze it and
>>> give you some feedback so we include this in CDRTool.
>>>
>>> Besides the rating, I’ve to check if the code that now sets the the
>>> ‘route’ for the CDRs and if there are no problems.
>>>
>>>
>>> --
>>> Tijmen de Mes
>>> AG-Projects
>>>
>>> On 23 januari 2014 at 21:21:26, David M. Lee (d...@digium.com) wrote:
>>>
>>> I’ve got a first attempt at a patch:
>>> https://gist.github.com/leedm777/8585690
>>>
>>> To get this to work, your CDR’s will have to record the application
>>> subtype. For me, I set $avp(s:call_class) = “audio.inbound” or
>>> “audio.outbound” as appropriate in the routes, and added
>>> Sip-Application-Type=$avp(s:call_class) to “radius_extra”.
>>>
>>> Billing rates will be matched on the full application, allowing
>>> different rates depending on the application subtype.
>>>
>>> It works with the simple testing I’ve been able to do on my desktop.
>>> Feedback, of course, is greatly appreciated.
>>>
>>> Duane - Does the patch work for you?
>>>
>>> Adrian - Any objections/concerns with this approach?
>>>
>>> If it looks good, I’ll work on updating the docs.
>>>
>>> Thanks!
>>> --
>>> David M. Lee
>>> Digium, Inc. | Software Developer
>>> 445 Jan Davis Drive NW - Huntsville, AL 35806 - USA
>>> Check us out at: www.digium.com & www.asterisk.org
>>>
>>> On Jan 23, 2014, at 4:43 AM, Adrian Georgescu 
>>> wrote:
>>>
>>> > I think it would be a good idea.
>>> >
>>> > Adrian
>>> >
>>> > On 22 Jan 2014, at 16:58, David Lee (digium)  wrote:
>>> >
>>> >> Duane Larson wrote:
>>> >>> I have been playing with CDRTool for a while but I am not sure if it
>>> is
>>> >>> possible to rate Origination (Inbound) calls differently than
>>> Termination
>>> >>> (Outbound) calls from my SIP Provider. For Origination I pay 0.0035
>>> and
>>> >>> for Termination I pay 0.005. Keep in mind these costs are for
>>> destination
>>> >>> "1”.
>>> >>
>>> >> I've recently run into nearly the same situation.
>>> >>
>>> >> I tried overloading the Sip-Application-Type field, but it's limited
>>> >> by the supportedApplicationTypes array in cdr_generic.php. There also
>>> >> seems to be hard coded logic for the different application types.
>>> >>
>>> >> I think I will patch CDRTool so that you can have subtypes of
>>> >> application types (audio.inbound, audio.outbound, etc.). This would
>>> >> allow the billing rates to be a bit more specific for these
>>> >> situations.
>>> >>
>>> >> Thoughts?
>>> >> --
>>> >> David M. Lee
>>> >> Digium, Inc. | Software Developer
>>> >> 445 Jan Davis Drive NW - Huntsville, AL 35806 - USA
>>> >> Check us out at: www.digium.com & www.asterisk.org
>>> >> ___
>>> >> 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-bi

Re: [OpenSIPS-Users] CDRTool - Rating Origination and Termination differently

[Duane Larson]

Not sure my "price" is being calculated correctly.

My audio.outbound should be $0.005
My audio.inbound should be $0.0035

Here is an example of a call that lasted 2:06 minutes and is audio.outbound
Increment=6 MinDuration=6 MaxDuration=6 ConnectFee=0.
CallId=dc1e32b1ba18ff91a3
67aa8df81e8e3c@0:0:0:0:0:0:0:0 Span=1 Duration=6 DestId=1 default
Profile=USA_Default Period=weekend Rate=USA_Default Interval=0-24 Cos
t=0.0050/60 Price=0.0005 PriceIn=0.

Here is an example of a call that lasted 1:33 minutes and is audio.inbound
Increment=6 MinDuration=6 MaxDuration=6 ConnectFee=0.
CallId=2e0334513a34964e7c0
a18cd3be449dd@108.166.97.17:5060 Span=1 Duration=6 DestId=1 default
Profile=USA_Default Period=weekend Rate=USA_Default Interval=0-24 C
ost=0.0035/60 Price=0.0003 PriceIn=0.

Looks like no matter what the duration is for the inbound calls it costs
$0.0003 and the outbound calls all cost $0.0005.




On Sat, Jan 25, 2014 at 6:24 PM, Duane Larson wrote:

> David/Tijmen/Adrian,
>
> It is working for me too.  Both inbound and outbound are being recognized
> and the different rates are being applied.  I will keep looking at it while
> more calls are being made to make sure there are no unforeseen issues.
>
>
> On Fri, Jan 24, 2014 at 5:35 AM, Tijmen de Mes wrote:
>
>> Hi David,
>>
>> Thanks for the patch. If have some time Monday I will analyze it and give
>> you some feedback so we include this in CDRTool.
>>
>> Besides the rating, I’ve to check if the code that now sets the the
>> ‘route’ for the CDRs and if there are no problems.
>>
>>
>> --
>> Tijmen de Mes
>> AG-Projects
>>
>> On 23 januari 2014 at 21:21:26, David M. Lee (d...@digium.com) wrote:
>>
>> I’ve got a first attempt at a patch:
>> https://gist.github.com/leedm777/8585690
>>
>> To get this to work, your CDR’s will have to record the application
>> subtype. For me, I set $avp(s:call_class) = “audio.inbound” or
>> “audio.outbound” as appropriate in the routes, and added
>> Sip-Application-Type=$avp(s:call_class) to “radius_extra”.
>>
>> Billing rates will be matched on the full application, allowing
>> different rates depending on the application subtype.
>>
>> It works with the simple testing I’ve been able to do on my desktop.
>> Feedback, of course, is greatly appreciated.
>>
>> Duane - Does the patch work for you?
>>
>> Adrian - Any objections/concerns with this approach?
>>
>> If it looks good, I’ll work on updating the docs.
>>
>> Thanks!
>> --
>> David M. Lee
>> Digium, Inc. | Software Developer
>> 445 Jan Davis Drive NW - Huntsville, AL 35806 - USA
>> Check us out at: www.digium.com & www.asterisk.org
>>
>> On Jan 23, 2014, at 4:43 AM, Adrian Georgescu 
>> wrote:
>>
>> > I think it would be a good idea.
>> >
>> > Adrian
>> >
>> > On 22 Jan 2014, at 16:58, David Lee (digium)  wrote:
>> >
>> >> Duane Larson wrote:
>> >>> I have been playing with CDRTool for a while but I am not sure if it
>> is
>> >>> possible to rate Origination (Inbound) calls differently than
>> Termination
>> >>> (Outbound) calls from my SIP Provider. For Origination I pay 0.0035
>> and
>> >>> for Termination I pay 0.005. Keep in mind these costs are for
>> destination
>> >>> "1”.
>> >>
>> >> I've recently run into nearly the same situation.
>> >>
>> >> I tried overloading the Sip-Application-Type field, but it's limited
>> >> by the supportedApplicationTypes array in cdr_generic.php. There also
>> >> seems to be hard coded logic for the different application types.
>> >>
>> >> I think I will patch CDRTool so that you can have subtypes of
>> >> application types (audio.inbound, audio.outbound, etc.). This would
>> >> allow the billing rates to be a bit more specific for these
>> >> situations.
>> >>
>> >> Thoughts?
>> >> --
>> >> David M. Lee
>> >> Digium, Inc. | Software Developer
>> >> 445 Jan Davis Drive NW - Huntsville, AL 35806 - USA
>> >> Check us out at: www.digium.com & www.asterisk.org
>> >> ___
>> >> 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
>>
>>
>
>
> --
> --
> *--*--*--*--*--*
> Duane
> *--*--*--*--*--*
> --
>



-- 
--
*--*--*--*--*--*
Duane
*--*--*--*--*--*
--
___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

Re: [OpenSIPS-Users] CDRTool - Rating Origination and Termination differently

[Duane Larson]

David/Tijmen/Adrian,

It is working for me too.  Both inbound and outbound are being recognized
and the different rates are being applied.  I will keep looking at it while
more calls are being made to make sure there are no unforeseen issues.


On Fri, Jan 24, 2014 at 5:35 AM, Tijmen de Mes wrote:

> Hi David,
>
> Thanks for the patch. If have some time Monday I will analyze it and give
> you some feedback so we include this in CDRTool.
>
> Besides the rating, I’ve to check if the code that now sets the the
> ‘route’ for the CDRs and if there are no problems.
>
>
> --
> Tijmen de Mes
> AG-Projects
>
> On 23 januari 2014 at 21:21:26, David M. Lee (d...@digium.com) wrote:
>
> I’ve got a first attempt at a patch:
> https://gist.github.com/leedm777/8585690
>
> To get this to work, your CDR’s will have to record the application
> subtype. For me, I set $avp(s:call_class) = “audio.inbound” or
> “audio.outbound” as appropriate in the routes, and added
> Sip-Application-Type=$avp(s:call_class) to “radius_extra”.
>
> Billing rates will be matched on the full application, allowing
> different rates depending on the application subtype.
>
> It works with the simple testing I’ve been able to do on my desktop.
> Feedback, of course, is greatly appreciated.
>
> Duane - Does the patch work for you?
>
> Adrian - Any objections/concerns with this approach?
>
> If it looks good, I’ll work on updating the docs.
>
> Thanks!
> --
> David M. Lee
> Digium, Inc. | Software Developer
> 445 Jan Davis Drive NW - Huntsville, AL 35806 - USA
> Check us out at: www.digium.com & www.asterisk.org
>
> On Jan 23, 2014, at 4:43 AM, Adrian Georgescu  wrote:
>
> > I think it would be a good idea.
> >
> > Adrian
> >
> > On 22 Jan 2014, at 16:58, David Lee (digium)  wrote:
> >
> >> Duane Larson wrote:
> >>> I have been playing with CDRTool for a while but I am not sure if it
> is
> >>> possible to rate Origination (Inbound) calls differently than
> Termination
> >>> (Outbound) calls from my SIP Provider. For Origination I pay 0.0035
> and
> >>> for Termination I pay 0.005. Keep in mind these costs are for
> destination
> >>> "1”.
> >>
> >> I've recently run into nearly the same situation.
> >>
> >> I tried overloading the Sip-Application-Type field, but it's limited
> >> by the supportedApplicationTypes array in cdr_generic.php. There also
> >> seems to be hard coded logic for the different application types.
> >>
> >> I think I will patch CDRTool so that you can have subtypes of
> >> application types (audio.inbound, audio.outbound, etc.). This would
> >> allow the billing rates to be a bit more specific for these
> >> situations.
> >>
> >> Thoughts?
> >> --
> >> David M. Lee
> >> Digium, Inc. | Software Developer
> >> 445 Jan Davis Drive NW - Huntsville, AL 35806 - USA
> >> Check us out at: www.digium.com & www.asterisk.org
> >> ___
> >> 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
>
>


-- 
--
*--*--*--*--*--*
Duane
*--*--*--*--*--*
--
___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

Re: [OpenSIPS-Users] CDRTool - Rating Origination and Termination differently

[Duane Larson]

Got CDRTool patched.  Will update OpenSIPS config and then play with it.
 Hope to have some testing done later in the day.


On Fri, Jan 24, 2014 at 5:35 AM, Tijmen de Mes wrote:

> Hi David,
>
> Thanks for the patch. If have some time Monday I will analyze it and give
> you some feedback so we include this in CDRTool.
>
> Besides the rating, I’ve to check if the code that now sets the the
> ‘route’ for the CDRs and if there are no problems.
>
>
> --
> Tijmen de Mes
> AG-Projects
>
> On 23 januari 2014 at 21:21:26, David M. Lee (d...@digium.com) wrote:
>
> I’ve got a first attempt at a patch:
> https://gist.github.com/leedm777/8585690
>
> To get this to work, your CDR’s will have to record the application
> subtype. For me, I set $avp(s:call_class) = “audio.inbound” or
> “audio.outbound” as appropriate in the routes, and added
> Sip-Application-Type=$avp(s:call_class) to “radius_extra”.
>
> Billing rates will be matched on the full application, allowing
> different rates depending on the application subtype.
>
> It works with the simple testing I’ve been able to do on my desktop.
> Feedback, of course, is greatly appreciated.
>
> Duane - Does the patch work for you?
>
> Adrian - Any objections/concerns with this approach?
>
> If it looks good, I’ll work on updating the docs.
>
> Thanks!
> --
> David M. Lee
> Digium, Inc. | Software Developer
> 445 Jan Davis Drive NW - Huntsville, AL 35806 - USA
> Check us out at: www.digium.com & www.asterisk.org
>
> On Jan 23, 2014, at 4:43 AM, Adrian Georgescu  wrote:
>
> > I think it would be a good idea.
> >
> > Adrian
> >
> > On 22 Jan 2014, at 16:58, David Lee (digium)  wrote:
> >
> >> Duane Larson wrote:
> >>> I have been playing with CDRTool for a while but I am not sure if it
> is
> >>> possible to rate Origination (Inbound) calls differently than
> Termination
> >>> (Outbound) calls from my SIP Provider. For Origination I pay 0.0035
> and
> >>> for Termination I pay 0.005. Keep in mind these costs are for
> destination
> >>> "1”.
> >>
> >> I've recently run into nearly the same situation.
> >>
> >> I tried overloading the Sip-Application-Type field, but it's limited
> >> by the supportedApplicationTypes array in cdr_generic.php. There also
> >> seems to be hard coded logic for the different application types.
> >>
> >> I think I will patch CDRTool so that you can have subtypes of
> >> application types (audio.inbound, audio.outbound, etc.). This would
> >> allow the billing rates to be a bit more specific for these
> >> situations.
> >>
> >> Thoughts?
> >> --
> >> David M. Lee
> >> Digium, Inc. | Software Developer
> >> 445 Jan Davis Drive NW - Huntsville, AL 35806 - USA
> >> Check us out at: www.digium.com & www.asterisk.org
> >> ___
> >> 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
>
>


-- 
--
*--*--*--*--*--*
Duane
*--*--*--*--*--*
--
___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

Re: [OpenSIPS-Users] CDRTool - Rating Origination and Termination differently

[Tijmen de Mes]

Hi David,

Thanks for the patch. If have some time Monday I will analyze it and give you 
some feedback so we include this in CDRTool.

Besides the rating, I’ve to check if the code that now sets the the ‘route’ for 
the CDRs and if there are no problems.

  
-- 
Tijmen de Mes
AG-Projects

On 23 januari 2014 at 21:21:26, David M. Lee (d...@digium.com) wrote:

I’ve got a first attempt at a patch:  
https://gist.github.com/leedm777/8585690  

To get this to work, your CDR’s will have to record the application  
subtype. For me, I set $avp(s:call_class) = “audio.inbound” or  
“audio.outbound” as appropriate in the routes, and added  
Sip-Application-Type=$avp(s:call_class) to “radius_extra”.  

Billing rates will be matched on the full application, allowing  
different rates depending on the application subtype.  

It works with the simple testing I’ve been able to do on my desktop.  
Feedback, of course, is greatly appreciated.  

Duane - Does the patch work for you?  

Adrian - Any objections/concerns with this approach?  

If it looks good, I’ll work on updating the docs.  

Thanks!  
--  
David M. Lee  
Digium, Inc. | Software Developer  
445 Jan Davis Drive NW - Huntsville, AL 35806 - USA  
Check us out at: www.digium.com & www.asterisk.org  

On Jan 23, 2014, at 4:43 AM, Adrian Georgescu  wrote:  

> I think it would be a good idea.  
>  
> Adrian  
>  
> On 22 Jan 2014, at 16:58, David Lee (digium)  wrote:  
>  
>> Duane Larson wrote:  
>>> I have been playing with CDRTool for a while but I am not sure if it is  
>>> possible to rate Origination (Inbound) calls differently than Termination  
>>> (Outbound) calls from my SIP Provider. For Origination I pay 0.0035 and  
>>> for Termination I pay 0.005. Keep in mind these costs are for destination  
>>> "1”.  
>>  
>> I've recently run into nearly the same situation.  
>>  
>> I tried overloading the Sip-Application-Type field, but it's limited  
>> by the supportedApplicationTypes array in cdr_generic.php. There also  
>> seems to be hard coded logic for the different application types.  
>>  
>> I think I will patch CDRTool so that you can have subtypes of  
>> application types (audio.inbound, audio.outbound, etc.). This would  
>> allow the billing rates to be a bit more specific for these  
>> situations.  
>>  
>> Thoughts?  
>> --  
>> David M. Lee  
>> Digium, Inc. | Software Developer  
>> 445 Jan Davis Drive NW - Huntsville, AL 35806 - USA  
>> Check us out at: www.digium.com & www.asterisk.org  
>> ___  
>> 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] CDRTool - Rating Origination and Termination differently

[David M. Lee]

I’ve got a first attempt at a patch:
  https://gist.github.com/leedm777/8585690

To get this to work, your CDR’s will have to record the application
subtype. For me, I set $avp(s:call_class) = “audio.inbound” or
“audio.outbound” as appropriate in the routes, and added
Sip-Application-Type=$avp(s:call_class) to “radius_extra”.

Billing rates will be matched on the full application, allowing
different rates depending on the application subtype.

It works with the simple testing I’ve been able to do on my desktop.
Feedback, of course, is greatly appreciated.

Duane - Does the patch work for you?

Adrian - Any objections/concerns with this approach?

If it looks good, I’ll work on updating the docs.

Thanks!
-- 
David M. Lee
Digium, Inc. | Software Developer
445 Jan Davis Drive NW - Huntsville, AL 35806 - USA
Check us out at:  www.digium.com  & www.asterisk.org

On Jan 23, 2014, at 4:43 AM, Adrian Georgescu  wrote:

> I think it would be a good idea.
> 
> Adrian
> 
> On 22 Jan 2014, at 16:58, David Lee (digium)  wrote:
> 
>> Duane Larson wrote:
>>> I have been playing with CDRTool for a while but I am not sure if it is
>>> possible to rate Origination (Inbound) calls differently than Termination
>>> (Outbound) calls from my SIP Provider.  For Origination I pay 0.0035 and
>>> for Termination I pay 0.005.  Keep in mind these costs are for destination
>>> "1”.
>> 
>> I've recently run into nearly the same situation.
>> 
>> I tried overloading the Sip-Application-Type field, but it's limited
>> by the supportedApplicationTypes array in cdr_generic.php. There also
>> seems to be hard coded logic for the different application types.
>> 
>> I think I will patch CDRTool so that you can have subtypes of
>> application types (audio.inbound, audio.outbound, etc.). This would
>> allow the billing rates to be a bit more specific for these
>> situations.
>> 
>> Thoughts?
>> -- 
>> David M. Lee
>> Digium, Inc. | Software Developer
>> 445 Jan Davis Drive NW - Huntsville, AL 35806 - USA
>> Check us out at:  www.digium.com  & www.asterisk.org
>> ___
>> 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] CDRTool - Rating Origination and Termination differently

[David M. Lee]

Excellent!

I'll post a link to the patch here when I've got it working.

-- 
David M. Lee
Digium, Inc. | Software Developer
445 Jan Davis Drive NW - Huntsville, AL 35806 - USA
Check us out at:  www.digium.com  & www.asterisk.org

On Jan 23, 2014, at 4:43 AM, Adrian Georgescu  wrote:

> I think it would be a good idea.
> 
> Adrian
> 
> On 22 Jan 2014, at 16:58, David Lee (digium)  wrote:
> 
>> Duane Larson wrote:
>>> I have been playing with CDRTool for a while but I am not sure if it is
>>> possible to rate Origination (Inbound) calls differently than Termination
>>> (Outbound) calls from my SIP Provider.  For Origination I pay 0.0035 and
>>> for Termination I pay 0.005.  Keep in mind these costs are for destination
>>> "1”.
>> 
>> I've recently run into nearly the same situation.
>> 
>> I tried overloading the Sip-Application-Type field, but it's limited
>> by the supportedApplicationTypes array in cdr_generic.php. There also
>> seems to be hard coded logic for the different application types.
>> 
>> I think I will patch CDRTool so that you can have subtypes of
>> application types (audio.inbound, audio.outbound, etc.). This would
>> allow the billing rates to be a bit more specific for these
>> situations.
>> 
>> Thoughts?
>> -- 
>> David M. Lee
>> Digium, Inc. | Software Developer
>> 445 Jan Davis Drive NW - Huntsville, AL 35806 - USA
>> Check us out at:  www.digium.com  & www.asterisk.org
>> ___
>> 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] CDRTool - Rating Origination and Termination differently

[Adrian Georgescu]

I think it would be a good idea.

Adrian

On 22 Jan 2014, at 16:58, David Lee (digium)  wrote:

> Duane Larson wrote:
>> I have been playing with CDRTool for a while but I am not sure if it is
>> possible to rate Origination (Inbound) calls differently than Termination
>> (Outbound) calls from my SIP Provider.  For Origination I pay 0.0035 and
>> for Termination I pay 0.005.  Keep in mind these costs are for destination
>> "1”.
> 
> I've recently run into nearly the same situation.
> 
> I tried overloading the Sip-Application-Type field, but it's limited
> by the supportedApplicationTypes array in cdr_generic.php. There also
> seems to be hard coded logic for the different application types.
> 
> I think I will patch CDRTool so that you can have subtypes of
> application types (audio.inbound, audio.outbound, etc.). This would
> allow the billing rates to be a bit more specific for these
> situations.
> 
> Thoughts?
> -- 
> David M. Lee
> Digium, Inc. | Software Developer
> 445 Jan Davis Drive NW - Huntsville, AL 35806 - USA
> Check us out at:  www.digium.com  & www.asterisk.org
> ___
> Users mailing list
> Users@lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users



signature.asc
Description: Message signed with OpenPGP using GPGMail
___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

Re: [OpenSIPS-Users] CDRTool - Rating Origination and Termination differently

[Duane Larson]

If you are going to make a patch I might be interested in testing it as
long as AG-Projects are ok with adding it into future version.


On Wed, Jan 22, 2014 at 12:58 PM, David Lee (digium) wrote:

> Duane Larson wrote:
>
> I have been playing with CDRTool for a while but I am not sure if it is
> possible to rate Origination (Inbound) calls differently than Termination
> (Outbound) calls from my SIP Provider.  For Origination I pay 0.0035 and
> for Termination I pay 0.005.  Keep in mind these costs are for destination
> "1”.
>
>
> I've recently run into nearly the same situation.
>
> I tried overloading the Sip-Application-Type field, but it's limited
> by the supportedApplicationTypes array in cdr_generic.php. There also
> seems to be hard coded logic for the different application types.
>
> I think I will patch CDRTool so that you can have subtypes of
> application types (audio.inbound, audio.outbound, etc.). This would
> allow the billing rates to be a bit more specific for these
> situations.
>
> Thoughts?
> --
> David M. Lee
> Digium, Inc. | Software Developer
> 445 Jan Davis Drive NW - Huntsville, AL 35806 - USA
> Check us out at:  www.digium.com  & www.asterisk.org
>
> ___
> Users mailing list
> Users@lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>


-- 
--
*--*--*--*--*--*
Duane
*--*--*--*--*--*
--
___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

Re: [OpenSIPS-Users] CDRTool - Rating Origination and Termination differently

[David Lee (digium)]

Duane Larson wrote:
> I have been playing with CDRTool for a while but I am not sure if it is
> possible to rate Origination (Inbound) calls differently than Termination
> (Outbound) calls from my SIP Provider.  For Origination I pay 0.0035 and
> for Termination I pay 0.005.  Keep in mind these costs are for destination
> "1”.

I've recently run into nearly the same situation.

I tried overloading the Sip-Application-Type field, but it's limited
by the supportedApplicationTypes array in cdr_generic.php. There also
seems to be hard coded logic for the different application types.

I think I will patch CDRTool so that you can have subtypes of
application types (audio.inbound, audio.outbound, etc.). This would
allow the billing rates to be a bit more specific for these
situations.

Thoughts?
-- 
David M. Lee
Digium, Inc. | Software Developer
445 Jan Davis Drive NW - Huntsville, AL 35806 - USA
Check us out at:  www.digium.com  & www.asterisk.org___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

[OpenSIPS-Users] CDRTool - Rating Origination and Termination differently

[Duane Larson]

I have been playing with CDRTool for a while but I am not sure if it is
possible to rate Origination (Inbound) calls differently than Termination
(Outbound) calls from my SIP Provider.  For Origination I pay 0.0035 and
for Termination I pay 0.005.  Keep in mind these costs are for destination
"1".

I originally tried to set up customers by using the domain for each
customer and then pointed that to the Profile/Rate but with this both
Origination and Termination are priced the same because they both have the
same destination of "1".

I also tried to set up Trust Peers but my peers are always going to be the
same for Inbound and Outbound since it will always come from my Asterisk
servers.

I guess my question is "Is what I am trying to do possible with CDRTool"?
___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

[OpenSIPS-Users] CDRTool

[pa...@eremina.net]

We have installed CDRTool and find some strange behavior with E164 class.

I use E164_US class that extend E164 function. but when i change my
parameters in this:

*class E164_US extends E164 {*
*function E164_US($intAccessCode='011', $natAccessCode='',
$CountryCode="1",$ENUMtldRegexp="([1-9][0-9]{7,})") {*

It's not affect on logic when cdrtool find 'destination id', but when i do
it "hard":

*class E164_US extends E164 {*
*function E164_US($intAccessCode='011',
$natAccessCode='',$CountryCode="1",$ENUMtldRegexp="([1-9][0-9]{7,})") {*
*$this->regexp_international = "/^"."011"
.$intAccessCode."([1-9][0-9]{5,})\$/";*
*$this->regexp_national  =
"/^".$natAccessCode."([1-9][0-9]{9})\$/";*
*$this->CountryCode = "1";
*
*}*

It's work as documented in README.

Is it trouble in CDRTool? or just some PHP specific behavior in my case;
___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

Re: [OpenSIPS-Users] cdrtool

[Adrian Georgescu]

Please make a patch, we will analyze it and consider it for adding it to the 
main trunk.

Adrian

On Jun 15, 2013, at 12:59 AM, dotnetdub wrote:

> Hi Adrian,
> 
> Would you integrate this if we developed it?
> 
> Best
> Brian
> 
> 
> On 28 May 2013 12:44, Adrian Georgescu  wrote:
> It is not possible.
> 
> Adrian
> 
> On May 28, 2013, at 1:00 PM, dotnetdub wrote:
> 
> > Hi Guys,
> >
> > Is it possible to do quota by domain rather than user?
> >
> > Thanks
> > Brian
> > ___
> > 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] cdrtool

[dotnetdub]

Hi Adrian,

Would you integrate this if we developed it?

Best
Brian


On 28 May 2013 12:44, Adrian Georgescu  wrote:

> It is not possible.
>
> Adrian
>
> On May 28, 2013, at 1:00 PM, dotnetdub wrote:
>
> > Hi Guys,
> >
> > Is it possible to do quota by domain rather than user?
> >
> > Thanks
> > Brian
> > ___
> > 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] CDRTool - Callcontrol - Prepaid

[Leonardo Uzcudun]

thanks a lot Laszlo!!
I did it, i've configured wrong in the opensips the $avp(can_uri).
Now I've fixed it and CDRTool is answering properly.
I'll continue testing the CDRToll & CallControl.
Thanks again.

Leo.


 Da: Laszlo 
A: Leonardo Uzcudun  
Cc: OpenSIPS users mailling list  
Inviato: Mercoledì 12 Giugno 2013 21:17
Oggetto: Re: [OpenSIPS-Users] CDRTool - Callcontrol - Prepaid
 


Hmm, this sounds challenging :)
I'm working on a custom opensips user portal and admin interface at the moment, 
and it is a "nice to have" feature here too. 
cdrtool is also used here, so I'll play with this feature on my dev server. 
Let's see if there can be a solution, or not.

-Laszlo
2013.06.12. 12:27, "Leonardo Uzcudun"  ezt írta:

Thanks Laszlo, good idea! but it still not working.
> 
>Now i can see in the cdrtool web portal that the canonical-uri is  (check 
>the attached file, there is a comparison before and after changing the can-uri 
>to ) but when the sip user samsung@sip.mydomain places the call i still 
>seeing in the syslog:
> 
>Jun 12 11:56:50 sip cdrtool[1304]: MaxSessionTime Duration=7200 
>CallId=1517185829 From=sip:samsung@sip.mydomain Gateway=82.186.X.X 
>To=sip:ipad@sip.mydomain
>Jun 12 11:56:50 sip cdrtool[1304]: MaxSessionTime=unlimited Type=prepaid 
>CallId=1517185829 BillingParty=samsung@sip.mydomain DestId=None
>Jun 12 11:56:50 sip call-control[1985]: Call id 1517185829 of 
>samsung@sip.mydomain to sip:ipad@sip.mydomainsip is postpaid not limited
>
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
>One more thing, with change (can-uri ) when the cdrtool does the 
>normalization i see in the syslog:
> 
> 
> 
> 
>Jun 12 11:59:27 sip cdrtool[7012]: Error: cannot find destinations for 
>subscriber='samsung@sip.mydomain', domain ='', gateway='', reseller='0'
>Jun 12 11:59:27 sip cdrtool[7012]: Error: cannot find destination id for  
>of customer = '', total destinations = 0
> 
> 
> 
>Do i configuring something wrong in the cdrtool web portal -> Rating -> 
>Destinations?
> 
>Is is normal to have domain=''? shouldn't be sip.mydomain?
> 
>Thanks a lot for your help,
> 
>Leo.
> 
>
>
>Da: Laszlo 
>A: Leonardo Uzcudun ; OpenSIPS users mailling list 
> 
>Inviato: Martedì 11 Giugno 2013 18:26
>Oggetto: Re: [OpenSIPS-Users] CDRTool - Callcontrol - Prepaid
>
>
>
>what happens if you manually set $avp(can_uri) to a fixed value? like to , 
>and define this destination in cdrtool?
>2013.06.11. 18:08, "Leonardo Uzcudun"  ezt írta:
>
>Did it but still not working. I'm still receiving Maxsessiontime=unlimited and 
>DetsId=none :(
>>
>>
>>Is there any "default destination" (like a default gateway)? So no matched 
>>destination will use the "default destination" with an X price/rate/profile?
>>
>>
>>
>>Da: Adrian Georgescu 
>>A: OpenSIPS users mailling list  
>>Inviato: Martedì 11 Giugno 2013 17:18
>>Oggetto: Re: [OpenSIPS-Users] CDRTool - Callcontrol - Prepaid
>>
>>
>>
>>You need to add pricing info in the other billing tables too.
>>
>>
>>Adrian
>>
>>On Jun 11, 2013, at 3:24 PM, Leonardo Uzcudun wrote:
>>
>>Thanks again Adrian.
>>>You mean to insert in destinations (CDRtool web portal -> Rating -> 
>>>Destinations) the use...@example.com in the destination field?
>>>
>>>
>>>
>>>Da: Adrian Georgescu 
>>>A: OpenSIPS users mailling list  
>>>Inviato: Martedì 11 Giugno 2013 14:32
>>>Oggetto: Re: [OpenSIPS-Users] CDRTool - Callcontrol - Prepaid
>>>
>>>
>>>
>>>Never tried it myself for prepaid but you can setup SIP URIs as valid 
>>>destinations too and put a price on them.  
>>>
>>>
>>>Adrian
>>>
>>>
>>>
>>>On Jun 11, 2013, at 12:29 PM, Leonardo Uzcudun wrote:
>>>
>>>I guess this confirm why i can't use prepaid for calls between sip users..., 
>>>do you confirm it?
>>>>Thanks. 
>>>>
>>>>
>>>>Da: Adrian Georgescu 
>>>>A: OpenSIPS users mailling list  
>>>>Inviato: Martedì 11 Giugno 2013 11:57
>>>>Oggetto: Re: [OpenSIPS-Users] CDRTool - Callcontrol - Prepaid
>>>>
>>>>
>>>>
>>>>The prepaid engine was designed for PSTN destinations using phone numbers 
>>>>only.  
>>>>
>>>>
>>>>Adrian
>>>>
>&

Re: [OpenSIPS-Users] CDRTool - Callcontrol - Prepaid

[Laszlo]

Hmm, this sounds challenging :)
I'm working on a custom opensips user portal and admin interface at the
moment, and it is a "nice to have" feature here too.

cdrtool is also used here, so I'll play with this feature on my dev server.
Let's see if there can be a solution, or not.

-Laszlo
2013.06.12. 12:27, "Leonardo Uzcudun"  ezt írta:

> Thanks Laszlo, good idea! but it still not working.
>
> Now i can see in the cdrtool web portal that the canonical-uri is 
> (check the attached file, there is a comparison before and after changing
> the can-uri to ) but when the sip user samsung@sip.mydomain places
> the call i still seeing in the syslog:
>
> Jun 12 11:56:50 sip cdrtool[1304]: MaxSessionTime Duration=7200
> CallId=1517185829 From=sip:samsung@sip.mydomain Gateway=82.186.X.X
> To=sip:ipad@sip.mydomain
> Jun 12 11:56:50 sip cdrtool[1304]: *MaxSessionTime=unlimited*Type=prepaid 
> CallId=1517185829
> BillingParty=samsung@sip.mydomain *DestId=None
> *Jun 12 11:56:50 sip call-control[1985]: Call id 1517185829 of
> samsung@sip.mydomain to sip:ipad@*sip.mydomainsip* *is postpaid not
> limited*
>
>
>
>
>
>
>
>
>
>
>
> One more thing, with change (can-uri ) when the cdrtool does the
> normalization i see in the syslog:
>
>
>
>
> Jun 12 11:59:27 sip cdrtool[7012]: Error: cannot find destinations for
> subscriber='samsung@sip.mydomain', domain ='', gateway='', reseller='0'
> Jun 12 11:59:27 sip cdrtool[7012]: Error: cannot find destination id for
>  of customer = '', total destinations = 0
>
>
>
> Do i configuring something wrong in the cdrtool web portal -> Rating ->
> Destinations?
>
> Is is normal to have domain=''? shouldn't be sip.mydomain?
>
> Thanks a lot for your help,
>
> Leo.
>
>
>   *Da:* Laszlo 
> *A:* Leonardo Uzcudun ; OpenSIPS users mailling list <
> users@lists.opensips.org>
> *Inviato:* Martedì 11 Giugno 2013 18:26
> *Oggetto:* Re: [OpenSIPS-Users] CDRTool - Callcontrol - Prepaid
>
>  what happens if you manually set $avp(can_uri) to a fixed value? like to
> , and define this destination in cdrtool?
> 2013.06.11. 18:08, "Leonardo Uzcudun"  ezt írta:
>
>  Did it but still not working. I'm still receiving
> Maxsessiontime=unlimited and DetsId=none :(
>
> Is there any "default destination" (like a default gateway)? So no matched
> destination will use the "default destination" with an X price/rate/profile?
>
>   *Da:* Adrian Georgescu 
> *A:* OpenSIPS users mailling list 
> *Inviato:* Martedì 11 Giugno 2013 17:18
> *Oggetto:* Re: [OpenSIPS-Users] CDRTool - Callcontrol - Prepaid
>
>  You need to add pricing info in the other billing tables too.
>
> Adrian
>
>  On Jun 11, 2013, at 3:24 PM, Leonardo Uzcudun wrote:
>
>  Thanks again Adrian.
> You mean to insert in destinations (CDRtool web portal -> Rating ->
> Destinations) the use...@example.com in the destination field?
>
>   *Da:* Adrian Georgescu 
> *A:* OpenSIPS users mailling list 
> *Inviato:* Martedì 11 Giugno 2013 14:32
> *Oggetto:* Re: [OpenSIPS-Users] CDRTool - Callcontrol - Prepaid
>
>  Never tried it myself for prepaid but you can setup SIP URIs as valid
> destinations too and put a price on them.
>
> Adrian
>
>  On Jun 11, 2013, at 12:29 PM, Leonardo Uzcudun wrote:
>
>  I guess this confirm why i can't use prepaid for calls between sip
> users..., do you confirm it?
> Thanks.
>
>   *Da:* Adrian Georgescu 
> *A:* OpenSIPS users mailling list 
> *Inviato:* Martedì 11 Giugno 2013 11:57
> *Oggetto:* Re: [OpenSIPS-Users] CDRTool - Callcontrol - Prepaid
>
>  The prepaid engine was designed for PSTN destinations using phone
> numbers only.
>
> Adrian
>
>  On 11 Jun 2013, at 11:49, Leonardo Uzcudun  wrote:
>
>  Hello Adrian:
>
> From the following site (
> http://callcontrol.ag-projects.com/issues/1769#change-8449) i've found
> that you say "All internals of CDRTool rely on the fact that there is a
> normalized URI in the form of 00 + Country Code + Number."
> So, my question or doubt is:
> If there are 2 sip users within the same domain like use...@example.com
> and use...@example.com, can i implement prepaid billing between them or
> the prepaid will only work if they call to 00 + Country Code + Number sip
> accounts?
> Thanks,
>
> Leo
>  *Da:* Adrian Georgescu 
> *A:* OpenSIPS users mailling list 
> *Inviato:* Lunedì 10 Giugno 2013 21:39
> *Oggetto:* Re: [OpenSIPS-Users] CDRTool - Callcontrol - Prepaid
>
> There is Rating.txt document that contain sample rates files

Re: [OpenSIPS-Users] CDRTool - Callcontrol - Prepaid

[Laszlo]

what happens if you manually set $avp(can_uri) to a fixed value? like to
, and define this destination in cdrtool?
2013.06.11. 18:08, "Leonardo Uzcudun"  ezt írta:

> Did it but still not working. I'm still receiving Maxsessiontime=unlimited
> and DetsId=none :(
>
> Is there any "default destination" (like a default gateway)? So no matched
> destination will use the "default destination" with an X price/rate/profile?
>
>   --
>  *Da:* Adrian Georgescu 
> *A:* OpenSIPS users mailling list 
> *Inviato:* Martedì 11 Giugno 2013 17:18
> *Oggetto:* Re: [OpenSIPS-Users] CDRTool - Callcontrol - Prepaid
>
> You need to add pricing info in the other billing tables too.
>
> Adrian
>
> On Jun 11, 2013, at 3:24 PM, Leonardo Uzcudun wrote:
>
> Thanks again Adrian.
> You mean to insert in destinations (CDRtool web portal -> Rating ->
> Destinations) the use...@example.com in the destination field?
>
>   --
>  *Da:* Adrian Georgescu 
> *A:* OpenSIPS users mailling list 
> *Inviato:* Martedì 11 Giugno 2013 14:32
> *Oggetto:* Re: [OpenSIPS-Users] CDRTool - Callcontrol - Prepaid
>
> Never tried it myself for prepaid but you can setup SIP URIs as valid
> destinations too and put a price on them.
>
> Adrian
>
> On Jun 11, 2013, at 12:29 PM, Leonardo Uzcudun wrote:
>
> I guess this confirm why i can't use prepaid for calls between sip
> users..., do you confirm it?
> Thanks.
>
>   ----------
>  *Da:* Adrian Georgescu 
> *A:* OpenSIPS users mailling list 
> *Inviato:* Martedì 11 Giugno 2013 11:57
> *Oggetto:* Re: [OpenSIPS-Users] CDRTool - Callcontrol - Prepaid
>
> The prepaid engine was designed for PSTN destinations using phone numbers
> only.
>
> Adrian
>
> On 11 Jun 2013, at 11:49, Leonardo Uzcudun  wrote:
>
> Hello Adrian:
>
> From the following site (
> http://callcontrol.ag-projects.com/issues/1769#change-8449) i've found
> that you say "All internals of CDRTool rely on the fact that there is a
> normalized URI in the form of 00 + Country Code + Number."
> So, my question or doubt is:
> If there are 2 sip users within the same domain like use...@example.com
> and use...@example.com, can i implement prepaid billing between them or
> the prepaid will only work if they call to 00 + Country Code + Number sip
> accounts?
> Thanks,
>
> Leo
> --
> *Da:* Adrian Georgescu 
> *A:* OpenSIPS users mailling list 
> *Inviato:* Lunedì 10 Giugno 2013 21:39
> *Oggetto:* Re: [OpenSIPS-Users] CDRTool - Callcontrol - Prepaid
>
> There is Rating.txt document that contain sample rates files and examples
> of prepaid queries in the console that shows you how it works.
>
> Adrian
>
>
> On Jun 10, 2013, at 9:30 PM, Leonardo Uzcudun wrote:
>
> Hello All:
>
> After doing more tests i guess the problem is the missing DestId
> cdrtool log:
> Jun  8 02:51:12 sip cdrtool[13359]: MaxSessionTime=unlimited Type=prepaid
> CallId=1226626922 BillingParty=user01@mydomain DestId=None
>
> and considering the rating.txt doc point 3. Determination of the costs ->
> No rate will be returned if no 'destination id' is found.
>
> So, now my question is: If the Destination (cdrtool web portal -> Rating
> -> Destinations) must be a number (like 31 for the Netherlands), how will i
> match destination to mydomain?
>
> Thanks,
>
> Leo.
> --
> *Da:* leo 
> *A:* users@lists.opensips.org
> *Inviato:* Venerdì 7 Giugno 2013 9:38
> *Oggetto:* [OpenSIPS-Users] CDRTool - Callcontrol - Prepaid
>
> Hello:
>
> I need some help to understand the CDRTool - Callcontrol - Prepaid, all the
> efforts i could do reading, searching and testing to try to understand how
> it works were unsuccessful.
>
> My set-up would be very simple, I would like to give credit (in seconds) to
> the users and after the call is ended the call duration time should be
> subtracted to its balance.
>
> My first concern is how do i map a user in the opensips.subscriber
> (DB.table) to the prepaid billing?
> The second one would be, how would i configure the rating/quota/prepaid to
> have my set-up?
>
> Thanks for your help.
>
> Leo.
>
>
>
> --
> View this message in context:
> http://opensips-open-sip-server.1449251.n2.nabble.com/CDRTool-Callcontrol-Prepaid-tp7586750.html
> Sent from the OpenSIPS - Users mailing list archive at 
> Nabble.com<http://nabble.com/>
> .
>
> ___
> Users mailing list
> Users@lists.opensips.org
> http://lists.opensips.org/c

Re: [OpenSIPS-Users] CDRTool - Callcontrol - Prepaid

[Leonardo Uzcudun]

Thanks Laszlo, good idea! but it still not working.
 
Now i can see in the cdrtool web portal that the canonical-uri is  (check 
the attached file, there is a comparison before and after changing the can-uri 
to ) but when the sip user samsung@sip.mydomain places the call i still 
seeing in the syslog:
 
Jun 12 11:56:50 sip cdrtool[1304]: MaxSessionTime Duration=7200 
CallId=1517185829 From=sip:samsung@sip.mydomain Gateway=82.186.X.X 
To=sip:ipad@sip.mydomain
Jun 12 11:56:50 sip cdrtool[1304]: MaxSessionTime=unlimited Type=prepaid 
CallId=1517185829 BillingParty=samsung@sip.mydomain DestId=None
Jun 12 11:56:50 sip call-control[1985]: Call id 1517185829 of 
samsung@sip.mydomain to sip:ipad@sip.mydomainsip is postpaid not limited

 
 
 
 
 
 
 
 
 
 
 
One more thing, with change (can-uri ) when the cdrtool does the 
normalization i see in the syslog:
 
 
 
 
Jun 12 11:59:27 sip cdrtool[7012]: Error: cannot find destinations for 
subscriber='samsung@sip.mydomain', domain ='', gateway='', reseller='0'
Jun 12 11:59:27 sip cdrtool[7012]: Error: cannot find destination id for  
of customer = '', total destinations = 0
 
 
 
Do i configuring something wrong in the cdrtool web portal -> Rating -> 
Destinations?
 
Is is normal to have domain=''? shouldn't be sip.mydomain?
 
Thanks a lot for your help,
 
Leo.


Da: Laszlo 
A: Leonardo Uzcudun ; OpenSIPS users mailling list 
 
Inviato: Martedì 11 Giugno 2013 18:26
Oggetto: Re: [OpenSIPS-Users] CDRTool - Callcontrol - Prepaid



what happens if you manually set $avp(can_uri) to a fixed value? like to , 
and define this destination in cdrtool?
2013.06.11. 18:08, "Leonardo Uzcudun"  ezt írta:

Did it but still not working. I'm still receiving Maxsessiontime=unlimited and 
DetsId=none :(
>
>
>Is there any "default destination" (like a default gateway)? So no matched 
>destination will use the "default destination" with an X price/rate/profile?
>
>
>
>Da: Adrian Georgescu 
>A: OpenSIPS users mailling list  
>Inviato: Martedì 11 Giugno 2013 17:18
>Oggetto: Re: [OpenSIPS-Users] CDRTool - Callcontrol - Prepaid
>
>
>
>You need to add pricing info in the other billing tables too.
>
>
>Adrian
>
>On Jun 11, 2013, at 3:24 PM, Leonardo Uzcudun wrote:
>
>Thanks again Adrian.
>>You mean to insert in destinations (CDRtool web portal -> Rating -> 
>>Destinations) the use...@example.com in the destination field?
>>
>>
>>
>>Da: Adrian Georgescu 
>>A: OpenSIPS users mailling list  
>>Inviato: Martedì 11 Giugno 2013 14:32
>>Oggetto: Re: [OpenSIPS-Users] CDRTool - Callcontrol - Prepaid
>>
>>
>>
>>Never tried it myself for prepaid but you can setup SIP URIs as valid 
>>destinations too and put a price on them.  
>>
>>
>>Adrian
>>
>>
>>
>>On Jun 11, 2013, at 12:29 PM, Leonardo Uzcudun wrote:
>>
>>I guess this confirm why i can't use prepaid for calls between sip users..., 
>>do you confirm it?
>>>Thanks. 
>>>
>>>
>>>Da: Adrian Georgescu 
>>>A: OpenSIPS users mailling list  
>>>Inviato: Martedì 11 Giugno 2013 11:57
>>>Oggetto: Re: [OpenSIPS-Users] CDRTool - Callcontrol - Prepaid
>>>
>>>
>>>
>>>The prepaid engine was designed for PSTN destinations using phone numbers 
>>>only.  
>>>
>>>
>>>Adrian
>>>
>>>
>>>On 11 Jun 2013, at 11:49, Leonardo Uzcudun  wrote:
>>>
>>>Hello Adrian:
>>>>
>>>>From the following site 
>>>>(http://callcontrol.ag-projects.com/issues/1769#change-8449) i've found 
>>>>that you say "All internals of CDRTool rely on the fact that there is a 
>>>>normalized URI in the form of 00 + Country Code + Number."
>>>>So, my question or doubt is:
>>>>If there are 2 sip users within the same domain like use...@example.com and 
>>>>use...@example.com, can i implement prepaid billing between them or the 
>>>>prepaid will only work if they call to 00 + Country Code + Number sip 
>>>>accounts?
>>>>Thanks,
>>>>
>>>>Leo 
>>>>Da: Adrian Georgescu 
>>>>A: OpenSIPS users mailling list  
>>>>Inviato: Lunedì 10 Giugno 2013 21:39
>>>>Oggetto: Re: [OpenSIPS-Users] CDRTool - Callcontrol - Prepaid
>>>>
>>>>
>>>>
>>>>There is Rating.txt document that contain sample rates files and examples 
>>>>of prepaid queries in the console that shows you how it works.  
>>>>
>>>>
>>>&g

Re: [OpenSIPS-Users] CDRTool - Callcontrol - Prepaid

[Leonardo Uzcudun]

Did it but still not working. I'm still receiving Maxsessiontime=unlimited and 
DetsId=none :(

Is there any "default destination" (like a default gateway)? So no matched 
destination will use the "default destination" with an X price/rate/profile?




 Da: Adrian Georgescu 
A: OpenSIPS users mailling list  
Inviato: Martedì 11 Giugno 2013 17:18
Oggetto: Re: [OpenSIPS-Users] CDRTool - Callcontrol - Prepaid
 


You need to add pricing info in the other billing tables too.

Adrian

On Jun 11, 2013, at 3:24 PM, Leonardo Uzcudun wrote:

Thanks again Adrian.
>You mean to insert in destinations (CDRtool web portal -> Rating -> 
>Destinations) the use...@example.com in the destination field?
>
>
>
>
>
> Da: Adrian Georgescu 
>A: OpenSIPS users mailling list  
>Inviato: Martedì 11 Giugno 2013 14:32
>Oggetto: Re: [OpenSIPS-Users] CDRTool - Callcontrol - Prepaid
> 
>
>
>Never tried it myself for prepaid but you can setup SIP URIs as valid 
>destinations too and put a price on them. 
>
>
>Adrian
>
>
>
>On Jun 11, 2013, at 12:29 PM, Leonardo Uzcudun wrote:
>
>I guess this confirm why i can't use prepaid for calls between sip users..., 
>do you confirm it?
>>Thanks.
>>
>>
>>
>>____________
>> Da: Adrian Georgescu 
>>A: OpenSIPS users mailling list  
>>Inviato: Martedì 11 Giugno 2013 11:57
>>Oggetto: Re: [OpenSIPS-Users] CDRTool - Callcontrol - Prepaid
>> 
>>
>>
>>The prepaid engine was designed for PSTN destinations using phone numbers 
>>only. 
>>
>>
>>Adrian
>>
>>
>>On 11 Jun 2013, at 11:49, Leonardo Uzcudun  wrote:
>>
>>Hello Adrian:
>>>
>>>From the following site 
>>>(http://callcontrol.ag-projects.com/issues/1769#change-8449) i've found that 
>>>you say "All internals of CDRTool rely on the fact that there is a 
>>>normalized URI in the form of 00 + Country Code + Number."
>>>So, my
 question or doubt is:
>>>If there are 2 sip users within the same domain like use...@example.com and 
>>>use...@example.com, can i implement prepaid billing between them or the 
>>>prepaid will only work if they call to 00 + Country Code + Number sip 
>>>accounts?
>>>Thanks,
>>>
>>>Leo
>>>
>>>
>>>Da: Adrian Georgescu 
>>>A: OpenSIPS users mailling list  
>>>Inviato: Lunedì 10 Giugno 2013 21:39
>>>Oggetto: Re: [OpenSIPS-Users] CDRTool - Callcontrol - Prepaid
>>>
>>>
>>>
>>>There is Rating.txt document that contain sample rates files and examples of 
>>>prepaid queries in the console that shows you how it works. 
>>>
>>>
>>>Adrian
>>>
>>>
>>>
>>>
>>>On Jun 10, 2013, at 9:30 PM, Leonardo Uzcudun wrote:
>>>
>>>Hello All:
>>>>
>>>>
>>>>
>>>>After doing more tests i guess the problem is the missing DestId
>>>>cdrtool log:Jun  8 02:51:12 sip cdrtool[13359]: MaxSessionTime=unlimited 
>>>>Type=prepaid CallId=1226626922 BillingParty=user01@mydomain DestId=None
>>>>
>>>>and considering the rating.txt doc point 3. Determination of the costs -> 
>>>>No rate will be returned if no 'destination id' is found.
>>>>
>>>>
>>>>So, now my question is: If the Destination (cdrtool web portal -> Rating -> 
>>>>Destinations) must be a number (like 31 for the Netherlands), how will i 
>>>>match destination to mydomain?
>>>>
>>>>
>>>>Thanks,
>>>>
>>>>Leo.
>>>>
>>>>
>>>>Da: leo 
>>>>A: users@lists.opensips.org 
>>>>Inviato: Venerdì 7 Giugno 2013 9:38
>>>>Oggetto: [OpenSIPS-Users] CDRTool - Callcontrol - Prepaid
>>>>
>>>>
>>>>Hello:
>>>>
>>>>I need some help to understand the CDRTool - Callcontrol - Prepaid, all the
>>>>efforts i could do reading, searching and testing to try to understand how
>>>>it works were unsuccessful.
>>>>
>>>>My set-up would be very simple, I would like to give credit (in seconds) to
>>>>the users and after the call is ended the call duration time should be
>>>>subtracted to its balance.
>>>>
>>>>My first concern is how do i map a user in the opensips.subscriber
&g

Re: [OpenSIPS-Users] CDRTool - Callcontrol - Prepaid

[Adrian Georgescu]

You need to add pricing info in the other billing tables too.

Adrian

On Jun 11, 2013, at 3:24 PM, Leonardo Uzcudun wrote:

> Thanks again Adrian.
> You mean to insert in destinations (CDRtool web portal -> Rating -> 
> Destinations) the use...@example.com in the destination field?
> 
> Da: Adrian Georgescu 
> A: OpenSIPS users mailling list  
> Inviato: Martedì 11 Giugno 2013 14:32
> Oggetto: Re: [OpenSIPS-Users] CDRTool - Callcontrol - Prepaid
> 
> Never tried it myself for prepaid but you can setup SIP URIs as valid 
> destinations too and put a price on them. 
> 
> Adrian
> 
> On Jun 11, 2013, at 12:29 PM, Leonardo Uzcudun wrote:
> 
>> I guess this confirm why i can't use prepaid for calls between sip users..., 
>> do you confirm it?
>> Thanks.
>> 
>> Da: Adrian Georgescu 
>> A: OpenSIPS users mailling list  
>> Inviato: Martedì 11 Giugno 2013 11:57
>> Oggetto: Re: [OpenSIPS-Users] CDRTool - Callcontrol - Prepaid
>> 
>> The prepaid engine was designed for PSTN destinations using phone numbers 
>> only. 
>> 
>> Adrian
>> 
>> On 11 Jun 2013, at 11:49, Leonardo Uzcudun  wrote:
>> 
>>> Hello Adrian:
>>> 
>>> From the following site 
>>> (http://callcontrol.ag-projects.com/issues/1769#change-8449) i've found 
>>> that you say "All internals of CDRTool rely on the fact that there is a 
>>> normalized URI in the form of 00 + Country Code + Number."
>>> So, my question or doubt is:
>>> If there are 2 sip users within the same domain like use...@example.com and 
>>> use...@example.com, can i implement prepaid billing between them or the 
>>> prepaid will only work if they call to 00 + Country Code + Number sip 
>>> accounts?
>>> Thanks,
>>> 
>>> Leo
>>> Da: Adrian Georgescu 
>>> A: OpenSIPS users mailling list  
>>> Inviato: Lunedì 10 Giugno 2013 21:39
>>> Oggetto: Re: [OpenSIPS-Users] CDRTool - Callcontrol - Prepaid
>>> 
>>> There is Rating.txt document that contain sample rates files and examples 
>>> of prepaid queries in the console that shows you how it works. 
>>> 
>>> Adrian
>>> 
>>> 
>>> On Jun 10, 2013, at 9:30 PM, Leonardo Uzcudun wrote:
>>> 
>>>> Hello All:
>>>> 
>>>> After doing more tests i guess the problem is the missing DestId
>>>> cdrtool log:
>>>> Jun  8 02:51:12 sip cdrtool[13359]: MaxSessionTime=unlimited Type=prepaid 
>>>> CallId=1226626922 BillingParty=user01@mydomain DestId=None
>>>> 
>>>> and considering the rating.txt doc point 3. Determination of the costs -> 
>>>> No rate will be returned if no 'destination id' is found.
>>>> 
>>>> So, now my question is: If the Destination (cdrtool web portal -> Rating 
>>>> -> Destinations) must be a number (like 31 for the Netherlands), how will 
>>>> i match destination to mydomain?
>>>> 
>>>> Thanks,
>>>> 
>>>> Leo.
>>>> Da: leo 
>>>> A: users@lists.opensips.org 
>>>> Inviato: Venerdì 7 Giugno 2013 9:38
>>>> Oggetto: [OpenSIPS-Users] CDRTool - Callcontrol - Prepaid
>>>> 
>>>> Hello:
>>>> 
>>>> I need some help to understand the CDRTool - Callcontrol - Prepaid, all the
>>>> efforts i could do reading, searching and testing to try to understand how
>>>> it works were unsuccessful.
>>>> 
>>>> My set-up would be very simple, I would like to give credit (in seconds) to
>>>> the users and after the call is ended the call duration time should be
>>>> subtracted to its balance.
>>>> 
>>>> My first concern is how do i map a user in the opensips.subscriber
>>>> (DB.table) to the prepaid billing?
>>>> The second one would be, how would i configure the rating/quota/prepaid to
>>>> have my set-up?
>>>> 
>>>> Thanks for your help.
>>>> 
>>>> Leo.
>>>> 
>>>> 
>>>> 
>>>> --
>>>> View this message in context: 
>>>> http://opensips-open-sip-server.1449251.n2.nabble.com/CDRTool-Callcontrol-Prepaid-tp7586750.html
>>>> Sent from the OpenSIPS - Users mailing list archive at Nabble.com.
>>>> 
>>>> ___
>>>> Users mailing list
>>>> Users@lists.opensips.org
>>>> http://lists.opensips.org/

Re: [OpenSIPS-Users] CDRTool - Callcontrol - Prepaid

[Leonardo Uzcudun]

Thanks again Adrian.
You mean to insert in destinations (CDRtool web portal -> Rating -> 
Destinations) the use...@example.com in the destination field?




 Da: Adrian Georgescu 
A: OpenSIPS users mailling list  
Inviato: Martedì 11 Giugno 2013 14:32
Oggetto: Re: [OpenSIPS-Users] CDRTool - Callcontrol - Prepaid
 


Never tried it myself for prepaid but you can setup SIP URIs as valid 
destinations too and put a price on them. 

Adrian



On Jun 11, 2013, at 12:29 PM, Leonardo Uzcudun wrote:

I guess this confirm why i can't use prepaid for calls between sip users..., do 
you confirm it?
>Thanks.
>
>
>
>
> Da: Adrian Georgescu 
>A: OpenSIPS users mailling list  
>Inviato: Martedì 11 Giugno 2013 11:57
>Oggetto: Re: [OpenSIPS-Users] CDRTool - Callcontrol - Prepaid
> 
>
>
>The prepaid engine was designed for PSTN destinations using phone numbers 
>only. 
>
>
>Adrian
>
>
>On 11 Jun 2013, at 11:49, Leonardo Uzcudun  wrote:
>
>Hello Adrian:
>>
>>From the following site 
>>(http://callcontrol.ag-projects.com/issues/1769#change-8449) i've found that 
>>you say "All internals of CDRTool rely on the fact that there is a normalized 
>>URI in the form of 00 + Country Code + Number."
>>So, my
 question or doubt is:
>>If there are 2 sip users within the same domain like use...@example.com and 
>>use...@example.com, can i implement prepaid billing between them or the 
>>prepaid will only work if they call to 00 + Country Code + Number sip 
>>accounts?
>>Thanks,
>>
>>Leo
>>
>>
>>Da: Adrian Georgescu 
>>A: OpenSIPS users mailling list  
>>Inviato: Lunedì 10 Giugno 2013 21:39
>>Oggetto: Re: [OpenSIPS-Users] CDRTool - Callcontrol - Prepaid
>>
>>
>>
>>There is Rating.txt document that contain sample rates files and examples of 
>>prepaid queries in the console that shows you how it works. 
>>
>>
>>Adrian
>>
>>
>>
>>
>>On Jun 10, 2013, at 9:30 PM, Leonardo Uzcudun wrote:
>>
>>Hello All:
>>>
>>>
>>>
>>>After doing more tests i guess the problem is the missing DestId
>>>cdrtool log:Jun  8 02:51:12 sip cdrtool[13359]: MaxSessionTime=unlimited 
>>>Type=prepaid CallId=1226626922 BillingParty=user01@mydomain DestId=None
>>>
>>>and considering the rating.txt doc point 3. Determination of the costs -> No 
>>>rate will be returned if no 'destination id' is found.
>>>
>>>
>>>So, now my question is: If the Destination (cdrtool web portal -> Rating -> 
>>>Destinations) must be a number (like 31 for the Netherlands), how will i 
>>>match destination to mydomain?
>>>
>>>
>>>Thanks,
>>>
>>>Leo.
>>>
>>>
>>>Da: leo 
>>>A: users@lists.opensips.org 
>>>Inviato: Venerdì 7 Giugno 2013 9:38
>>>Oggetto: [OpenSIPS-Users] CDRTool - Callcontrol - Prepaid
>>>
>>>
>>>Hello:
>>>
>>>I need some help to understand the CDRTool - Callcontrol - Prepaid, all the
>>>efforts i could do reading, searching and testing to try to understand how
>>>it works were unsuccessful.
>>>
>>>My set-up would be very simple, I would like to give credit (in seconds) to
>>>the users and after the call is ended the call duration time should be
>>>subtracted to its balance.
>>>
>>>My first concern is how do i map a user in the opensips.subscriber
>>>(DB.table) to the prepaid billing?
>>>The second one would be, how
 would i configure the rating/quota/prepaid to
>>>have my set-up?
>>>
>>>Thanks for your help.
>>>
>>>Leo.
>>>
>>>
>>>
>>>--
>>>View this message in context: 
>>>http://opensips-open-sip-server.1449251.n2.nabble.com/CDRTool-Callcontrol-Prepaid-tp7586750.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
>>>
>>
>>___
>>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
>

___
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] CDRTool - Callcontrol - Prepaid

[Adrian Georgescu]

Never tried it myself for prepaid but you can setup SIP URIs as valid 
destinations too and put a price on them. 

Adrian

On Jun 11, 2013, at 12:29 PM, Leonardo Uzcudun wrote:

> I guess this confirm why i can't use prepaid for calls between sip users..., 
> do you confirm it?
> Thanks.
> 
> Da: Adrian Georgescu 
> A: OpenSIPS users mailling list  
> Inviato: Martedì 11 Giugno 2013 11:57
> Oggetto: Re: [OpenSIPS-Users] CDRTool - Callcontrol - Prepaid
> 
> The prepaid engine was designed for PSTN destinations using phone numbers 
> only. 
> 
> Adrian
> 
> On 11 Jun 2013, at 11:49, Leonardo Uzcudun  wrote:
> 
>> Hello Adrian:
>> 
>> From the following site 
>> (http://callcontrol.ag-projects.com/issues/1769#change-8449) i've found that 
>> you say "All internals of CDRTool rely on the fact that there is a 
>> normalized URI in the form of 00 + Country Code + Number."
>> So, my question or doubt is:
>> If there are 2 sip users within the same domain like use...@example.com and 
>> use...@example.com, can i implement prepaid billing between them or the 
>> prepaid will only work if they call to 00 + Country Code + Number sip 
>> accounts?
>> Thanks,
>> 
>> Leo
>> Da: Adrian Georgescu 
>> A: OpenSIPS users mailling list  
>> Inviato: Lunedì 10 Giugno 2013 21:39
>> Oggetto: Re: [OpenSIPS-Users] CDRTool - Callcontrol - Prepaid
>> 
>> There is Rating.txt document that contain sample rates files and examples of 
>> prepaid queries in the console that shows you how it works. 
>> 
>> Adrian
>> 
>> 
>> On Jun 10, 2013, at 9:30 PM, Leonardo Uzcudun wrote:
>> 
>>> Hello All:
>>> 
>>> After doing more tests i guess the problem is the missing DestId
>>> cdrtool log:
>>> Jun  8 02:51:12 sip cdrtool[13359]: MaxSessionTime=unlimited Type=prepaid 
>>> CallId=1226626922 BillingParty=user01@mydomain DestId=None
>>> 
>>> and considering the rating.txt doc point 3. Determination of the costs -> 
>>> No rate will be returned if no 'destination id' is found.
>>> 
>>> So, now my question is: If the Destination (cdrtool web portal -> Rating -> 
>>> Destinations) must be a number (like 31 for the Netherlands), how will i 
>>> match destination to mydomain?
>>> 
>>> Thanks,
>>> 
>>> Leo.
>>> Da: leo 
>>> A: users@lists.opensips.org 
>>> Inviato: Venerdì 7 Giugno 2013 9:38
>>> Oggetto: [OpenSIPS-Users] CDRTool - Callcontrol - Prepaid
>>> 
>>> Hello:
>>> 
>>> I need some help to understand the CDRTool - Callcontrol - Prepaid, all the
>>> efforts i could do reading, searching and testing to try to understand how
>>> it works were unsuccessful.
>>> 
>>> My set-up would be very simple, I would like to give credit (in seconds) to
>>> the users and after the call is ended the call duration time should be
>>> subtracted to its balance.
>>> 
>>> My first concern is how do i map a user in the opensips.subscriber
>>> (DB.table) to the prepaid billing?
>>> The second one would be, how would i configure the rating/quota/prepaid to
>>> have my set-up?
>>> 
>>> Thanks for your help.
>>> 
>>> Leo.
>>> 
>>> 
>>> 
>>> --
>>> View this message in context: 
>>> http://opensips-open-sip-server.1449251.n2.nabble.com/CDRTool-Callcontrol-Prepaid-tp7586750.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
>> 
>> 
>> ___
>> 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

___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

Re: [OpenSIPS-Users] CDRTool - Callcontrol - Prepaid

[Leonardo Uzcudun]

I guess this confirm why i can't use prepaid for calls between sip users..., do 
you confirm it?
Thanks.



 Da: Adrian Georgescu 
A: OpenSIPS users mailling list  
Inviato: Martedì 11 Giugno 2013 11:57
Oggetto: Re: [OpenSIPS-Users] CDRTool - Callcontrol - Prepaid
 


The prepaid engine was designed for PSTN destinations using phone numbers only. 

Adrian


On 11 Jun 2013, at 11:49, Leonardo Uzcudun  wrote:

Hello Adrian:
>
>From the following site 
>(http://callcontrol.ag-projects.com/issues/1769#change-8449) i've found that 
>you say "All internals of CDRTool rely on the fact that there is a normalized 
>URI in the form of 00 + Country Code + Number."
>So, my question or doubt is:
>If there are 2 sip users within the same domain like use...@example.com and 
>use...@example.com, can i implement prepaid billing between them or the 
>prepaid will only work if they call to 00 + Country Code + Number sip accounts?
>Thanks,
>
>Leo
>
>
>Da: Adrian Georgescu 
>A: OpenSIPS users mailling list  
>Inviato: Lunedì 10 Giugno 2013 21:39
>Oggetto: Re: [OpenSIPS-Users] CDRTool - Callcontrol - Prepaid
>
>
>
>There is Rating.txt document that contain sample rates files and examples of 
>prepaid queries in the console that shows you how it works. 
>
>
>Adrian
>
>
>
>
>On Jun 10, 2013, at 9:30 PM, Leonardo Uzcudun wrote:
>
>Hello All:
>>
>>
>>
>>After doing more tests i guess the problem is the missing DestId
>>cdrtool log:Jun  8 02:51:12 sip cdrtool[13359]: MaxSessionTime=unlimited 
>>Type=prepaid CallId=1226626922 BillingParty=user01@mydomain DestId=None
>>
>>and considering the rating.txt doc point 3. Determination of the costs -> No 
>>rate will be returned if no 'destination id' is found.
>>
>>
>>So, now my question is: If the Destination (cdrtool web portal -> Rating -> 
>>Destinations) must be a number (like 31 for the Netherlands), how will i 
>>match destination to mydomain?
>>
>>
>>Thanks,
>>
>>Leo.
>>
>>
>>Da: leo 
>>A: users@lists.opensips.org 
>>Inviato: Venerdì 7 Giugno 2013 9:38
>>Oggetto: [OpenSIPS-Users] CDRTool - Callcontrol - Prepaid
>>
>>
>>Hello:
>>
>>I need some help to understand the CDRTool - Callcontrol - Prepaid, all the
>>efforts i could do reading, searching and testing to try to understand how
>>it works were unsuccessful.
>>
>>My set-up would be very simple, I would like to give credit (in seconds) to
>>the users and after the call is ended the call duration time should be
>>subtracted to its balance.
>>
>>My first concern is how do i map a user in the opensips.subscriber
>>(DB.table) to the prepaid billing?
>>The second one would be, how would i configure the rating/quota/prepaid to
>>have my set-up?
>>
>>Thanks for your help.
>>
>>Leo.
>>
>>
>>
>>--
>>View this message in context: 
>>http://opensips-open-sip-server.1449251.n2.nabble.com/CDRTool-Callcontrol-Prepaid-tp7586750.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
>>
>
>___
>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] CDRTool - Callcontrol - Prepaid

[Adrian Georgescu]

The prepaid engine was designed for PSTN destinations using phone numbers only. 

Adrian

On 11 Jun 2013, at 11:49, Leonardo Uzcudun  wrote:

> Hello Adrian:
> 
> From the following site 
> (http://callcontrol.ag-projects.com/issues/1769#change-8449) i've found that 
> you say "All internals of CDRTool rely on the fact that there is a normalized 
> URI in the form of 00 + Country Code + Number."
> So, my question or doubt is:
> If there are 2 sip users within the same domain like use...@example.com and 
> use...@example.com, can i implement prepaid billing between them or the 
> prepaid will only work if they call to 00 + Country Code + Number sip 
> accounts?
> Thanks,
> 
> Leo
> Da: Adrian Georgescu 
> A: OpenSIPS users mailling list  
> Inviato: Lunedì 10 Giugno 2013 21:39
> Oggetto: Re: [OpenSIPS-Users] CDRTool - Callcontrol - Prepaid
> 
> There is Rating.txt document that contain sample rates files and examples of 
> prepaid queries in the console that shows you how it works. 
> 
> Adrian
> 
> 
> On Jun 10, 2013, at 9:30 PM, Leonardo Uzcudun wrote:
> 
>> Hello All:
>> 
>> After doing more tests i guess the problem is the missing DestId
>> cdrtool log:
>> Jun  8 02:51:12 sip cdrtool[13359]: MaxSessionTime=unlimited Type=prepaid 
>> CallId=1226626922 BillingParty=user01@mydomain DestId=None
>> 
>> and considering the rating.txt doc point 3. Determination of the costs -> No 
>> rate will be returned if no 'destination id' is found.
>> 
>> So, now my question is: If the Destination (cdrtool web portal -> Rating -> 
>> Destinations) must be a number (like 31 for the Netherlands), how will i 
>> match destination to mydomain?
>> 
>> Thanks,
>> 
>> Leo.
>> Da: leo 
>> A: users@lists.opensips.org 
>> Inviato: Venerdì 7 Giugno 2013 9:38
>> Oggetto: [OpenSIPS-Users] CDRTool - Callcontrol - Prepaid
>> 
>> Hello:
>> 
>> I need some help to understand the CDRTool - Callcontrol - Prepaid, all the
>> efforts i could do reading, searching and testing to try to understand how
>> it works were unsuccessful.
>> 
>> My set-up would be very simple, I would like to give credit (in seconds) to
>> the users and after the call is ended the call duration time should be
>> subtracted to its balance.
>> 
>> My first concern is how do i map a user in the opensips.subscriber
>> (DB.table) to the prepaid billing?
>> The second one would be, how would i configure the rating/quota/prepaid to
>> have my set-up?
>> 
>> Thanks for your help.
>> 
>> Leo.
>> 
>> 
>> 
>> --
>> View this message in context: 
>> http://opensips-open-sip-server.1449251.n2.nabble.com/CDRTool-Callcontrol-Prepaid-tp7586750.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
> 
> 
> ___
> 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] CDRTool - Callcontrol - Prepaid

[Leonardo Uzcudun]

Hello Adrian:

From the following site 
(http://callcontrol.ag-projects.com/issues/1769#change-8449) i've found that 
you say "All internals of CDRTool rely on the fact that there is a normalized 
URI in the form of 00 + Country Code  + Number."
So, my question or doubt is:
If there are 2 sip users within the same domain like use...@example.com and 
use...@example.com, can i implement prepaid billing between them or the prepaid 
will only work if they call to 00 + Country Code  + Number sip accounts?
Thanks,

Leo


 Da: Adrian Georgescu 
A: OpenSIPS users mailling list  
Inviato: Lunedì 10 Giugno 2013 21:39
Oggetto: Re: [OpenSIPS-Users] CDRTool - Callcontrol - Prepaid
 


There is Rating.txt document that contain sample rates files and examples of 
prepaid queries in the console that shows you how it works. 

Adrian




On Jun 10, 2013, at 9:30 PM, Leonardo Uzcudun wrote:

Hello All:
>
>
>
>After doing more tests i guess the problem is the missing DestId
>cdrtool log:Jun  8 02:51:12 sip cdrtool[13359]: MaxSessionTime=unlimited 
Type=prepaid CallId=1226626922 BillingParty=user01@mydomain DestId=None
>
>and considering the rating.txt doc point 3. Determination of the costs -> No 
>rate will be returned if no 'destination id' is found. 
>
>
>So, now my question is: If the Destination (cdrtool web portal -> Rating -> 
>Destinations) must be a number (like 31 for the Netherlands), how will i match 
>destination to mydomain?
>
>
>
Thanks,
>
>Leo.
>
>
> Da: leo 
>A: users@lists.opensips.org 
>Inviato: Venerdì 7 Giugno 2013 9:38
>Oggetto: [OpenSIPS-Users] CDRTool - Callcontrol - Prepaid
> 
>
>Hello:
>
>I need some help to understand the CDRTool - Callcontrol - Prepaid, all the
>efforts i could do reading, searching and testing to try to understand how
>it works were unsuccessful.
>
>My set-up would be very simple, I would like to give credit (in seconds) to
>the users and after the call is
 ended the call duration time should be
>subtracted to its balance.
>
>My first concern is how do i map a user in the opensips.subscriber
>(DB.table) to the prepaid billing?
>The second one would be, how would i configure the rating/quota/prepaid to
>have my set-up?
>
>Thanks for your help.
>
>Leo.
>
>
>
>--
>View this message in context: 
>http://opensips-open-sip-server.1449251.n2.nabble.com/CDRTool-Callcontrol-Prepaid-tp7586750.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
>

___
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] CDRTool - Callcontrol - Prepaid

[Leonardo Uzcudun]

Yes, i've read it (several times). I'm already testing connected to the cdrtool 
by telnet.
Anyway this is not helping me




 Da: Adrian Georgescu 
A: OpenSIPS users mailling list  
Inviato: Lunedì 10 Giugno 2013 21:39
Oggetto: Re: [OpenSIPS-Users] CDRTool - Callcontrol - Prepaid
 


There is Rating.txt document that contain sample rates files and examples of 
prepaid queries in the console that shows you how it works. 

Adrian




On Jun 10, 2013, at 9:30 PM, Leonardo Uzcudun wrote:

Hello All:
>
>
>
>After doing more tests i guess the problem is the missing DestId
>cdrtool log:Jun  8 02:51:12 sip cdrtool[13359]: MaxSessionTime=unlimited 
Type=prepaid CallId=1226626922 BillingParty=user01@mydomain DestId=None
>
>and considering the rating.txt doc point 3. Determination of the costs -> No 
>rate will be returned if no 'destination id' is found. 
>
>
>So, now my question is: If the Destination (cdrtool web portal -> Rating -> 
>Destinations) must be a number (like 31 for the Netherlands), how will i match 
>destination to mydomain?
>
>
>
Thanks,
>
>Leo.
>
>
> Da: leo 
>A: users@lists.opensips.org 
>Inviato: Venerdì 7 Giugno 2013 9:38
>Oggetto: [OpenSIPS-Users] CDRTool - Callcontrol - Prepaid
> 
>
>Hello:
>
>I need some help to understand the CDRTool - Callcontrol - Prepaid, all the
>efforts i could do reading, searching and testing to try to understand how
>it works were unsuccessful.
>
>My set-up would be very simple, I would like to give credit (in seconds) to
>the users and after the call is
 ended the call duration time should be
>subtracted to its balance.
>
>My first concern is how do i map a user in the opensips.subscriber
>(DB.table) to the prepaid billing?
>The second one would be, how would i configure the rating/quota/prepaid to
>have my set-up?
>
>Thanks for your help.
>
>Leo.
>
>
>
>--
>View this message in context: 
>http://opensips-open-sip-server.1449251.n2.nabble.com/CDRTool-Callcontrol-Prepaid-tp7586750.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
>

___
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] CDRTool - Callcontrol - Prepaid

[Adrian Georgescu]

There is Rating.txt document that contain sample rates files and examples of 
prepaid queries in the console that shows you how it works. 

Adrian


On Jun 10, 2013, at 9:30 PM, Leonardo Uzcudun wrote:

> Hello All:
> 
> After doing more tests i guess the problem is the missing DestId
> cdrtool log:
> Jun  8 02:51:12 sip cdrtool[13359]: MaxSessionTime=unlimited Type=prepaid 
> CallId=1226626922 BillingParty=user01@mydomain DestId=None
> 
> and considering the rating.txt doc point 3. Determination of the costs -> No 
> rate will be returned if no 'destination id' is found.
> 
> So, now my question is: If the Destination (cdrtool web portal -> Rating -> 
> Destinations) must be a number (like 31 for the Netherlands), how will i 
> match destination to mydomain?
> 
> Thanks,
> 
> Leo.
> Da: leo 
> A: users@lists.opensips.org 
> Inviato: Venerdì 7 Giugno 2013 9:38
> Oggetto: [OpenSIPS-Users] CDRTool - Callcontrol - Prepaid
> 
> Hello:
> 
> I need some help to understand the CDRTool - Callcontrol - Prepaid, all the
> efforts i could do reading, searching and testing to try to understand how
> it works were unsuccessful.
> 
> My set-up would be very simple, I would like to give credit (in seconds) to
> the users and after the call is ended the call duration time should be
> subtracted to its balance.
> 
> My first concern is how do i map a user in the opensips.subscriber
> (DB.table) to the prepaid billing?
> The second one would be, how would i configure the rating/quota/prepaid to
> have my set-up?
> 
> Thanks for your help.
> 
> Leo.
> 
> 
> 
> --
> View this message in context: 
> http://opensips-open-sip-server.1449251.n2.nabble.com/CDRTool-Callcontrol-Prepaid-tp7586750.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

___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

Re: [OpenSIPS-Users] CDRTool - Callcontrol - Prepaid

[Leonardo Uzcudun]

Hello All:


After doing more tests i guess the problem is the missing DestId
cdrtool log:Jun  8 02:51:12 sip cdrtool[13359]: MaxSessionTime=unlimited 
Type=prepaid CallId=1226626922 BillingParty=user01@mydomain DestId=None

and considering the rating.txt doc point 3. Determination of the costs -> No 
rate will be returned if no 'destination id' is found. 

So, now my question is: If the Destination (cdrtool web portal -> Rating -> 
Destinations) must be a number (like 31 for the Netherlands), how will i match 
destination to mydomain?

Thanks,

Leo.


 Da: leo 
A: users@lists.opensips.org 
Inviato: Venerdì 7 Giugno 2013 9:38
Oggetto: [OpenSIPS-Users] CDRTool - Callcontrol - Prepaid
 

Hello:

I need some help to understand the CDRTool - Callcontrol - Prepaid, all the
efforts i could do reading, searching and testing to try to understand how
it works were unsuccessful.

My set-up would be very simple, I would like to give credit (in seconds) to
the users and after the call is ended the call duration time should be
subtracted to its balance.

My first concern is how do i map a user in the opensips.subscriber
(DB.table) to the prepaid billing?
The second one would be, how would i configure the rating/quota/prepaid to
have my set-up?

Thanks for your help.

Leo.



--
View this message in context: 
http://opensips-open-sip-server.1449251.n2.nabble.com/CDRTool-Callcontrol-Prepaid-tp7586750.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] CDRTool - Callcontrol - Prepaid

[Leonardo Uzcudun]

Yes, the subscriber user01@mydomain (of course, mydomian is a valid domain) is 
in the cdrtool.prepaid. What do you mean with "You need to add the prepaid user 
and its balance to cdrtool prepaid table too" is there anywhere else that i 
should flag/mark the user as prepaid?

If you check the logs, the cdrtool is identifying it as prepaid (Type=prepaid):
Jun  8 02:51:12 sip cdrtool[13359]: MaxSessionTime Duration=36000 
CallId=1226626922 From=sip:user01@mydomain Gateway=X.X.X.X 
To=sip:user02@mydomain
Jun  8 02:51:12 sip cdrtool[13359]: MaxSessionTime=unlimited 
Type=prepaid CallId=1226626922 BillingParty=user01@mydomain DestId=None


I think the problem is that the cdrtool is answering MaxSessionTime=unlimited 
or DestId=None.
Thanks for your help,

Leo.




 Da: Adrian Georgescu 
A: OpenSIPS users mailling list  
Inviato: Lunedì 10 Giugno 2013 15:23
Oggetto: Re: [OpenSIPS-Users] CDRTool - Callcontrol - Prepaid
 


You need to add the prepaid user and its balance to cdrtool prepaid table too.

Adrian


On Jun 10, 2013, at 2:17 PM, Leonardo Uzcudun wrote:

Thanks Adrian for replying me but how do I enable it? The only note i've found 
in the cdrtool and callcontrol was to add the quote column to the 
opensips.subscriber (that i've already added it). Should i add another column?
>
>
>
>
>
>
>
> Da: Adrian Georgescu 
>A: Leonardo Uzcudun ; OpenSIPS users mailling list 
> 
>Inviato: Lunedì 10 Giugno 2013 13:45
>Oggetto: Re: [OpenSIPS-Users] CDRTool - Callcontrol - Prepaid
> 
>
>
>You must mark the user as prepaid in OpenSIPS subscribers table.
>
>
>Adrian
>
>
>
>On Jun 8, 2013, at 7:26 PM, Leonardo Uzcudun wrote:
>
>I guess, i've got some progress...but i can't understand why is not working.
>>Form the cdrtool logs i've:
>>
>>Jun  8 02:51:12 sip cdrtool[13359]: MaxSessionTime Duration=36000 
CallId=1226626922 From=sip:user01@mydomain Gateway=X.X.X.X 
To=sip:user02@mydomain
>>Jun  8 02:51:12 sip cdrtool[13359]: MaxSessionTime=unlimited 
Type=prepaid CallId=1226626922 BillingParty=user01@mydomain DestId=None
>>now cdrtool says: Type=prepaid
>>
>>but from the callcontrol:
>>Jun  8 02:51:12 sip call-control[29789]: Call id 1226626922 of 
>>user01@mydomainto sip:user02@mydomainis postpaid not limited
>>Why callcontrol has identified it as "postpaid not limited"?
>>
>>My configuration is for a sigle domain, no PSTN.
>>Thanks for your help if someone could
>>
>>
>>
>>
>>
>>
>> Da: leo 
>>A: users@lists.opensips.org 
>>Inviato: Venerdì 7 Giugno 2013 9:38
>>Oggetto: [OpenSIPS-Users] CDRTool - Callcontrol - Prepaid
>> 
>>
>>Hello:
>>
>>I need some help to understand the CDRTool - Callcontrol - Prepaid, all the
>>efforts i could do reading, searching and testing to try to understand how
>>it works were unsuccessful.
>>
>>My set-up would be very simple, I would like to give credit (in seconds) to
>>the users and after the call is ended the call duration time should be
>>subtracted to its balance.
>>
>>My first concern is how do i map a user in the opensips.subscriber
>>(DB.table) to the prepaid billing?
>>The second one would be, how would i configure the rating/quota/prepaid to
>>have my set-up?
>>
>>Thanks for your help.
>>
>>Leo.
>>
>>
>>
>>--
>>View this message in context: 
>>http://opensips-open-sip-server.1449251.n2.nabble.com/CDRTool-Callcontrol-Prepaid-tp7586750.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
>>
>
>
>___
>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] CDRTool - Callcontrol - Prepaid

[Adrian Georgescu]

You need to add the prepaid user and its balance to cdrtool prepaid table too.

Adrian

On Jun 10, 2013, at 2:17 PM, Leonardo Uzcudun wrote:

> Thanks Adrian for replying me but how do I enable it? The only note i've 
> found in the cdrtool and callcontrol was to add the quote column to the 
> opensips.subscriber (that i've already added it). Should i add another column?
> 
> 
> Da: Adrian Georgescu 
> A: Leonardo Uzcudun ; OpenSIPS users mailling list 
>  
> Inviato: Lunedì 10 Giugno 2013 13:45
> Oggetto: Re: [OpenSIPS-Users] CDRTool - Callcontrol - Prepaid
> 
> You must mark the user as prepaid in OpenSIPS subscribers table.
> 
> Adrian
> 
> On Jun 8, 2013, at 7:26 PM, Leonardo Uzcudun wrote:
> 
>> I guess, i've got some progress...but i can't understand why is not working.
>> Form the cdrtool logs i've:
>> 
>> Jun  8 02:51:12 sip cdrtool[13359]: MaxSessionTime Duration=36000 
>> CallId=1226626922 From=sip:user01@mydomain Gateway=X.X.X.X 
>> To=sip:user02@mydomain
>> Jun  8 02:51:12 sip cdrtool[13359]: MaxSessionTime=unlimited Type=prepaid 
>> CallId=1226626922 BillingParty=user01@mydomain DestId=None
>> now cdrtool says: Type=prepaid
>> 
>> but from the callcontrol:
>> Jun  8 02:51:12 sip call-control[29789]: Call id 1226626922 of 
>> user01@mydomain to sip:user02@mydomain is postpaid not limited
>> Why callcontrol has identified it as "postpaid not limited"?
>> 
>> My configuration is for a sigle domain, no PSTN.
>> Thanks for your help if someone could
>> 
>> 
>> Da: leo 
>> A: users@lists.opensips.org 
>> Inviato: Venerdì 7 Giugno 2013 9:38
>> Oggetto: [OpenSIPS-Users] CDRTool - Callcontrol - Prepaid
>> 
>> Hello:
>> 
>> I need some help to understand the CDRTool - Callcontrol - Prepaid, all the
>> efforts i could do reading, searching and testing to try to understand how
>> it works were unsuccessful.
>> 
>> My set-up would be very simple, I would like to give credit (in seconds) to
>> the users and after the call is ended the call duration time should be
>> subtracted to its balance.
>> 
>> My first concern is how do i map a user in the opensips.subscriber
>> (DB.table) to the prepaid billing?
>> The second one would be, how would i configure the rating/quota/prepaid to
>> have my set-up?
>> 
>> Thanks for your help.
>> 
>> Leo.
>> 
>> 
>> 
>> --
>> View this message in context: 
>> http://opensips-open-sip-server.1449251.n2.nabble.com/CDRTool-Callcontrol-Prepaid-tp7586750.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
> 
> 
> 
> ___
> 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] CDRTool - Callcontrol - Prepaid

[Leonardo Uzcudun]

Thanks Adrian for replying me but how do I enable it? The only note i've found 
in the cdrtool and callcontrol was to add the quote column to the 
opensips.subscriber (that i've already added it). Should i add another column?





 Da: Adrian Georgescu 
A: Leonardo Uzcudun ; OpenSIPS users mailling list 
 
Inviato: Lunedì 10 Giugno 2013 13:45
Oggetto: Re: [OpenSIPS-Users] CDRTool - Callcontrol - Prepaid
 


You must mark the user as prepaid in OpenSIPS subscribers table.

Adrian



On Jun 8, 2013, at 7:26 PM, Leonardo Uzcudun wrote:

I guess, i've got some progress...but i can't understand why is not working.
>Form the cdrtool logs i've:
>
>Jun  8 02:51:12 sip cdrtool[13359]: MaxSessionTime Duration=36000 
CallId=1226626922 From=sip:user01@mydomain Gateway=X.X.X.X 
To=sip:user02@mydomain
>Jun  8 02:51:12 sip cdrtool[13359]: MaxSessionTime=unlimited 
Type=prepaid CallId=1226626922 BillingParty=user01@mydomain DestId=None
>now cdrtool says: Type=prepaid
>
>but from the callcontrol:
>Jun  8 02:51:12 sip call-control[29789]: Call id 1226626922 of 
>user01@mydomainto sip:user02@mydomainis postpaid not limited
>Why callcontrol has identified it as "postpaid not limited"?
>
>My configuration is for a sigle domain, no PSTN.
>Thanks for your help if someone could
>
>
>
>
>
>____
> Da: leo 
>A: users@lists.opensips.org 
>Inviato: Venerdì 7 Giugno 2013 9:38
>Oggetto: [OpenSIPS-Users] CDRTool - Callcontrol - Prepaid
> 
>
>Hello:
>
>I need some help to understand the CDRTool - Callcontrol - Prepaid, all the
>efforts i could do reading, searching and testing to try to understand how
>it works were unsuccessful.
>
>My set-up would be very simple, I would like to give credit (in seconds) to
>the users and after the call is ended the call duration time should be
>subtracted to its balance.
>
>My first concern is how do i map a user in the opensips.subscriber
>(DB.table) to the prepaid billing?
>The second one would be, how would i configure the rating/quota/prepaid to
>have my set-up?
>
>Thanks for your help.
>
>Leo.
>
>
>
>--
>View this message in context: 
>http://opensips-open-sip-server.1449251.n2.nabble.com/CDRTool-Callcontrol-Prepaid-tp7586750.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
>___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

Re: [OpenSIPS-Users] CDRTool - Callcontrol - Prepaid

[Adrian Georgescu]

You must mark the user as prepaid in OpenSIPS subscribers table.

Adrian

On Jun 8, 2013, at 7:26 PM, Leonardo Uzcudun wrote:

> I guess, i've got some progress...but i can't understand why is not working.
> Form the cdrtool logs i've:
> 
> Jun  8 02:51:12 sip cdrtool[13359]: MaxSessionTime Duration=36000 
> CallId=1226626922 From=sip:user01@mydomain Gateway=X.X.X.X 
> To=sip:user02@mydomain
> Jun  8 02:51:12 sip cdrtool[13359]: MaxSessionTime=unlimited Type=prepaid 
> CallId=1226626922 BillingParty=user01@mydomain DestId=None
> now cdrtool says: Type=prepaid
> 
> but from the callcontrol:
> Jun  8 02:51:12 sip call-control[29789]: Call id 1226626922 of 
> user01@mydomain to sip:user02@mydomain is postpaid not limited
> Why callcontrol has identified it as "postpaid not limited"?
> 
> My configuration is for a sigle domain, no PSTN.
> Thanks for your help if someone could
> 
> 
> Da: leo 
> A: users@lists.opensips.org 
> Inviato: Venerdì 7 Giugno 2013 9:38
> Oggetto: [OpenSIPS-Users] CDRTool - Callcontrol - Prepaid
> 
> Hello:
> 
> I need some help to understand the CDRTool - Callcontrol - Prepaid, all the
> efforts i could do reading, searching and testing to try to understand how
> it works were unsuccessful.
> 
> My set-up would be very simple, I would like to give credit (in seconds) to
> the users and after the call is ended the call duration time should be
> subtracted to its balance.
> 
> My first concern is how do i map a user in the opensips.subscriber
> (DB.table) to the prepaid billing?
> The second one would be, how would i configure the rating/quota/prepaid to
> have my set-up?
> 
> Thanks for your help.
> 
> Leo.
> 
> 
> 
> --
> View this message in context: 
> http://opensips-open-sip-server.1449251.n2.nabble.com/CDRTool-Callcontrol-Prepaid-tp7586750.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

___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

Re: [OpenSIPS-Users] CDRTool - Callcontrol - Prepaid

[Leonardo Uzcudun]

I guess, i've got some progress...but i can't understand why is not working.
Form the cdrtool logs i've:

Jun  8 02:51:12 sip cdrtool[13359]: MaxSessionTime Duration=36000 
CallId=1226626922 From=sip:user01@mydomain Gateway=X.X.X.X 
To=sip:user02@mydomain
Jun  8 02:51:12 sip cdrtool[13359]: MaxSessionTime=unlimited 
Type=prepaid CallId=1226626922 BillingParty=user01@mydomain DestId=None
now cdrtool says: Type=prepaid

but from the callcontrol:
Jun  8 02:51:12 sip call-control[29789]: Call id 1226626922 of 
user01@mydomainto sip:user02@mydomainis postpaid not limited
Why callcontrol has identified it as "postpaid not limited"?

My configuration is for a sigle domain, no PSTN.
Thanks for your help if someone could





 Da: leo 
A: users@lists.opensips.org 
Inviato: Venerdì 7 Giugno 2013 9:38
Oggetto: [OpenSIPS-Users] CDRTool - Callcontrol - Prepaid
 

Hello:

I need some help to understand the CDRTool - Callcontrol - Prepaid, all the
efforts i could do reading, searching and testing to try to understand how
it works were unsuccessful.

My set-up would be very simple, I would like to give credit (in seconds) to
the users and after the call is ended the call duration time should be
subtracted to its balance.

My first concern is how do i map a user in the opensips.subscriber
(DB.table) to the prepaid billing?
The second one would be, how would i configure the rating/quota/prepaid to
have my set-up?

Thanks for your help.

Leo.



--
View this message in context: 
http://opensips-open-sip-server.1449251.n2.nabble.com/CDRTool-Callcontrol-Prepaid-tp7586750.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] CDRTool - Callcontrol - Prepaid

[Leonardo Uzcudun]

Thanks for the advice Stefano but i'd like to understand how the things works 
and do them by myself.
Of course, if it would exist any training about CDRTool/Callcontrol for sure i 
would participate.




 Da: Stefano Pisani 
A: users@lists.opensips.org 
Inviato: Venerdì 7 Giugno 2013 10:32
Oggetto: Re: [OpenSIPS-Users] CDRTool - Callcontrol - Prepaid
 

What about to buy professional support?

Il 07/06/2013 09.38, leo ha scritto:
> Hello:
>
> I need some help to understand the CDRTool - Callcontrol - Prepaid, all the
> efforts i could do reading, searching and testing to try to understand how
> it works were unsuccessful.
>
> My set-up would be very simple, I would like to give credit (in seconds) to
> the users and after the call is ended the call duration time should be
> subtracted to its balance.
>
> My first concern is how do i map a user in the opensips.subscriber
> (DB.table) to the prepaid billing?
> The second one would be, how would i configure the rating/quota/prepaid to
> have my set-up?
>
> Thanks for your help.
>
> Leo.
>
>
>
> --
> View this message in context: 
> http://opensips-open-sip-server.1449251.n2.nabble.com/CDRTool-Callcontrol-Prepaid-tp7586750.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___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

Re: [OpenSIPS-Users] cdrtool

[Adrian Georgescu]

It is not possible.

Adrian

On May 28, 2013, at 1:00 PM, dotnetdub wrote:

> Hi Guys,
> 
> Is it possible to do quota by domain rather than user?
> 
> Thanks
> Brian
> ___
> 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