[Users] Billing System

[harry gaillac]

Does freeradius is able to calculate "AcctSessionTime"
with acct_unique ?

harry
--- Klaus Darilion <klaus.mailinglists at pernau.at> a
écrit :

> harry gaillac wrote:
> > How can I get one radacctid per sip session ?
> 
> You have to do it yourself. ser can only generate
> start records and stop 
> records. (at least 2 CDRs per call, eventually more
> in case of re-INVITEs)
> 
> You have to write a script which matches start and
> stop records, 
> calculate the duration of the call and then write
> the combined CDR into 
> another table.
> 
> Usually this combined CDRs (one CDR per call) can be
> imported into 
> billing systems.
> 
> regards
> klaus
> 
> 
> > Harry
> > 
> > PS: 
> > sorry for html file (no javascript)
> > --- Klaus Darilion <klaus.mailinglists at pernau.at>
> a
> > écrit :
> > 
> > 
> >>Hi Harry!
> >>
> >>Please do not send html attachments (in particular
> >>not if it includs 
> >>javascript).
> >>
> >>As Bogdan already sead, you got an entry for each
> >>SIP transaction -> 
> >>everthing works fine, except you may miss some
> >>important attributes, 
> >>e.g. the SIP method:
> >>   ATTRIBUTE Sip-Method           101  integer   
> #
> >>Schulzrinne, acc
> >>
> >>regards
> >>klaus
> >>
> >>harry gaillac wrote:
> >>
> >>>Sorry,
> >>>
> >>>Here is a html file
> >>>
> >>>Regards
> >>>
> >>>
> >>>
> >>>>Sorry Harry, but this email is not readable.
> >>>>
> >>>>you may try to attach it as .txt file in a
> >>
> >>readable
> >>
> >>>>format
> >>>>
> >>>>regards
> >>>>klaus
> >>>>
> >>>>harry gaillac wrote:
> >>>>
> >>>>
> >>>>>Hello,
> >>>>>
> >>>>>I have some problems to solve before using
> >>>>
> >>>>Freeside 
> >>>>
> >>>>
> >>>>>I configure ser for accounting (acc module)
> with
> >>>>>freeradius-1.0.1 and mysql to store accounting
> >>>>>
> >>>>>I set flag for invite and bye/cancel messages
> >>>>
> >>>>however
> >>>>
> >>>>
> >>>>>i have more than one RadAcctId per
> AcctSessionId 
> >>
> >>>>.
> >>>>
> >>>>
> >>>>>Here is my radacct table:
> >>>
> >>>
> >>>
> >>>
> >>>	
> >>>
> >>>	
> >>>		
> >>>
> >>
> >
>
___________________________________________________________________________
> > 
> >>>Appel audio GRATUIT partout dans le monde avec le
> >>
> >>nouveau Yahoo! Messenger 
> >>
> >>>Téléchargez cette version sur
> >>
> >>http://fr.messenger.yahoo.com
> >>
> >>>
> >>>
> >
>
------------------------------------------------------------------------
> > 
> >>>
> >>>  Résultat de la requête SQL
> >>>
> >>>*Serveur:* localhost
> >>>*Base de données:* radius
> >>>*Généré le :* Mercredi 28 Septembre 2005 à 17:49
> >>>*Généré par:* phpMyAdmin 2.6.2 / MySQL
> >>
> >>4.0.24_Debian-10-log
> >>
> >>>*requête SQL:* SELECT * FROM `radacct` LIMIT 0,
> >>
> >>30;
> >>
> >>>*Enregistrements:* 3
> >>>
> >>>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
> >>>1 	e2e856d4-66ec011e-59666f75 at 192.1 
> >>
> >>6a144727119f5e1f 	85 at nxs.yi.org 
> >>
> >>>  	80.119.12.168 	5060 	  	2005-09-28 17:47:03 
> >>
> >>0000-00-00 
> >>
> >>>00:00:00 	0 	  	  	  	0 	0 
> >>
> >>sip:87 at nxs.yi.org=3Buser=3Dphone 
> >>
> >>>sip:85 at nxs.yi.org 	  	IAPP-Register 	  	  	0 	0
> >>>2 	e2e856d4-66ec011e-59666f75 at 192.1 
> >>
> >>6a144727119f5e1f 	85 at nxs.yi.org 
> >>
> >>>  	80.119.12.168 	5060 	  	2005-09-28 17:47:03 
> >>
> >>0000-00-00 
> >>
> >>>00:00:00 	0 	  	  	  	0 	0 
> >>
> >>sip:87 at nxs.yi.org=3Buser=3Dphone 
> >>
> >>>sip:85 at nxs.yi.org 	  	IAPP-Register 	  	  	0 	0
> >>>3 	e2e856d4-66ec011e-59666f75 at 192.1 
> >>
> >>2fa4db0d9f32cb09 	87 at nxs.yi.org 
> >>
> >>>  	80.119.12.168 	5060 	  	2005-09-28 17:47:16 
> >>
> >>2005-09-28 
> >>
> >>>17:47:16 	0 	  	  	  	0 	0 	sip:85 at nxs.yi.org 
> >>>sip:87 at nxs.yi.org=3Buser=3Dphone 	  
> IAPP-Register
> >>
> >>	  	  	0 	0
> >>
> >>
> 
=== message truncated ===



	

	
		
___________________________________________________________________________ 
Appel audio GRATUIT partout dans le monde avec le nouveau Yahoo! Messenger 
Téléchargez cette version sur http://fr.messenger.yahoo.com