harry gaillac wrote:

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)

Really?

<script type="text/javascript" language="javascript1.2"> <!-- // Do print the page if (typeof(window.print) != 'undefined') { window.print(); } //--> </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@192.16 368b436f04276620 84@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@192.16 368b436f04276620 84@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@192.16 368b436f04276620 84@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@192.16 368b436f04276620 84@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@192.16 368b436f04276620 84@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@iptel.org http://mail.iptel.org/mailman/listinfo/serusers