Re: [Freeswitch-users] Need to know
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.
---------- Forwarded message ---------- From: Ahmed Munir <ahmedmunir007@gmail.com> To: FreeSwitch <freeswitch-users@lists.freeswitch.org> Date: Wed, 30 Sep 2009 10:28:41 +0600 Subject: [Freeswitch-users] Need to know 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
---------- Forwarded message ---------- From: William Suffill <william.suffill@gmail.com> To: freeswitch-users@lists.freeswitch.org Date: Wed, 30 Sep 2009 00:43:37 -0400 Subject: Re: [Freeswitch-users] Need to know 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
-- Regards, Ahmed Munir
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
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:
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
-- -Rupa
participants (3)
-
Ahmed Munir
-
Rupa Schomaker
-
William Suffill