[OpenSER-Users] Re: How can it be simpler and working? CDRTool
flavio
flavio at asteriskguide.com
Thu Aug 9 14:25:23 CEST 2007
Marc,
I'm using 5.1.5 and it is working. Check the /var/log/syslog for errors in
the normalization process
Something like:
Aug 6 07:18:55 debian CDRTool[3973]: Error: Cannot find rates for callid=,
d
omain=192.168.1.160, destination=1305, profile=441, app=audio
The correct in the tests I have made is:
Aug 6 07:47:44 debian CDRTool[3973]: ShowPrice Id=88 Timestamp=1186400781
Du
ration=57 inputTraffic=0 outputTraffic=0 From=1000 at 192.168.1.160
To=001305345
6789 at 192.168.1.160 Gateway=192.168.1.118 Application=audio
Aug 6 07:47:44 debian CDRTool[3973]: ConnectFee=0.0000 Span=1 Duration=57
De
stId=1305 domain=192.168.1.160 Profile=441 Period=weekday Rate=441
Interval=8
-19 Cost=0.0200/10 Price=0.1140
please activate the following parameter in the global.inc file
(reportMissingRates).
$CDRTool['rating']=array("priceDenominator" => 10000,"priceDecimalDigits"
=> 4,"minimumDurationCharged"=> 0,"durationPeriodRated"=>
60,"trafficSizeRated"=> 1024,"reportMissingRates"=> 1,"minimumDuration"=>
0);
I hope it helps, it took me a long time before to start working.
Cheers
Flavio
----- Original Message -----
From: "Marc LEURENT" <lftsy at free.fr>
To: "flavio" <flavio at asteriskguide.com>
Cc: <users at openser.org>
Sent: Thursday, August 09, 2007 9:01 AM
Subject: Re: [OpenSER-Users] Re: How can it be simpler and working? CDRTool
> Yes, I've added all rights to my account...
> and price is NULL in the database until a Normalize is done! All prices
> are set to 0.0000 after...
>
> And after a
> Normalize datasource ser_radius, database DB_radius, table radacct200708
> Aug 9 14:00:02 sd-7501 CDRTool[18946]: ShowPrice Id=3
> Timestamp=1186660750 Duration=11 inputTraffic=0 outputTraffic=0
> From=sip:106 at sd-7501.dedibox.fr
> To=6713 at sd-7501.dedibox.fr Gateway= Application=audio
>
>
>
>
> flavio a écrit :
>> Marc,
>>
>> Have you checked your user rights in the CDRTool (is show price item
>> highlighted?). My CDRtool shown x.xxx in the price and that's was the
>> cause.
>>
>> Flavio
>>
>> ----- Original Message ----- From: "Marc LEURENT" <lftsy at free.fr>
>> To: "Dan-Cristian Bogos" <dan.bogos at gmail.com>
>> Cc: <users at openser.org>
>> Sent: Thursday, August 09, 2007 8:01 AM
>> Subject: [OpenSER-Users] Re: How can it be simpler and working? CDRTool
>>
>>
>> I'm starting to fell sorry to bother you like that...
>> I have changed the database like you said, but it is still not working...
>>
>> ShowPrice From=sip:101 at sd-7501.dedibox.fr To=0033677832974
>> Duration=5923
>> 0.0000
>>
>> Should I try to downgrade to version 5.1.3 like yours?
>>
>> ShowMemory
>> 1 destinations
>> 1 customers
>> 1 profiles
>> 1 rates
>> 0 holidays
>> 2 prepaid accounts
>> 1 sessions
>> 1 sessions last minute
>> 1 sessions last hour
>> 1 sessions last day
>>
>>
>> but in the database, the prepaid account is credited by 10.00
>> ShowPrepaidAccounts Filter=101 at sd-7501.dedibox.fr
>> Account=101 at sd-7501.dedibox.fr Balance=10040.0000
>>
>> ShowCustomers
>> default
>>
>>
>> ShowAccounts
>> Error: Invalid request
>>
>> MaxSessionTime From=sip:101 at sd-7501.dedibox.fr
>> To=sip:106 at sd-7501.dedibox.fr Duration=7200 Lock=1
>> none
>>
>> DebitBalance From=sip:101 at sd-7501.dedibox.fr
>> To=sip:106 at sd-7501.dedibox.fr Duration=59
>> Ok
>>
>>
>>
>>
>> Dan-Cristian Bogos a écrit :
>>> Ok, let's take it in your way. I would rather modify your data into:
>>>
>>> Destinations:
>>> Ops,Gateway,Domain,Subscriber,Destination Id,Description
>>> 2,,,,131,TEST INTERNATIONAL
>>>
>>> Customers:
>>> Ops,Gateway,Domain,Subscriber,WeekDay,Fallback,WeekEnd,Fallback,Timezone,Incr,Minim
>>>
>>> 2,,,,441,,441,,,1,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,,,,441,441,8,441,19,441,24,441,0
>>>
>>> Rates:
>>> Ops,Gateway,Domain,Subscriber,Rate Id,Destination,Price,App,Connect
>>> 2,,,,441,131,2100,audio,0
>>>
>>> U did not have a rate id and no App. Without App field for me it does
>>> not calculate either.
>>>
>>> DanB
>>>
>>>>
>>>>
>>>> But, the command ShowPrice returns:
>>>> ShowPrice From=sip:101 at sd-7501.dedibox.fr To=0033677832974
>>>> Duration=59
>>>> 0.0000
>>>>
>>>>
>>>> I have a field TrafficRate in the database but doesn't appear on the
>>>> CDRTool interface
>>>> I put random values inside
>>>>
>>>>
>>>> Dan-Cristian Bogos a écrit :
>>>>> My version is:
>>>>> CDRTool version 5.1.3
>>>>>
>>>>> In my rates table I have one more field more which is TrafficRate. I
>>>>> see that this one is missing on your side.
>>>>> Can u also create a default rate table without filling any of the
>>>>> gateway, subscriber, domain in profiles? This one should match all the
>>>>> destinations. Maybe would be useful till u make it work to have only
>>>>> the test row and remove anything else to take it gradually.
>>>>> Also, try querying for price with 00 added in the front of the
>>>>> destination since this is the default prefix set in CDRTool for
>>>>> international destinations (without being necessary to be added in
>>>>> rate or destination table).
>>>>>
>>>>> DanB
>>>>>
>>>>> On 8/9/07, Marc LEURENT <lftsy at free.fr> wrote:
>>>>>> 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
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>
>> _______________________________________________
>> Users mailing list
>> Users at openser.org
>> http://openser.org/cgi-bin/mailman/listinfo/users
More information about the sr-users
mailing list