[Users] Billing System - sr-users - kamailio.org

List overview All Threads
Download

[Users] Billing System

[Serusers] Mediaproxy must be with...

[Serusers] SER Codecs/Web Admin

harry gaillac

22 Sep 2005 22 Sep '05

4:04 p.m.

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

Reply

Show replies by date

Daniel-Constantin Mierla

24 Sep 24 Sep

7:26 p.m.

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(a)openser.org http://openser.org/cgi-bin/mailman/listinfo/users

Reply

harry gaillac

27 Sep 27 Sep

12:38 p.m.

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(a)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

http://fr.messenger.yahoo.com

_______________________________________________ Users mailing list Users(a)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

Reply

harry gaillac

28 Sep 28 Sep

5:36 p.m.

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(a)192.1 | 8794453f19310360 | 85(a)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(a)192.1 | 8794453f19310360 | 85(a)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(a)192.1 | 8794453f19310360 | 85(a)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(a)192.1 | 8794453f19310360 | 85(a)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(a)192.1 | 8794453f19310360 | 85(a)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(a)192.1 | 8794453f19310360 | 85(a)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

Reply

Klaus Darilion

6:31 p.m.

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(a)192.1 | 8794453f19310360 | 85(a)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(a)192.1 | 8794453f19310360 | 85(a)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(a)192.1 | 8794453f19310360 | 85(a)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(a)192.1 | 8794453f19310360 | 85(a)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(a)192.1 | 8794453f19310360 | 85(a)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(a)192.1 | 8794453f19310360 | 85(a)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(a)openser.org http://openser.org/cgi-bin/mailman/listinfo/users

Reply

harry gaillac

6:56 p.m.

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

Reply

Bogdan-Andrei Iancu

7:08 p.m.

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(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:85@nxs.yi.org sip:87@nxs.yi.org=3Buser=3Dphone IAPP-Register 0 0 ------------------------------------------------------------------------ _______________________________________________ Users mailing list Users(a)openser.org http://openser.org/cgi-bin/mailman/listinfo/users

Reply

harry gaillac

7:33 p.m.

I set modparam("acc", "report_ack", 0) but i can't get "AcctSessionTime" Why !! Harry --- Bogdan-Andrei Iancu <bogdan(a)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

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:85@nxs.yi.org

sip:87@nxs.yi.org=3Buser=3Dphone IAPP-Register

0 0

------------------------------------------------------------------------

>_______________________________________________ >Users mailing list >Users(a)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

Reply

Klaus Darilion

7:29 p.m.

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:85@nxs.yi.org sip:87@nxs.yi.org=3Buser=3Dphone IAPP-Register 0 0

Reply

harry gaillac

7:37 p.m.

How can I get one radacctid per sip session ? 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: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

Reply

Klaus Darilion

8:06 p.m.

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

Reply

harry gaillac

8:36 p.m.

Does freeradius is able to calculate "AcctSessionTime" with acct_unique ? harry --- Klaus Darilion <klaus.mailinglists(a)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(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: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

Reply

Olivier Taylor

29 Sep 29 Sep

9:22 a.m.

New subject: RE : [Users] Billing System

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 :

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: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(a)openser.org http://openser.org/cgi-bin/mailman/listinfo/users

Reply

harry gaillac

10 Oct 10 Oct

12:16 a.m.

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(a)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

http://fr.messenger.yahoo.com

_______________________________________________ Users mailing list Users(a)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

Reply

6984

days inactive

7001

days old

sr-users@lists.kamailio.org

Manage subscription

13 comments

5 participants

tags (0)

participants (5)

Bogdan-Andrei Iancu
Daniel-Constantin Mierla
harry gaillac
Klaus Darilion
Olivier Taylor