[Freeswitch-users] mod_nibblebill cdr

budi wibowo bwibowo at gmail.com
Wed Nov 10 13:17:29 PST 2010


thx, i will try that.
other opinion, i found
2010-11-11 04:03:18.503474 [DEBUG] mod_dingaling.c:1350 CHANNEL LOOPBACK
2010-11-11 04:03:18.505460 [DEBUG] mod_nibblebill.c:572 Received request via
SESSION_HEARTBEAT!
2010-11-11 04:03:18.505460 [DEBUG] mod_nibblebill.c:433 Attempting to bill
at $0.03 per minute to account 1000
2010-11-11 04:03:18.505460 [INFO] mod_nibblebill.c:485 Beginning new billing
on *93dc8ab7-6f8d-4918-ab32-b4a4ad115eaf*
2010-11-11 04:03:18.505460 [DEBUG] mod_nibblebill.c:491 0 seconds passed
since last bill time of 2010-11-11 04:03:18
on debug mode.

93dc8ab7-6f8d-4918-ab32-b4a4ad115eaf can be found on cdr , how to insert
this info and call cost to new table?


regards

budi


On Thu, Nov 4, 2010 at 10:37 AM, Dome Charoenyost <dome at tel.co.th> wrote:

> This is my cdr_csv.conf.xml
>
> <configuration name="cdr_csv.conf" description="CDR CSV Format">
>  <settings>
>    <!-- 'cdr-csv' will always be appended to log-base -->
>    <!--<param name="log-base" value="/var/log"/>-->
>    <param name="default-template" value="sql"/>
>    <!-- This is like the info app but after the call is hung up -->
>    <!--<param name="debug" value="true"/>-->
>    <param name="rotate-on-hup" value="true"/>
>    <!-- may be a b or ab -->
>    <param name="legs" value="ab"/>
>        <!-- Only log in Master.csv -->
>    <param name="master-file-only" value="true"/>
>  </settings>
>  <templates>
>    <template name="sql">INSERT INTO voipcall
>
> (prate,pcost,provider,provider_id,pprefix,bleg,price,duration,initialincrement,regularincrement,graceperiod,tariffdesc,prefix,service_charge,cost,username,callingstationid,calledstationid,duration_raw,acctstoptime,acctstarttime,acctsessionid,hangup_cause)
>    values
> (${prate},(${billsec}+1)/60.00*${prate},'${provider_name}',${provider_id},${pprefix},'${bleg_uuid}',${tux_rate},${t_duration},${in_block},${re_block},${gr_block},'${dest}','${iprefix}',${ser_charge},${tux_total_billed}/100,'${tux_account}','${caller_id_number}',
> '${dnumber}',(${billsec}+1), '${end_stamp}','${start_stamp}'
> ,'${uuid}','${hangup_cause}');</template>
>
>
>
> 2010/11/4 budi wibowo <bwibowo at gmail.com>:
> > the perl script can parse all cdr and insert to database, but no info
> about
> > the cost defined in nibblebill.
> >
> > On Wed, Nov 3, 2010 at 1:52 PM, Dome Charoenyost <dome at tel.co.th> wrote:
> >>
> >> 2010/11/3 William Suffill <william.suffill at gmail.com>:
> >> > You can customize the variables stored by mod cdr_csv to include those
> >> > set by nibblebill if you rather not have mess with mod_cdr_xml
> >> >
> >> > http://wiki.freeswitch.org/wiki/Mod_cdr_csv#Variables_in_a_template
> >> >
> >> I agree :)
> >> for my solution i modify nibble bill support many feature initial
> >> block , regular block, grace period (30/6 , 1/1 , 60/60),  multiple
> >> rate (first 2 minute  0.5 usd and next 0.2 usd)  .. etc
> >> and define channel variable for csv cdr (about 30 columns)
> >>
> >> Dome C.
> >>
> >>
> >>
> >> > Just define a  new template that includes the nibblebill variables and
> >> > use that instead of the default.
> >> >
> >> > -- W
> >> >
> >> > PS: I would include an example but don't have it handy.
> >> >
> >> > _______________________________________________
> >> > 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
> >
> >
> > _______________________________________________
> > 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20101111/79e555e4/attachment.html 


More information about the FreeSWITCH-users mailing list