[Users] Billing System

Klaus Darilion klaus.mailinglists at pernau.at
Wed Sep 28 18:29:12 CEST 2005


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
> 





More information about the sr-users mailing list