[Freeswitch-users] mod_lcr + nibble_bill + leg B

[Madovsky]

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 at 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 at 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 at 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 at 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 at 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 at 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 at 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 at lists.freeswitch.org
  http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
  UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
  http://www.freeswitch.org
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20100731/01699d37/attachment-0001.html