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:[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 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,[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,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,[EMAIL PROTECTED],10030.0000,2007-08-08 17:57:00,,0000-00-00
00:00:00,0.0000,0,
2,[EMAIL PROTECTED],20010.0000,2007-08-08 17:38:09,,0000-00-00
00: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 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";"[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 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:[EMAIL PROTECTED]
[EMAIL PROTECTED] Gateway= Application=audio
_______________________________________________
Users mailing list
[email protected]
http://openser.org/cgi-bin/mailman/listinfo/users
