[OpenSER-Users] Re: OpenSER + CDRTool

Marc LEURENT lftsy at free.fr
Thu Aug 9 11:41:40 CEST 2007


I have added:

Destination:
Ops,Gateway,Domain,Subscriber,Destination Id,Description
2,,sd-7501.dedibox.fr,,31800,Ma Dst TEST
2,,,33677832974,131,TEST INTERNATIONAL

Profiles:
Ops,Gateway,Domain,Subscriber,Profile Id,Rate Id1,00-H1,Rate Id2,H1-H2,Rate Id3,H2-H3,Rate Id4,H3-24
2,,sd-7501.dedibox.fr,101 at sd-7501.dedibox.fr,441,441,8,441,19,441,24,441,0
2,,sd-7501.dedibox.fr,106 at sd-7501.dedibox.fr,441,441,8,441,19,441,24,441,0
2,,,33677832974,441,441,22,441,23,441,24,441,0

Rates:
Ops,Gateway,Domain,Subscriber,Rate Id,Destination,Price,App,Connect
2,,sd-7501.dedibox.fr,,441,31800,2100,audio,4647
2,,sd-7501.dedibox.fr,101 at sd-7501.dedibox.fr,441,31800,200,audio,2364
2,,sd-7501.dedibox.fr,102 at sd-7501.dedibox.fr,441,31800,200,audio,245
2,,,33677832974,441,131,2100,,2426



ShowPrice      From=sip:101 at sd-7501.dedibox.fr To=33677832974 Duration=59
0.0000

But it is still not working...
Could you spent some time sending me a part of yours...
And are you using CDRTool 5.2.1??

Thanks


Dan-Cristian Bogos a écrit :
> Hi Marc,
> 
> can u do me a favor and try adding in an international destination in
> your pricelist and try placing a call to it. See if you get billing
> calculation for it. I suspect that your billing doesn't match the
> destination due to prefixes which are normally stripped. Not quite a
> CDRTool internals expert but my installation simply works for
> international destinations.
> 
> DanB
> 
> On 8/9/07, Marc LEURENT <lftsy at free.fr> wrote:
>> Hello Dan-Cristian,
>>
>> I just want a simple thing, that when I'm connecting to the rating engine using telnet: telnet 127.0.0.1 9024
>> When I enter such a command, that the price should be != 0:
>>
>> ShowPrice      From=sip:101 at sd-7501.dedibox.fr To=sip:106 at sd-7501.dedibox.fr Duration=59
>> 0.0000
>>
>> Help would be very grateful...
>> Thanks...
>>
>>
>> The rating engine is requesting the good radaact200708 table (I have change my globac.inc conf file
>> "ser_radius"=>array(
>>                     "name"               => "OpenSER",
>>                     "class"              => "CDRS_ser_radius",
>>                     "table"              => "radacct".date("Ym"),
>>                         ......
>>
>> )
>>
>>
>>
>> Here is a view of the rating tables... And I don't understand where I'm wrong..
>>
>> Destinations:
>> Ops,Gateway,Domain,Subscriber,Destination Id,Description
>> 2,,sd-7501.dedibox.fr,,31800,Ma Dst TEST
>>
>> Customers:
>> Ops,Gateway,Domain,Subscriber,WeekDay,Fallback,WeekEnd,Fallback,Timezone,Incr,Minim
>> 2,,sd-7501.dedibox.fr,101 at sd-7501.dedibox.fr,441,,442,,Europe/Paris,20,1
>> 2,,sd-7501.dedibox.fr,106 at sd-7501.dedibox.fr,441,,442,,Europe/Paris,34,1
>>
>> Profiles:
>> Ops,Gateway,Domain,Subscriber,Profile Id,Rate Id1,00-H1,Rate Id2,H1-H2,Rate Id3,H2-H3,Rate Id4,H3-24
>> 2,,sd-7501.dedibox.fr,,441,442,8,441,19,441,24,441,0
>> 2,,sd-7501.dedibox.fr,,442,442,24,442,0,442,0,442,0
>>
>> Rates:
>> Ops,Gateway,Domain,Subscriber,Rate Id,Destination,Price,App,Connect
>> 2,,,,441,31800,2100,audio,0
>> 2,,,,442,31800,200,audio,0
>>
>> Prepaid:
>> Ops,Account,Balance,Last change,Lock,Start time,Last price,Max,Destination
>> 2,101 at sd-7501.dedibox.fr,10030.0000,2007-08-08 17:57:00,,0000-00-00 00:00:00,0.0000,0,
>> 2,106 at sd-7501.dedibox.fr,20010.0000,2007-08-08 17:38:09,,0000-00-00 00:00:00,0.0000,0,
>>
>>
>>
>>
>> ShowPrepaidAccounts Filter=sd-7501.dedibox.fr
>> Account=101 at sd-7501.dedibox.fr              Balance=10030.0000
>> Account=106 at sd-7501.dedibox.fr              Balance=20010.0000
>>
>>
>>
>>
>>
>> And here is my radacct200708 table:
>> RadAcctId       AcctSessionId   AcctUniqueId    UserName        Realm   NASIPAddress    NASPortId       NASPortType     AcctStartTime   AcctStopTime    AcctSessionTime
>> AcctAuthentic   ConnectInfo_start       ConnectInfo_stop        AcctInputOctets         AcctOutputOctets        CalledStationId         CallingStationId        AcctTerminateCause
>> ServiceType     FramedProtocol  FramedIPAddress         AcctStartDelay  AcctStopDelay   SipMethod       SipResponseCode         SipToTag        SipFromTag
>> SipTranslatedRequestURI         SipUserAgents   SipApplicationType      SipCodecs       SipRPID         SipRPIDHeader   SourceIP        SourcePort      CanonicalURI    DelayTime
>> Timestamp       DestinationId   Rate    Price   Normalized      BillingId       MediaInfo       RTPStatistics   FromHeader      UserAgent       Contact
>>
>> "2";"vjyxdmwkbbjajnc at 192.168.95.50";"336224af44cd989a";"sip:106 at sd-7501.dedibox.fr";"sd-7501.dedibox.fr";"88.191.45.91";"5060";;"2007-08-09
>> 10:55:58";"2007-08-09
>> 10:56:03";"5";NULL;NULL;;"0";"0";;;"200";"Sip-Session";;;"0";"0";"INVITE";"200";"c0a80101-20e94fd";"nxitc";;;;;;;;;"101 at sd-7501.dedibox.fr";;"0";;;NULL;"0";;NULL;;;;
>>
>>
>>
>> And my syslog:
>>
>> Aug  9 11:00:03 sd-7501 CDRTool[17377]: Normalize datasource ser_radius, database DB_radius, table radacct200708
>> Aug  9 11:00:03 sd-7501 CDRTool[17377]: Lock ser_radius:radacct200708
>> Aug  9 11:00:03 sd-7501 CDRTool[17097]: ShowPrice Id=2 Timestamp=1186649758 Duration=5 inputTraffic=0 outputTraffic=0 From=sip:106 at sd-7501.dedibox.fr
>> To=101 at sd-7501.dedibox.fr Gateway= Application=audio
>>
>>
>>
>>
>>
>>




More information about the sr-users mailing list