29 Sep
2005
29 Sep
'05
9:22 a.m.
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(a)openser.org [mailto:users-bounces@openser.org] De la part
de harry gaillac
Envoyé : mercredi 28 septembre 2005 19:37
À : Klaus Darilion
Cc : users(a)openser.org
Objet : Re: [Users] Billing System
Does freeradius is able to calculate "AcctSessionTime"
with acct_unique ?
harry
--- Klaus Darilion <klaus.mailinglists(a)pernau.at> a
écrit :
------------------------------------------------------------------------
sip:85@nxs.yi.org
=== 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(a)openser.org http://openser.org/cgi-bin/mailman/listinfo/users
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(a)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(a)192.1
>>
>>6a144727119f5e1f 85(a)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(a)192.1
>>
>>6a144727119f5e1f 85(a)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(a)192.1
>>
>>2fa4db0d9f32cb09 87(a)nxs.yi.org
>>
>>> 80.119.12.168 5060 2005-09-28 17:47:16
>>
>>2005-09-28
>>
>>>17:47:16 0 0 0
>>sip:87@nxs.yi.org=3Buser=3Dphone
IAPP-Register
>
> 0 0
>
>