Re: [OpenSER-Users] Re: How can it be simpler and working? CDRTool

flavio Thu, 09 Aug 2007 04:54:32 -0700

Marc,

Have you checked your user rights in the CDRTool (is show price itemhighlighted?). My CDRtool shown x.xxx in the price and that's was thecause.


Flavio

----- Original Message -----From: "Marc LEURENT" <[EMAIL PROTECTED]>

To: "Dan-Cristian Bogos" <[EMAIL PROTECTED]>
Cc: <[email protected]>
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:[EMAIL PROTECTED] To=0033677832974Duration=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 [EMAIL PROTECTED]
[EMAIL PROTECTED]              Balance=10040.0000

ShowCustomers
default


ShowAccounts
Error: Invalid request

MaxSessionTime From=sip:[EMAIL PROTECTED] To=sip:[EMAIL PROTECTED]Duration=7200 Lock=1

none

DebitBalance From=sip:[EMAIL PROTECTED] To=sip:[EMAIL PROTECTED]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:[EMAIL PROTECTED] To=0033677832974Duration=59
0.0000
I have a field TrafficRate in the database but doesn't appear on theCDRTool 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 <[EMAIL PROTECTED]> 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,RateId2,H1-H2,Rate Id3,H2-H3,Rate Id4,H3-24
2,,sd-7501.dedibox.fr,[EMAIL PROTECTED],441,441,8,441,19,441,24,441,0
2,,sd-7501.dedibox.fr,[EMAIL PROTECTED],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,[EMAIL PROTECTED],441,31800,200,audio,2364
2,,sd-7501.dedibox.fr,[EMAIL PROTECTED],441,31800,200,audio,245
2,,,33677832974,441,131,2100,,2426
ShowPrice From=sip:[EMAIL PROTECTED] To=33677832974Duration=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 <[EMAIL PROTECTED]> wrote:
Hello Dan-Cristian,
I just want a simple thing, that when I'm connecting to the ratingengine 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 havechange 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 whereI'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,RateId2,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,Lastprice,Max,Destination2,[EMAIL PROTECTED],10030.0000,2007-08-08 17:57:00,,0000-00-0000:00:00,0.0000,0,2,[EMAIL PROTECTED],20010.0000,2007-08-08 17:38:09,,0000-00-0000: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 RealmNASIPAddress NASPortId NASPortType AcctStartTimeAcctStopTime AcctSessionTimeAcctAuthentic ConnectInfo_start ConnectInfo_stopAcctInputOctets AcctOutputOctets CalledStationIdCallingStationId AcctTerminateCauseServiceType FramedProtocol FramedIPAddressAcctStartDelay AcctStopDelay SipMethod SipResponseCodeSipToTag SipFromTagSipTranslatedRequestURI SipUserAgents SipApplicationTypeSipCodecs SipRPID SipRPIDHeader SourceIPSourcePort CanonicalURI DelayTimeTimestamp DestinationId Rate Price NormalizedBillingId MediaInfo RTPStatistics FromHeaderUserAgent 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 datasourceser_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=2Timestamp=1186649758 Duration=5 inputTraffic=0 outputTraffic=0From=sip:[EMAIL PROTECTED]
[EMAIL PROTECTED] Gateway= Application=audio


_______________________________________________
Users mailing list
[email protected]

http://openser.org/cgi-bin/mailman/listinfo/users


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

Re: [OpenSER-Users] Re: How can it be simpler and working? CDRTool

Reply via email to