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@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@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@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@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@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@freeswitch.org
http://www.freeswitchsolutions.com

FreeSWITCH-powered IP PBX: The CudaTel Communication Server
http://www.cudatel.com

Official FreeSWITCH Sites
http://www.freeswitch.org
http://wiki.freeswitch.org
http://www.cluecon.com

FreeSWITCH-users mailing list
FreeSWITCH-users@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@freeswitch.org
http://www.freeswitchsolutions.com

FreeSWITCH-powered IP PBX: The CudaTel Communication Server
http://www.cudatel.com

Official FreeSWITCH Sites
http://www.freeswitch.org
http://wiki.freeswitch.org
http://www.cluecon.com

FreeSWITCH-users mailing list
FreeSWITCH-users@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@freeswitch.org
http://www.freeswitchsolutions.com

FreeSWITCH-powered IP PBX: The CudaTel Communication Server
http://www.cudatel.com

Official FreeSWITCH Sites
http://www.freeswitch.org
http://wiki.freeswitch.org
http://www.cluecon.com

FreeSWITCH-users mailing list
FreeSWITCH-users@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@freeswitch.org
http://www.freeswitchsolutions.com

FreeSWITCH-powered IP PBX: The CudaTel Communication Server
http://www.cudatel.com

Official FreeSWITCH Sites
http://www.freeswitch.org
http://wiki.freeswitch.org
http://www.cluecon.com

FreeSWITCH-users mailing list
FreeSWITCH-users@lists.freeswitch.org
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
http://www.freeswitch.org