[Freeswitch-users] Nibblebill database question

[David Villasmil]

Hello Rupa,

the query if ok, the user is there:

mysql> select * from sip_users;
+----+----------+----------+----------------+------------+--------------+--------------+
| id | username | password | rateplan       | balance    | domain       |
max_channels |
+----+----------+----------+----------------+------------+--------------+--------------+
|  1 | 1002     | 1234     | retail_default | 100.000000 | 192.168.1.44 |
         1 |
+----+----------+----------+----------------+------------+--------------+--------------+
1 row in set (0.00 sec)


and the actual sql executed by nibblebill:

mysql> SELECT balance AS nibble_balance FROM sip_users WHERE id='1';
+----------------+
| nibble_balance |
+----------------+
|     100.000000 |
+----------------+
1 row in set (0.00 sec)


so that's ok..


any othe ideas?

Thanks a lot for your help!


David



On Wed, Feb 13, 2013 at 3:35 AM, Rupa Schomaker <rupa at rupa.com> wrote:

>
> On Tue, Feb 12, 2013 at 5:26 PM, David Villasmil <
> david.villasmil.work at gmail.com> wrote:
>
>> call goes out fine... no billing though:
>>
>>
>> 2013-02-12 19:21:49.844277 [DEBUG] mod_nibblebill.c:504 22 seconds passed
>> since last bill time of 2013-02-12 19:21:27
>> 2013-02-12 19:21:49.844277 [DEBUG] mod_nibblebill.c:521 Billing $0.018983
>> to 1 (Call: d442dc6b-a3a7-423a-8450-598d17ca43b3 / 0.000000 so far)
>> 2013-02-12 19:21:49.844277 [DEBUG] mod_nibblebill.c:351 Doing update query
>> [UPDATE sip_users SET balance=balance-0.018983 WHERE ='1']
>> 2013-02-12 19:21:49.844277 [CRIT] mod_nibblebill.c:535 Failed to log to
>> database!
>> 2013-02-12 19:21:49.844277 [DEBUG] mod_nibblebill.c:378 Doing lookup query
>> [SELECT balance AS nibble_balance FROM sip_users WHERE ='1']
>> 2013-02-12 19:21:49.844277 [ERR] mod_nibblebill.c:380 Error running this
>> query: [SELECT balance AS nibble_balance FROM sip_users WHERE ='1']
>>
>>
>> the select go fine if executed "by hand"
>>
>
> None of those SQL statements are valid.  (hint: WHERE = '1' is no good).
>  Been a while since I hacked/worked with nibblebill, but I'm pretty sure
> the 'id' field isn't not being filled in the sql for some reason.
>
>
> --
> -Rupa
>
> _________________________________________________________________________
> Professional FreeSWITCH Consulting Services:
> consulting at freeswitch.org
> http://www.freeswitchsolutions.com
>
> 
> 
>
> Official FreeSWITCH Sites
> http://www.freeswitch.org
> http://wiki.freeswitch.org
> http://www.cluecon.com
>
> FreeSWITCH-users mailing list
> FreeSWITCH-users at lists.freeswitch.org
> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
> http://www.freeswitch.org
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20130213/3f2bbaf6/attachment-0001.html