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@sd-7501.dedibox.fr,441,441,8,441,19,441,24,441,0 2,,sd-7501.dedibox.fr,106@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@sd-7501.dedibox.fr,441,31800,200,audio,2364 2,,sd-7501.dedibox.fr,102@sd-7501.dedibox.fr,441,31800,200,audio,245 2,,,33677832974,441,131,2100,,2426

ShowPrice From=sip:101@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@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@sd-7501.dedibox.fr,441,,442,,Europe/Paris,20,1 2,,sd-7501.dedibox.fr,106@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@sd-7501.dedibox.fr,10030.0000,2007-08-08 17:57:00,,0000-00-00 00:00:00,0.0000,0, 2,106@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@sd-7501.dedibox.fr Balance=10030.0000 Account=106@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@sd-7501.dedibox.fr Gateway= Application=audio

I'm trying to set the simpler one...

I have created a default rate profile:

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,441,441,,2,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,,,,,131,2100,,2426

But, the command ShowPrice returns: ShowPrice From=sip:101@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@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@sd-7501.dedibox.fr,441,441,8,441,19,441,24,441,0 2,,sd-7501.dedibox.fr,106@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@sd-7501.dedibox.fr,441,31800,200,audio,2364 2,,sd-7501.dedibox.fr,102@sd-7501.dedibox.fr,441,31800,200,audio,245 2,,,33677832974,441,131,2100,,2426

ShowPrice From=sip:101@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@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@sd-7501.dedibox.fr,441,,442,,Europe/Paris,20,1 2,,sd-7501.dedibox.fr,106@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@sd-7501.dedibox.fr,10030.0000,2007-08-08 17:57:00,,0000-00-00 00:00:00,0.0000,0, 2,106@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@sd-7501.dedibox.fr Balance=10030.0000 Account=106@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@sd-7501.dedibox.fr Gateway= Application=audio

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@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@sd-7501.dedibox.fr Account=101@sd-7501.dedibox.fr Balance=10040.0000

ShowCustomers default

ShowAccounts Error: Invalid request

MaxSessionTime From=sip:101@sd-7501.dedibox.fr To=sip:106@sd-7501.dedibox.fr Duration=7200 Lock=1 none

DebitBalance From=sip:101@sd-7501.dedibox.fr To=sip:106@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@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@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@sd-7501.dedibox.fr,441,441,8,441,19,441,24,441,0 2,,sd-7501.dedibox.fr,106@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@sd-7501.dedibox.fr,441,31800,200,audio,2364 2,,sd-7501.dedibox.fr,102@sd-7501.dedibox.fr,441,31800,200,audio,245 2,,,33677832974,441,131,2100,,2426

ShowPrice From=sip:101@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@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@sd-7501.dedibox.fr,441,,442,,Europe/Paris,20,1 2,,sd-7501.dedibox.fr,106@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@sd-7501.dedibox.fr,10030.0000,2007-08-08 17:57:00,,0000-00-00 00:00:00,0.0000,0, 2,106@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@sd-7501.dedibox.fr Balance=10030.0000 Account=106@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@sd-7501.dedibox.fr Gateway= Application=audio

Yes, but when I do that, I can check in the mysql.log:

DebitBalance From=sip:101@sd-7501.dedibox.fr To=0033677832975 Duration=5467 Ok

10638 Query update prepaid set balance = balance - '0.0000', change_date = NOW(), last_call_price = '0.0000', call_in_progress = '0000-00-00 00:00:00', call_lock = '0', maxsessiontime = '0' where account = '101@sd-7501.dedibox.fr'

To there should be an error just there in the tables, but I can't find it... I don't understand

...

...

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

Dan-Cristian Bogos a écrit :

I would not downgrade it just because this one works for me. I think that AG-Projects did not release something which doesn't work so there must be some trick around.

U said that there was balance deducting. How did u ask that? Did u use MaxSessionTime and DebitBalance commands to simulate a call? If your balance was deducted it looks like there was some price found. Maybe would be useful to find out that.

DanB

On 8/9/07, Marc LEURENT lftsy@free.fr wrote:

...

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@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@sd-7501.dedibox.fr Account=101@sd-7501.dedibox.fr Balance=10040.0000

ShowCustomers default

ShowAccounts Error: Invalid request

MaxSessionTime From=sip:101@sd-7501.dedibox.fr To=sip:106@sd-7501.dedibox.fr Duration=7200 Lock=1 none

DebitBalance From=sip:101@sd-7501.dedibox.fr To=sip:106@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@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@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@sd-7501.dedibox.fr,441,441,8,441,19,441,24,441,0 2,,sd-7501.dedibox.fr,106@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@sd-7501.dedibox.fr,441,31800,200,audio,2364 2,,sd-7501.dedibox.fr,102@sd-7501.dedibox.fr,441,31800,200,audio,245 2,,,33677832974,441,131,2100,,2426

ShowPrice From=sip:101@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@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@sd-7501.dedibox.fr,441,,442,,Europe/Paris,20,1 >> 2,,sd-7501.dedibox.fr,106@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@sd-7501.dedibox.fr,10030.0000,2007-08-08 17:57:00,,0000-00-00 00:00:00,0.0000,0, >> 2,106@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@sd-7501.dedibox.fr Balance=10030.0000 >> Account=106@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@sd-7501.dedibox.fr Gateway= Application=audio >> >> >> >> >> >>

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@sd-7501.dedibox.fr To=6713@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@free.fr To: "Dan-Cristian Bogos" dan.bogos@gmail.com Cc: users@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@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@sd-7501.dedibox.fr Account=101@sd-7501.dedibox.fr Balance=10040.0000

ShowCustomers default

ShowAccounts Error: Invalid request

MaxSessionTime From=sip:101@sd-7501.dedibox.fr To=sip:106@sd-7501.dedibox.fr Duration=7200 Lock=1 none

DebitBalance From=sip:101@sd-7501.dedibox.fr To=sip:106@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@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@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@sd-7501.dedibox.fr,441,441,8,441,19,441,24,441,0

2,,sd-7501.dedibox.fr,106@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@sd-7501.dedibox.fr,441,31800,200,audio,2364 2,,sd-7501.dedibox.fr,102@sd-7501.dedibox.fr,441,31800,200,audio,245 2,,,33677832974,441,131,2100,,2426

ShowPrice From=sip:101@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@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@sd-7501.dedibox.fr,441,,442,,Europe/Paris,20,1 > > 2,,sd-7501.dedibox.fr,106@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@sd-7501.dedibox.fr,10030.0000,2007-08-08 > 17:57:00,,0000-00-00 00:00:00,0.0000,0, > 2,106@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@sd-7501.dedibox.fr Balance=10030.0000 > Account=106@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@sd-7501.dedibox.fr Gateway= Application=audio > > > > > >

---

Users mailing list Users@openser.org http://openser.org/cgi-bin/mailman/listinfo/users

I've got a running tail -f /var/lig/messages and I haven't seen a single error... It's just that it calculates 0.0000 for the price

I have already added the $CDRTool['rating'] parameter..

Id don't have the same message: Aug 9 14:00:02 sd-7501 CDRTool[18946]: ShowPrice Id=3 Timestamp=1186660750 Duration=11 inputTraffic=0 outputTraffic=0 From=sip:106@sd-7501.dedibox.fr To=6713@sd-7501.dedibox.fr Gateway= Application=audio Aug 9 14:00:02 sd-7501 CDRTool[19627]: Normalization done in 0 s, memory usage: 9.90 MB Aug 9 14:00:02 sd-7501 CDRTool[19627]: 1 CDRs, 1 normalized in 0 s @ 0 cps

But there is no "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 " after

Do I have to activate something else??

flavio a écrit :

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@192.168.1.160 To=001305345 6789@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@free.fr To: "flavio" flavio@asteriskguide.com Cc: users@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@sd-7501.dedibox.fr To=6713@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@free.fr To: "Dan-Cristian Bogos" dan.bogos@gmail.com Cc: users@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@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@sd-7501.dedibox.fr Account=101@sd-7501.dedibox.fr Balance=10040.0000

ShowCustomers default

ShowAccounts Error: Invalid request

MaxSessionTime From=sip:101@sd-7501.dedibox.fr To=sip:106@sd-7501.dedibox.fr Duration=7200 Lock=1 none

DebitBalance From=sip:101@sd-7501.dedibox.fr To=sip:106@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@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@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@sd-7501.dedibox.fr,441,441,8,441,19,441,24,441,0 > > > 2,,sd-7501.dedibox.fr,106@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@sd-7501.dedibox.fr,441,31800,200,audio,2364 > > 2,,sd-7501.dedibox.fr,102@sd-7501.dedibox.fr,441,31800,200,audio,245 > 2,,,33677832974,441,131,2100,,2426 > > > > ShowPrice From=sip:101@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@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@sd-7501.dedibox.fr,441,,442,,Europe/Paris,20,1 >>> >>> >>> 2,,sd-7501.dedibox.fr,106@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@sd-7501.dedibox.fr,10030.0000,2007-08-08 >>> 17:57:00,,0000-00-00 00:00:00,0.0000,0, >>> 2,106@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@sd-7501.dedibox.fr Balance=10030.0000 >>> Account=106@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@sd-7501.dedibox.fr Gateway= Application=audio >>> >>> >>> >>> >>> >>>

---

Users mailing list Users@openser.org http://openser.org/cgi-bin/mailman/listinfo/users