[OpenSIPS-Users] Problems with CDRTool 8.0.4

[Raúl Alexis Betancor Santana]

On Domingo 05 Septiembre 2010 12:39:59 Saúl Ibarra Corretgé escribió:
> On 09/05/2010 01:08 PM, Raúl Alexis Betancor Santana wrote:
> > Hi all,
> > 
> > I'm testing CDRTool 8.0.4 and getting some problems with it ..
> > 
> > Let first say what I have done:
> > 
> > - Install cdrtool 8.0.4 from darcs repo
> > - Install freeradius-xs from ag-projects deb's repo
> > - Setup mysql, tables created, users, stored procs, all that it's ok
> > - Setup OpenSIPS as Install.txt from cdrtool said ... with the
> > radius_extra param of acc module and so on ..
> > 
> > Now, if I run freeradius -X for testing ... I get ...
> > 
> > rad_recv: Accounting-Request packet from host XXX.XXX.XXX.XXX:60397,
> > id=182, length=485
> > 
> >          Acct-Status-Type = Start
> >          Service-Type = Sip-Session
> >          Sip-Response-Code = 200
> >          Sip-Method = Invite
> >          Attr-55 = 0x4c837891
> >          Sip-From-Tag = "y5jps2ys0j"
> >          Sip-To-Tag = "as79e94c07"
> >          Acct-Session-Id = "3c4d8c5b7b6e-qq6pz2331syr"
> >          User-Name = "8orrIzfee at test.com"
> >          Calling-Station-Id = "sip:8orrIzfee at sip.test.com"
> >          Called-Station-Id = "sip:349YYZZZKKK at sip.test.com;user=phone"
> >          Sip-Translated-Request-URI = "sip:s at 192.168.0.2"
> >          Canonical-URI = "sip:34928382524 at sip.test.com;user=phone"
> >          User-Agent = "snom360/7.3.30"
> >          Contact =
> >          "<sip:8orrIzfee at 192.168.2.119:2048;line=6iqmugdl>;reg-id=1"
> >          From-Header = ""Ra\303\272l Alexis Betancor Santana"
> > 
> > <sip:8orrIzfee at sip.test.com>;tag=y5jps2ys0j"
> > 
> >          NAS-Port = 5060
> >          Acct-Delay-Time = 0
> >          NAS-IP-Address = XXX.XXX.XXX.XXX
> >    
> >    Processing the preacct section of radiusd.conf
> > 
> > modcall: entering group preacct for request 0
> > 
> >    modcall[preacct]: module "preprocess" returns noop for request 0
> > 
> > rlm_acct_unique: Hashing 'Sip-To-Tag = "as79e94c07",Sip-From-Tag =
> > "y5jps2ys0j",Client-IP-Address = XXX.XXX.XXX.XXX,Acct-Session-Id =
> > "3c4d8c5b7b6e-qq6pz2331syr"'
> > rlm_acct_unique: Acct-Unique-Session-ID = "c9518f17b9dd1b07".
> > 
> >    modcall[preacct]: module "acct_unique" returns ok for request 0
> >    
> >      rlm_realm: Looking up realm "test.com" for User-Name =
> > 
> > "8orrIzfee at test.com"
> > 
> >      rlm_realm: No such realm "test.com"
> >    
> >    modcall[preacct]: module "suffix" returns noop for request 0
> > 
> > modcall: leaving group preacct (returns ok) for request 0
> > 
> >    Processing the accounting section of radiusd.conf
> > 
> > modcall: entering group accounting for request 0
> > radius_xlat: 
> > '/var/log/freeradius/radacct/XXX.XXX.XXX.XXX/detail-20100905'
> > rlm_detail:
> > /var/log/freeradius/radacct/%{Client-IP-Address}/detail-%Y%m%d expands
> > to /var/log/freeradius/radacct/XXX.XXX.XXX.XXX/detail-20100905
> > 
> >    modcall[accounting]: module "detail" returns ok for request 0
> > 
> > WARNING: Attempt to use unknown xlat function, or non-existent attribute
> > in string %{Sip-Application-Type}
> > 
> > I don't see Sip-Application-Type defined in dictionary.opensips and it's
> > clear that OpenSIPS it's not sending it to freeradius, also ... who I
> > get it value from the opensips script? ... I mean where do I have to put
> > a
> > $avp(s:sip_application_type) = "something"  ? and what should be
> > "something"?
> > 
> > I have checked cdrtool code ... and don't see where it use
> > sip_application_type ... maybe I loosed something obvious.
> 
> Sip-Application-Type is meant to contain what type of application the
> SIP session is performing. This can be "audio", "video", "file-transfer"
> and "chat". You need to set this from the OpenSIPS script as the
> Sip-Application-Type radius attribute.

But is not defined in the dictionary.opensip that cames with cdrtool ... I 
suppose I should put it there or Freeradius and the radiusclient-ng will not 
know what to do with it.

Also ... does cdrtool have a way of billing based on sip-application-type? ... 
because I have not seen anything about that on the code.

Also, I get errors with the accounting_stop_query in sql.conf of freeradius, 
because of  Connect-Info that is also not transmited to the radius server

Best regards.
-- 
Raúl Alexis Betancor Santana
Dimensión Virtual