Does freeradius is able to calculate "AcctSessionTime" with acct_unique ?
harry --- Klaus Darilion <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> > 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 [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 > >> > >> > === 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 _______________________________________________ Users mailing list [email protected] http://openser.org/cgi-bin/mailman/listinfo/users
