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 <[EMAIL PROTECTED]> 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:[EMAIL PROTECTED] To=sip:[EMAIL PROTECTED] 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,[EMAIL PROTECTED],441,,442,,Europe/Paris,20,1
> 2,,sd-7501.dedibox.fr,[EMAIL PROTECTED],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,[EMAIL PROTECTED],10030.0000,2007-08-08 17:57:00,,0000-00-00 
> 00:00:00,0.0000,0,
> 2,[EMAIL PROTECTED],20010.0000,2007-08-08 17:38:09,,0000-00-00 
> 00:00:00,0.0000,0,
>
>
>
>
> ShowPrepaidAccounts Filter=sd-7501.dedibox.fr
> [EMAIL PROTECTED]              Balance=10030.0000
> [EMAIL PROTECTED]              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";"[EMAIL PROTECTED]";"336224af44cd989a";"sip:[EMAIL 
> PROTECTED]";"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";;;;;;;;;"[EMAIL
>  PROTECTED]";;"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:[EMAIL PROTECTED]
> [EMAIL PROTECTED] Gateway= Application=audio
>
>
>
>
>
>

_______________________________________________
Users mailing list
[email protected]
http://openser.org/cgi-bin/mailman/listinfo/users

Reply via email to