From renemontilva@gmail.com Fri May  9 21:45:35 2014
From: Rene Montilva <renemontilva@gmail.com>
To: sr-users@lists.kamailio.org
Subject: Re: [SR-Users] CNXCC PrePaid module
Date: Fri, 09 May 2014 15:15:29 -0430
Message-ID:
 <CALbkU0QXNVBD8-F9=vqCsVBUcSgUie08nSHznucoiNC8GK4cYw@mail.gmail.com>
In-Reply-To:
 <CA+3gBcn9XwJQTiY1SMGuQ4B51npNMvwykUAMshVXP6bgT44a=Q@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="===============1571588529=="

--===============1571588529==
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: quoted-printable

Hi Carlos

This my kamailio config:

#!ifdef CNXCC_MONEY
sql_query("ca", "select * from
billing.sel_customer_credit('pepe','xxxxxxx","ra");

xlog("L_INFO", "Setting up money based credit control");

if($dbr(ra=3D>rows)> 0){
xlog("L_INFO", "saldo:$dbr(ra=3D>[0,0]) y seg:$dbr(ra=3D>[0,1]) ");

$var(credit) =3D $dbr(ra=3D>[0,0]); # 30$ of credit
$var(cost_per_sec) =3D $dbr(ra=3D>[0,1]); # 1$ per sec
$var(i_pulse) =3D "1"; # 1$ to establish the call
$var(f_pulse) =3D "1"; # 1$ per second


}

sql_result_free ("ra");

# if only one call is established, that call should last 9 seconds.

if (!cnxcc_set_max_credit("$var(client)",
"$var(credit)",
"$var(cost_per_sec)",
"$var(i_pulse)",



And this are the values by syslog info

INFO: <script>: saldo:0.0006500000 y seg:0.000666666666666667
ERROR: cnxcc [cnxcc_mod.c:1425]: set_max_credit(): credit value must be >
0: 0.000000






On Fri, May 9, 2014 at 3:08 PM, Carlos Ruiz D=C3=ADaz
<carlos.ruizdiaz(a)gmail.com>wrote:

> Hi,
>
> Can you paste the code you are using, with the values that each variable
> contain at the moment of initiating the call?
>
> Regards,
>
>
> On Fri, May 9, 2014 at 2:35 PM, Rene Montilva <renemontilva(a)gmail.com>wro=
te:
>
>> Hi list
>>
>> I don't understand prepaid logic calculation, because when my credit is 0
>> or lees than cost per second, the call is established equal
>>
>> $var(i_pulse) and $var(f_pulse) how this works????
>>
>>
>>
>> _______________________________________________
>> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
>> sr-users(a)lists.sip-router.org
>> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
>>
>>
>
>
> --
> Carlos
> http://caruizdiaz.com
> http://ngvoice.com
> +52 55 3048 3303
>
> _______________________________________________
> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
> sr-users(a)lists.sip-router.org
> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
>
>



--===============1571588529==
Content-Type: text/html
Content-Transfer-Encoding: base64
Content-Disposition: attachment; filename="attachment.html"
MIME-Version: 1.0

PGRpdiBkaXI9Imx0ciI+PGRpdj5IaSBDYXJsb3M8YnI+PC9kaXY+PGRpdj48YnI+VGhpcyBteSBr
YW1haWxpbyBjb25maWc6IDxicj48YnI+IyFpZmRlZiBDTlhDQ19NT05FWTxicj5zcWxfcXVlcnko
JnF1b3Q7Y2EmcXVvdDssICZxdW90O3NlbGVjdCAqIGZyb23CoCBiaWxsaW5nLnNlbF9jdXN0b21l
cl9jcmVkaXQoJiMzOTtwZXBlJiMzOTssJiMzOTt4eHh4eHh4JnF1b3Q7LCZxdW90O3JhJnF1b3Q7
KTs8YnI+Cjxicj54bG9nKCZxdW90O0xfSU5GTyZxdW90OywgJnF1b3Q7U2V0dGluZyB1cCBtb25l
eSBiYXNlZCBjcmVkaXQgY29udHJvbCZxdW90Oyk7PGJyPjxicj5pZigkZGJyKHJhPSZndDtyb3dz
KSZndDsgMCl7PGJyPnhsb2coJnF1b3Q7TF9JTkZPJnF1b3Q7LCAmcXVvdDtzYWxkbzokZGJyKHJh
PSZndDtbMCwwXSkgeSBzZWc6JGRicihyYT0mZ3Q7WzAsMV0pICZxdW90Oyk7PGJyPjxicj4kdmFy
KGNyZWRpdCkgPSAkZGJyKHJhPSZndDtbMCwwXSk7ICMgMzAkIG9mIGNyZWRpdDxicj4KJHZhcihj
b3N0X3Blcl9zZWMpID0gJGRicihyYT0mZ3Q7WzAsMV0pOyAjIDEkIHBlciBzZWM8YnI+JHZhcihp
X3B1bHNlKSA9ICZxdW90OzEmcXVvdDs7ICMgMSQgdG8gZXN0YWJsaXNoIHRoZSBjYWxsPGJyPiR2
YXIoZl9wdWxzZSkgPSAmcXVvdDsxJnF1b3Q7OyAjIDEkIHBlciBzZWNvbmQ8YnI+PGJyPjxicj59
PGJyPjxicj5zcWxfcmVzdWx0X2ZyZWUgKCZxdW90O3JhJnF1b3Q7KTs8YnI+Cjxicj4jIGlmIG9u
bHkgb25lIGNhbGwgaXMgZXN0YWJsaXNoZWQsIHRoYXQgY2FsbCBzaG91bGQgbGFzdCA5IHNlY29u
ZHMuPGJyPjxicj5pZiAoIWNueGNjX3NldF9tYXhfY3JlZGl0KCZxdW90OyR2YXIoY2xpZW50KSZx
dW90Oyw8YnI+JnF1b3Q7JHZhcihjcmVkaXQpJnF1b3Q7LDxicj4mcXVvdDskdmFyKGNvc3RfcGVy
X3NlYykmcXVvdDssPGJyPiZxdW90OyR2YXIoaV9wdWxzZSkmcXVvdDssPGJyPgo8YnI+PGJyPjxi
cj48L2Rpdj48ZGl2PkFuZCB0aGlzIGFyZSB0aGUgdmFsdWVzIGJ5IHN5c2xvZyBpbmZvPGJyPjxi
cj5JTkZPOiAmbHQ7c2NyaXB0Jmd0Ozogc2FsZG86MC4wMDA2NTAwMDAwIHkgc2VnOjAuMDAwNjY2
NjY2NjY2NjY2NjY3IDxicj5FUlJPUjogY254Y2MgW2NueGNjX21vZC5jOjE0MjVdOiBzZXRfbWF4
X2NyZWRpdCgpOiBjcmVkaXQgdmFsdWUgbXVzdCBiZSAmZ3Q7IDA6IDAuMDAwMDAwPGJyPgo8YnI+
PGJyPjxicj48L2Rpdj48ZGl2PsKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqAgPGJy
PjwvZGl2PjwvZGl2PjxkaXYgY2xhc3M9ImdtYWlsX2V4dHJhIj48YnI+PGJyPjxkaXYgY2xhc3M9
ImdtYWlsX3F1b3RlIj5PbiBGcmksIE1heSA5LCAyMDE0IGF0IDM6MDggUE0sIENhcmxvcyBSdWl6
IETDrWF6IDxzcGFuIGRpcj0ibHRyIj4mbHQ7PGEgaHJlZj0ibWFpbHRvOmNhcmxvcy5ydWl6ZGlh
ekBnbWFpbC5jb20iIHRhcmdldD0iX2JsYW5rIj5jYXJsb3MucnVpemRpYXpAZ21haWwuY29tPC9h
PiZndDs8L3NwYW4+IHdyb3RlOjxicj4KPGJsb2NrcXVvdGUgY2xhc3M9ImdtYWlsX3F1b3RlIiBz
dHlsZT0ibWFyZ2luOjAgMCAwIC44ZXg7Ym9yZGVyLWxlZnQ6MXB4ICNjY2Mgc29saWQ7cGFkZGlu
Zy1sZWZ0OjFleCI+PGRpdiBkaXI9Imx0ciI+PGRpdj5IaSw8L2Rpdj48ZGl2Pjxicj48L2Rpdj5D
YW4geW91IHBhc3RlIHRoZSBjb2RlIHlvdSBhcmUgdXNpbmcsIHdpdGggdGhlIHZhbHVlcyB0aGF0
IGVhY2ggdmFyaWFibGUgY29udGFpbiBhdCB0aGUgbW9tZW50IG9mIGluaXRpYXRpbmcgdGhlIGNh
bGw/PGRpdj4KPGJyPjwvZGl2PjxkaXY+UmVnYXJkcyw8L2Rpdj48L2Rpdj48ZGl2IGNsYXNzPSJn
bWFpbF9leHRyYSI+Cjxicj48YnI+PGRpdiBjbGFzcz0iZ21haWxfcXVvdGUiPjxkaXY+PGRpdiBj
bGFzcz0iaDUiPk9uIEZyaSwgTWF5IDksIDIwMTQgYXQgMjozNSBQTSwgUmVuZSBNb250aWx2YSA8
c3BhbiBkaXI9Imx0ciI+Jmx0OzxhIGhyZWY9Im1haWx0bzpyZW5lbW9udGlsdmFAZ21haWwuY29t
IiB0YXJnZXQ9Il9ibGFuayI+cmVuZW1vbnRpbHZhQGdtYWlsLmNvbTwvYT4mZ3Q7PC9zcGFuPiB3
cm90ZTo8YnI+CjwvZGl2PjwvZGl2PjxibG9ja3F1b3RlIGNsYXNzPSJnbWFpbF9xdW90ZSIgc3R5
bGU9Im1hcmdpbjowIDAgMCAuOGV4O2JvcmRlci1sZWZ0OjFweCAjY2NjIHNvbGlkO3BhZGRpbmct
bGVmdDoxZXgiPjxkaXY+PGRpdiBjbGFzcz0iaDUiPgo8ZGl2IGRpcj0ibHRyIj48ZGl2PjxkaXY+
SGkgbGlzdDxicj48YnI+PC9kaXY+SSBkb24mIzM5O3QgdW5kZXJzdGFuZCBwcmVwYWlkIGxvZ2lj
IGNhbGN1bGF0aW9uLCBiZWNhdXNlIHdoZW4gbXkgY3JlZGl0IGlzIDAgb3IgbGVlcyB0aGFuIGNv
c3QgcGVyIHNlY29uZCwgdGhlIGNhbGwgaXMgZXN0YWJsaXNoZWQgZXF1YWw8YnI+PGJyPjwvZGl2
PiR2YXIoaV9wdWxzZSkgYW5kICR2YXIoZl9wdWxzZSkgaG93IHRoaXMgd29ya3M/Pz8/PGJyPgoK
CjxkaXY+PGJyPjxicj48L2Rpdj48L2Rpdj4KPGJyPjwvZGl2PjwvZGl2Pl9fX19fX19fX19fX19f
X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fPGJyPgpTSVAgRXhwcmVzcyBSb3V0ZXIg
KFNFUikgYW5kIEthbWFpbGlvIChPcGVuU0VSKSAtIHNyLXVzZXJzIG1haWxpbmcgbGlzdDxicj4K
PGEgaHJlZj0ibWFpbHRvOnNyLXVzZXJzQGxpc3RzLnNpcC1yb3V0ZXIub3JnIiB0YXJnZXQ9Il9i
bGFuayI+c3ItdXNlcnNAbGlzdHMuc2lwLXJvdXRlci5vcmc8L2E+PGJyPgo8YSBocmVmPSJodHRw
Oi8vbGlzdHMuc2lwLXJvdXRlci5vcmcvY2dpLWJpbi9tYWlsbWFuL2xpc3RpbmZvL3NyLXVzZXJz
IiB0YXJnZXQ9Il9ibGFuayI+aHR0cDovL2xpc3RzLnNpcC1yb3V0ZXIub3JnL2NnaS1iaW4vbWFp
bG1hbi9saXN0aW5mby9zci11c2VyczwvYT48YnI+Cjxicj48L2Jsb2NrcXVvdGU+PC9kaXY+PHNw
YW4gY2xhc3M9IkhPRW5aYiI+PGZvbnQgY29sb3I9IiM4ODg4ODgiPjxicj48YnIgY2xlYXI9ImFs
bCI+PGRpdj48YnI+PC9kaXY+LS0gPGJyPjxkaXYgZGlyPSJsdHIiPkNhcmxvczxkaXY+PGEgaHJl
Zj0iaHR0cDovL2NhcnVpemRpYXouY29tIiB0YXJnZXQ9Il9ibGFuayI+aHR0cDovL2NhcnVpemRp
YXouY29tPC9hPjwvZGl2PjxkaXY+PGEgaHJlZj0iaHR0cDovL25ndm9pY2UuY29tIiB0YXJnZXQ9
Il9ibGFuayI+aHR0cDovL25ndm9pY2UuY29tPC9hPjwvZGl2PgoKPGRpdj48YSBocmVmPSJ0ZWw6
JTJCNTIlMjA1NSUyMDMwNDglMjAzMzAzIiB2YWx1ZT0iKzUyNTUzMDQ4MzMwMyIgdGFyZ2V0PSJf
YmxhbmsiPis1MiA1NSAzMDQ4IDMzMDM8L2E+PC9kaXY+PC9kaXY+CjwvZm9udD48L3NwYW4+PC9k
aXY+Cjxicj5fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fXzxi
cj4KU0lQIEV4cHJlc3MgUm91dGVyIChTRVIpIGFuZCBLYW1haWxpbyAoT3BlblNFUikgLSBzci11
c2VycyBtYWlsaW5nIGxpc3Q8YnI+CjxhIGhyZWY9Im1haWx0bzpzci11c2Vyc0BsaXN0cy5zaXAt
cm91dGVyLm9yZyI+c3ItdXNlcnNAbGlzdHMuc2lwLXJvdXRlci5vcmc8L2E+PGJyPgo8YSBocmVm
PSJodHRwOi8vbGlzdHMuc2lwLXJvdXRlci5vcmcvY2dpLWJpbi9tYWlsbWFuL2xpc3RpbmZvL3Ny
LXVzZXJzIiB0YXJnZXQ9Il9ibGFuayI+aHR0cDovL2xpc3RzLnNpcC1yb3V0ZXIub3JnL2NnaS1i
aW4vbWFpbG1hbi9saXN0aW5mby9zci11c2VyczwvYT48YnI+Cjxicj48L2Jsb2NrcXVvdGU+PC9k
aXY+PGJyPjwvZGl2Pgo=

--===============1571588529==--