Hi,
How to deduct the call cost or credits for the subscribers with the cnxcc module?
Input Please
Thanks & Kind Regards, Logeshwaran G
Hi, cnxcc doesn't provide this feature. Is not aware of any backend, it just controls subscriber's balance, money or time, as instructed. You can calculate the amount to be deducted after the call ends (if you're doing money based accounting) using dlg variables to store the needed information (start_time, end_time, cost per second) and then updating the balance via sqlops module's functions.
Cheers,
Federico
On Wed, Aug 23, 2017 at 7:50 AM, Logeshwaran G logeshwarangs@gmail.com wrote:
Hi,
How to deduct the call cost or credits for the subscribers with the cnxcc module?
Input Please
Thanks & Kind Regards, Logeshwaran G
Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
Thanks For your Input Federico, Will try it .
Thanks & Kind Regards, Logeshwaran G
On Wed, Aug 23, 2017 at 5:45 PM, Federico Cabiddu < federico.cabiddu@gmail.com> wrote:
Hi, cnxcc doesn't provide this feature. Is not aware of any backend, it just controls subscriber's balance, money or time, as instructed. You can calculate the amount to be deducted after the call ends (if you're doing money based accounting) using dlg variables to store the needed information (start_time, end_time, cost per second) and then updating the balance via sqlops module's functions.
Cheers,
Federico
On Wed, Aug 23, 2017 at 7:50 AM, Logeshwaran G logeshwarangs@gmail.com wrote:
Hi,
How to deduct the call cost or credits for the subscribers with the cnxcc module?
Input Please
Thanks & Kind Regards, Logeshwaran G
Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
Hi,
Is this the correct way of using the CNXCC for cost deduction, Guide me please.
route[CNXCC] { $var(customer) = $fU; $var(cps) = "1.00"; # cost per second $var(initial_p) = "1"; # intial pulse $var(final_p) = "1"; #Final_pulse $var(minbal) = 1; $var(ret) = avp_db_query("SELECT credits FROM subscriber where username='$fU'", "$avp(s:credits)"); xlog("L_WARN", "CNXCC: var(ret)=$var(ret) avp(s:credits)=$avp(s:credits)\n"); cnxcc_set_max_credit("$var(customer)", "$avp(s:credits)", "$var(cps)", "$var(initial_p)", "$var(final_p)"); if ($avp(s:credits)< $var(minbal)){ xlog("L_ALERT", "ALERT: Credit balance is low, sent 403:Forbidden. required=$var(minbal)\n"); sl_send_reply("403", "Forbidden: Low balance"); drop;
} }
Thanks & Kind Regards, Logeshwaran G
On Fri, Aug 25, 2017 at 11:14 AM, Logeshwaran G logeshwarangs@gmail.com wrote:
Thanks For your Input Federico, Will try it .
Thanks & Kind Regards, Logeshwaran G
On Wed, Aug 23, 2017 at 5:45 PM, Federico Cabiddu < federico.cabiddu@gmail.com> wrote:
Hi, cnxcc doesn't provide this feature. Is not aware of any backend, it just controls subscriber's balance, money or time, as instructed. You can calculate the amount to be deducted after the call ends (if you're doing money based accounting) using dlg variables to store the needed information (start_time, end_time, cost per second) and then updating the balance via sqlops module's functions.
Cheers,
Federico
On Wed, Aug 23, 2017 at 7:50 AM, Logeshwaran G logeshwarangs@gmail.com wrote:
Hi,
How to deduct the call cost or credits for the subscribers with the cnxcc module?
Input Please
Thanks & Kind Regards, Logeshwaran G
Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
Hi, yes it's correct, but if you want to deduct the cost at the end of the call you should use dlg_var to store cps etc.
Regards,
Federico
On Wed, Aug 30, 2017 at 7:16 AM, Logeshwaran G logeshwarangs@gmail.com wrote:
Hi,
Is this the correct way of using the CNXCC for cost deduction, Guide me please.
route[CNXCC] { $var(customer) = $fU; $var(cps) = "1.00"; # cost per second $var(initial_p) = "1"; # intial pulse $var(final_p) = "1"; #Final_pulse $var(minbal) = 1; $var(ret) = avp_db_query("SELECT credits FROM subscriber where username='$fU'", "$avp(s:credits)"); xlog("L_WARN", "CNXCC: var(ret)=$var(ret) avp(s:credits)=$avp(s:credits)\n"); cnxcc_set_max_credit("$var(customer)", "$avp(s:credits)", "$var(cps)", "$var(initial_p)", "$var(final_p)"); if ($avp(s:credits)< $var(minbal)){ xlog("L_ALERT", "ALERT: Credit balance is low, sent 403:Forbidden. required=$var(minbal)\n"); sl_send_reply("403", "Forbidden: Low balance"); drop;
}}
Thanks & Kind Regards, Logeshwaran G
On Fri, Aug 25, 2017 at 11:14 AM, Logeshwaran G logeshwarangs@gmail.com wrote:
Thanks For your Input Federico, Will try it .
Thanks & Kind Regards, Logeshwaran G
On Wed, Aug 23, 2017 at 5:45 PM, Federico Cabiddu < federico.cabiddu@gmail.com> wrote:
Hi, cnxcc doesn't provide this feature. Is not aware of any backend, it just controls subscriber's balance, money or time, as instructed. You can calculate the amount to be deducted after the call ends (if you're doing money based accounting) using dlg variables to store the needed information (start_time, end_time, cost per second) and then updating the balance via sqlops module's functions.
Cheers,
Federico
On Wed, Aug 23, 2017 at 7:50 AM, Logeshwaran G logeshwarangs@gmail.com wrote:
Hi,
How to deduct the call cost or credits for the subscribers with the cnxcc module?
Input Please
Thanks & Kind Regards, Logeshwaran G
Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
Thanks Federico! Will try it out.
Thanks & Kind Regards, Logeshwaran G
On Wed, Aug 30, 2017 at 11:34 AM, Federico Cabiddu < federico.cabiddu@gmail.com> wrote:
Hi, yes it's correct, but if you want to deduct the cost at the end of the call you should use dlg_var to store cps etc.
Regards,
Federico
On Wed, Aug 30, 2017 at 7:16 AM, Logeshwaran G logeshwarangs@gmail.com wrote:
Hi,
Is this the correct way of using the CNXCC for cost deduction, Guide me please.
route[CNXCC] { $var(customer) = $fU; $var(cps) = "1.00"; # cost per second $var(initial_p) = "1"; # intial pulse $var(final_p) = "1"; #Final_pulse $var(minbal) = 1; $var(ret) = avp_db_query("SELECT credits FROM subscriber where username='$fU'", "$avp(s:credits)"); xlog("L_WARN", "CNXCC: var(ret)=$var(ret) avp(s:credits)=$avp(s:credits)\n"); cnxcc_set_max_credit("$var(customer)", "$avp(s:credits)", "$var(cps)", "$var(initial_p)", "$var(final_p)"); if ($avp(s:credits)< $var(minbal)){ xlog("L_ALERT", "ALERT: Credit balance is low, sent 403:Forbidden. required=$var(minbal)\n"); sl_send_reply("403", "Forbidden: Low balance"); drop;
}}
Thanks & Kind Regards, Logeshwaran G
On Fri, Aug 25, 2017 at 11:14 AM, Logeshwaran G logeshwarangs@gmail.com wrote:
Thanks For your Input Federico, Will try it .
Thanks & Kind Regards, Logeshwaran G
On Wed, Aug 23, 2017 at 5:45 PM, Federico Cabiddu < federico.cabiddu@gmail.com> wrote:
Hi, cnxcc doesn't provide this feature. Is not aware of any backend, it just controls subscriber's balance, money or time, as instructed. You can calculate the amount to be deducted after the call ends (if you're doing money based accounting) using dlg variables to store the needed information (start_time, end_time, cost per second) and then updating the balance via sqlops module's functions.
Cheers,
Federico
On Wed, Aug 23, 2017 at 7:50 AM, Logeshwaran G <logeshwarangs@gmail.com
wrote:
Hi,
How to deduct the call cost or credits for the subscribers with the cnxcc module?
Input Please
Thanks & Kind Regards, Logeshwaran G
Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
This might help you. https://github.com/caruizdiaz/cnxcc-example?files=1
On 30 Aug 2017 11:09 am, "Logeshwaran G" logeshwarangs@gmail.com wrote:
Thanks Federico! Will try it out.
Thanks & Kind Regards, Logeshwaran G
On Wed, Aug 30, 2017 at 11:34 AM, Federico Cabiddu < federico.cabiddu@gmail.com> wrote:
Hi, yes it's correct, but if you want to deduct the cost at the end of the call you should use dlg_var to store cps etc.
Regards,
Federico
On Wed, Aug 30, 2017 at 7:16 AM, Logeshwaran G logeshwarangs@gmail.com wrote:
Hi,
Is this the correct way of using the CNXCC for cost deduction, Guide me please.
route[CNXCC] { $var(customer) = $fU; $var(cps) = "1.00"; # cost per second $var(initial_p) = "1"; # intial pulse $var(final_p) = "1"; #Final_pulse $var(minbal) = 1; $var(ret) = avp_db_query("SELECT credits FROM subscriber where username='$fU'", "$avp(s:credits)"); xlog("L_WARN", "CNXCC: var(ret)=$var(ret) avp(s:credits)=$avp(s:credits)\n"); cnxcc_set_max_credit("$var(customer)", "$avp(s:credits)", "$var(cps)", "$var(initial_p)", "$var(final_p)"); if ($avp(s:credits)< $var(minbal)){ xlog("L_ALERT", "ALERT: Credit balance is low, sent 403:Forbidden. required=$var(minbal)\n"); sl_send_reply("403", "Forbidden: Low balance"); drop;
}}
Thanks & Kind Regards, Logeshwaran G
On Fri, Aug 25, 2017 at 11:14 AM, Logeshwaran G <logeshwarangs@gmail.com
wrote:
Thanks For your Input Federico, Will try it .
Thanks & Kind Regards, Logeshwaran G
On Wed, Aug 23, 2017 at 5:45 PM, Federico Cabiddu < federico.cabiddu@gmail.com> wrote:
Hi, cnxcc doesn't provide this feature. Is not aware of any backend, it just controls subscriber's balance, money or time, as instructed. You can calculate the amount to be deducted after the call ends (if you're doing money based accounting) using dlg variables to store the needed information (start_time, end_time, cost per second) and then updating the balance via sqlops module's functions.
Cheers,
Federico
On Wed, Aug 23, 2017 at 7:50 AM, Logeshwaran G < logeshwarangs@gmail.com> wrote:
Hi,
How to deduct the call cost or credits for the subscribers with the cnxcc module?
Input Please
Thanks & Kind Regards, Logeshwaran G
Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
Thank You
Thanks & Kind Regards, Logeshwaran G
On Wed, Aug 30, 2017 at 11:40 AM, Aqs Younas aqsyounas@gmail.com wrote:
This might help you. https://github.com/caruizdiaz/cnxcc-example?files=1
On 30 Aug 2017 11:09 am, "Logeshwaran G" logeshwarangs@gmail.com wrote:
Thanks Federico! Will try it out.
Thanks & Kind Regards, Logeshwaran G
On Wed, Aug 30, 2017 at 11:34 AM, Federico Cabiddu < federico.cabiddu@gmail.com> wrote:
Hi, yes it's correct, but if you want to deduct the cost at the end of the call you should use dlg_var to store cps etc.
Regards,
Federico
On Wed, Aug 30, 2017 at 7:16 AM, Logeshwaran G logeshwarangs@gmail.com wrote:
Hi,
Is this the correct way of using the CNXCC for cost deduction, Guide me please.
route[CNXCC] { $var(customer) = $fU; $var(cps) = "1.00"; # cost per second $var(initial_p) = "1"; # intial pulse $var(final_p) = "1"; #Final_pulse $var(minbal) = 1; $var(ret) = avp_db_query("SELECT credits FROM subscriber where username='$fU'", "$avp(s:credits)"); xlog("L_WARN", "CNXCC: var(ret)=$var(ret) avp(s:credits)=$avp(s:credits)\n"); cnxcc_set_max_credit("$var(customer)", "$avp(s:credits)", "$var(cps)", "$var(initial_p)", "$var(final_p)"); if ($avp(s:credits)< $var(minbal)){ xlog("L_ALERT", "ALERT: Credit balance is low, sent 403:Forbidden. required=$var(minbal)\n"); sl_send_reply("403", "Forbidden: Low balance"); drop;
}}
Thanks & Kind Regards, Logeshwaran G
On Fri, Aug 25, 2017 at 11:14 AM, Logeshwaran G < logeshwarangs@gmail.com> wrote:
Thanks For your Input Federico, Will try it .
Thanks & Kind Regards, Logeshwaran G
On Wed, Aug 23, 2017 at 5:45 PM, Federico Cabiddu < federico.cabiddu@gmail.com> wrote:
Hi, cnxcc doesn't provide this feature. Is not aware of any backend, it just controls subscriber's balance, money or time, as instructed. You can calculate the amount to be deducted after the call ends (if you're doing money based accounting) using dlg variables to store the needed information (start_time, end_time, cost per second) and then updating the balance via sqlops module's functions.
Cheers,
Federico
On Wed, Aug 23, 2017 at 7:50 AM, Logeshwaran G < logeshwarangs@gmail.com> wrote:
> Hi, > > How to deduct the call cost or credits for the subscribers with the > cnxcc module? > > Input Please > > > Thanks & Kind Regards, > Logeshwaran G > > _______________________________________________ > Kamailio (SER) - Users Mailing List > sr-users@lists.kamailio.org > https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users > >
Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
Hi,
I am using the below scenario : but there is no cost deduction happening , Correct me if I am wrong.
route[CNXCC] { $dlg_var(subscriber) = $fU; $dlg_var(customer_id) = "customer-" + $fU; $dlg_var(initial_p) = "1"; $dlg_var(final_p) = "1"; $dlg_var(cps) = "1"; ; $var(minbal) = 1; $var(ret) = avp_db_query("SELECT credits FROM subscriber where username='$fU'", "$avp(s:credits)"); xlog("L_WARN", "CNXCC: var(ret)=$var(ret) avp(s:credits)=$avp(s:credits)\n"); #if(!cnxcc_set_max_credit("$var(customer)", "$avp(s:credits)", "$var(cps)", "$var(initial_p)", "$var(final_p)")) if(!cnxcc_set_max_credit("$dlg_var(subscriber)", "$avp(s:credits)", "$dlg_var(cps)", "$dlg_var(initial_p)", "$dlg_var(final_p)")) { xlog("Error setting up credit control"); sl_reply_error(); exit;
} if ($avp(s:credits)< $var(minbal)){ xlog("L_ALERT", "ALERT: Credit balance is low, sent 403:Forbidden. required=$var(minbal)\n"); sl_send_reply("403", "Forbidden: Low balance"); drop;
} }
event_route[cnxcc:call-shutdown] { xlog("L_ALERT", "event_route:cnxcc: [$ci]: call killed");
# perform some kind of notification, database update, email sending, etc. }
Thanks & Kind Regards, Logeshwaran G
On Wed, Aug 30, 2017 at 11:40 AM, Aqs Younas aqsyounas@gmail.com wrote:
This might help you. https://github.com/caruizdiaz/cnxcc-example?files=1
On 30 Aug 2017 11:09 am, "Logeshwaran G" logeshwarangs@gmail.com wrote:
Thanks Federico! Will try it out.
Thanks & Kind Regards, Logeshwaran G
On Wed, Aug 30, 2017 at 11:34 AM, Federico Cabiddu < federico.cabiddu@gmail.com> wrote:
Hi, yes it's correct, but if you want to deduct the cost at the end of the call you should use dlg_var to store cps etc.
Regards,
Federico
On Wed, Aug 30, 2017 at 7:16 AM, Logeshwaran G logeshwarangs@gmail.com wrote:
Hi,
Is this the correct way of using the CNXCC for cost deduction, Guide me please.
route[CNXCC] { $var(customer) = $fU; $var(cps) = "1.00"; # cost per second $var(initial_p) = "1"; # intial pulse $var(final_p) = "1"; #Final_pulse $var(minbal) = 1; $var(ret) = avp_db_query("SELECT credits FROM subscriber where username='$fU'", "$avp(s:credits)"); xlog("L_WARN", "CNXCC: var(ret)=$var(ret) avp(s:credits)=$avp(s:credits)\n"); cnxcc_set_max_credit("$var(customer)", "$avp(s:credits)", "$var(cps)", "$var(initial_p)", "$var(final_p)"); if ($avp(s:credits)< $var(minbal)){ xlog("L_ALERT", "ALERT: Credit balance is low, sent 403:Forbidden. required=$var(minbal)\n"); sl_send_reply("403", "Forbidden: Low balance"); drop;
}}
Thanks & Kind Regards, Logeshwaran G
On Fri, Aug 25, 2017 at 11:14 AM, Logeshwaran G < logeshwarangs@gmail.com> wrote:
Thanks For your Input Federico, Will try it .
Thanks & Kind Regards, Logeshwaran G
On Wed, Aug 23, 2017 at 5:45 PM, Federico Cabiddu < federico.cabiddu@gmail.com> wrote:
Hi, cnxcc doesn't provide this feature. Is not aware of any backend, it just controls subscriber's balance, money or time, as instructed. You can calculate the amount to be deducted after the call ends (if you're doing money based accounting) using dlg variables to store the needed information (start_time, end_time, cost per second) and then updating the balance via sqlops module's functions.
Cheers,
Federico
On Wed, Aug 23, 2017 at 7:50 AM, Logeshwaran G < logeshwarangs@gmail.com> wrote:
> Hi, > > How to deduct the call cost or credits for the subscribers with the > cnxcc module? > > Input Please > > > Thanks & Kind Regards, > Logeshwaran G > > _______________________________________________ > Kamailio (SER) - Users Mailing List > sr-users@lists.kamailio.org > https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users > >
Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
Hi, did you read this comment in the event_route?
# perform some kind of notification, database update, email sending, etc.
Have you put any logic to do the accounting there (as I suggested)?
Regards,
Federico
On Wed, Aug 30, 2017 at 9:50 AM, Logeshwaran G logeshwarangs@gmail.com wrote:
Hi,
I am using the below scenario : but there is no cost deduction happening , Correct me if I am wrong.
route[CNXCC] { $dlg_var(subscriber) = $fU; $dlg_var(customer_id) = "customer-" + $fU; $dlg_var(initial_p) = "1"; $dlg_var(final_p) = "1"; $dlg_var(cps) = "1"; ; $var(minbal) = 1; $var(ret) = avp_db_query("SELECT credits FROM subscriber where username='$fU'", "$avp(s:credits)"); xlog("L_WARN", "CNXCC: var(ret)=$var(ret) avp(s:credits)=$avp(s:credits)\n"); #if(!cnxcc_set_max_credit("$var(customer)", "$avp(s:credits)", "$var(cps)", "$var(initial_p)", "$var(final_p)")) if(!cnxcc_set_max_credit("$dlg_var(subscriber)", "$avp(s:credits)", "$dlg_var(cps)", "$dlg_var(initial_p)", "$dlg_var(final_p)")) { xlog("Error setting up credit control"); sl_reply_error(); exit;
} if ($avp(s:credits)< $var(minbal)){ xlog("L_ALERT", "ALERT: Credit balance is low, sent403:Forbidden. required=$var(minbal)\n"); sl_send_reply("403", "Forbidden: Low balance"); drop;
}}
event_route[cnxcc:call-shutdown] { xlog("L_ALERT", "event_route:cnxcc: [$ci]: call killed");
# perform some kind of notification, database update, emailsending, etc. }
Thanks & Kind Regards, Logeshwaran G
On Wed, Aug 30, 2017 at 11:40 AM, Aqs Younas aqsyounas@gmail.com wrote:
This might help you. https://github.com/caruizdiaz/cnxcc-example?files=1
On 30 Aug 2017 11:09 am, "Logeshwaran G" logeshwarangs@gmail.com wrote:
Thanks Federico! Will try it out.
Thanks & Kind Regards, Logeshwaran G
On Wed, Aug 30, 2017 at 11:34 AM, Federico Cabiddu < federico.cabiddu@gmail.com> wrote:
Hi, yes it's correct, but if you want to deduct the cost at the end of the call you should use dlg_var to store cps etc.
Regards,
Federico
On Wed, Aug 30, 2017 at 7:16 AM, Logeshwaran G <logeshwarangs@gmail.com
wrote:
Hi,
Is this the correct way of using the CNXCC for cost deduction, Guide me please.
route[CNXCC] { $var(customer) = $fU; $var(cps) = "1.00"; # cost per second $var(initial_p) = "1"; # intial pulse $var(final_p) = "1"; #Final_pulse $var(minbal) = 1; $var(ret) = avp_db_query("SELECT credits FROM subscriber where username='$fU'", "$avp(s:credits)"); xlog("L_WARN", "CNXCC: var(ret)=$var(ret) avp(s:credits)=$avp(s:credits)\n"); cnxcc_set_max_credit("$var(customer)", "$avp(s:credits)", "$var(cps)", "$var(initial_p)", "$var(final_p)"); if ($avp(s:credits)< $var(minbal)){ xlog("L_ALERT", "ALERT: Credit balance is low, sent 403:Forbidden. required=$var(minbal)\n"); sl_send_reply("403", "Forbidden: Low balance"); drop;
}}
Thanks & Kind Regards, Logeshwaran G
On Fri, Aug 25, 2017 at 11:14 AM, Logeshwaran G < logeshwarangs@gmail.com> wrote:
Thanks For your Input Federico, Will try it .
Thanks & Kind Regards, Logeshwaran G
On Wed, Aug 23, 2017 at 5:45 PM, Federico Cabiddu < federico.cabiddu@gmail.com> wrote:
> Hi, > cnxcc doesn't provide this feature. Is not aware of any backend, it > just controls subscriber's balance, money or time, as instructed. > You can calculate the amount to be deducted after the call ends (if > you're doing money based accounting) using dlg variables to store the > needed information (start_time, end_time, cost per second) and then > updating the balance via sqlops module's functions. > > Cheers, > > Federico > > On Wed, Aug 23, 2017 at 7:50 AM, Logeshwaran G < > logeshwarangs@gmail.com> wrote: > >> Hi, >> >> How to deduct the call cost or credits for the subscribers with the >> cnxcc module? >> >> Input Please >> >> >> Thanks & Kind Regards, >> Logeshwaran G >> >> _______________________________________________ >> Kamailio (SER) - Users Mailing List >> sr-users@lists.kamailio.org >> https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users >> >> > > _______________________________________________ > Kamailio (SER) - Users Mailing List > sr-users@lists.kamailio.org > https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users > >
Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
As per your Input I have changed the Variables to dialog variables, But I dont know what to add in event route.
Thanks & Kind Regards, Logeshwaran G
On Wed, Aug 30, 2017 at 2:00 PM, Federico Cabiddu < federico.cabiddu@gmail.com> wrote:
Hi, did you read this comment in the event_route?
# perform some kind of notification, database update, email sending, etc.
Have you put any logic to do the accounting there (as I suggested)?
Regards,
Federico
On Wed, Aug 30, 2017 at 9:50 AM, Logeshwaran G logeshwarangs@gmail.com wrote:
Hi,
I am using the below scenario : but there is no cost deduction happening , Correct me if I am wrong.
route[CNXCC] { $dlg_var(subscriber) = $fU; $dlg_var(customer_id) = "customer-" + $fU; $dlg_var(initial_p) = "1"; $dlg_var(final_p) = "1"; $dlg_var(cps) = "1"; ; $var(minbal) = 1; $var(ret) = avp_db_query("SELECT credits FROM subscriber where username='$fU'", "$avp(s:credits)"); xlog("L_WARN", "CNXCC: var(ret)=$var(ret) avp(s:credits)=$avp(s:credits)\n"); #if(!cnxcc_set_max_credit("$var(customer)", "$avp(s:credits)", "$var(cps)", "$var(initial_p)", "$var(final_p)")) if(!cnxcc_set_max_credit("$dlg_var(subscriber)", "$avp(s:credits)", "$dlg_var(cps)", "$dlg_var(initial_p)", "$dlg_var(final_p)")) { xlog("Error setting up credit control"); sl_reply_error(); exit;
} if ($avp(s:credits)< $var(minbal)){ xlog("L_ALERT", "ALERT: Credit balance is low, sent403:Forbidden. required=$var(minbal)\n"); sl_send_reply("403", "Forbidden: Low balance"); drop;
}}
event_route[cnxcc:call-shutdown] { xlog("L_ALERT", "event_route:cnxcc: [$ci]: call killed");
# perform some kind of notification, database update, emailsending, etc. }
Thanks & Kind Regards, Logeshwaran G
On Wed, Aug 30, 2017 at 11:40 AM, Aqs Younas aqsyounas@gmail.com wrote:
This might help you. https://github.com/caruizdiaz/cnxcc-example?files=1
On 30 Aug 2017 11:09 am, "Logeshwaran G" logeshwarangs@gmail.com wrote:
Thanks Federico! Will try it out.
Thanks & Kind Regards, Logeshwaran G
On Wed, Aug 30, 2017 at 11:34 AM, Federico Cabiddu < federico.cabiddu@gmail.com> wrote:
Hi, yes it's correct, but if you want to deduct the cost at the end of the call you should use dlg_var to store cps etc.
Regards,
Federico
On Wed, Aug 30, 2017 at 7:16 AM, Logeshwaran G < logeshwarangs@gmail.com> wrote:
Hi,
Is this the correct way of using the CNXCC for cost deduction, Guide me please.
route[CNXCC] { $var(customer) = $fU; $var(cps) = "1.00"; # cost per second $var(initial_p) = "1"; # intial pulse $var(final_p) = "1"; #Final_pulse $var(minbal) = 1; $var(ret) = avp_db_query("SELECT credits FROM subscriber where username='$fU'", "$avp(s:credits)"); xlog("L_WARN", "CNXCC: var(ret)=$var(ret) avp(s:credits)=$avp(s:credits)\n"); cnxcc_set_max_credit("$var(customer)", "$avp(s:credits)", "$var(cps)", "$var(initial_p)", "$var(final_p)"); if ($avp(s:credits)< $var(minbal)){ xlog("L_ALERT", "ALERT: Credit balance is low, sent 403:Forbidden. required=$var(minbal)\n"); sl_send_reply("403", "Forbidden: Low balance"); drop;
}}
Thanks & Kind Regards, Logeshwaran G
On Fri, Aug 25, 2017 at 11:14 AM, Logeshwaran G < logeshwarangs@gmail.com> wrote:
> Thanks For your Input Federico, Will try it . > > Thanks & Kind Regards, > Logeshwaran G > > On Wed, Aug 23, 2017 at 5:45 PM, Federico Cabiddu < > federico.cabiddu@gmail.com> wrote: > >> Hi, >> cnxcc doesn't provide this feature. Is not aware of any backend, it >> just controls subscriber's balance, money or time, as instructed. >> You can calculate the amount to be deducted after the call ends (if >> you're doing money based accounting) using dlg variables to store the >> needed information (start_time, end_time, cost per second) and then >> updating the balance via sqlops module's functions. >> >> Cheers, >> >> Federico >> >> On Wed, Aug 23, 2017 at 7:50 AM, Logeshwaran G < >> logeshwarangs@gmail.com> wrote: >> >>> Hi, >>> >>> How to deduct the call cost or credits for the subscribers with >>> the cnxcc module? >>> >>> Input Please >>> >>> >>> Thanks & Kind Regards, >>> Logeshwaran G >>> >>> _______________________________________________ >>> Kamailio (SER) - Users Mailing List >>> sr-users@lists.kamailio.org >>> https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users >>> >>> >> >> _______________________________________________ >> Kamailio (SER) - Users Mailing List >> sr-users@lists.kamailio.org >> https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users >> >> >
Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
Hi, I told you previously hat you have to use sql_ops to actually do the update of the balance after calculating the call cost using the dialog variables.
Cheers,
Federico
On Wed, Aug 30, 2017 at 10:34 AM, Logeshwaran G logeshwarangs@gmail.com wrote:
As per your Input I have changed the Variables to dialog variables, But I dont know what to add in event route.
Thanks & Kind Regards, Logeshwaran G
On Wed, Aug 30, 2017 at 2:00 PM, Federico Cabiddu < federico.cabiddu@gmail.com> wrote:
Hi, did you read this comment in the event_route?
# perform some kind of notification, database update, email sending, etc.
Have you put any logic to do the accounting there (as I suggested)?
Regards,
Federico
On Wed, Aug 30, 2017 at 9:50 AM, Logeshwaran G logeshwarangs@gmail.com wrote:
Hi,
I am using the below scenario : but there is no cost deduction happening , Correct me if I am wrong.
route[CNXCC] { $dlg_var(subscriber) = $fU; $dlg_var(customer_id) = "customer-" + $fU; $dlg_var(initial_p) = "1"; $dlg_var(final_p) = "1"; $dlg_var(cps) = "1"; ; $var(minbal) = 1; $var(ret) = avp_db_query("SELECT credits FROM subscriber where username='$fU'", "$avp(s:credits)"); xlog("L_WARN", "CNXCC: var(ret)=$var(ret) avp(s:credits)=$avp(s:credits)\n"); #if(!cnxcc_set_max_credit("$var(customer)", "$avp(s:credits)", "$var(cps)", "$var(initial_p)", "$var(final_p)")) if(!cnxcc_set_max_credit("$dlg_var(subscriber)", "$avp(s:credits)", "$dlg_var(cps)", "$dlg_var(initial_p)", "$dlg_var(final_p)")) { xlog("Error setting up credit control"); sl_reply_error(); exit;
} if ($avp(s:credits)< $var(minbal)){ xlog("L_ALERT", "ALERT: Credit balance is low, sent403:Forbidden. required=$var(minbal)\n"); sl_send_reply("403", "Forbidden: Low balance"); drop;
}}
event_route[cnxcc:call-shutdown] { xlog("L_ALERT", "event_route:cnxcc: [$ci]: call killed");
# perform some kind of notification, database update, emailsending, etc. }
Thanks & Kind Regards, Logeshwaran G
On Wed, Aug 30, 2017 at 11:40 AM, Aqs Younas aqsyounas@gmail.com wrote:
This might help you. https://github.com/caruizdiaz/cnxcc-example?files=1
On 30 Aug 2017 11:09 am, "Logeshwaran G" logeshwarangs@gmail.com wrote:
Thanks Federico! Will try it out.
Thanks & Kind Regards, Logeshwaran G
On Wed, Aug 30, 2017 at 11:34 AM, Federico Cabiddu < federico.cabiddu@gmail.com> wrote:
Hi, yes it's correct, but if you want to deduct the cost at the end of the call you should use dlg_var to store cps etc.
Regards,
Federico
On Wed, Aug 30, 2017 at 7:16 AM, Logeshwaran G < logeshwarangs@gmail.com> wrote:
> Hi, > > Is this the correct way of using the CNXCC for cost deduction, Guide > me please. > > route[CNXCC] > { > $var(customer) = $fU; > $var(cps) = "1.00"; # cost per second > $var(initial_p) = "1"; # intial pulse > $var(final_p) = "1"; #Final_pulse > $var(minbal) = 1; > $var(ret) = avp_db_query("SELECT credits FROM subscriber > where username='$fU'", "$avp(s:credits)"); > xlog("L_WARN", "CNXCC: var(ret)=$var(ret) > avp(s:credits)=$avp(s:credits)\n"); > cnxcc_set_max_credit("$var(customer)", "$avp(s:credits)", > "$var(cps)", "$var(initial_p)", "$var(final_p)"); > if ($avp(s:credits)< $var(minbal)){ > xlog("L_ALERT", "ALERT: Credit balance is low, sent > 403:Forbidden. required=$var(minbal)\n"); > sl_send_reply("403", "Forbidden: Low balance"); > drop; > > } > } > > > > > Thanks & Kind Regards, > Logeshwaran G > > On Fri, Aug 25, 2017 at 11:14 AM, Logeshwaran G < > logeshwarangs@gmail.com> wrote: > >> Thanks For your Input Federico, Will try it . >> >> Thanks & Kind Regards, >> Logeshwaran G >> >> On Wed, Aug 23, 2017 at 5:45 PM, Federico Cabiddu < >> federico.cabiddu@gmail.com> wrote: >> >>> Hi, >>> cnxcc doesn't provide this feature. Is not aware of any backend, >>> it just controls subscriber's balance, money or time, as instructed. >>> You can calculate the amount to be deducted after the call ends >>> (if you're doing money based accounting) using dlg variables to store the >>> needed information (start_time, end_time, cost per second) and then >>> updating the balance via sqlops module's functions. >>> >>> Cheers, >>> >>> Federico >>> >>> On Wed, Aug 23, 2017 at 7:50 AM, Logeshwaran G < >>> logeshwarangs@gmail.com> wrote: >>> >>>> Hi, >>>> >>>> How to deduct the call cost or credits for the subscribers with >>>> the cnxcc module? >>>> >>>> Input Please >>>> >>>> >>>> Thanks & Kind Regards, >>>> Logeshwaran G >>>> >>>> _______________________________________________ >>>> Kamailio (SER) - Users Mailing List >>>> sr-users@lists.kamailio.org >>>> https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users >>>> >>>> >>> >>> _______________________________________________ >>> Kamailio (SER) - Users Mailing List >>> sr-users@lists.kamailio.org >>> https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users >>> >>> >> > > _______________________________________________ > Kamailio (SER) - Users Mailing List > sr-users@lists.kamailio.org > https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users > >
Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
Ok let me try it out!
Will add the sqlops query module in the event route!
Thanks
Thanks & Kind Regards, Logeshwaran G
On Wed, Aug 30, 2017 at 2:09 PM, Federico Cabiddu < federico.cabiddu@gmail.com> wrote:
Hi, I told you previously hat you have to use sql_ops to actually do the update of the balance after calculating the call cost using the dialog variables.
Cheers,
Federico
On Wed, Aug 30, 2017 at 10:34 AM, Logeshwaran G logeshwarangs@gmail.com wrote:
As per your Input I have changed the Variables to dialog variables, But I dont know what to add in event route.
Thanks & Kind Regards, Logeshwaran G
On Wed, Aug 30, 2017 at 2:00 PM, Federico Cabiddu < federico.cabiddu@gmail.com> wrote:
Hi, did you read this comment in the event_route?
# perform some kind of notification, database update, email sending, etc.
Have you put any logic to do the accounting there (as I suggested)?
Regards,
Federico
On Wed, Aug 30, 2017 at 9:50 AM, Logeshwaran G logeshwarangs@gmail.com wrote:
Hi,
I am using the below scenario : but there is no cost deduction happening , Correct me if I am wrong.
route[CNXCC] { $dlg_var(subscriber) = $fU; $dlg_var(customer_id) = "customer-" + $fU; $dlg_var(initial_p) = "1"; $dlg_var(final_p) = "1"; $dlg_var(cps) = "1"; ; $var(minbal) = 1; $var(ret) = avp_db_query("SELECT credits FROM subscriber where username='$fU'", "$avp(s:credits)"); xlog("L_WARN", "CNXCC: var(ret)=$var(ret) avp(s:credits)=$avp(s:credits)\n"); #if(!cnxcc_set_max_credit("$var(customer)", "$avp(s:credits)", "$var(cps)", "$var(initial_p)", "$var(final_p)")) if(!cnxcc_set_max_credit("$dlg_var(subscriber)", "$avp(s:credits)", "$dlg_var(cps)", "$dlg_var(initial_p)", "$dlg_var(final_p)")) { xlog("Error setting up credit control"); sl_reply_error(); exit;
} if ($avp(s:credits)< $var(minbal)){ xlog("L_ALERT", "ALERT: Credit balance is low, sent403:Forbidden. required=$var(minbal)\n"); sl_send_reply("403", "Forbidden: Low balance"); drop;
}}
event_route[cnxcc:call-shutdown] { xlog("L_ALERT", "event_route:cnxcc: [$ci]: call killed");
# perform some kind of notification, database update, emailsending, etc. }
Thanks & Kind Regards, Logeshwaran G
On Wed, Aug 30, 2017 at 11:40 AM, Aqs Younas aqsyounas@gmail.com wrote:
This might help you. https://github.com/caruizdiaz/cnxcc-example?files=1
On 30 Aug 2017 11:09 am, "Logeshwaran G" logeshwarangs@gmail.com wrote:
Thanks Federico! Will try it out.
Thanks & Kind Regards, Logeshwaran G
On Wed, Aug 30, 2017 at 11:34 AM, Federico Cabiddu < federico.cabiddu@gmail.com> wrote:
> Hi, > yes it's correct, but if you want to deduct the cost at the end of > the call you should use dlg_var to store cps etc. > > Regards, > > Federico > > On Wed, Aug 30, 2017 at 7:16 AM, Logeshwaran G < > logeshwarangs@gmail.com> wrote: > >> Hi, >> >> Is this the correct way of using the CNXCC for cost deduction, >> Guide me please. >> >> route[CNXCC] >> { >> $var(customer) = $fU; >> $var(cps) = "1.00"; # cost per second >> $var(initial_p) = "1"; # intial pulse >> $var(final_p) = "1"; #Final_pulse >> $var(minbal) = 1; >> $var(ret) = avp_db_query("SELECT credits FROM subscriber >> where username='$fU'", "$avp(s:credits)"); >> xlog("L_WARN", "CNXCC: var(ret)=$var(ret) >> avp(s:credits)=$avp(s:credits)\n"); >> cnxcc_set_max_credit("$var(customer)", "$avp(s:credits)", >> "$var(cps)", "$var(initial_p)", "$var(final_p)"); >> if ($avp(s:credits)< $var(minbal)){ >> xlog("L_ALERT", "ALERT: Credit balance is low, sent >> 403:Forbidden. required=$var(minbal)\n"); >> sl_send_reply("403", "Forbidden: Low balance"); >> drop; >> >> } >> } >> >> >> >> >> Thanks & Kind Regards, >> Logeshwaran G >> >> On Fri, Aug 25, 2017 at 11:14 AM, Logeshwaran G < >> logeshwarangs@gmail.com> wrote: >> >>> Thanks For your Input Federico, Will try it . >>> >>> Thanks & Kind Regards, >>> Logeshwaran G >>> >>> On Wed, Aug 23, 2017 at 5:45 PM, Federico Cabiddu < >>> federico.cabiddu@gmail.com> wrote: >>> >>>> Hi, >>>> cnxcc doesn't provide this feature. Is not aware of any backend, >>>> it just controls subscriber's balance, money or time, as instructed. >>>> You can calculate the amount to be deducted after the call ends >>>> (if you're doing money based accounting) using dlg variables to store the >>>> needed information (start_time, end_time, cost per second) and then >>>> updating the balance via sqlops module's functions. >>>> >>>> Cheers, >>>> >>>> Federico >>>> >>>> On Wed, Aug 23, 2017 at 7:50 AM, Logeshwaran G < >>>> logeshwarangs@gmail.com> wrote: >>>> >>>>> Hi, >>>>> >>>>> How to deduct the call cost or credits for the subscribers with >>>>> the cnxcc module? >>>>> >>>>> Input Please >>>>> >>>>> >>>>> Thanks & Kind Regards, >>>>> Logeshwaran G >>>>> >>>>> _______________________________________________ >>>>> Kamailio (SER) - Users Mailing List >>>>> sr-users@lists.kamailio.org >>>>> https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users >>>>> >>>>> >>>> >>>> _______________________________________________ >>>> Kamailio (SER) - Users Mailing List >>>> sr-users@lists.kamailio.org >>>> https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users >>>> >>>> >>> >> >> _______________________________________________ >> Kamailio (SER) - Users Mailing List >> sr-users@lists.kamailio.org >> https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users >> >> > > _______________________________________________ > Kamailio (SER) - Users Mailing List > sr-users@lists.kamailio.org > https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users > >
Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
Hi ,
I have tried the Cnxcc to deduct the credit amount and its working fine. Please find the below logs in kamailio -ddd mode.
10(19003) DEBUG: cnxcc [cnxcc_check.c:85]: check_calls_by_money(): CID [4vL4DJsLpRSfwoMaJVbegWBLWy7k7-UP], start_timestamp [1504598301], seconds alive [36], consumed credit [20.000000] 10(19003) DEBUG: cnxcc [cnxcc_check.c:107]: check_calls_by_money(): Client [8888] | Ended-Calls-Credit-Spent: 0.000000 TotalCredit/MaxCredit: 20.000000/30.000000 10(19003) DEBUG: cnxcc [cnxcc_check.c:85]: check_calls_by_money(): CID [4vL4DJsLpRSfwoMaJVbegWBLWy7k7-UP], start_timestamp [1504598301], seconds alive [37], consumed credit [20.000000] 10(19003) DEBUG: cnxcc [cnxcc_check.c:107]: check_calls_by_money(): Client [8888] | Ended-Calls-Credit-Spent: 0.000000 TotalCredit/MaxCredit: 20.000000/30.000000
But Through Sql query how can I get the Deducted Value.. For Example in my case, in the above kamailio log, Total Credit Spent is 20.00, Where this values are storing in Database. Please Guide me
Thanks & Kind Regards, Logeshwaran G
On Wed, Aug 30, 2017 at 2:12 PM, Logeshwaran G logeshwarangs@gmail.com wrote:
Ok let me try it out!
Will add the sqlops query module in the event route!
Thanks
Thanks & Kind Regards, Logeshwaran G
On Wed, Aug 30, 2017 at 2:09 PM, Federico Cabiddu < federico.cabiddu@gmail.com> wrote:
Hi, I told you previously hat you have to use sql_ops to actually do the update of the balance after calculating the call cost using the dialog variables.
Cheers,
Federico
On Wed, Aug 30, 2017 at 10:34 AM, Logeshwaran G logeshwarangs@gmail.com wrote:
As per your Input I have changed the Variables to dialog variables, But I dont know what to add in event route.
Thanks & Kind Regards, Logeshwaran G
On Wed, Aug 30, 2017 at 2:00 PM, Federico Cabiddu < federico.cabiddu@gmail.com> wrote:
Hi, did you read this comment in the event_route?
# perform some kind of notification, database update, email sending, etc.
Have you put any logic to do the accounting there (as I suggested)?
Regards,
Federico
On Wed, Aug 30, 2017 at 9:50 AM, Logeshwaran G <logeshwarangs@gmail.com
wrote:
Hi,
I am using the below scenario : but there is no cost deduction happening , Correct me if I am wrong.
route[CNXCC] { $dlg_var(subscriber) = $fU; $dlg_var(customer_id) = "customer-" + $fU; $dlg_var(initial_p) = "1"; $dlg_var(final_p) = "1"; $dlg_var(cps) = "1"; ; $var(minbal) = 1; $var(ret) = avp_db_query("SELECT credits FROM subscriber where username='$fU'", "$avp(s:credits)"); xlog("L_WARN", "CNXCC: var(ret)=$var(ret) avp(s:credits)=$avp(s:credits)\n"); #if(!cnxcc_set_max_credit("$var(customer)", "$avp(s:credits)", "$var(cps)", "$var(initial_p)", "$var(final_p)")) if(!cnxcc_set_max_credit("$dlg_var(subscriber)", "$avp(s:credits)", "$dlg_var(cps)", "$dlg_var(initial_p)", "$dlg_var(final_p)")) { xlog("Error setting up credit control"); sl_reply_error(); exit;
} if ($avp(s:credits)< $var(minbal)){ xlog("L_ALERT", "ALERT: Credit balance is low, sent403:Forbidden. required=$var(minbal)\n"); sl_send_reply("403", "Forbidden: Low balance"); drop;
}}
event_route[cnxcc:call-shutdown] { xlog("L_ALERT", "event_route:cnxcc: [$ci]: call killed");
# perform some kind of notification, database update, emailsending, etc. }
Thanks & Kind Regards, Logeshwaran G
On Wed, Aug 30, 2017 at 11:40 AM, Aqs Younas aqsyounas@gmail.com wrote:
This might help you. https://github.com/caruizdiaz/cnxcc-example?files=1
On 30 Aug 2017 11:09 am, "Logeshwaran G" logeshwarangs@gmail.com wrote:
> Thanks Federico! Will try it out. > > Thanks & Kind Regards, > Logeshwaran G > > On Wed, Aug 30, 2017 at 11:34 AM, Federico Cabiddu < > federico.cabiddu@gmail.com> wrote: > >> Hi, >> yes it's correct, but if you want to deduct the cost at the end of >> the call you should use dlg_var to store cps etc. >> >> Regards, >> >> Federico >> >> On Wed, Aug 30, 2017 at 7:16 AM, Logeshwaran G < >> logeshwarangs@gmail.com> wrote: >> >>> Hi, >>> >>> Is this the correct way of using the CNXCC for cost deduction, >>> Guide me please. >>> >>> route[CNXCC] >>> { >>> $var(customer) = $fU; >>> $var(cps) = "1.00"; # cost per second >>> $var(initial_p) = "1"; # intial pulse >>> $var(final_p) = "1"; #Final_pulse >>> $var(minbal) = 1; >>> $var(ret) = avp_db_query("SELECT credits FROM subscriber >>> where username='$fU'", "$avp(s:credits)"); >>> xlog("L_WARN", "CNXCC: var(ret)=$var(ret) >>> avp(s:credits)=$avp(s:credits)\n"); >>> cnxcc_set_max_credit("$var(customer)", "$avp(s:credits)", >>> "$var(cps)", "$var(initial_p)", "$var(final_p)"); >>> if ($avp(s:credits)< $var(minbal)){ >>> xlog("L_ALERT", "ALERT: Credit balance is low, >>> sent 403:Forbidden. required=$var(minbal)\n"); >>> sl_send_reply("403", "Forbidden: Low balance"); >>> drop; >>> >>> } >>> } >>> >>> >>> >>> >>> Thanks & Kind Regards, >>> Logeshwaran G >>> >>> On Fri, Aug 25, 2017 at 11:14 AM, Logeshwaran G < >>> logeshwarangs@gmail.com> wrote: >>> >>>> Thanks For your Input Federico, Will try it . >>>> >>>> Thanks & Kind Regards, >>>> Logeshwaran G >>>> >>>> On Wed, Aug 23, 2017 at 5:45 PM, Federico Cabiddu < >>>> federico.cabiddu@gmail.com> wrote: >>>> >>>>> Hi, >>>>> cnxcc doesn't provide this feature. Is not aware of any backend, >>>>> it just controls subscriber's balance, money or time, as instructed. >>>>> You can calculate the amount to be deducted after the call ends >>>>> (if you're doing money based accounting) using dlg variables to store the >>>>> needed information (start_time, end_time, cost per second) and then >>>>> updating the balance via sqlops module's functions. >>>>> >>>>> Cheers, >>>>> >>>>> Federico >>>>> >>>>> On Wed, Aug 23, 2017 at 7:50 AM, Logeshwaran G < >>>>> logeshwarangs@gmail.com> wrote: >>>>> >>>>>> Hi, >>>>>> >>>>>> How to deduct the call cost or credits for the subscribers with >>>>>> the cnxcc module? >>>>>> >>>>>> Input Please >>>>>> >>>>>> >>>>>> Thanks & Kind Regards, >>>>>> Logeshwaran G >>>>>> >>>>>> _______________________________________________ >>>>>> Kamailio (SER) - Users Mailing List >>>>>> sr-users@lists.kamailio.org >>>>>> https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users >>>>>> >>>>>> >>>>> >>>>> _______________________________________________ >>>>> Kamailio (SER) - Users Mailing List >>>>> sr-users@lists.kamailio.org >>>>> https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users >>>>> >>>>> >>>> >>> >>> _______________________________________________ >>> Kamailio (SER) - Users Mailing List >>> sr-users@lists.kamailio.org >>> https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users >>> >>> >> >> _______________________________________________ >> Kamailio (SER) - Users Mailing List >> sr-users@lists.kamailio.org >> https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users >> >> > > _______________________________________________ > Kamailio (SER) - Users Mailing List > sr-users@lists.kamailio.org > https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users > > _______________________________________________ Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
Input Please
Thanks & Kind Regards, *Logeshwaran G*
*"Be Hungry, Stay Foolish"*
On Tue, Sep 5, 2017 at 2:07 PM, Logeshwaran G logeshwarangs@gmail.com wrote:
Hi ,
I have tried the Cnxcc to deduct the credit amount and its working fine. Please find the below logs in kamailio -ddd mode.
10(19003) DEBUG: cnxcc [cnxcc_check.c:85]: check_calls_by_money(): CID [ 4vL4DJsLpRSfwoMaJVbegWBLWy7k7-UP], start_timestamp [1504598301], seconds alive [36], consumed credit [20.000000] 10(19003) DEBUG: cnxcc [cnxcc_check.c:107]: check_calls_by_money(): Client [8888] | Ended-Calls-Credit-Spent: 0.000000 TotalCredit/MaxCredit: 20.000000/30.000000 10(19003) DEBUG: cnxcc [cnxcc_check.c:85]: check_calls_by_money(): CID [ 4vL4DJsLpRSfwoMaJVbegWBLWy7k7-UP], start_timestamp [1504598301], seconds alive [37], consumed credit [20.000000] 10(19003) DEBUG: cnxcc [cnxcc_check.c:107]: check_calls_by_money(): Client [8888] | Ended-Calls-Credit-Spent: 0.000000 TotalCredit/MaxCredit: 20.000000/30.000000
But Through Sql query how can I get the Deducted Value.. For Example in my case, in the above kamailio log, Total Credit Spent is 20.00, Where this values are storing in Database. Please Guide me
Thanks & Kind Regards, Logeshwaran G
On Wed, Aug 30, 2017 at 2:12 PM, Logeshwaran G logeshwarangs@gmail.com wrote:
Ok let me try it out!
Will add the sqlops query module in the event route!
Thanks
Thanks & Kind Regards, Logeshwaran G
On Wed, Aug 30, 2017 at 2:09 PM, Federico Cabiddu < federico.cabiddu@gmail.com> wrote:
Hi, I told you previously hat you have to use sql_ops to actually do the update of the balance after calculating the call cost using the dialog variables.
Cheers,
Federico
On Wed, Aug 30, 2017 at 10:34 AM, Logeshwaran G <logeshwarangs@gmail.com
wrote:
As per your Input I have changed the Variables to dialog variables, But I dont know what to add in event route.
Thanks & Kind Regards, Logeshwaran G
On Wed, Aug 30, 2017 at 2:00 PM, Federico Cabiddu < federico.cabiddu@gmail.com> wrote:
Hi, did you read this comment in the event_route?
# perform some kind of notification, database update, email sending, etc.
Have you put any logic to do the accounting there (as I suggested)?
Regards,
Federico
On Wed, Aug 30, 2017 at 9:50 AM, Logeshwaran G < logeshwarangs@gmail.com> wrote:
Hi,
I am using the below scenario : but there is no cost deduction happening , Correct me if I am wrong.
route[CNXCC] { $dlg_var(subscriber) = $fU; $dlg_var(customer_id) = "customer-" + $fU; $dlg_var(initial_p) = "1"; $dlg_var(final_p) = "1"; $dlg_var(cps) = "1"; ; $var(minbal) = 1; $var(ret) = avp_db_query("SELECT credits FROM subscriber where username='$fU'", "$avp(s:credits)"); xlog("L_WARN", "CNXCC: var(ret)=$var(ret) avp(s:credits)=$avp(s:credits)\n"); #if(!cnxcc_set_max_credit("$var(customer)", "$avp(s:credits)", "$var(cps)", "$var(initial_p)", "$var(final_p)")) if(!cnxcc_set_max_credit("$dlg_var(subscriber)", "$avp(s:credits)", "$dlg_var(cps)", "$dlg_var(initial_p)", "$dlg_var(final_p)")) { xlog("Error setting up credit control"); sl_reply_error(); exit;
} if ($avp(s:credits)< $var(minbal)){ xlog("L_ALERT", "ALERT: Credit balance is low, sent403:Forbidden. required=$var(minbal)\n"); sl_send_reply("403", "Forbidden: Low balance"); drop;
}}
event_route[cnxcc:call-shutdown] { xlog("L_ALERT", "event_route:cnxcc: [$ci]: call killed");
# perform some kind of notification, database update, emailsending, etc. }
Thanks & Kind Regards, Logeshwaran G
On Wed, Aug 30, 2017 at 11:40 AM, Aqs Younas aqsyounas@gmail.com wrote:
> This might help you. > https://github.com/caruizdiaz/cnxcc-example?files=1 > > On 30 Aug 2017 11:09 am, "Logeshwaran G" logeshwarangs@gmail.com > wrote: > >> Thanks Federico! Will try it out. >> >> Thanks & Kind Regards, >> Logeshwaran G >> >> On Wed, Aug 30, 2017 at 11:34 AM, Federico Cabiddu < >> federico.cabiddu@gmail.com> wrote: >> >>> Hi, >>> yes it's correct, but if you want to deduct the cost at the end of >>> the call you should use dlg_var to store cps etc. >>> >>> Regards, >>> >>> Federico >>> >>> On Wed, Aug 30, 2017 at 7:16 AM, Logeshwaran G < >>> logeshwarangs@gmail.com> wrote: >>> >>>> Hi, >>>> >>>> Is this the correct way of using the CNXCC for cost deduction, >>>> Guide me please. >>>> >>>> route[CNXCC] >>>> { >>>> $var(customer) = $fU; >>>> $var(cps) = "1.00"; # cost per second >>>> $var(initial_p) = "1"; # intial pulse >>>> $var(final_p) = "1"; #Final_pulse >>>> $var(minbal) = 1; >>>> $var(ret) = avp_db_query("SELECT credits FROM subscriber >>>> where username='$fU'", "$avp(s:credits)"); >>>> xlog("L_WARN", "CNXCC: var(ret)=$var(ret) >>>> avp(s:credits)=$avp(s:credits)\n"); >>>> cnxcc_set_max_credit("$var(customer)", >>>> "$avp(s:credits)", "$var(cps)", "$var(initial_p)", "$var(final_p)"); >>>> if ($avp(s:credits)< $var(minbal)){ >>>> xlog("L_ALERT", "ALERT: Credit balance is low, >>>> sent 403:Forbidden. required=$var(minbal)\n"); >>>> sl_send_reply("403", "Forbidden: Low balance"); >>>> drop; >>>> >>>> } >>>> } >>>> >>>> >>>> >>>> >>>> Thanks & Kind Regards, >>>> Logeshwaran G >>>> >>>> On Fri, Aug 25, 2017 at 11:14 AM, Logeshwaran G < >>>> logeshwarangs@gmail.com> wrote: >>>> >>>>> Thanks For your Input Federico, Will try it . >>>>> >>>>> Thanks & Kind Regards, >>>>> Logeshwaran G >>>>> >>>>> On Wed, Aug 23, 2017 at 5:45 PM, Federico Cabiddu < >>>>> federico.cabiddu@gmail.com> wrote: >>>>> >>>>>> Hi, >>>>>> cnxcc doesn't provide this feature. Is not aware of any >>>>>> backend, it just controls subscriber's balance, money or time, as >>>>>> instructed. >>>>>> You can calculate the amount to be deducted after the call ends >>>>>> (if you're doing money based accounting) using dlg variables to store the >>>>>> needed information (start_time, end_time, cost per second) and then >>>>>> updating the balance via sqlops module's functions. >>>>>> >>>>>> Cheers, >>>>>> >>>>>> Federico >>>>>> >>>>>> On Wed, Aug 23, 2017 at 7:50 AM, Logeshwaran G < >>>>>> logeshwarangs@gmail.com> wrote: >>>>>> >>>>>>> Hi, >>>>>>> >>>>>>> How to deduct the call cost or credits for the subscribers >>>>>>> with the cnxcc module? >>>>>>> >>>>>>> Input Please >>>>>>> >>>>>>> >>>>>>> Thanks & Kind Regards, >>>>>>> Logeshwaran G >>>>>>> >>>>>>> _______________________________________________ >>>>>>> Kamailio (SER) - Users Mailing List >>>>>>> sr-users@lists.kamailio.org >>>>>>> https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users >>>>>>> >>>>>>> >>>>>> >>>>>> _______________________________________________ >>>>>> Kamailio (SER) - Users Mailing List >>>>>> sr-users@lists.kamailio.org >>>>>> https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users >>>>>> >>>>>> >>>>> >>>> >>>> _______________________________________________ >>>> Kamailio (SER) - Users Mailing List >>>> sr-users@lists.kamailio.org >>>> https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users >>>> >>>> >>> >>> _______________________________________________ >>> Kamailio (SER) - Users Mailing List >>> sr-users@lists.kamailio.org >>> https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users >>> >>> >> >> _______________________________________________ >> Kamailio (SER) - Users Mailing List >> sr-users@lists.kamailio.org >> https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users >> >> > _______________________________________________ > Kamailio (SER) - Users Mailing List > sr-users@lists.kamailio.org > https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users > >
Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
Hi, I have strictly no idea of where you decided to store the balance in the db, what is the table structure you decided to use and so on.
From where are you taking the user's credit before calling cnxcc? I suppose
you should use the same table/field when updating. There is no ready made solution for this in Kamailio, you have to use its building blocks, the modules, to achieve this. Have a (deep) look at modules' documentation and at the example that has been suggested.
Cheers,
Federico
On Thu, Sep 7, 2017 at 8:20 AM, Logeshwaran G logeshwarangs@gmail.com wrote:
Input Please
Thanks & Kind Regards, *Logeshwaran G*
*"Be Hungry, Stay Foolish"*
On Tue, Sep 5, 2017 at 2:07 PM, Logeshwaran G logeshwarangs@gmail.com wrote:
Hi ,
I have tried the Cnxcc to deduct the credit amount and its working fine. Please find the below logs in kamailio -ddd mode.
10(19003) DEBUG: cnxcc [cnxcc_check.c:85]: check_calls_by_money(): CID [4vL4DJsLpRSfwoMaJVbegWBLWy7k7-UP], start_timestamp [1504598301], seconds alive [36], consumed credit [20.000000] 10(19003) DEBUG: cnxcc [cnxcc_check.c:107]: check_calls_by_money(): Client [8888] | Ended-Calls-Credit-Spent: 0.000000 TotalCredit/MaxCredit: 20.000000/30.000000 10(19003) DEBUG: cnxcc [cnxcc_check.c:85]: check_calls_by_money(): CID [4vL4DJsLpRSfwoMaJVbegWBLWy7k7-UP], start_timestamp [1504598301], seconds alive [37], consumed credit [20.000000] 10(19003) DEBUG: cnxcc [cnxcc_check.c:107]: check_calls_by_money(): Client [8888] | Ended-Calls-Credit-Spent: 0.000000 TotalCredit/MaxCredit: 20.000000/30.000000
But Through Sql query how can I get the Deducted Value.. For Example in my case, in the above kamailio log, Total Credit Spent is 20.00, Where this values are storing in Database. Please Guide me
Thanks & Kind Regards, Logeshwaran G
On Wed, Aug 30, 2017 at 2:12 PM, Logeshwaran G logeshwarangs@gmail.com wrote:
Ok let me try it out!
Will add the sqlops query module in the event route!
Thanks
Thanks & Kind Regards, Logeshwaran G
On Wed, Aug 30, 2017 at 2:09 PM, Federico Cabiddu < federico.cabiddu@gmail.com> wrote:
Hi, I told you previously hat you have to use sql_ops to actually do the update of the balance after calculating the call cost using the dialog variables.
Cheers,
Federico
On Wed, Aug 30, 2017 at 10:34 AM, Logeshwaran G < logeshwarangs@gmail.com> wrote:
As per your Input I have changed the Variables to dialog variables, But I dont know what to add in event route.
Thanks & Kind Regards, Logeshwaran G
On Wed, Aug 30, 2017 at 2:00 PM, Federico Cabiddu < federico.cabiddu@gmail.com> wrote:
Hi, did you read this comment in the event_route?
# perform some kind of notification, database update, email sending, etc.
Have you put any logic to do the accounting there (as I suggested)?
Regards,
Federico
On Wed, Aug 30, 2017 at 9:50 AM, Logeshwaran G < logeshwarangs@gmail.com> wrote:
> Hi, > > I am using the below scenario : but there is no cost deduction > happening , Correct me if I am wrong. > > route[CNXCC] > { > $dlg_var(subscriber) = $fU; > $dlg_var(customer_id) = "customer-" + $fU; > $dlg_var(initial_p) = "1"; > $dlg_var(final_p) = "1"; > $dlg_var(cps) = "1"; ; > $var(minbal) = 1; > $var(ret) = avp_db_query("SELECT credits FROM subscriber > where username='$fU'", "$avp(s:credits)"); > xlog("L_WARN", "CNXCC: var(ret)=$var(ret) > avp(s:credits)=$avp(s:credits)\n"); > #if(!cnxcc_set_max_credit("$var(customer)", > "$avp(s:credits)", "$var(cps)", "$var(initial_p)", "$var(final_p)")) > if(!cnxcc_set_max_credit("$dlg_var(subscriber)", > "$avp(s:credits)", "$dlg_var(cps)", "$dlg_var(initial_p)", > "$dlg_var(final_p)")) > { > xlog("Error setting up credit control"); > sl_reply_error(); > exit; > > } > if ($avp(s:credits)< $var(minbal)){ > xlog("L_ALERT", "ALERT: Credit balance is low, sent > 403:Forbidden. required=$var(minbal)\n"); > sl_send_reply("403", "Forbidden: Low balance"); > drop; > > } > } > > event_route[cnxcc:call-shutdown] > { > xlog("L_ALERT", "event_route:cnxcc: [$ci]: call killed"); > > # perform some kind of notification, database update, email > sending, etc. > } > > Thanks & Kind Regards, > Logeshwaran G > > On Wed, Aug 30, 2017 at 11:40 AM, Aqs Younas aqsyounas@gmail.com > wrote: > >> This might help you. >> https://github.com/caruizdiaz/cnxcc-example?files=1 >> >> On 30 Aug 2017 11:09 am, "Logeshwaran G" logeshwarangs@gmail.com >> wrote: >> >>> Thanks Federico! Will try it out. >>> >>> Thanks & Kind Regards, >>> Logeshwaran G >>> >>> On Wed, Aug 30, 2017 at 11:34 AM, Federico Cabiddu < >>> federico.cabiddu@gmail.com> wrote: >>> >>>> Hi, >>>> yes it's correct, but if you want to deduct the cost at the end >>>> of the call you should use dlg_var to store cps etc. >>>> >>>> Regards, >>>> >>>> Federico >>>> >>>> On Wed, Aug 30, 2017 at 7:16 AM, Logeshwaran G < >>>> logeshwarangs@gmail.com> wrote: >>>> >>>>> Hi, >>>>> >>>>> Is this the correct way of using the CNXCC for cost deduction, >>>>> Guide me please. >>>>> >>>>> route[CNXCC] >>>>> { >>>>> $var(customer) = $fU; >>>>> $var(cps) = "1.00"; # cost per second >>>>> $var(initial_p) = "1"; # intial pulse >>>>> $var(final_p) = "1"; #Final_pulse >>>>> $var(minbal) = 1; >>>>> $var(ret) = avp_db_query("SELECT credits FROM subscriber >>>>> where username='$fU'", "$avp(s:credits)"); >>>>> xlog("L_WARN", "CNXCC: var(ret)=$var(ret) >>>>> avp(s:credits)=$avp(s:credits)\n"); >>>>> cnxcc_set_max_credit("$var(customer)", >>>>> "$avp(s:credits)", "$var(cps)", "$var(initial_p)", "$var(final_p)"); >>>>> if ($avp(s:credits)< $var(minbal)){ >>>>> xlog("L_ALERT", "ALERT: Credit balance is low, >>>>> sent 403:Forbidden. required=$var(minbal)\n"); >>>>> sl_send_reply("403", "Forbidden: Low balance"); >>>>> drop; >>>>> >>>>> } >>>>> } >>>>> >>>>> >>>>> >>>>> >>>>> Thanks & Kind Regards, >>>>> Logeshwaran G >>>>> >>>>> On Fri, Aug 25, 2017 at 11:14 AM, Logeshwaran G < >>>>> logeshwarangs@gmail.com> wrote: >>>>> >>>>>> Thanks For your Input Federico, Will try it . >>>>>> >>>>>> Thanks & Kind Regards, >>>>>> Logeshwaran G >>>>>> >>>>>> On Wed, Aug 23, 2017 at 5:45 PM, Federico Cabiddu < >>>>>> federico.cabiddu@gmail.com> wrote: >>>>>> >>>>>>> Hi, >>>>>>> cnxcc doesn't provide this feature. Is not aware of any >>>>>>> backend, it just controls subscriber's balance, money or time, as >>>>>>> instructed. >>>>>>> You can calculate the amount to be deducted after the call >>>>>>> ends (if you're doing money based accounting) using dlg variables to store >>>>>>> the needed information (start_time, end_time, cost per second) and then >>>>>>> updating the balance via sqlops module's functions. >>>>>>> >>>>>>> Cheers, >>>>>>> >>>>>>> Federico >>>>>>> >>>>>>> On Wed, Aug 23, 2017 at 7:50 AM, Logeshwaran G < >>>>>>> logeshwarangs@gmail.com> wrote: >>>>>>> >>>>>>>> Hi, >>>>>>>> >>>>>>>> How to deduct the call cost or credits for the subscribers >>>>>>>> with the cnxcc module? >>>>>>>> >>>>>>>> Input Please >>>>>>>> >>>>>>>> >>>>>>>> Thanks & Kind Regards, >>>>>>>> Logeshwaran G >>>>>>>> >>>>>>>> _______________________________________________ >>>>>>>> Kamailio (SER) - Users Mailing List >>>>>>>> sr-users@lists.kamailio.org >>>>>>>> https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users >>>>>>>> >>>>>>>> >>>>>>> >>>>>>> _______________________________________________ >>>>>>> Kamailio (SER) - Users Mailing List >>>>>>> sr-users@lists.kamailio.org >>>>>>> https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users >>>>>>> >>>>>>> >>>>>> >>>>> >>>>> _______________________________________________ >>>>> Kamailio (SER) - Users Mailing List >>>>> sr-users@lists.kamailio.org >>>>> https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users >>>>> >>>>> >>>> >>>> _______________________________________________ >>>> Kamailio (SER) - Users Mailing List >>>> sr-users@lists.kamailio.org >>>> https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users >>>> >>>> >>> >>> _______________________________________________ >>> Kamailio (SER) - Users Mailing List >>> sr-users@lists.kamailio.org >>> https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users >>> >>> >> _______________________________________________ >> Kamailio (SER) - Users Mailing List >> sr-users@lists.kamailio.org >> https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users >> >> > > _______________________________________________ > Kamailio (SER) - Users Mailing List > sr-users@lists.kamailio.org > https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users > >
Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
-
Aqs Younas -
Federico Cabiddu -
Logeshwaran G