Problem is with SELECT query, most likely db connection parameters are missing/invalid OR the db user configured does not have enough permissions to execute SELECT,<div><br></div><div><span class="nu0" style="color:rgb(51,51,51);font-family:'Courier New',Courier,monospace;font-size:11px;background-color:rgb(255,255,255)">2013</span><span class="nu0" style="color:rgb(51,51,51);font-family:'Courier New',Courier,monospace;font-size:11px;background-color:rgb(255,255,255)">-03</span><span class="nu0" style="color:rgb(51,51,51);font-family:'Courier New',Courier,monospace;font-size:11px;background-color:rgb(255,255,255)">-01</span><span style="color:rgb(51,51,51);font-family:'Courier New',Courier,monospace;font-size:11px;background-color:rgb(255,255,255)"> </span><span class="nu0" style="color:rgb(51,51,51);font-family:'Courier New',Courier,monospace;font-size:11px;background-color:rgb(255,255,255)">22</span><span style="color:rgb(51,51,51);font-family:'Courier New',Courier,monospace;font-size:11px;background-color:rgb(255,255,255)">:</span><span class="nu0" style="color:rgb(51,51,51);font-family:'Courier New',Courier,monospace;font-size:11px;background-color:rgb(255,255,255)">29</span><span style="color:rgb(51,51,51);font-family:'Courier New',Courier,monospace;font-size:11px;background-color:rgb(255,255,255)">:</span><span class="nu0" style="color:rgb(51,51,51);font-family:'Courier New',Courier,monospace;font-size:11px;background-color:rgb(255,255,255)">52.293493</span><span style="color:rgb(51,51,51);font-family:'Courier New',Courier,monospace;font-size:11px;background-color:rgb(255,255,255)"> </span><span class="br0" style="color:rgb(51,51,51);font-family:'Courier New',Courier,monospace;font-size:11px;background-color:rgb(255,255,255)">[</span><span style="color:rgb(51,51,51);font-family:'Courier New',Courier,monospace;font-size:11px;background-color:rgb(255,255,255)">ERR</span><span class="br0" style="color:rgb(51,51,51);font-family:'Courier New',Courier,monospace;font-size:11px;background-color:rgb(255,255,255)">]</span><span style="color:rgb(51,51,51);font-family:'Courier New',Courier,monospace;font-size:11px;background-color:rgb(255,255,255)"> mod_nibblebill.c:</span><span class="nu0" style="color:rgb(51,51,51);font-family:'Courier New',Courier,monospace;font-size:11px;background-color:rgb(255,255,255)">380</span><span style="color:rgb(51,51,51);font-family:'Courier New',Courier,monospace;font-size:11px;background-color:rgb(255,255,255)"> Error running this query: </span><span class="br0" style="color:rgb(51,51,51);font-family:'Courier New',Courier,monospace;font-size:11px;background-color:rgb(255,255,255)">[</span><span style="color:rgb(51,51,51);font-family:'Courier New',Courier,monospace;font-size:11px;background-color:rgb(255,255,255)">SELECT `cash` AS nibble_balance FROM `tb_accounts` WHERE `id`=</span><span class="nu0" style="color:rgb(51,51,51);font-family:'Courier New',Courier,monospace;font-size:11px;background-color:rgb(255,255,255)">1</span><span class="br0" style="color:rgb(51,51,51);font-family:'Courier New',Courier,monospace;font-size:11px;background-color:rgb(255,255,255)">]</span><br>
<div><br></div><div>Login db server from FS machine with same db user as configured in FS configs and run above query, it would give you hint on what is actually wrong.</div><div><br></div><div>Thank you.</div><div><br><br>
<div class="gmail_quote">On Fri, Mar 1, 2013 at 1:42 PM, Shahzad Bhatti <span dir="ltr"><<a href="mailto:shahzad.bhatti@g-r-v.com" target="_blank">shahzad.bhatti@g-r-v.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="ltr">hi<div>i am using a nibblebill the call cost but have some problem in it. my nibblebill.conf.xml file is as<div><br></div><div><div><a href="http://pastebin.freeswitch.org/20650" target="_blank">http://pastebin.freeswitch.org/20650</a><br>
</div><div><br></div></div></div><div>and console log is <br></div><div><br></div><div><a href="http://pastebin.freeswitch.org/20651" target="_blank">http://pastebin.freeswitch.org/20651</a><br></div><div><br></div><div>
i got Error <b>Failed to log to database! </b>Doing update query </div>
<div><br></div><div>reply me about the issue </div><div><br></div><div>Regards</div><span class="HOEnZb"><font color="#888888"><div><br></div><div>Shahzad Bhatti</div></font></span></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><br clear="all"><div><br></div>-- <br><span style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">Muhammad Shahzad</span><br style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">
<span style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">------------------------------</span><span style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">-----</span><br style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">
<span style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">CISCO Rich Media Communication Specialist (CRMCS)</span><br style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">
<span style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">CISCO Certified Network Associate (CCNA)</span><br style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">
<span style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">Cell: +49 176 99 83 10 85</span><br style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">
<span style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">MSN: </span><a href="mailto:shari_786pk@hotmail.com" style="color:rgb(17,85,204);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)" target="_blank">shari_786pk@hotmail.com</a><br style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">
<span style="color:rgb(136,136,136);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">Email: </span><a href="mailto:shaheryarkh@googlemail.com" style="color:rgb(17,85,204);font-family:arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)" target="_blank">shaheryarkh@googlemail.com</a>
</div></div>