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
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 -----
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
Sent: Wednesday, July 28, 2010 1:26 PM
Subject: [Freeswitch-users] mod_lcr + nibble_bill + leg B

Hi,
 
I followed the article at
 
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




--
-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