[OpenSER-Users] OpenSER + CDRTool

[Dan-Cristian Bogos]

Marc,

unfortunately I don't know any logs generated by CDRTool ( only some
summary tasks seen in syslog). It looks like u have a problem in
matching your CDRs.

There are some variables in cdrlib.phtml like intAccessCode which
helped me in matching the destinations which are not international (
the destination list for CDRTool had to be for me in International
format in order to be matched).

Hope those tips would help.

Cheers,
DanB

On 8/7/07, Marc LEURENT <lftsy at free.fr> wrote:
> Yes I have followed the tutorial and after some changes due to upgrades, it's working,
> in the cdrtool web interface, I can see the cdrs... With the time of the calls, the canonical URI, the billing_party...
> But the price is not calculated...
>
> Is there any way to see if cdrtool is doing something?
> In my last email, i have posted the databases...
>
> Thanks
>
> Dan-Cristian Bogos a écrit :
> > Hello Marc,
> >
> > did u follow ./doc/INSTALL.txt?  Can u access CDRTool via the web
> > interface? Make sure u can see the cdrs with the search tool. After
> > that it is a question of proper setting the pricelist (since it can be
> > pretty complex) and making sure u can connect to rating engine.
> >
> > Cheers,
> > DanB
> >
> > On 8/7/07, Marc LEURENT <lftsy at free.fr> wrote:
> >> Hello everybody,
> >> I was wondering what should I add in my cdrtool configuration to enable the communication price calculation
> >> CDRTool has evrything he needs from the freeradius.acct table, billing party and Canonical URI...
> >>
> >>
> >> Is it possible to monitor what CDRTool is doing???
> >> Is there logs somewhere...
> >> Thanks
> >>
> >>
> >>
> >> I have also filled the billing_rates database:
> >> id      gateway                 domain  subscriber      name    destination     durationRate    trafficRate     application     connectCost
> >> "1";;"sd-7501.dedibox.fr";;;"103 at sd-7501.dedibox.fr";"23";;"3";"2"
> >>
> >>
> >> destinations database:
> >> id      gateway         domain  subscriber      dest_id         dest_name
> >> "1";;"sd-7501.dedibox.fr";"103 at sd-7501.dedibox.fr";"1";"Domaine SIP locale"
> >>
> >> billing_customers:
> >> id      gateway         domain  subscriber      profile_name1   profile_name1_alt       profile_name2   profile_name2_alt       timezone        increment       min_duration    country_code
> >> "1";;"sd-7501.dedibox.fr";"103 at sd-7501.dedibox.fr";;;;;;"10";"10";
> >> "2";;"sd-7501.dedibox.fr";"106 at sd-7501.dedibox.fr";;;;;;"20";"35";
> >>
> >>
> >>
> >> Here is what I see with CDRTool interface:
> >>
> >> 1N      2007-08-07 10:38:52     88.191.45.91                    103 at sd-7501.dedibox.fr          00:04           0.00    0.00     Ok (200)
> >> Signalling information
> >>         Session:         sjozozxmfficcar at 192.168.95.47
> >>         Start time:     2007-08-07 10:38:52 Europe/Paris
> >>         Stop time:      2007-08-07 10:38:56 Europe/Paris
> >>         Method:         INVITE from :
> >>         From:
> >>         Dialed URI:
> >>         Canonical URI:  103 at sd-7501.dedibox.fr
> >>         Next hop URI:
> >>         Billing Party:  sip:106 at sd-7501.dedibox.fr
> >>
> >> Rating information
> >>         Free call
> >>
> >>
> >>
> >> Best Regards,
> >>
> >> Marc LEURENT
> >>
> >> _______________________________________________
> >> Users mailing list
> >> Users at openser.org
> >> http://openser.org/cgi-bin/mailman/listinfo/users
> >>
>