<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<p>but btw you can set any variable name with your custom sql in
nibblebill conf like</p>
<pre><param name="custom_sql_lookup" value="SELECT cash AS nibble_hello_balance FROM accounts WHERE account_code='${nibble_account}'"/>
</pre>
<div class="moz-cite-prefix">On 1/15/2018 10:47 AM, Madovsky wrote:<br>
</div>
<blockquote type="cite"
cite="mid:4d1a8be4-cc76-45a3-54b9-6bd288567e2b@madovsky.org">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<p>Sorry I mixed the official var name with mine I use for other
purpose.</p>
<p>it's nibble_balance, not nibble_current_balance<br>
</p>
<div class="moz-cite-prefix">On 1/15/2018 9:50 AM, <a
class="moz-txt-link-abbreviated"
href="mailto:igor.potjevlesch@gmail.com"
moz-do-not-send="true">igor.potjevlesch@gmail.com</a> wrote:<br>
</div>
<blockquote type="cite"
cite="mid:008d01d38e29$61c9ba10$255d2e30$@gmail.com">
<meta http-equiv="Content-Type" content="text/html;
charset=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered
medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
color:black;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
pre
{mso-style-priority:99;
mso-style-link:"Préformaté HTML Car";
margin:0cm;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";
color:black;}
p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
{mso-style-priority:34;
margin-top:0cm;
margin-right:0cm;
margin-bottom:0cm;
margin-left:36.0pt;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
color:black;}
p.msonormal0, li.msonormal0, div.msonormal0
{mso-style-name:msonormal;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
color:black;}
span.PrformatHTMLCar
{mso-style-name:"Préformaté HTML Car";
mso-style-priority:99;
mso-style-link:"Préformaté HTML";
font-family:Consolas;
color:black;}
p.inbox-inbox-p1, li.inbox-inbox-p1, div.inbox-inbox-p1
{mso-style-name:inbox-inbox-p1;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
color:black;}
span.inbox-inbox-s1
{mso-style-name:inbox-inbox-s1;}
span.inbox-inbox-apple-converted-space
{mso-style-name:inbox-inbox-apple-converted-space;}
span.EmailStyle24
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:windowtext;}
span.EmailStyle25
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:windowtext;}
span.EmailStyle26
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:windowtext;}
span.EmailStyle27
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:windowtext;}
span.EmailStyle28
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:windowtext;}
span.EmailStyle29
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:windowtext;}
span.EmailStyle30
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:windowtext;}
span.EmailStyle31
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:windowtext;}
span.EmailStyle32
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:windowtext;}
span.EmailStyle33
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:windowtext;}
span.EmailStyle34
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:windowtext;}
span.EmailStyle35
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:windowtext;}
span.EmailStyle36
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:windowtext;}
span.EmailStyle37
{mso-style-type:personal;
font-family:"Calibri",sans-serif;
color:windowtext;}
span.EmailStyle39
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 70.85pt 70.85pt 70.85pt;}
div.WordSection1
{page:WordSection1;}
/* List Definitions */
@list l0
{mso-list-id:244918271;
mso-list-type:hybrid;
mso-list-template-ids:1201440206 67895311 67895321 67895323 67895311 67895321 67895323 67895311 67895321 67895323;}
@list l0:level1
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l0:level2
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l0:level3
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
@list l0:level4
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l0:level5
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l0:level6
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
@list l0:level7
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l0:level8
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l0:level9
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
@list l1
{mso-list-id:1505319215;
mso-list-template-ids:1531709166;}
ol
{margin-bottom:0cm;}
ul
{margin-bottom:0cm;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
<div class="WordSection1">
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB">Ah ok, I didn't know nibble_current_balance.<br>
So with something like that should work, but unfortunately
not:<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB"><o:p> </o:p></span></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB"><action application="set"
data="nibble_account=98"/><o:p></o:p></span></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB"><action application="set"
data="nibble_rate=0.0115"/><o:p></o:p></span></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB"><action application="set"
data="nibble_minimum=1"/><o:p></o:p></span></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB"><action application="set"
data="nibble_rounding=2"/><o:p></o:p></span></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB"><action application="set" data="heartbeat
1"/><o:p></o:p></span></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB"><action application="set"
data="nibble_current_balance" inline="true"/><o:p></o:p></span></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB"><condition break="on-true"
field="${cond(${nibble_current_balance} <= 0 ? YES :
NO)}" expression="^YES$"><o:p></o:p></span></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB"> </span><span
style="color:windowtext;mso-fareast-language:EN-US"><action
application="hangup" data="hangup_cause"/><o:p></o:p></span></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"></condition><o:p></o:p></span></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB">The call is processed whereas balance in DB
is equal to 0.<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1
1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span style="color:windowtext">De :</span></b><span
style="color:windowtext"> FreeSWITCH-users [<a
class="moz-txt-link-freetext"
href="mailto:freeswitch-users-bounces@lists.freeswitch.org"
moz-do-not-send="true">mailto:freeswitch-users-bounces@lists.freeswitch.org</a>]
<b>De la part de</b> Madovsky<br>
<b>Envoyé :</b> lundi 15 janvier 2018 17:59<br>
<b>À :</b> 'FreeSWITCH Users Help' <a
class="moz-txt-link-rfc2396E"
href="mailto:freeswitch-users@lists.freeswitch.org"
moz-do-not-send="true"><freeswitch-users@lists.freeswitch.org></a><br>
<b>Objet :</b> Re: [Freeswitch-users] Use Nibblebill
with PostgreSQL<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">>
<span style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB">I don't understand what is supposed to do the
SQL request? I think that, indeed, nibble_balance is not
set at the moment of the condition.</span><o:p></o:p></p>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><o:p> </o:p></p>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB">when you set the nibble account so nibblebill
makes the SQL request you set in its config</span><o:p></o:p></p>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB">to populate nibble_current_balance, so if you
make a condition with nibble_current_balance just after
set nibble_account</span><o:p></o:p></p>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB">so you should set it inline to make the
condition available</span><o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal">On 1/15/2018 5:29 AM, <a
href="mailto:igor.potjevlesch@gmail.com"
moz-do-not-send="true">igor.potjevlesch@gmail.com</a>
wrote:<o:p></o:p></p>
</div>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US">Hello,</span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"> </span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB">I'm still stuck with Nibblebill config.
Even if the current balance is 0 or negative, the
dialplan start the call.</span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB"> </span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB">Someone would have some examples of config
where this behaviour is avoided? Thank you!</span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB"> </span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB">Regards,</span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB"> </span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB">Igor.</span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB"> </span><o:p></o:p></p>
<div>
<div style="border:none;border-top:solid #E1E1E1
1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span style="color:windowtext">De :</span></b><span
style="color:windowtext"> <a
href="mailto:igor.potjevlesch@gmail.com"
moz-do-not-send="true">igor.potjevlesch@gmail.com</a>
[<a href="mailto:igor.potjevlesch@gmail.com"
moz-do-not-send="true">mailto:igor.potjevlesch@gmail.com</a>]
<br>
<b>Envoyé :</b> mercredi 10 janvier 2018 15:49<br>
<b>À :</b> 'Madovsky' <a
href="mailto:infos@madovsky.org"
moz-do-not-send="true"><infos@madovsky.org></a><br>
<b>Objet :</b> RE: [Freeswitch-users] Use Nibblebill
with PostgreSQL</span><o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB">This is the log: Action log(INFO
${nibble_balance} is equal or lower than 0)</span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB">With or without "set nibble_balance". So I
guess that this variable is undefined.</span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB"> </span><o:p></o:p></p>
<div>
<div style="border:none;border-top:solid #E1E1E1
1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span style="color:windowtext"
lang="EN-GB">De :</span></b><span
style="color:windowtext" lang="EN-GB"> <a
href="mailto:igor.potjevlesch@gmail.com"
moz-do-not-send="true">igor.potjevlesch@gmail.com</a>
[<a href="mailto:igor.potjevlesch@gmail.com"
moz-do-not-send="true">mailto:igor.potjevlesch@gmail.com</a>]
<br>
<b>Envoyé :</b> mercredi 10 janvier 2018 15:39<br>
<b>À :</b> 'Madovsky' <<a
href="mailto:infos@madovsky.org"
moz-do-not-send="true">infos@madovsky.org</a>><br>
<b>Objet :</b> RE: [Freeswitch-users] Use Nibblebill
with PostgreSQL</span><o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"><span lang="EN-GB"> </span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB">I don't understand what is supposed to do
the SQL request? I think that, indeed, nibble_balance is
not set at the moment of the condition.</span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB"> </span><o:p></o:p></p>
<div>
<div style="border:none;border-top:solid #E1E1E1
1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span style="color:windowtext">De :</span></b><span
style="color:windowtext"> Madovsky [<a
href="mailto:infos@madovsky.org"
moz-do-not-send="true">mailto:infos@madovsky.org</a>]
<br>
<b>Envoyé :</b> mardi 9 janvier 2018 21:24<br>
<b>À :</b> <a
href="mailto:igor.potjevlesch@gmail.com"
moz-do-not-send="true">igor.potjevlesch@gmail.com</a><br>
<b>Objet :</b> Re: [Freeswitch-users] Use Nibblebill
with PostgreSQL</span><o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal" style="margin-bottom:12.0pt">you should
remove<br>
<span style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB"><br>
<action application="set" data="nibble_balance"
inline="true"/><br>
<br>
since when you populate nibble_account it makes
automatically the SQL request<br>
and populate nibble_balance.<br>
then don't forget to put all nibble variables on the
bridge <br>
like {nibble_account=${nibble_account},etc.}sofia/xxx</span><o:p></o:p></p>
<div>
<p class="MsoNormal">On 1/9/2018 8:14 AM, <a
href="mailto:igor.potjevlesch@gmail.com"
moz-do-not-send="true">igor.potjevlesch@gmail.com</a>
wrote:<o:p></o:p></p>
</div>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB">I didn't. What does it mean "inline" in
that case?</span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB"> </span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB">I tried like this and add "inline" on all
settings. So, now the dialplan looks like this:</span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB"> </span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB"> <action
application="set" data="nibble_account=1"
inline="true"/></span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB"> <action
application="set" data="nibble_rate=1"
inline="true"/></span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB"> <action
application="set" data="nibble_minimum=1"
inline="true"/></span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB"> <action
application="set" data="nibble_rounding=2"
inline="true"/></span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB"> <action
application="set" data="nibble_balance"
inline="true"/></span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB"> <action
application="nibblebill" data="heartbeat 1"/></span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB"> <condition
break="on-true" field="${cond(${nibble_balance} <=
0 ? YES : NO)}" expression="^YES$"></span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB"> <action
application="log" data="INFO ${nibble_balance} is
equal or lower than 0"/></span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB"> </condition></span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB"> </span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB"> <action
application="bridge"
data="{nibble_account=1,nibble_rate=1,nibble_minimum=1,nibble_rounding=2,absolute_codec_string=PCMA,101,sip_invite_domain=$${ext-sip-ip}}sofia/gateway/outbound/0$1"/></span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB"> </span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB">The logs are showing the following
outputs and the call start:</span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB"> </span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB">8d308628-f555-11e7-9064-df48dc662f2c |---
Dialplan: <a
href="mailto:sofia/client_in/+123456789@A.B.C.D"
moz-do-not-send="true">sofia/client_in/+123456789@A.B.C.D</a>
Action set(nibble_account=1) INLINE</span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB">8d308628-f555-11e7-9064-df48dc662f2c
EXECUTE <a
href="mailto:sofia/client_in/+123456789@A.B.C.D"
moz-do-not-send="true">sofia/client_in/+123456789@A.B.C.D</a>
set(nibble_account=1)</span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB">8d308628-f555-11e7-9064-df48dc662f2c
2018-01-09 16:55:44.782489 [DEBUG] mod_dptools.c:1548
SET <a
href="mailto:sofia/client_in/+123456789@A.B.C.D"
moz-do-not-send="true">sofia/client_in/+123456789@A.B.C.D</a>
[nibble_account]=[1]</span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB">8d308628-f555-11e7-9064-df48dc662f2c |---
Dialplan: <a
href="mailto:sofia/client_in/+123456789@A.B.C.D"
moz-do-not-send="true">sofia/client_in/+123456789@A.B.C.D</a>
Action set(nibble_rate=1) INLINE</span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB">8d308628-f555-11e7-9064-df48dc662f2c
EXECUTE <a
href="mailto:sofia/client_in/+123456789@A.B.C.D"
moz-do-not-send="true">sofia/client_in/+123456789@A.B.C.D</a>
set(nibble_rate=1)</span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB">8d308628-f555-11e7-9064-df48dc662f2c
2018-01-09 16:55:44.782489 [DEBUG] mod_dptools.c:1548
SET <a
href="mailto:sofia/client_in/+123456789@A.B.C.D"
moz-do-not-send="true">sofia/client_in/+123456789@A.B.C.D</a>
[nibble_rate]=[1]</span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB">8d308628-f555-11e7-9064-df48dc662f2c |---
Dialplan: <a
href="mailto:sofia/client_in/+123456789@A.B.C.D"
moz-do-not-send="true">sofia/client_in/+123456789@A.B.C.D</a>
Action set(nibble_minimum=1) INLINE</span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB">8d308628-f555-11e7-9064-df48dc662f2c
EXECUTE <a
href="mailto:sofia/client_in/+123456789@A.B.C.D"
moz-do-not-send="true">sofia/client_in/+123456789@A.B.C.D</a>
set(nibble_minimum=1)</span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB">8d308628-f555-11e7-9064-df48dc662f2c
2018-01-09 16:55:44.782489 [DEBUG] mod_dptools.c:1548
SET <a
href="mailto:sofia/client_in/+123456789@A.B.C.D"
moz-do-not-send="true">sofia/client_in/+123456789@A.B.C.D</a>
[nibble_minimum]=[1]</span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB">8d308628-f555-11e7-9064-df48dc662f2c |---
Dialplan: <a
href="mailto:sofia/client_in/+123456789@A.B.C.D"
moz-do-not-send="true">sofia/client_in/+123456789@A.B.C.D</a>
Action set(nibble_rounding=2) INLINE</span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB">8d308628-f555-11e7-9064-df48dc662f2c
EXECUTE <a
href="mailto:sofia/client_in/+123456789@A.B.C.D"
moz-do-not-send="true">sofia/client_in/+123456789@A.B.C.D</a>
set(nibble_rounding=2)</span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB">8d308628-f555-11e7-9064-df48dc662f2c
2018-01-09 16:55:44.782489 [DEBUG] mod_dptools.c:1548
SET <a
href="mailto:sofia/client_in/+123456789@A.B.C.D"
moz-do-not-send="true">sofia/client_in/+123456789@A.B.C.D</a>
[nibble_rounding]=[2]</span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB">8d308628-f555-11e7-9064-df48dc662f2c |---
Dialplan: <a
href="mailto:sofia/client_in/+123456789@A.B.C.D"
moz-do-not-send="true">sofia/client_in/+123456789@A.B.C.D</a>
Action set(nibble_balance) INLINE</span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB">8d308628-f555-11e7-9064-df48dc662f2c
EXECUTE <a
href="mailto:sofia/client_in/+123456789@A.B.C.D"
moz-do-not-send="true">sofia/client_in/+123456789@A.B.C.D</a>
set(nibble_balance)</span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB">8d308628-f555-11e7-9064-df48dc662f2c
2018-01-09 16:55:44.782489 [DEBUG] mod_dptools.c:1548
SET <a
href="mailto:sofia/client_in/+123456789@A.B.C.D"
moz-do-not-send="true">sofia/client_in/+123456789@A.B.C.D</a>
[nibble_balance]=[UNDEF]</span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB">8d308628-f555-11e7-9064-df48dc662f2c |---
Dialplan: <a
href="mailto:sofia/client_in/+123456789@A.B.C.D"
moz-do-not-send="true">sofia/client_in/+123456789@A.B.C.D</a>
Action nibblebill(heartbeat 1)</span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB">8d308628-f555-11e7-9064-df48dc662f2c |---
Dialplan: <a
href="mailto:sofia/client_in/+123456789@A.B.C.D"
moz-do-not-send="true">sofia/client_in/+123456789@A.B.C.D</a>
Action
bridge({nibble_account=1,nibble_rate=1,nibble_minimum=1,nibble_rounding=2,absolute_codec_string=PCMA,101,sip_invite_domain=}sofia/gateway/out/0123456789)</span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB">8d308628-f555-11e7-9064-df48dc662f2c |---
Dialplan: <a
href="mailto:sofia/client_in/+123456789@A.B.C.D"
moz-do-not-send="true">sofia/client_in/+123456789@A.B.C.D</a>
Action hangup(hangup_cause)</span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB"> </span><o:p></o:p></p>
<div>
<div style="border:none;border-top:solid #E1E1E1
1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span style="color:windowtext">De :</span></b><span
style="color:windowtext"> Madovsky [<a
href="mailto:infos@madovsky.org"
moz-do-not-send="true">mailto:infos@madovsky.org</a>]
<br>
<b>Envoyé :</b> lundi 8 janvier 2018 19:52<br>
<b>À :</b> <a
href="mailto:igor.potjevlesch@gmail.com"
moz-do-not-send="true">igor.potjevlesch@gmail.com</a><br>
<b>Objet :</b> Re: [Freeswitch-users] Use
Nibblebill with PostgreSQL</span><o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"> <o:p></o:p></p>
<p>did you set nibble balance inline="true" before the
condition?<o:p></o:p></p>
<p>also check with log just after you set the var to be
sure the SQL return a value<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<div>
<p class="MsoNormal">On 1/8/2018 10:24 AM, <a
href="mailto:igor.potjevlesch@gmail.com"
moz-do-not-send="true">igor.potjevlesch@gmail.com</a>
wrote:<o:p></o:p></p>
</div>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US">I
basically tried this:</span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB"><condition break="on-true"
field="${cond(${nibble_balance} <= 0 ? YES :
NO)}" expression="^YES$"></span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB"> <action
application="log" data="INFO ${nibble_balance} is
equal or lower than 0"/></span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB"> </span><span
style="color:windowtext;mso-fareast-language:EN-US"></condition></span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"> </span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB">But I didn't see anything in the logs,
the call begin to start.</span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB"> </span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB">Regards,</span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB"> </span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB">Igor</span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB"> </span><o:p></o:p></p>
<div>
<div style="border:none;border-top:solid #E1E1E1
1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span
style="color:windowtext">De :</span></b><span
style="color:windowtext"> Madovsky [<a
href="mailto:infos@madovsky.org"
moz-do-not-send="true">mailto:infos@madovsky.org</a>]
<br>
<b>Envoyé :</b> vendredi 5 janvier 2018 14:44<br>
<b>À :</b> <a
href="mailto:igor.potjevlesch@gmail.com"
moz-do-not-send="true">igor.potjevlesch@gmail.com</a><br>
<b>Objet :</b> Re: [Freeswitch-users] Use
Nibblebill with PostgreSQL</span><o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"> <o:p></o:p></p>
<p>Yes in a nested condition for ex.<o:p></o:p></p>
<p>this method is more robust that trust nibblebill to
do all the job<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<div>
<p class="MsoNormal">On 1/5/2018 5:33 AM, <a
href="mailto:igor.potjevlesch@gmail.com"
moz-do-not-send="true">igor.potjevlesch@gmail.com</a>
wrote:<o:p></o:p></p>
</div>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB">It means that I can test
${nibble_balance} before right?</span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB"> </span><o:p></o:p></p>
<div>
<div style="border:none;border-top:solid #E1E1E1
1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span
style="color:windowtext">De :</span></b><span
style="color:windowtext"> Madovsky [<a
href="mailto:infos@madovsky.org"
moz-do-not-send="true">mailto:infos@madovsky.org</a>]
<br>
<b>Envoyé :</b> jeudi 4 janvier 2018 20:31<br>
<b>À :</b> <a
href="mailto:igor.potjevlesch@gmail.com"
moz-do-not-send="true">igor.potjevlesch@gmail.com</a><br>
<b>Objet :</b> Re: [Freeswitch-users] Use
Nibblebill with PostgreSQL</span><o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"> <o:p></o:p></p>
<p>you should make a nested condition before the
bridge<o:p></o:p></p>
<p>and if the balance not good transfer the call to
hangup or something else<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<div>
<p class="MsoNormal">On 1/4/2018 8:03 AM, <a
href="mailto:igor.potjevlesch@gmail.com"
moz-do-not-send="true">igor.potjevlesch@gmail.com</a>
wrote:<o:p></o:p></p>
</div>
<blockquote
style="margin-top:5.0pt;margin-bottom:5.0pt">
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB">I uncommented this in the config
file of nibblebill:</span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB"> </span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB"><param name="custom_sql_lookup"
value="SELECT euros AS nibble_balance FROM solde
WHERE customer_id='${nibble_account}'"/></span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB"> </span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB">The request is working fine
according to the logs, but the call is still
placed with the logs:</span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB"> </span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB">2018-01-04 16:59:07.571051 [DEBUG]
mod_nibblebill.c:422 Doing lookup query</span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB">[SELECT euros AS nibble_balance
FROM solde WHERE customer_id='1']</span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB">2018-01-04 16:59:07.571051 [DEBUG]
mod_nibblebill.c:430 Retrieved current balance
for account 1 (balance = -0.040000)</span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB">31fe25c6-f168-11e7-a065-b10720ff818b
2018-01-04 16:59:07.571051 [DEBUG]
mod_nibblebill.c:523 Comparing -0.040000 to
hangup balance of 1.000000, taking into account
minimum charge of 1.000000</span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB">31fe25c6-f168-11e7-a065-b10720ff818b
2018-01-04 16:59:07.571051 [DEBUG]
mod_nibblebill.c:526 Balance of -0.040000 fell
below allowed amount of 1.000000! (Account 1)</span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB"> </span><o:p></o:p></p>
<div>
<div style="border:none;border-top:solid #E1E1E1
1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span
style="color:windowtext">De :</span></b><span
style="color:windowtext"> Madovsky [<a
href="mailto:infos@madovsky.org"
moz-do-not-send="true">mailto:infos@madovsky.org</a>]
<br>
<b>Envoyé :</b> jeudi 4 janvier 2018 16:37<br>
<b>À :</b> <a
href="mailto:igor.potjevlesch@gmail.com"
moz-do-not-send="true">igor.potjevlesch@gmail.com</a><br>
<b>Objet :</b> Re: [Freeswitch-users] Use
Nibblebill with PostgreSQL</span><o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"> <o:p></o:p></p>
<p>add an sql request into nibblebill and link it to
nibble_balance variables inline in diaplan<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<div>
<p class="MsoNormal">On 1/4/2018 7:35 AM, <a
href="mailto:igor.potjevlesch@gmail.com"
moz-do-not-send="true">igor.potjevlesch@gmail.com</a>
wrote:<o:p></o:p></p>
</div>
<blockquote
style="margin-top:5.0pt;margin-bottom:5.0pt">
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB">Yes, why not, but I don't find
how to check the balance before a bridge.</span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB"> </span><o:p></o:p></p>
<div>
<div style="border:none;border-top:solid #E1E1E1
1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span
style="color:windowtext">De :</span></b><span
style="color:windowtext"> Madovsky [<a
href="mailto:infos@madovsky.org"
moz-do-not-send="true">mailto:infos@madovsky.org</a>]
<br>
<b>Envoyé :</b> jeudi 4 janvier 2018 16:29<br>
<b>À :</b> <a
href="mailto:igor.potjevlesch@gmail.com"
moz-do-not-send="true">igor.potjevlesch@gmail.com</a><br>
<b>Objet :</b> Re: [Freeswitch-users] Use
Nibblebill with PostgreSQL</span><o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"> <o:p></o:p></p>
<p>it starts because you don't have any user
linked to your nibble_account<o:p></o:p></p>
<p>so the only way to not start the call is to
create a condition with the nibble balance
before<o:p></o:p></p>
<p>the bridge<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<div>
<p class="MsoNormal">On 1/4/2018 7:22 AM, <a
href="mailto:igor.potjevlesch@gmail.com"
moz-do-not-send="true">igor.potjevlesch@gmail.com</a>
wrote:<o:p></o:p></p>
</div>
<blockquote
style="margin-top:5.0pt;margin-bottom:5.0pt">
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB">I did this:</span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB">dca705f8-f161-11e7-9f81-b10720ff818b
|--- Dialplan: <a
href="mailto:sofia/trunk1/+4425482090@A.B.C.D"
moz-do-not-send="true">sofia/trunk1/+4425482090@A.B.C.D</a>
Action set(nibble_account=1)</span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB">dca705f8-f161-11e7-9f81-b10720ff818b
|--- Dialplan: sofia/trunk1 <a
href="mailto:/+4425482090@A.B.C.D"
moz-do-not-send="true">/+4425482090@A.B.C.D</a>
Action set(nibble_rate=1)</span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB">dca705f8-f161-11e7-9f81-b10720ff818b
|--- Dialplan: <a
href="mailto:sofia/trunk1/+4425482090@A.B.C.D"
moz-do-not-send="true">sofia/trunk1/+4425482090@A.B.C.D</a>
Action set(nibble_minimum=1)</span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB">dca705f8-f161-11e7-9f81-b10720ff818b
|--- Dialplan: <a
href="mailto:sofia/trunk1/+4425482090@A.B.C.D"
moz-do-not-send="true">sofia/trunk1/+4425482090@A.B.C.D</a>
Action set(nibble_rounding=2)</span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB">dca705f8-f161-11e7-9f81-b10720ff818b
|--- Dialplan: <a
href="mailto:sofia/trunk1/+4425482090@A.B.C.D"
moz-do-not-send="true">sofia/trunk1/+4425482090@A.B.C.D</a>
Action nibblebill(heartbeat 1)</span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB">dca705f8-f161-11e7-9f81-b10720ff818b
|--- Dialplan: <a
href="mailto:sofia/trunk1/+4425482090@A.B.C.D"
moz-do-not-send="true">sofia/trunk1/+4425482090@A.B.C.D</a>
Action
bridge({nibble_account=1,nibble_rate=1,nibble_minimum=1,nibble_rounding=2,absolute_codec_string=PCMA,101,sip_invite_domain=}sofia/gateway/out_1/0123456789)</span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB">[…]</span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB">2018-01-04 16:13:47.410971
[DEBUG] mod_nibblebill.c:430 Retrieved
current balance for account 1 (balance =
0.000000)</span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB">dca7b05c-f161-11e7-9f9a-b10720ff818b
2018-01-04 16:13:47.410971 [DEBUG]
mod_nibblebill.c:523 Comparing 0.000000 to
hangup balance of 1.000000, taking into
account minimum charge of 1.000000</span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB">dca7b05c-f161-11e7-9f9a-b10720ff818b
2018-01-04 16:13:47.410971 [DEBUG]
mod_nibblebill.c:526 Balance of 0.000000
fell below allowed amount of 1.000000!
(Account 1)</span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB"> </span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB">But the call still starts. </span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB"> </span><o:p></o:p></p>
<div>
<div style="border:none;border-top:solid
#E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span
style="color:windowtext">De :</span></b><span
style="color:windowtext"> Madovsky [<a
href="mailto:infos@madovsky.org"
moz-do-not-send="true">mailto:infos@madovsky.org</a>]
<br>
<b>Envoyé :</b> jeudi 4 janvier 2018
16:09<br>
<b>À :</b> <a
href="mailto:igor.potjevlesch@gmail.com"
moz-do-not-send="true">igor.potjevlesch@gmail.com</a><br>
<b>Objet :</b> Re: [Freeswitch-users]
Use Nibblebill with PostgreSQL</span><o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"> <o:p></o:p></p>
<p>the nibblebill variables must be on the
bridge like<o:p></o:p></p>
<p><span style="mso-fareast-language:EN-US"
lang="EN-GB"><action application="bridge"
data="{nibble_account=1,nibble_rate=1,etc....absolute_codec_string=PCMA,101,sip_invite_domain=$${ext-sip-ip}}sofia/gateway/out_01/0$1"/></span><o:p></o:p></p>
<p class="MsoNormal"
style="margin-bottom:12.0pt">do not use
"export" since I noticed some strange behavior
with it.<br>
I don't know how nibblebill behaves without a
nibble_account linked to a user account,<br>
so I cannot help for this case<o:p></o:p></p>
<div>
<p class="MsoNormal">On 1/4/2018 7:06 AM, <a
href="mailto:igor.potjevlesch@gmail.com"
moz-do-not-send="true">igor.potjevlesch@gmail.com</a>
wrote:<o:p></o:p></p>
</div>
<blockquote
style="margin-top:5.0pt;margin-bottom:5.0pt">
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB">I don't have a registered
user. It's a peer trusted by his IP
address.</span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB">During the call the credit is
updated every seconds but even without
credit, the call start and stop
immediately.</span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB"> </span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB">Yes I know. I will switch to
more reasonable value after my tests. </span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB"> </span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB">What do you mean by "export
all nibblebill variables to the bridge"?</span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB"> </span><o:p></o:p></p>
<div>
<div style="border:none;border-top:solid
#E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span
style="color:windowtext">De :</span></b><span
style="color:windowtext"> Madovsky [<a
href="mailto:infos@madovsky.org"
moz-do-not-send="true">mailto:infos@madovsky.org</a>]
<br>
<b>Envoyé :</b> jeudi 4 janvier 2018
15:52<br>
<b>À :</b> <a
href="mailto:igor.potjevlesch@gmail.com"
moz-do-not-send="true">igor.potjevlesch@gmail.com</a><br>
<b>Objet :</b> Re: [Freeswitch-users]
Use Nibblebill with PostgreSQL</span><o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"> <o:p></o:p></p>
<p>> <span
style="mso-fareast-language:EN-US"
lang="EN-GB"><action application="set"
data="nibble_account=1"/></span><o:p></o:p></p>
<p><span style="mso-fareast-language:EN-US"
lang="EN-GB">is 1 a valid nibble_account
of a registered user?</span><o:p></o:p></p>
<p><span style="mso-fareast-language:EN-US"
lang="EN-GB">> <action
application="nibblebill" data="check"/></span><o:p></o:p></p>
<p><span style="mso-fareast-language:EN-US"
lang="EN-GB">you dont' need to check, as
nibblebill automatically check the balance</span><o:p></o:p></p>
<p><span style="mso-fareast-language:EN-US"
lang="EN-GB">if the nibble_account is
linked to a registered user</span><o:p></o:p></p>
<p><span style="mso-fareast-language:EN-US"
lang="EN-GB">> <action
application="nibblebill" data="heartbeat
1"/></span><o:p></o:p></p>
<p><span style="mso-fareast-language:EN-US"
lang="EN-GB">be aware that heartbeat to 1
means a request to your DB every second</span><o:p></o:p></p>
<p><span style="mso-fareast-language:EN-US"
lang="EN-GB">about your issue you should
export all nibblebill variables to the
bridge too</span><o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<div>
<p class="MsoNormal">On 1/4/2018 6:46 AM, <a
href="mailto:igor.potjevlesch@gmail.com"
moz-do-not-send="true">igor.potjevlesch@gmail.com</a>
wrote:<o:p></o:p></p>
</div>
<blockquote
style="margin-top:5.0pt;margin-bottom:5.0pt">
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB">That's the case:</span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB"> <condition
break="on-true"
expression="^\+44([1-9][0-9]{8})$"
field="destination_number"></span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB"> <action
application="set"
data="nibble_account=1"/></span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB"> <action
application="nibblebill"
data="check"/></span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB"> <action
application="set"
data="nibble_rate=1"/></span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB"> <action
application="set"
data="nibble_minimum=1"/></span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB"> <action
application="set"
data="nibble_rounding=2"/></span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB"> <action
application="nibblebill" data="heartbeat
1"/></span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB"> <action
application="bridge"
data="{absolute_codec_string=PCMA,101,sip_invite_domain=$${ext-sip-ip}}sofia/gateway/out_01/0$1"/></span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB"> <action
application="hangup"
data="hangup_cause"/></span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB">
</condition></span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB"> </span><o:p></o:p></p>
<div>
<div style="border:none;border-top:solid
#E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span
style="color:windowtext">De :</span></b><span
style="color:windowtext"> Madovsky [<a
href="mailto:infos@madovsky.org"
moz-do-not-send="true">mailto:infos@madovsky.org</a>]
<br>
<b>Envoyé :</b> jeudi 4 janvier 2018
12:41<br>
<b>À :</b> <a
href="mailto:igor.potjevlesch@gmail.com"
moz-do-not-send="true">igor.potjevlesch@gmail.com</a><br>
<b>Objet :</b> Re:
[Freeswitch-users] Use Nibblebill
with PostgreSQL</span><o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"> <o:p></o:p></p>
<div>
<p class="MsoNormal">you must check or set
nibble_account before the call<br>
<br>
On 1/4/2018 3:35 AM, <a
href="mailto:igor.potjevlesch@gmail.com"
moz-do-not-send="true">igor.potjevlesch@gmail.com</a>
wrote:<o:p></o:p></p>
</div>
<blockquote
style="margin-top:5.0pt;margin-bottom:5.0pt">
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US">Hello,</span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"> </span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB">Finally the billing works
good. Would it be possible to setup
the rates in db? I don't find example
or documentation related to this.</span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB"> </span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB">Also, I don't understand
why the call is allowed for bridging
whereas the balance is 0 or negative?</span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB"> </span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB">Regards,</span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB"> </span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB">Igor.</span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB"> </span><o:p></o:p></p>
<div>
<div style="border:none;border-top:solid
#E1E1E1 1.0pt;padding:3.0pt 0cm 0cm
0cm">
<p class="MsoNormal"><b><span
style="color:windowtext">De :</span></b><span
style="color:windowtext"> <a
href="mailto:igor.potjevlesch@gmail.com"
moz-do-not-send="true">igor.potjevlesch@gmail.com</a>
[<a
href="mailto:igor.potjevlesch@gmail.com"
moz-do-not-send="true">mailto:igor.potjevlesch@gmail.com</a>]
<br>
<b>Envoyé :</b> jeudi 4 janvier
2018 10:19<br>
<b>À :</b> 'FreeSWITCH Users Help'
<a
href="mailto:freeswitch-users@lists.freeswitch.org"
moz-do-not-send="true"><freeswitch-users@lists.freeswitch.org></a><br>
<b>Objet :</b> RE:
[Freeswitch-users] Use Nibblebill
with PostgreSQL</span><o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US">Hello,</span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB"><br>
Thank you!</span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB">Both db_dsn and odbc-dsn
work. db-dsn fails.</span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB">I keep the version with
odbc-dsn because in that case I don't
have the warning about deprecated
function for versions earlier than
1.4.2 even if I run 1.6.</span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB"> </span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB">What is the best
according to you? db_dsn or odbc-dsn?</span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB"> </span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB">I have additional
questions related to nibble:</span><o:p></o:p></p>
<ol style="margin-top:0cm" start="1"
type="1">
<li class="MsoNormal"
style="color:windowtext;mso-list:l0
level1 lfo3"><span
style="mso-fareast-language:EN-US"
lang="EN-GB">After hanging up the
call, I see in the logs the good
value: "mod_nibblebill.c:590 Billing
$0.000234" but some line after there
is another update:
"mod_nibblebill.c:622 Rounding to
precision 1.000000, total 1.000000
(0.999793 excess)". So the call is
billed 1 instead of 0.000234. </span><o:p></o:p></li>
<li class="MsoNormal"
style="color:windowtext;mso-list:l0
level1 lfo3"><span
style="mso-fareast-language:EN-US"
lang="EN-GB">Is it possible to setup
in the db scheme different prefixes
and their rate? Instead of putting
them raw in the dialplan or any
other config file?</span><o:p></o:p></li>
</ol>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB"> </span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB">Thank you in advance for
your clarification.<br>
<br>
Regards,</span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB"> </span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB">Igor.</span><o:p></o:p></p>
<p class="MsoNormal"><span
style="color:windowtext;mso-fareast-language:EN-US"
lang="EN-GB"> </span><o:p></o:p></p>
<div>
<div style="border:none;border-top:solid
#E1E1E1 1.0pt;padding:3.0pt 0cm 0cm
0cm">
<p class="MsoNormal"><b><span
style="color:windowtext">De :</span></b><span
style="color:windowtext">
FreeSWITCH-users [<a
href="mailto:freeswitch-users-bounces@lists.freeswitch.org"
moz-do-not-send="true">mailto:freeswitch-users-bounces@lists.freeswitch.org</a>]
<b>De la part de</b> Madovsky<br>
<b>Envoyé :</b> mercredi 3 janvier
2018 22:18<br>
<b>À :</b> <a
href="mailto:freeswitch-users@lists.freeswitch.org"
moz-do-not-send="true">freeswitch-users@lists.freeswitch.org</a><br>
<b>Objet :</b> Re:
[Freeswitch-users] Use Nibblebill
with PostgreSQL</span><o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"> <o:p></o:p></p>
<p>If you compiled FS with
--enable-core-odbc-support so you can
use<o:p></o:p></p>
<p><param name="odbc-dsn"
value="pgsql://hostaddr=xx.xx.xx.xx
port=xxxx dbname=xxx user=xxx
password='xxxx' options='-c
client_min_messages=NOTICE'
application_name='freeswitch'" /><o:p></o:p></p>
<p>you must set odbc.ini<o:p></o:p></p>
<div>
<p class="MsoNormal">On 1/3/2018 1:02
PM, Geoff Mina wrote:<o:p></o:p></p>
</div>
<blockquote
style="margin-top:5.0pt;margin-bottom:5.0pt">
<p class="MsoNormal">I think the param
is db-dsn. Not the underscore
version. <o:p></o:p></p>
<div>
<p class="MsoNormal"
style="margin-bottom:12.0pt"><br>
On Jan 3, 2018, at 12:59 PM, Sergey
Safarov <<a
href="mailto:s.safarov@gmail.com"
moz-do-not-send="true">s.safarov@gmail.com</a>>
wrote:<o:p></o:p></p>
</div>
<blockquote
style="margin-top:5.0pt;margin-bottom:5.0pt">
<div>
<div>
<p class="MsoNormal">I used
connection string<o:p></o:p></p>
<p class="inbox-inbox-p1"><span
class="inbox-inbox-apple-converted-space"><span
style="color:blue"> </span></span><span
class="inbox-inbox-s1"><span
style="color:blue"><param
name="db_dsn"
value="pgsql://hostaddr=127.0.0.1
dbname=******* user=*******
password=*******"/></span></span><o:p></o:p></p>
<p class="inbox-inbox-p1"><span
class="inbox-inbox-s1">Sergey</span><o:p></o:p></p>
</div>
<p class="MsoNormal"> <o:p></o:p></p>
<div>
<div>
<p class="MsoNormal">ср, 3 янв.
2018 г. в 22:06, <<a
href="mailto:igor.potjevlesch@gmail.com"
moz-do-not-send="true">igor.potjevlesch@gmail.com</a>>:<o:p></o:p></p>
</div>
<blockquote
style="border:none;border-left:solid
#CCCCCC 1.0pt;padding:0cm 0cm
0cm
6.0pt;margin-left:4.8pt;margin-top:5.0pt;margin-right:0cm;margin-bottom:5.0pt">
<div>
<div>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">Hello
!<o:p></o:p></p>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span
lang="EN-GB">I try to
connect Nibblebill
directly to PostgreSQL
but it still fails.</span><o:p></o:p></p>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span
lang="EN-GB">I follow
the documentation and
setup the param like
this: <param
name="odbc_dsn"
value="pgsql://A.B.C.D
dbname=prepaid
user=prepaid
password=<hidden>"/></span><o:p></o:p></p>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span
lang="EN-GB"> </span><o:p></o:p></p>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span
lang="EN-GB">When I
hangup a call, the logs
report the following:
52c8b77c-f0b8-11e7-8d19-5566a3fb77f6
2018-01-03
20:00:19.037333 [CRIT]
mod_nibblebill.c:604
Failed to log to
database!</span><o:p></o:p></p>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span
lang="EN-GB"> </span><o:p></o:p></p>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span
lang="EN-GB">Any idea on
how to proceed with FS
1.6? Thank you!</span><o:p></o:p></p>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span
lang="EN-GB"> </span><o:p></o:p></p>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span
lang="EN-GB">Regards,</span><o:p></o:p></p>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span
lang="EN-GB"> </span><o:p></o:p></p>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span
lang="EN-GB">Igor.</span><o:p></o:p></p>
<p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span
lang="EN-GB"> </span><o:p></o:p></p>
</div>
</div>
<p class="MsoNormal">_________________________________________________________________________<br>
Professional FreeSWITCH
Consulting Services:<br>
<a
href="mailto:consulting@freeswitch.org"
target="_blank"
moz-do-not-send="true">consulting@freeswitch.org</a><br>
<a
href="http://www.freeswitchsolutions.com"
target="_blank"
moz-do-not-send="true">http://www.freeswitchsolutions.com</a><br>
<br>
Official FreeSWITCH Sites<br>
<a
href="http://www.freeswitch.org"
target="_blank"
moz-do-not-send="true">http://www.freeswitch.org</a><br>
<a
href="http://confluence.freeswitch.org"
target="_blank"
moz-do-not-send="true">http://confluence.freeswitch.org</a><br>
<a
href="http://www.cluecon.com"
target="_blank"
moz-do-not-send="true">http://www.cluecon.com</a><br>
<br>
FreeSWITCH-users mailing list<br>
<a
href="mailto:FreeSWITCH-users@lists.freeswitch.org"
target="_blank"
moz-do-not-send="true">FreeSWITCH-users@lists.freeswitch.org</a><br>
<a
href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users"
target="_blank"
moz-do-not-send="true">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a
href="http://lists.freeswitch.org/mailman/options/freeswitch-users"
target="_blank"
moz-do-not-send="true">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a
href="http://www.freeswitch.org"
target="_blank"
moz-do-not-send="true">http://www.freeswitch.org</a><o:p></o:p></p>
</blockquote>
</div>
</div>
</blockquote>
<blockquote
style="margin-top:5.0pt;margin-bottom:5.0pt">
<div>
<p class="MsoNormal">_________________________________________________________________________<br>
Professional FreeSWITCH Consulting
Services:<br>
<a
href="mailto:consulting@freeswitch.org"
moz-do-not-send="true">consulting@freeswitch.org</a><br>
<a
href="http://www.freeswitchsolutions.com"
moz-do-not-send="true">http://www.freeswitchsolutions.com</a><br>
<br>
Official FreeSWITCH Sites<br>
<a
href="http://www.freeswitch.org"
moz-do-not-send="true">http://www.freeswitch.org</a><br>
<a
href="http://confluence.freeswitch.org"
moz-do-not-send="true">http://confluence.freeswitch.org</a><br>
<a href="http://www.cluecon.com"
moz-do-not-send="true">http://www.cluecon.com</a><br>
<br>
FreeSWITCH-users mailing list<br>
<a
href="mailto:FreeSWITCH-users@lists.freeswitch.org"
moz-do-not-send="true">FreeSWITCH-users@lists.freeswitch.org</a><br>
<a
href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users"
moz-do-not-send="true">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a
href="http://lists.freeswitch.org/mailman/options/freeswitch-users"
moz-do-not-send="true">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a
href="http://www.freeswitch.org"
moz-do-not-send="true">http://www.freeswitch.org</a><o:p></o:p></p>
</div>
</blockquote>
<p class="MsoNormal"
style="margin-bottom:12.0pt"><br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<o:p></o:p></p>
<pre>_________________________________________________________________________<o:p></o:p></pre>
<pre>Professional FreeSWITCH Consulting Services:<o:p></o:p></pre>
<pre><a href="mailto:consulting@freeswitch.org" moz-do-not-send="true">consulting@freeswitch.org</a><o:p></o:p></pre>
<pre><a href="http://www.freeswitchsolutions.com" moz-do-not-send="true">http://www.freeswitchsolutions.com</a><o:p></o:p></pre>
<pre> <o:p></o:p></pre>
<pre>Official FreeSWITCH Sites<o:p></o:p></pre>
<pre><a href="http://www.freeswitch.org" moz-do-not-send="true">http://www.freeswitch.org</a><o:p></o:p></pre>
<pre><a href="http://confluence.freeswitch.org" moz-do-not-send="true">http://confluence.freeswitch.org</a><o:p></o:p></pre>
<pre><a href="http://www.cluecon.com" moz-do-not-send="true">http://www.cluecon.com</a><o:p></o:p></pre>
<pre> <o:p></o:p></pre>
<pre>FreeSWITCH-users mailing list<o:p></o:p></pre>
<pre><a href="mailto:FreeSWITCH-users@lists.freeswitch.org" moz-do-not-send="true">FreeSWITCH-users@lists.freeswitch.org</a><o:p></o:p></pre>
<pre><a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" moz-do-not-send="true">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><o:p></o:p></pre>
<pre>UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" moz-do-not-send="true">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><o:p></o:p></pre>
<pre><a href="http://www.freeswitch.org" moz-do-not-send="true">http://www.freeswitch.org</a><o:p></o:p></pre>
</blockquote>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal"
style="margin-bottom:12.0pt"><br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<o:p></o:p></p>
<pre>_________________________________________________________________________<o:p></o:p></pre>
<pre>Professional FreeSWITCH Consulting Services:<o:p></o:p></pre>
<pre><a href="mailto:consulting@freeswitch.org" moz-do-not-send="true">consulting@freeswitch.org</a><o:p></o:p></pre>
<pre><a href="http://www.freeswitchsolutions.com" moz-do-not-send="true">http://www.freeswitchsolutions.com</a><o:p></o:p></pre>
<pre> <o:p></o:p></pre>
<pre>Official FreeSWITCH Sites<o:p></o:p></pre>
<pre><a href="http://www.freeswitch.org" moz-do-not-send="true">http://www.freeswitch.org</a><o:p></o:p></pre>
<pre><a href="http://confluence.freeswitch.org" moz-do-not-send="true">http://confluence.freeswitch.org</a><o:p></o:p></pre>
<pre><a href="http://www.cluecon.com" moz-do-not-send="true">http://www.cluecon.com</a><o:p></o:p></pre>
<pre> <o:p></o:p></pre>
<pre>FreeSWITCH-users mailing list<o:p></o:p></pre>
<pre><a href="mailto:FreeSWITCH-users@lists.freeswitch.org" moz-do-not-send="true">FreeSWITCH-users@lists.freeswitch.org</a><o:p></o:p></pre>
<pre><a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" moz-do-not-send="true">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><o:p></o:p></pre>
<pre>UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" moz-do-not-send="true">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><o:p></o:p></pre>
<pre><a href="http://www.freeswitch.org" moz-do-not-send="true">http://www.freeswitch.org</a><o:p></o:p></pre>
</blockquote>
<p class="MsoNormal"> <o:p></o:p></p>
</blockquote>
<p class="MsoNormal"> <o:p></o:p></p>
</blockquote>
<p class="MsoNormal"> <o:p></o:p></p>
</blockquote>
<p class="MsoNormal"> <o:p></o:p></p>
</blockquote>
<p class="MsoNormal"> <o:p></o:p></p>
</blockquote>
<p class="MsoNormal"> <o:p></o:p></p>
</blockquote>
<p class="MsoNormal"> <o:p></o:p></p>
</blockquote>
<p class="MsoNormal"> <o:p></o:p></p>
</blockquote>
<p class="MsoNormal"> <o:p></o:p></p>
</blockquote>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_________________________________________________________________________
Professional FreeSWITCH Consulting Services:
<a class="moz-txt-link-abbreviated" href="mailto:consulting@freeswitch.org" moz-do-not-send="true">consulting@freeswitch.org</a>
<a class="moz-txt-link-freetext" href="http://www.freeswitchsolutions.com" moz-do-not-send="true">http://www.freeswitchsolutions.com</a>
Official FreeSWITCH Sites
<a class="moz-txt-link-freetext" href="http://www.freeswitch.org" moz-do-not-send="true">http://www.freeswitch.org</a>
<a class="moz-txt-link-freetext" href="http://confluence.freeswitch.org" moz-do-not-send="true">http://confluence.freeswitch.org</a>
<a class="moz-txt-link-freetext" href="http://www.cluecon.com" moz-do-not-send="true">http://www.cluecon.com</a>
FreeSWITCH-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:FreeSWITCH-users@lists.freeswitch.org" moz-do-not-send="true">FreeSWITCH-users@lists.freeswitch.org</a>
<a class="moz-txt-link-freetext" href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" moz-do-not-send="true">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a>
UNSUBSCRIBE:<a class="moz-txt-link-freetext" href="http://lists.freeswitch.org/mailman/options/freeswitch-users" moz-do-not-send="true">http://lists.freeswitch.org/mailman/options/freeswitch-users</a>
<a class="moz-txt-link-freetext" href="http://www.freeswitch.org" moz-do-not-send="true">http://www.freeswitch.org</a></pre>
</blockquote>
<br>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_________________________________________________________________________
Professional FreeSWITCH Consulting Services:
<a class="moz-txt-link-abbreviated" href="mailto:consulting@freeswitch.org">consulting@freeswitch.org</a>
<a class="moz-txt-link-freetext" href="http://www.freeswitchsolutions.com">http://www.freeswitchsolutions.com</a>
Official FreeSWITCH Sites
<a class="moz-txt-link-freetext" href="http://www.freeswitch.org">http://www.freeswitch.org</a>
<a class="moz-txt-link-freetext" href="http://confluence.freeswitch.org">http://confluence.freeswitch.org</a>
<a class="moz-txt-link-freetext" href="http://www.cluecon.com">http://www.cluecon.com</a>
FreeSWITCH-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a>
<a class="moz-txt-link-freetext" href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a>
UNSUBSCRIBE:<a class="moz-txt-link-freetext" href="http://lists.freeswitch.org/mailman/options/freeswitch-users">http://lists.freeswitch.org/mailman/options/freeswitch-users</a>
<a class="moz-txt-link-freetext" href="http://www.freeswitch.org">http://www.freeswitch.org</a></pre>
</blockquote>
<br>
</body>
</html>