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
___________________________________________________________________________
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
