Re: [Users] Billing System

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