Skip to site navigation (Press enter)

Re: [Users] Billing System

harry gaillac Wed, 28 Sep 2005 09:34:09 -0700

I set modparam("acc", "report_ack", 0) but i can't get
 "AcctSessionTime"


Why !!

Harry

--- Bogdan-Andrei Iancu <[EMAIL PROTECTED]> a
écrit :

> Hi Harry,
> 
> the 3 records corresponds to the INVITE, ACK and BYE
> of the call between 
> 87 and 85. If you disable ack accounting, you will
> get only two records: 
> INVITE (start) and BYE (stop).
> 
> regards,
> bogdan
> 
> 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   [EMAIL PROTECTED] 
> 6a144727119f5e1f 
> > [EMAIL PROTECTED]           80.119.12.168   5060      
> 2005-09-28 17:47:03 
> > 0000-00-00 00:00:00         0                               0       0 
> > sip:[EMAIL PROTECTED] 
> sip:[EMAIL PROTECTED]           
> > IAPP-Register                       0       0
> > 2   [EMAIL PROTECTED] 
> 6a144727119f5e1f 
> > [EMAIL PROTECTED]           80.119.12.168   5060      
> 2005-09-28 17:47:03 
> > 0000-00-00 00:00:00         0                               0       0 
> > sip:[EMAIL PROTECTED] 
> sip:[EMAIL PROTECTED]           
> > IAPP-Register                       0       0
> > 3   [EMAIL PROTECTED] 
> 2fa4db0d9f32cb09 
> > [EMAIL PROTECTED]           80.119.12.168   5060      
> 2005-09-28 17:47:16 
> > 2005-09-28 17:47:16         0                               0       0 
> sip:[EMAIL PROTECTED] 
> > sip:[EMAIL PROTECTED]               IAPP-Register
>                       0       0
> >
>
>------------------------------------------------------------------------
> >
> >_______________________________________________
> >Users mailing list
> >[email protected]
> >http://openser.org/cgi-bin/mailman/listinfo/users
> >  
> >
> 
> 


        

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

Title: Résultat de la requête SQL - phpMyAdmin 2.6.2

Résultat de la requête SQL

Serveur: localhost
Base de données: radius
Généré le : Mercredi 28 Septembre 2005 à 18:26
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: 4

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	[EMAIL PROTECTED]	04321cda8a5f6657	[EMAIL PROTECTED]	nxs.yi.org	80.119.12.168	5060		2005-09-28 18:25:56	0000-00-00 00:00:00	0				0	0	sip:[EMAIL PROTECTED]	sip:[EMAIL PROTECTED]		IAPP-Register			0	0
2	[EMAIL PROTECTED]	81cbe9687474ec35	[EMAIL PROTECTED]	nxs.yi.org	80.119.12.168	5060		2005-09-28 18:26:02	2005-09-28 18:26:02	0				0	0	sip:[EMAIL PROTECTED]	sip:[EMAIL PROTECTED]		IAPP-Register			0	0
3	[EMAIL PROTECTED]	04321cda8a5f6657	[EMAIL PROTECTED]		80.119.12.168	5060		2005-09-28 18:26:16	0000-00-00 00:00:00	0				0	0	sip:[EMAIL PROTECTED]	sip:[EMAIL PROTECTED]		IAPP-Register			0	0
4	[EMAIL PROTECTED]	81cbe9687474ec35	[EMAIL PROTECTED]		80.119.12.168	5060		2005-09-28 18:26:22	2005-09-28 18:26:22	0				0	0	sip:[EMAIL PROTECTED]	sip:[EMAIL PROTECTED]		IAPP-Register			0	0

_______________________________________________
Users mailing list
[email protected]
http://openser.org/cgi-bin/mailman/listinfo/users