VoIP Mailing List Archives

[ahmedmunir007 at gmail...]

Hi,

I want to use mod_nibble in freeswitch for billing purpose. I've got some questions, as I'm listing down below;

1-  How I create MySQL connection with FS?
2-  Is it possible to query the database when billing occurs?
3-  Will database credentials require each time when query to database?
4-  I'm currently running MySQL database in production for billing purposes.Will it be okay to use my current database for mod_nibble?

Kindly advise me soon and also please provide me the links as well.
--
Regards,

Ahmed Munir

[william.suffill at gma...]

mod_nibble uses ODBC. Via ODBC u can connect to mysql.

http://wiki.freeswitch.org/wiki/Using_ODBC_in_the_core

mod_nibble has it's own table design.
http://wiki.freeswitch.org/wiki/Mod_nibblebill

It may be possible to tweak it to use your current tables but I'd
suggest getting the
basics working based on the documentation on the wiki and build from there.

-- W

_______________________________________________
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

[ahmedmunir007 at gmail...]

Hi,

Thanks for reply.  Actually I'm currently running asterisk and for billing I'm using MySQL database. In the database i've listed various destination against their different rates. When call is made a script which queries MySQL for billing. My question is, how can I do this in FS using mod nibbles(note: I'm running asterisk in realtime)? And my other question is, will MySQL authenticates each time when call is made on FS?


Kindly advise me.

 

[william.suffill at gma...]

You could also use mod_lcr to query the cost to aply to the nibblebill as well.
ODBC keeps the connection to MySQL open as needed and reconnects if need be.

-- W

_______________________________________________
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

[rupa at rupa.com]

and (if using custom_sql + the right query) you can now have the
channelvar lcr_user_rate populated with your end-user-rate tables
which can then be used by mod_nibblebill or other billing engine.

Just committed and wiki updated.

On Wed, Sep 30, 2009 at 11:30 AM, William Suffill
<william.suffill@gmail.com> wrote: