Hi,
The only problem is that session time is calculted between the invite eand the Bye, it should be calculated between Ack and Bye. You need a module calculating the session correctly, we do that by using jradius.
Olivier
-----Message d'origine----- De : users-bounces@openser.org [mailto:users-bounces@openser.org] De la part de harry gaillac Envoyé : mercredi 28 septembre 2005 19:37 À : Klaus Darilion Cc : users@openser.org Objet : Re: [Users] Billing System
Does freeradius is able to calculate "AcctSessionTime" with acct_unique ?
harry --- Klaus Darilion klaus.mailinglists@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@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
------------------------------------------------------------------------
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@192.1
6a144727119f5e1f 85@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@nxs.yi.org=3Buser=3Dphone
sip:85@nxs.yi.org IAPP-Register 0 0 2 e2e856d4-66ec011e-59666f75@192.1
6a144727119f5e1f 85@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@nxs.yi.org=3Buser=3Dphone
sip:85@nxs.yi.org IAPP-Register 0 0 3 e2e856d4-66ec011e-59666f75@192.1
2fa4db0d9f32cb09 87@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@nxs.yi.org
sip:87@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
_______________________________________________ Users mailing list Users@openser.org http://openser.org/cgi-bin/mailman/listinfo/users