[OpenSER-Users] OpenSER + CDRTool

[Marc LEURENT]

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