Hello,
Somebody has tested freeSide billing system !?
Harry
___________________________________________________________________________ Appel audio GRATUIT partout dans le monde avec le nouveau Yahoo! Messenger Téléchargez cette version sur http://fr.messenger.yahoo.com
Hello,
On 09/22/05 16:04, harry gaillac wrote:
Hello,
Somebody has tested freeSide billing system !?
I didn't, but if you will do it, please send a report on the mailing list.
Daniel
Harry
___________________________________________________________________________ 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
Hello Daniel-Constantin,
I'll do it ASAP !
Regards Harry
PS: I'm waiting for asterisk b2bua 1.2 released . http://developer.berlios.de/projects/b2bua/
--- Daniel-Constantin Mierla daniel@voice-system.ro a écrit :
Hello,
On 09/22/05 16:04, harry gaillac wrote:
Hello,
Somebody has tested freeSide billing system !?
I didn't, but if you will do it, please send a report on the mailing list.
Daniel
Harry
Appel audio GRATUIT partout dans le monde avec le
nouveau Yahoo! Messenger
Téléchargez cette version sur
Users mailing list Users@openser.org 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
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:
mysql> select * from radacct; +-----------+----------------------------------+------------------+---------------+------------+---------------+-----------+-------------+---------------------+---------------------+-----------------+---------------+-------------------+------------------+-----------------+------------------+----------------------------------+-------------------+--------------------+---------------+----------------+-----------------+----------------+---------------+ | 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 | bb1e53c6-584dd9b0-e3f97bf7@192.1 | 8794453f19310360 | 85@nxs.yi.org | nxs.yi.org | 80.119.12.168 | 5060 | | 2005-09-28 16:26:15 | 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 | bb1e53c6-584dd9b0-e3f97bf7@192.1 | 8794453f19310360 | 85@nxs.yi.org | nxs.yi.org | 80.119.12.168 | 5060 | | 2005-09-28 16:26:15 | 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 | bb1e53c6-584dd9b0-e3f97bf7@192.1 | 8794453f19310360 | 85@nxs.yi.org | nxs.yi.org | 80.119.12.168 | 5060 | | 2005-09-28 16:26:26 | 2005-09-28 16:26:26 | 0 | | | | 0 | 0 | sip:87@nxs.yi.org=3Buser=3Dphone | sip:85@nxs.yi.org | | IAPP-Register | | | 0 | 0 | | 4 | bb1e53c6-584dd9b0-e3f97bf7@192.1 | 8794453f19310360 | 85@nxs.yi.org | | 80.119.12.168 | 5060 | | 2005-09-28 16:26:35 | 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 | | 5 | bb1e53c6-584dd9b0-e3f97bf7@192.1 | 8794453f19310360 | 85@nxs.yi.org | | 80.119.12.168 | 5060 | | 2005-09-28 16:26:35 | 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 | | 6 | bb1e53c6-584dd9b0-e3f97bf7@192.1 | 8794453f19310360 | 85@nxs.yi.org | | 80.119.12.168 | 5060 | | 2005-09-28 16:26:46 | 2005-09-28 16:26:46 | 0 | | | | 0 | 0 | sip:87@nxs.yi.org=3Buser=3Dphone | sip:85@nxs.yi.org | | IAPP-Register | | | 0 | 0 | +-----------+----------------------------------+------------------+---------------+------------+---------------+-----------+-------------+---------------------+---------------------+-----------------+---------------+-------------------+------------------+-----------------+------------------+----------------------------------+-------------------+--------------------+---------------+----------------+-----------------+----------------+---------------+ 6 rows in set (0.00 sec)
Regards Harry
___________________________________________________________________________ Appel audio GRATUIT partout dans le monde avec le nouveau Yahoo! Messenger Téléchargez cette version sur http://fr.messenger.yahoo.com
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:
mysql> select * from radacct; +-----------+----------------------------------+------------------+---------------+------------+---------------+-----------+-------------+---------------------+---------------------+-----------------+---------------+-------------------+------------------+-----------------+------------------+----------------------------------+-------------------+--------------------+---------------+----------------+-----------------+----------------+---------------+ | 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 | bb1e53c6-584dd9b0-e3f97bf7@192.1 | 8794453f19310360 | 85@nxs.yi.org | nxs.yi.org | 80.119.12.168 | 5060 | | 2005-09-28 16:26:15 | 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 | bb1e53c6-584dd9b0-e3f97bf7@192.1 | 8794453f19310360 | 85@nxs.yi.org | nxs.yi.org | 80.119.12.168 | 5060 | | 2005-09-28 16:26:15 | 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 | bb1e53c6-584dd9b0-e3f97bf7@192.1 | 8794453f19310360 | 85@nxs.yi.org | nxs.yi.org | 80.119.12.168 | 5060 | | 2005-09-28 16:26:26 | 2005-09-28 16:26:26 | 0 | | | | 0 | 0 | sip:87@nxs.yi.org=3Buser=3Dphone | sip:85@nxs.yi.org | | IAPP-Register | | | 0 | 0 | | 4 | bb1e53c6-584dd9b0-e3f97bf7@192.1 | 8794453f19310360 | 85@nxs.yi.org | | 80.119.12.168 | 5060 | | 2005-09-28 16:26:35 | 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 | | 5 | bb1e53c6-584dd9b0-e3f97bf7@192.1 | 8794453f19310360 | 85@nxs.yi.org | | 80.119.12.168 | 5060 | | 2005-09-28 16:26:35 | 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 | | 6 | bb1e53c6-584dd9b0-e3f97bf7@192.1 | 8794453f19310360 | 85@nxs.yi.org | | 80.119.12.168 | 5060 | | 2005-09-28 16:26:46 | 2005-09-28 16:26:46 | 0 | | | | 0 | 0 | sip:87@nxs.yi.org=3Buser=3Dphone | sip:85@nxs.yi.org | | IAPP-Register | | | 0 | 0 | +-----------+----------------------------------+------------------+---------------+------------+---------------+-----------+-------------+---------------------+---------------------+-----------------+---------------+-------------------+------------------+-----------------+------------------+----------------------------------+-------------------+--------------------+---------------+----------------+-----------------+----------------+---------------+ 6 rows in set (0.00 sec)
Regards Harry
___________________________________________________________________________ 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
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
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 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
Users mailing list Users@openser.org http://openser.org/cgi-bin/mailman/listinfo/users
I set modparam("acc", "report_ack", 0) but i can't get "AcctSessionTime"
Why !!
Harry
--- Bogdan-Andrei Iancu bogdan@voice-system.ro 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
------------------------------------------------------------------------
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
Users mailing list Users@openser.org 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
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@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
How can I get one radacctid per sip session ? 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
___________________________________________________________________________ Appel audio GRATUIT partout dans le monde avec le nouveau Yahoo! Messenger Téléchargez cette version sur http://fr.messenger.yahoo.com
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___________________________________________________________________________ Appel audio GRATUIT partout dans le monde avec le nouveau Yahoo! Messenger Téléchargez cette version sur http://fr.messenger.yahoo.com
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
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
Hello,
I've been installing freeside 1.5.8 CVS. I wish to test the voip billing features. Anybody has already configured the voip billing features .
Regards Harry --- Daniel-Constantin Mierla daniel@voice-system.ro a écrit :
Hello,
On 09/22/05 16:04, harry gaillac wrote:
Hello,
Somebody has tested freeSide billing system !?
I didn't, but if you will do it, please send a report on the mailing list.
Daniel
Harry
Appel audio GRATUIT partout dans le monde avec le
nouveau Yahoo! Messenger
Téléchargez cette version sur
Users mailing list Users@openser.org 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
-
Bogdan-Andrei Iancu -
Daniel-Constantin Mierla -
harry gaillac -
Klaus Darilion -
Olivier Taylor