9 Aug
2007
9 Aug
'07
12:09 p.m.
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