[Freeswitch-users] Nibblebill database question

[David Villasmil]

ok, some more info:

dialplan:


On Tue, Feb 12, 2013 at 8:33 PM, David Villasmil <
david.villasmil.work at gmail.com> wrote:

> 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/20130213/49fe3f90/attachment-0001.html