[Freeswitch-users] Nibblebill database question

Wed Feb 13 20:40:33 MSK 2013

Specifically it's introduced by commit 5c176e8 which was resolving FS-4810,
which is indeed adding support for the the generalised DSN interface.

http://fisheye.freeswitch.org/changelog/freeswitch.git?showid=5c176e889d8cc2da7efb18a89782407ee5524a74
http://jira.freeswitch.org/browse/FS-4810

-Steve

On 13 February 2013 17:37, Steven Ayre <steveayre at gmail.com> wrote:

> Looks like this difference is brought in by the modifications to support
> the generalised DSN interface. odbc-dsn would be consistent with all other
> modules, so I guess that's why it's happened.
>
> But...
> The HEAD of v1.2.stable understands db_dsn but not odbc-dsn.
> The HEAD of master understands odbc-dsn but not db_dsn.
>
> This is a configuration breaking behaviour, which doesn't seem to have
> been documented!
>
> At the very least it'd make sense for the master branch to understand both
> odbc-dsn and db_dsn for backwards compatibility. I'll file a Jira with a
> patch (it's a trivial fix) in a moment.
>
> -Steve
>
>
>
>
>
>
> On 13 February 2013 17:33, Steven Ayre <steveayre at gmail.com> wrote:
>
>> How are you setting the DSN?
>>
>> The param name mentioned earlier is wrong. Reading the source the correct
>> parameter is "odbc-dsn". Looks like the wiki documentation is incorrect.
>>
>> -Steve
>>
>>
>>
>>
>> On 13 February 2013 15:33, David Villasmil <
>> david.villasmil.work at gmail.com> wrote:
>>
>>> hello Avi,
>>>
>>> that's right, but nevermind that, that's the output when I was trying
>>> something else:
>>>
>>> 2013-02-12 19:32:07.784156 [INFO] mod_nibblebill.c:498 Beginning new
>>> billing on 58e6762b-c049-470e-84f7-519a815ab6f0
>>> 2013-02-12 19:32:07.784156 [CRIT] mod_nibblebill.c:535 Failed to log to
>>> database!
>>> 2013-02-12 19:32:07.784156 [ERR] mod_nibblebill.c:380 Error running this
>>> query: [SELECT balance AS nibble_balance FROM sip_users WHERE id='1']
>>>
>>>
>>> On Wed, Feb 13, 2013 at 12:58 PM, Avi Marcus <avi at avimarcus.net> wrote:
>>>
>>>> Your logs showed the queries run were:
>>>>
>>>> UPDATE sip_users SET balance=balance-0.018983 WHERE ='1'
>>>> SELECT balance AS nibble_balance FROM sip_users WHERE ='1'
>>>>
>>>>  You just tried now.. "WHERE *id*='1' " -- they are not the same
>>>> query...
>>>>
>>>> -Avi
>>>>
>>>>
>>>>
>>>> On Wed, Feb 13, 2013 at 12:48 PM, David Villasmil <
>>>> david.villasmil.work at gmail.com> wrote:
>>>>
>>>>> 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
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>> _________________________________________________________________________
>>>>> 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
>>>>>
>>>>>
>>>>
>>>>
>>>> _________________________________________________________________________
>>>> 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
>>>>
>>>>
>>>
>>> _________________________________________________________________________
>>> 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/9a7872e6/attachment-0001.html 