[Freeswitch-users] Nibblebill database question

David Villasmil david.villasmil.work at gmail.com
Tue Feb 12 22:33:25 MSK 2013


Hello,

Is uncommenting the "custom sql" lines mandatory?? it doesn't seem so, i do
see nibblebill trying to do it's job:

2013-02-12 19:32:07.784156 [DEBUG] mod_nibblebill.c:351 Doing update query
[UPDATE sip_users SET balance=balance-0.027683 WHERE id='1']
2013-02-12 19:32:07.784156 [CRIT] mod_nibblebill.c:535 Failed to log to
database!
2013-02-12 19:32:07.784156 [DEBUG] mod_nibblebill.c:378 Doing lookup query
[SELECT balance AS nibble_balance FROM sip_users WHERE id='1']
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 Tue, Feb 12, 2013 at 8:23 PM, David Villasmil <
david.villasmil.work at gmail.com> wrote:

> No, there's nothing related to db:
>
> 2013-02-12 19:23:04.823909 [CONSOLE] switch_loadable_module.c:1348
> Successfully Loaded [mod_nibblebill]
> 2013-02-12 19:23:04.823909 [NOTICE] switch_loadable_module.c:254 Adding
> Application 'nibblebill'
> 2013-02-12 19:23:04.823909 [NOTICE] switch_loadable_module.c:298 Adding
> API Function 'nibblebill'
>
>
>
>
> On Tue, Feb 12, 2013 at 8:04 PM, Avi Marcus <avi at avimarcus.net> wrote:
>
>> Last I saw, if you load/reload mod_nibblebill, it logs which DSN it's
>> using to fs_cli / freeswitch.log.
>>
>> -Avi
>>
>> On Tue, Feb 12, 2013 at 9:00 PM, David Villasmil <
>> david.villasmil.work at gmail.com> wrote:
>>
>>> Yes, it does have the option, but it doesn't seem to be using a
>>> different one... I must've missed something...
>>>
>>>
>>> On Tue, Feb 12, 2013 at 7:53 PM, Avi Marcus <avi at avimarcus.net> wrote:
>>>
>>>> All modules that touch the DB (I think!) have their own configuration
>>>> that allows you pick the database.
>>>> mod_nibblebill does indeed has a param name="db_dsn" option so yes, it
>>>> will honor that.
>>>>
>>>> -Avi
>>>>
>>>> On Tue, Feb 12, 2013 at 8:11 PM, David Villasmil <
>>>> david.villasmil.work at gmail.com> wrote:
>>>>
>>>>> Hello guys,
>>>>>
>>>>> I have created 2 dsns, one for freeswitch core "freeswitch" and one
>>>>> for nibblebill ("whatever").
>>>>> Is it possible to use different dsns in core and nibblebill? or does
>>>>> nibblebill uses the same dsn as the core??
>>>>>
>>>>> thanks
>>>>>
>>>>> David
>>>>>
>>>>>
>>>>> _________________________________________________________________________
>>>>> 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/20130212/de4064e6/attachment-0001.html 


Join us at ClueCon 2011 Aug 9-11, 2011
More information about the FreeSWITCH-users mailing list