[Serusers] Radius accounting and freeside

[Klaus Darilion]

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 at 192.16 	368b436f04276620 	84 at 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 at nxs.yi.org=3Buser=3Dphone 
> sip:84 at nxs.yi.org 	  	IAPP-AP-Check 	  	  	0 	0
> 2 	2e3a5cab-8dcdfe1-ee9a3182 at 192.16 	368b436f04276620 	84 at 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 at nxs.yi.org=3Buser=3Dphone 
> sip:84 at nxs.yi.org 	  	IAPP-AP-Check 	  	  	0 	0
> 3 	2e3a5cab-8dcdfe1-ee9a3182 at 192.16 	368b436f04276620 	84 at 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 at nxs.yi.org=3Buser=3Dphone 
> sip:84 at nxs.yi.org 	  	IAPP-AP-Check 	  	  	0 	0
> 4 	2e3a5cab-8dcdfe1-ee9a3182 at 192.16 	368b436f04276620 	84 at 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 at nxs.yi.org=3Buser=3Dphone 
> sip:84 at nxs.yi.org 	  	IAPP-AP-Check 	  	  	0 	0
> 5 	2e3a5cab-8dcdfe1-ee9a3182 at 192.16 	368b436f04276620 	84 at 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 at nxs.yi.org=3Buser=3Dphone 
> sip:84 at nxs.yi.org 	  	IAPP-AP-Check 	  	  	0 	0
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> Serusers mailing list
> serusers at lists.iptel.org
> http://lists.iptel.org/mailman/listinfo/serusers