[OpenSER-Users] Re: OpenSER + CDRTool

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(a)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@sd-7501.dedibox.fr To=sip:106@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(a)sd-7501.dedibox.fr,441,,442,,Europe/Paris,20,1 > 2,,sd-7501.dedibox.fr,106(a)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(a)sd-7501.dedibox.fr,10030.0000,2007-08-08 17:57:00,,0000-00-00 00:00:00,0.0000,0, > 2,106(a)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(a)sd-7501.dedibox.fr Balance=10030.0000 > Account=106(a)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@192.168.95.50";"336224af44cd989a";"sip:106@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@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@sd-7501.dedibox.fr > To=101(a)sd-7501.dedibox.fr Gateway= Application=audio > > > > > >