[Users] Billing System

Klaus Darilion klaus.mailinglists at pernau.at
Wed Sep 28 19:06:17 CEST 2005


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
>>
>>
> 
> 
> 
> 	
> 
> 	
> 		
> ___________________________________________________________________________ 
> Appel audio GRATUIT partout dans le monde avec le nouveau Yahoo! Messenger 
> Téléchargez cette version sur http://fr.messenger.yahoo.com
> 
> 





More information about the Users mailing list