<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=iso-8859-1" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.6001.18904">
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT size=2>Ok I followed the wiki,</FONT></DIV>
<DIV><FONT size=2>installed the last FS git,</FONT></DIV>
<DIV><FONT size=2>set lcr custom sql as this:</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2> <profile
name="default"><BR> <param name="custom_sql"
value="<BR>SELECT l.digits, c.carrier_name, l.rate, cg.prefix AS gw_prefix,
cg.suffix AS gw_suffix,<BR> l.lead_strip,
l.trail_strip, l.prefix, l.suffix, cg.codec, l.cid, a.id AS
nibble_account,<BR> l.rate*2.1 AS
nibble_rate, a.warn_limit AS lowbal_amt,a.nobal_limit AS nobal_amt<BR>FROM lcr
l<BR> JOIN carriers c ON
l.carrier_id=c.id<BR> JOIN carrier_gateway cg ON
c.id=cg.carrier_id<BR> JOIN accounts a ON
a.id='${account_code}'<BR>WHERE c.enabled = '1' AND cg.enabled = '1' AND
l.enabled = '1'<BR> AND digits_prefix @>
'${lcr_query_expanded_digits}'<BR>ORDER BY digits DESC, rate
ASC;<BR> "/><BR> <param
name="export_fields"
value="nibble_account,nibble_rate,lowbal_amt,nobal_amt"/><BR>
</profile><BR></FONT></DIV>
<DIV><FONT size=2>but now no debit is done in cash field of accounts in
both sense leg A or leg B .</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>Any idea ?</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>thanks</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>F</DIV></FONT>
<DIV><FONT size=2></FONT> </DIV>
<BLOCKQUOTE
style="BORDER-LEFT: #000000 2px solid; PADDING-LEFT: 5px; PADDING-RIGHT: 0px; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="FONT: 10pt arial; BACKGROUND: #e4e4e4; font-color: black"><B>From:</B>
<A title=rupa@rupa.com href="mailto:rupa@rupa.com">Rupa Schomaker</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A
title=freeswitch-users@lists.freeswitch.org
href="mailto:freeswitch-users@lists.freeswitch.org">FreeSWITCH Users Help</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Thursday, July 29, 2010 2:12
AM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Re: [Freeswitch-users] mod_lcr +
nibble_bill + leg B</DIV>
<DIV><BR></DIV>the tables? If you followed the wiki they are fine.
<DIV><BR></DIV>
<DIV>That example is if you want to bridge using an expanded dialstring later
on.</DIV>
<DIV><BR></DIV>
<DIV>You can also:</DIV>
<DIV><BR></DIV>
<DIV>bridge to lcr/$1 (hmm... I need to make it support profile, right
now it only uses default)</DIV>
<DIV><BR></DIV>
<DIV>or transfer to "lcr $1 public"</DIV>
<DIV><BR></DIV>
<DIV>or execute_extension "lcr $1 public" if you want to continue processing
after the call</DIV>
<DIV><BR></DIV>
<DIV>If you intend to use limit, only the lcr/ endpoint or transfer or
execute_extension methods support automatic limits on the b-leg.</DIV>
<DIV><BR></DIV>
<DIV>On Wed, Jul 28, 2010 at 1:19 PM, Madovsky <SPAN dir=ltr><<A
href="mailto:infos@madovsky.org">infos@madovsky.org</A>></SPAN>
wrote:</DIV>
<DIV>
<DIV class=gmail_quote>
<BLOCKQUOTE
style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex"
class=gmail_quote>
<DIV bgcolor="#ffffff">
<DIV><FONT size=2>if I update FS, should I remove all the lcr tables
?</FONT></DIV>
<DIV><FONT size=2>should I also activate lcr in dialplan with</FONT></DIV>
<DIV><FONT size=2><action application="lcr" data="$1 public"/>
?</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>thx</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>F</FONT></DIV>
<BLOCKQUOTE
style="BORDER-LEFT: #000000 2px solid; PADDING-LEFT: 5px; PADDING-RIGHT: 0px; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px"
dir=ltr>
<DIV class=im>
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV style="FONT: 10pt arial; BACKGROUND: #e4e4e4"><B>From:</B> <A
title=infos@madovsky.org href="mailto:infos@madovsky.org"
target=_blank>Madovsky</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A
title=freeswitch-users@lists.freeswitch.org
href="mailto:freeswitch-users@lists.freeswitch.org"
target=_blank>FreeSWITCH Users Help</A> </DIV></DIV>
<DIV>
<DIV></DIV>
<DIV class=h5>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Wednesday, July 28, 2010 2:02
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Re: [Freeswitch-users]
mod_lcr + nibble_bill + leg B</DIV>
<DIV><BR></DIV>
<DIV><FONT size=2>for now I can't.</FONT></DIV>
<DIV><FONT size=2>it will take ages before I correct my
cluster....</FONT></DIV>
<BLOCKQUOTE
style="BORDER-LEFT: #000000 2px solid; PADDING-LEFT: 5px; PADDING-RIGHT: 0px; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV style="FONT: 10pt arial; BACKGROUND: #e4e4e4"><B>From:</B> <A
title=rupa@rupa.com href="mailto:rupa@rupa.com" target=_blank>Rupa
Schomaker</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A
title=freeswitch-users@lists.freeswitch.org
href="mailto:freeswitch-users@lists.freeswitch.org"
target=_blank>FreeSWITCH Users Help</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Wednesday, July 28, 2010 1:48
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Re: [Freeswitch-users]
mod_lcr + nibble_bill + leg B</DIV>
<DIV><BR></DIV>umm.... update to latest git version?<BR><BR>
<DIV class=gmail_quote>On Wed, Jul 28, 2010 at 12:40 PM, Madovsky <SPAN
dir=ltr><<A href="mailto:infos@madovsky.org"
target=_blank>infos@madovsky.org</A>></SPAN> wrote:<BR>
<BLOCKQUOTE
style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex"
class=gmail_quote>
<DIV bgcolor="#ffffff">
<DIV><FONT size=2>ok apparently I use a version of mod_lcr (svn
17134)</FONT></DIV>
<DIV><FONT size=2>where there are only id,name and cash field in the
table.</FONT></DIV>
<DIV><FONT size=2>so the SQL request failed...</FONT></DIV>
<DIV><FONT size=2>Is there any similar settings for this version
?</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>Thanks</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>F</FONT></DIV>
<BLOCKQUOTE
style="BORDER-LEFT: #000000 2px solid; PADDING-LEFT: 5px; PADDING-RIGHT: 0px; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px">
<DIV>
<DIV></DIV>
<DIV>
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV style="FONT: 10pt arial; BACKGROUND: #e4e4e4"><B>From:</B> <A
title=infos@madovsky.org href="mailto:infos@madovsky.org"
target=_blank>Madovsky</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A
title=freeswitch-users@lists.freeswitch.org
href="mailto:freeswitch-users@lists.freeswitch.org"
target=_blank>freeswitch-users@lists.freeswitch.org</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Wednesday, July 28, 2010
1:26 PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> [Freeswitch-users]
mod_lcr + nibble_bill + leg B</DIV>
<DIV><BR></DIV>
<DIV><FONT size=2>Hi,</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>I followed the article at</FONT></DIV>
<DIV><FONT size=2><A href="http://wiki.freeswitch.org/wiki/Mod_lcr"
target=_blank>http://wiki.freeswitch.org/wiki/Mod_lcr</A></FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>to activate nibble bill with mod_lcr on leg B, but
the nibble bill</FONT></DIV>
<DIV><FONT size=2>account is not debited.</FONT></DIV>
<DIV><FONT size=2>I tried to put</FONT></DIV>
<DIV><FONT size=2><action application="lcr"
data="${dialed_extension} public"/></FONT></DIV>
<DIV><FONT size=2>in dialplan with no success, it generates a "bad
gateway" error when</FONT></DIV>
<DIV><FONT size=2>I tried to call the user from outside
FS.</FONT></DIV>
<DIV><FONT size=2>did I forget to set something ?</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>Thanks</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>F</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV></DIV></DIV>
<P></P>
<HR>
<DIV>
<P></P>_______________________________________________<BR>FreeSWITCH-users
mailing list<BR><A
href="mailto:FreeSWITCH-users@lists.freeswitch.org"
target=_blank>FreeSWITCH-users@lists.freeswitch.org</A><BR><A
href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users"
target=_blank>http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</A><BR>UNSUBSCRIBE:<A
href="http://lists.freeswitch.org/mailman/options/freeswitch-users"
target=_blank>http://lists.freeswitch.org/mailman/options/freeswitch-users</A><BR><A
href="http://www.freeswitch.org"
target=_blank>http://www.freeswitch.org</A><BR></DIV>
<P></P></BLOCKQUOTE></DIV><BR>_______________________________________________<BR>FreeSWITCH-users
mailing list<BR><A href="mailto:FreeSWITCH-users@lists.freeswitch.org"
target=_blank>FreeSWITCH-users@lists.freeswitch.org</A><BR><A
href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users"
target=_blank>http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</A><BR>UNSUBSCRIBE:<A
href="http://lists.freeswitch.org/mailman/options/freeswitch-users"
target=_blank>http://lists.freeswitch.org/mailman/options/freeswitch-users</A><BR><A
href="http://www.freeswitch.org"
target=_blank>http://www.freeswitch.org</A><BR><BR></BLOCKQUOTE></DIV><BR><BR
clear=all><BR>-- <BR>-Rupa<BR>
<P></P>
<HR>
<P></P>_______________________________________________<BR>FreeSWITCH-users
mailing list<BR><A href="mailto:FreeSWITCH-users@lists.freeswitch.org"
target=_blank>FreeSWITCH-users@lists.freeswitch.org</A><BR><A
href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users"
target=_blank>http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</A><BR>UNSUBSCRIBE:<A
href="http://lists.freeswitch.org/mailman/options/freeswitch-users"
target=_blank>http://lists.freeswitch.org/mailman/options/freeswitch-users</A><BR><A
href="http://www.freeswitch.org"
target=_blank>http://www.freeswitch.org</A><BR>
<P></P></BLOCKQUOTE></DIV></DIV></BLOCKQUOTE></DIV><BR>_______________________________________________<BR>FreeSWITCH-users
mailing list<BR><A
href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</A><BR><A
href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users"
target=_blank>http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</A><BR>UNSUBSCRIBE:<A
href="http://lists.freeswitch.org/mailman/options/freeswitch-users"
target=_blank>http://lists.freeswitch.org/mailman/options/freeswitch-users</A><BR><A
href="http://www.freeswitch.org"
target=_blank>http://www.freeswitch.org</A><BR><BR></BLOCKQUOTE></DIV><BR><BR
clear=all><BR>-- <BR>-Rupa<BR></DIV>
<P>
<HR>
<P></P>_______________________________________________<BR>FreeSWITCH-users
mailing
list<BR>FreeSWITCH-users@lists.freeswitch.org<BR>http://lists.freeswitch.org/mailman/listinfo/freeswitch-users<BR>UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users<BR>http://www.freeswitch.org<BR></BLOCKQUOTE></BODY></HTML>