[Users] Re: [Serusers] Radius accounting and freeside

Hello, I try to setup ser-0.9.4 for accounting with freeradius-1.0.2 and mysql-4. Here is a part of my ser.cfg file # -- acc params -- modparam("acc", "db_url", "mysql://xxx:xxx@nxs.yi.org/ser") modparam("acc", "radius_config", "/etc/radiusclient-ng/radiusclient.conf") modparam("acc", "log_fmt", "miocfsp") modparam("acc", "failed_transactions", 1) modparam("acc", "db_flag", 2) modparam("acc", "db_missed_flag", 3) modparam("acc", "service_type", 16) modparam("acc", "report_cancels", 1) modparam("acc", "report_ack", 1) modparam("acc", "radius_flag", 4) modparam("acc", "radius_missed_flag", 5) I set "setflag(4);" for INVITE BYE and CANCEL messages. Look at my sql.php.html file (no script)

I can't fix Acct-Start-Time and Acct-Stop-Time to calculate Acct-Session-Time with freeside How can I do it ? Thanks for help 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 ------------------------------------------------------------------------ Résultat de la requête SQL *Serveur:* localhost *Base de données:* radius *Généré le :* Dimanche 16 Octobre 2005 à 17:19 *Généré par:* phpMyAdmin 2.6.2 / MySQL 4.0.24_Debian-10sarge1-log *requête SQL:* SELECT * FROM `radacct` LIMIT 0, 30; *Enregistrements:* 5 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 2e3a5cab-8dcdfe1-ee9a3182(a)192.16 368b436f04276620 84(a)nxs.yi.org nxs.yi.org 80.119.13.76 5060 2005-10-16 17:10:10 0000-00-00 00:00:00 0 0 0 sip:86@nxs.yi.org=3Buser=3Dphone sip:84@nxs.yi.org IAPP-AP-Check 0 0 2 2e3a5cab-8dcdfe1-ee9a3182(a)192.16 368b436f04276620 84(a)nxs.yi.org nxs.yi.org 80.119.13.76 5060 2005-10-16 17:10:10 0000-00-00 00:00:00 0 0 0 sip:86@nxs.yi.org=3Buser=3Dphone sip:84@nxs.yi.org IAPP-AP-Check 0 0 3 2e3a5cab-8dcdfe1-ee9a3182(a)192.16 368b436f04276620 84(a)nxs.yi.org 80.119.13.76 5060 2005-10-16 17:10:30 0000-00-00 00:00:00 0 0 0 sip:86@nxs.yi.org=3Buser=3Dphone sip:84@nxs.yi.org IAPP-AP-Check 0 0 4 2e3a5cab-8dcdfe1-ee9a3182(a)192.16 368b436f04276620 84(a)nxs.yi.org 80.119.13.76 5060 2005-10-16 17:10:30 0000-00-00 00:00:00 0 0 0 sip:86@nxs.yi.org=3Buser=3Dphone sip:84@nxs.yi.org IAPP-AP-Check 0 0 5 2e3a5cab-8dcdfe1-ee9a3182(a)192.16 368b436f04276620 84(a)nxs.yi.org 80.119.13.76 5060 2005-10-16 17:10:32 2005-10-16 17:10:32 0 0 0 sip:86@nxs.yi.org=3Buser=3Dphone sip:84@nxs.yi.org IAPP-AP-Check 0 0 ------------------------------------------------------------------------ _______________________________________________ Serusers mailing list Serusers(a)iptel.org http://mail.iptel.org/mailman/listinfo/serusers