Try connecting to the DB at the commandline via that DSN:<div><br></div><div>> isql freeswitch:freeswitch:freeswitchrw</div><div><br></div><div>And run the failing query:</div><div>SELECT cash AS nibble_balance FROM accounts WHERE account_code='2';</div>
<div><br></div><div>to see what the error is.</div><div><br></div><div>-Steve</div><div><br></div><div><br></div><div><br></div><div><br></div><div><div><br><div class="gmail_quote">On 29 June 2013 17:58, <span dir="ltr"><<a href="mailto:mrajib321@yahoo.com" target="_blank">mrajib321@yahoo.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div style="font-size:12pt;font-family:times new roman,new york,times,serif"><div>Hi,</div><div> Is anyone running or tested mod_nibblebill on the latest release of FreeSWITCH 1.2.10. A simple internal profile call between two SIP clients completes successfully but fails to debit the balance. I have the following configuration settings</div>
<div><br></div><div style="font-style:normal;font-size:16px;background-color:transparent;font-family:times new roman,new york,times,serif">Dialplan configuration<br><action application="set" data="nibble_rate=0.20"/><br>
<action application="set" data="$${nibble_account}"/><br><br>User directory configuration<br><variable name="nibble_account" value="1"/></div><div style="font-style:normal;font-size:16px;background-color:transparent;font-family:times new roman,new york,times,serif">
<br></div><div style="font-style:normal;font-size:16px;background-color:transparent;font-family:times new roman,new york,times,serif">Nibblebill module configuration <br></div><div style="font-style:normal;font-size:16px;background-color:transparent;font-family:times new roman,new york,times,serif">
<param name="odbc_dsn" value="odbc://freeswitch:freeswitch:freeswitchrw"/><br><param name="db_table" value="accounts"/><br><param name="db_column_cash" value="cash"/><br>
<param name="db_column_account" value="id"/><br></div><div style="font-style:normal;font-size:16px;background-color:transparent;font-family:times new roman,new york,times,serif"><br></div><div style="font-style:normal;font-size:16px;background-color:transparent;font-family:times new roman,new york,times,serif">
ODBC driver has been tested
sucessfully with mySQL using isql command.</div><div style="font-style:normal;font-size:16px;background-color:transparent;font-family:times new roman,new york,times,serif"><br></div><div style="font-style:normal;font-size:16px;background-color:transparent;font-family:times new roman,new york,times,serif">
Running FreeSWITCH 1.2.10 on Linux machine</div><div style="font-style:normal;font-size:16px;background-color:transparent;font-family:times new roman,new york,times,serif"></div><div style="font-style:normal;font-size:16px;background-color:transparent;font-family:times new roman,new york,times,serif">
<div class="MsoNormal">FreeSWITCH Version 1.2.10+git~20130625T154058Z~30be15fd52</div><div class="MsoNormal"><br></div><div style="font-style:normal;font-size:16px;background-color:transparent;font-family:times new roman,new york,times,serif" class="MsoNormal">
Any pointers on how to fix the error would be appreciated. Thanks.<br></div>
</div><div style="font-style:normal;font-size:16px;background-color:transparent;font-family:times new roman,new york,times,serif"><br></div><div style="font-style:normal;font-size:16px;background-color:transparent;font-family:times new roman,new york,times,serif">
I received the following errors:</div><div><br></div><div style="font-style:normal;font-size:16px;background-color:transparent;font-family:times new roman,new york,times,serif"></div><div style="font-style:normal;font-size:16px;background-color:transparent;font-family:times new roman,new york,times,serif">
<div class="MsoNormal">2013-06-28 14:24:49.488199 <b><span style="color:red">[ERR</span></b>] mod_nibblebill.c:403 Error
running this query: [SELECT cash AS nibble_balance FROM accounts WHERE
account_code='1']</div>
<div class="MsoNormal">2013-06-28 14:24:49.488199 [INFO] mod_dialplan_xml.c:558
Processing 1600 <1600>->1601 in context default</div>
<div class="MsoNormal">2013-06-28 14:24:49.488199 <b><span style="color:red">[ERR]</span></b><span style="color:red"> </span>mod_dptools.c:1351
No variable name specified.</div>
<div class="MsoNormal">2013-06-28 14:24:49.508248 [NOTICE] switch_channel.c:1030
New Channel sofia/internal/<a href="http://sip:1601@192.168.104.191:5073" target="_blank">sip:1601@192.168.104.191:5073</a>
[e0a7b224-c48e-449d-b8ca-280ea016af07]</div>
<div class="MsoNormal">2013-06-28 14:24:49.528204 [NOTICE] sofia.c:6443 Channel
[sofia/internal/<a href="http://sip:1601@192.168.104.191:5073" target="_blank">sip:1601@192.168.104.191:5073</a>] has been answered</div>
<div class="MsoNormal">2013-06-28 14:24:49.528204 [NOTICE] sofia_glue.c:4291
Pre-Answer sofia/internal/<a href="mailto:1600@192.168.104.191" target="_blank">1600@192.168.104.191</a>!</div>
<div class="MsoNormal">2013-06-28 14:24:49.528204 [NOTICE] switch_ivr_originate.c:3427
Channel [sofia/internal/<a href="mailto:1600@192.168.104.191" target="_blank">1600@192.168.104.191</a>] has been answered</div>
<div class="MsoNormal">2013-06-28 14:24:54.568203 [NOTICE] sofia.c:716 Hangup
sofia/internal/<a href="mailto:1600@192.168.104.191" target="_blank">1600@192.168.104.191</a> [CS_EXECUTE] [NORMAL_CLEARING]</div>
<div class="MsoNormal">2013-06-28 14:24:54.588237 [NOTICE] switch_ivr_bridge.c:721
Hangup sofia/internal/<a href="http://sip:1601@192.168.104.191:5073" target="_blank">sip:1601@192.168.104.191:5073</a> [CS_EXCHANGE_MEDIA]
[NORMAL_CLEARING]</div>
<div class="MsoNormal">2013-06-28 14:24:54.588237 <b><span style="color:red">[ERR] </span></b>mod_nibblebill.c:403 Error
running this query: [SELECT cash AS nibble_balance FROM accounts WHERE
account_code='2']</div>
<div class="MsoNormal">2013-06-28 14:24:54.588237 <b><span style="color:red">[ERR]</span></b><span style="color:red"> </span>mod_nibblebill.c:403
Error running this query: [SELECT cash AS nibble_balance FROM accounts WHERE
account_code='2']</div>
<div class="MsoNormal">2013-06-28 14:24:54.588237 [INFO] mod_nibblebill.c:521
Beginning new billing on 51157e70-fb95-4c90-91f6-3575f097fe00</div>
<div class="MsoNormal"><span style="font-weight:bold">2013-06-28 14:24:54.588237 <span><span style="color:red">[CRIT]</span></span><span style="color:red"> </span>mod_nibblebill.c:558
Failed to log to database!</span></div>
<div class="MsoNormal">2013-06-28 14:24:54.588237 <b><span style="color:red">[ERR]</span></b><span style="color:red"> </span>mod_nibblebill.c:403
Error running this query: [SELECT cash AS nibble_balance FROM accounts WHERE
account_code='1']</div>
</div></div></div><br>_________________________________________________________________________<br>
Professional FreeSWITCH Consulting Services:<br>
<a href="mailto:consulting@freeswitch.org">consulting@freeswitch.org</a><br>
<a href="http://www.freeswitchsolutions.com" target="_blank">http://www.freeswitchsolutions.com</a><br>
<br>
FreeSWITCH-powered IP PBX: The CudaTel Communication Server<br>
<a href="http://www.cudatel.com" target="_blank">http://www.cudatel.com</a><br>
<br>
Official FreeSWITCH Sites<br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
<a href="http://wiki.freeswitch.org" target="_blank">http://wiki.freeswitch.org</a><br>
<a href="http://www.cluecon.com" target="_blank">http://www.cluecon.com</a><br>
<br>
FreeSWITCH-users mailing list<br>
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a><br>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
<br></blockquote></div><br></div></div>