Re: [Freeswitch-users] mod_lcr + nibble_bill + leg B
if I update FS, should I remove all the lcr tables ? should I also activate lcr in dialplan with <action application="lcr" data="$1 public"/> ? thx F ----- Original Message ----- From: Madovsky To: FreeSWITCH Users Help Sent: Wednesday, July 28, 2010 2:02 PM Subject: Re: [Freeswitch-users] mod_lcr + nibble_bill + leg B for now I can't. it will take ages before I correct my cluster.... ----- Original Message ----- From: Rupa Schomaker To: FreeSWITCH Users Help Sent: Wednesday, July 28, 2010 1:48 PM Subject: Re: [Freeswitch-users] mod_lcr + nibble_bill + leg B umm.... update to latest git version? On Wed, Jul 28, 2010 at 12:40 PM, Madovsky <infos@madovsky.org> wrote: ok apparently I use a version of mod_lcr (svn 17134) where there are only id,name and cash field in the table. so the SQL request failed... Is there any similar settings for this version ? Thanks F ----- Original Message ----- From: Madovsky To: freeswitch-users@lists.freeswitch.org Sent: Wednesday, July 28, 2010 1:26 PM Subject: [Freeswitch-users] mod_lcr + nibble_bill + leg B Hi, I followed the article at http://wiki.freeswitch.org/wiki/Mod_lcr to activate nibble bill with mod_lcr on leg B, but the nibble bill account is not debited. I tried to put <action application="lcr" data="${dialed_extension} public"/> in dialplan with no success, it generates a "bad gateway" error when I tried to call the user from outside FS. did I forget to set something ? Thanks F ------------------------------------------------------------------------ _______________________________________________ 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 _______________________________________________ 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 ---------------------------------------------------------------------------- _______________________________________________ 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
the tables? If you followed the wiki they are fine. That example is if you want to bridge using an expanded dialstring later on. You can also: bridge to lcr/$1 (hmm... I need to make it support profile, right now it only uses default) or transfer to "lcr $1 public" or execute_extension "lcr $1 public" if you want to continue processing after the call If you intend to use limit, only the lcr/ endpoint or transfer or execute_extension methods support automatic limits on the b-leg. On Wed, Jul 28, 2010 at 1:19 PM, Madovsky <infos@madovsky.org> wrote:
if I update FS, should I remove all the lcr tables ? should I also activate lcr in dialplan with <action application="lcr" data="$1 public"/> ?
thx
F
----- Original Message ----- *From:* Madovsky <infos@madovsky.org> *To:* FreeSWITCH Users Help <freeswitch-users@lists.freeswitch.org> *Sent:* Wednesday, July 28, 2010 2:02 PM *Subject:* Re: [Freeswitch-users] mod_lcr + nibble_bill + leg B
for now I can't. it will take ages before I correct my cluster....
----- Original Message ----- *From:* Rupa Schomaker <rupa@rupa.com> *To:* FreeSWITCH Users Help <freeswitch-users@lists.freeswitch.org> *Sent:* Wednesday, July 28, 2010 1:48 PM *Subject:* Re: [Freeswitch-users] mod_lcr + nibble_bill + leg B
umm.... update to latest git version?
On Wed, Jul 28, 2010 at 12:40 PM, Madovsky <infos@madovsky.org> wrote:
ok apparently I use a version of mod_lcr (svn 17134) where there are only id,name and cash field in the table. so the SQL request failed... Is there any similar settings for this version ?
Thanks
F
----- Original Message ----- *From:* Madovsky <infos@madovsky.org> *To:* freeswitch-users@lists.freeswitch.org *Sent:* Wednesday, July 28, 2010 1:26 PM *Subject:* [Freeswitch-users] mod_lcr + nibble_bill + leg B
Hi,
I followed the article at http://wiki.freeswitch.org/wiki/Mod_lcr
to activate nibble bill with mod_lcr on leg B, but the nibble bill account is not debited. I tried to put <action application="lcr" data="${dialed_extension} public"/> in dialplan with no success, it generates a "bad gateway" error when I tried to call the user from outside FS. did I forget to set something ?
Thanks
F
------------------------------
_______________________________________________ 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
_______________________________________________ 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
------------------------------
_______________________________________________ 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
_______________________________________________ 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
Rupa, I'm sorry but your example in nibble_bill inegration with lcr shows this : JOIN accounts a ON a.account_code = '${account_code}' but on nibble_bill wiki page there is no table name changedit's always id,name,cash.So do I rename a.account_code as a.id in your SQL example ?and add also the fieldswarn_limit and nobal_limit in nibble_bill accounts table ?ThxFranck----- Original Message ----- From: Rupa Schomaker To: FreeSWITCH Users Help Sent: Thursday, July 29, 2010 2:12 AM Subject: Re: [Freeswitch-users] mod_lcr + nibble_bill + leg B the tables? If you followed the wiki they are fine. That example is if you want to bridge using an expanded dialstring later on. You can also: bridge to lcr/$1 (hmm... I need to make it support profile, right now it only uses default) or transfer to "lcr $1 public" or execute_extension "lcr $1 public" if you want to continue processing after the call If you intend to use limit, only the lcr/ endpoint or transfer or execute_extension methods support automatic limits on the b-leg. On Wed, Jul 28, 2010 at 1:19 PM, Madovsky <infos@madovsky.org> wrote: if I update FS, should I remove all the lcr tables ? should I also activate lcr in dialplan with <action application="lcr" data="$1 public"/> ? thx F ----- Original Message ----- From: Madovsky To: FreeSWITCH Users Help Sent: Wednesday, July 28, 2010 2:02 PM Subject: Re: [Freeswitch-users] mod_lcr + nibble_bill + leg B for now I can't. it will take ages before I correct my cluster.... ----- Original Message ----- From: Rupa Schomaker To: FreeSWITCH Users Help Sent: Wednesday, July 28, 2010 1:48 PM Subject: Re: [Freeswitch-users] mod_lcr + nibble_bill + leg B umm.... update to latest git version? On Wed, Jul 28, 2010 at 12:40 PM, Madovsky <infos@madovsky.org> wrote: ok apparently I use a version of mod_lcr (svn 17134) where there are only id,name and cash field in the table. so the SQL request failed... Is there any similar settings for this version ? Thanks F ----- Original Message ----- From: Madovsky To: freeswitch-users@lists.freeswitch.org Sent: Wednesday, July 28, 2010 1:26 PM Subject: [Freeswitch-users] mod_lcr + nibble_bill + leg B Hi, I followed the article at http://wiki.freeswitch.org/wiki/Mod_lcr to activate nibble bill with mod_lcr on leg B, but the nibble bill account is not debited. I tried to put <action application="lcr" data="${dialed_extension} public"/> in dialplan with no success, it generates a "bad gateway" error when I tried to call the user from outside FS. did I forget to set something ? Thanks F -------------------------------------------------------------------- _______________________________________________ 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 _______________________________________________ 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 ------------------------------------------------------------------------ _______________________________________________ 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 _______________________________________________ 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 ------------------------------------------------------------------------------ _______________________________________________ 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
Ok I followed the wiki, installed the last FS git, set lcr custom sql as this: <profile name="default"> <param name="custom_sql" value=" SELECT l.digits, c.carrier_name, l.rate, cg.prefix AS gw_prefix, cg.suffix AS gw_suffix, l.lead_strip, l.trail_strip, l.prefix, l.suffix, cg.codec, l.cid, a.id AS nibble_account, l.rate*2.1 AS nibble_rate, a.warn_limit AS lowbal_amt,a.nobal_limit AS nobal_amt FROM lcr l JOIN carriers c ON l.carrier_id=c.id JOIN carrier_gateway cg ON c.id=cg.carrier_id JOIN accounts a ON a.id='${account_code}' WHERE c.enabled = '1' AND cg.enabled = '1' AND l.enabled = '1' AND digits_prefix @> '${lcr_query_expanded_digits}' ORDER BY digits DESC, rate ASC; "/> <param name="export_fields" value="nibble_account,nibble_rate,lowbal_amt,nobal_amt"/> </profile> but now no debit is done in cash field of accounts in both sense leg A or leg B . Any idea ? thanks F ----- Original Message ----- From: Rupa Schomaker To: FreeSWITCH Users Help Sent: Thursday, July 29, 2010 2:12 AM Subject: Re: [Freeswitch-users] mod_lcr + nibble_bill + leg B the tables? If you followed the wiki they are fine. That example is if you want to bridge using an expanded dialstring later on. You can also: bridge to lcr/$1 (hmm... I need to make it support profile, right now it only uses default) or transfer to "lcr $1 public" or execute_extension "lcr $1 public" if you want to continue processing after the call If you intend to use limit, only the lcr/ endpoint or transfer or execute_extension methods support automatic limits on the b-leg. On Wed, Jul 28, 2010 at 1:19 PM, Madovsky <infos@madovsky.org> wrote: if I update FS, should I remove all the lcr tables ? should I also activate lcr in dialplan with <action application="lcr" data="$1 public"/> ? thx F ----- Original Message ----- From: Madovsky To: FreeSWITCH Users Help Sent: Wednesday, July 28, 2010 2:02 PM Subject: Re: [Freeswitch-users] mod_lcr + nibble_bill + leg B for now I can't. it will take ages before I correct my cluster.... ----- Original Message ----- From: Rupa Schomaker To: FreeSWITCH Users Help Sent: Wednesday, July 28, 2010 1:48 PM Subject: Re: [Freeswitch-users] mod_lcr + nibble_bill + leg B umm.... update to latest git version? On Wed, Jul 28, 2010 at 12:40 PM, Madovsky <infos@madovsky.org> wrote: ok apparently I use a version of mod_lcr (svn 17134) where there are only id,name and cash field in the table. so the SQL request failed... Is there any similar settings for this version ? Thanks F ----- Original Message ----- From: Madovsky To: freeswitch-users@lists.freeswitch.org Sent: Wednesday, July 28, 2010 1:26 PM Subject: [Freeswitch-users] mod_lcr + nibble_bill + leg B Hi, I followed the article at http://wiki.freeswitch.org/wiki/Mod_lcr to activate nibble bill with mod_lcr on leg B, but the nibble bill account is not debited. I tried to put <action application="lcr" data="${dialed_extension} public"/> in dialplan with no success, it generates a "bad gateway" error when I tried to call the user from outside FS. did I forget to set something ? Thanks F -------------------------------------------------------------------- _______________________________________________ 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 _______________________________________________ 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 ------------------------------------------------------------------------ _______________________________________________ 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 _______________________________________________ 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 ------------------------------------------------------------------------------ _______________________________________________ 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
participants (2)
-
Madovsky
-
Rupa Schomaker