Hi, you must look to sql.conf file. You need to change this file as you need. Just look for doc and examples. And at best signin for freeradius maillist. and ask guys there. -----Original Message----- From: openh323gk-users-admin@lists.sourceforge.net [mailto:openh323gk-users-admin@lists.sourceforge.net]On Behalf Of slesru Sent: Thursday, August 07, 2003 5:18 AM To: openh323gk-users@lists.sourceforge.net Subject: RE: [Openh323gk-users] radius accounting. report? --- Oleg Ustinov <Oleg.Ustinov@nectis.com> wrote: > Hi, > we use freeradius and use standart freradius MySQL > solution. > It's works without any problem (out of known "todo" > services like disconnect > causes etc.) > Hmm. Here is accounting info: Sending Accounting-Response of id 83 to 192.168.22.211:32775 rad_recv: Accounting-Request packet from host 192.168.22.211:32775, id=84, length=482 Acct-Status-Type = Stop NAS-IP-Address = 192.168.22.211 NAS-Identifier = "testgk" NAS-Port-Type = Virtual Service-Type = Login-User Acct-Session-Id = "c25f0007" User-Name = "chr" Framed-IP-Address = 192.168.22.1 Acct-Session-Time = 14 Calling-Station-Id = "41" Called-Station-Id = "12" h323-gw-id = "h323-gw-id=testgk" h323-conf-id = "h323-conf-id=C5D47010 C72A11D7 8004FC3A 9D89CB1E" h323-call-origin = "h323-call-origin=proxy" h323-call-type = "h323-call-type=VoIP" h323-setup-time = "h323-setup-time=14:54:21.309 SAMST Wed Aug 6 2003" h323-connect-time = "h323-connect-time=14:54:21.309 SAMST Wed Aug 6 2003" h323-disconnect-time = "h323-disconnect-time=14:54:35.995 SAMST Wed Aug 6 2003" h323-disconnect-cause = "h323-disconnect-cause=0" h323-remote-address = "h323-remote-address=192.168.22.229" Acct-Delay-Time = 0 And this is what freeradius writes to mysql: query: INSERT into 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) values('', 'c25f0007', '', 'chr', '', '192.168.22.211', '', 'Virtual', '0', '2003-08-06 14:54:35', '14', '', '', '', '', '', '12', '41', '', 'Login-User', '', '192.168.22.1', '0', '0') As you see some info is lost... > You have look to freeradius documentation. There is > full description and > examples. I know :-) > But you can use any billing soft worked with > readius. It works very well. > Could you point me to one? __________________________________ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com ------------------------------------------------------- This SF.Net email sponsored by: Free pre-built ASP.NET sites including Data Reports, E-commerce, Portals, and Forums are available now. Download today and enter to win an XBOX or Visual Studio .NET. http://aspnet.click-url.com/go/psa00100003ave/direct;at.aspnet_072303_01/01 _______________________________________________ List: Openh323gk-users@lists.sourceforge.net Archive: http://sourceforge.net/mailarchive/forum.php?forum_id=8549 Homepage: http://www.gnugk.org/ ------------------------------------------------------- This SF.Net email sponsored by: Free pre-built ASP.NET sites including Data Reports, E-commerce, Portals, and Forums are available now. Download today and enter to win an XBOX or Visual Studio .NET. http://aspnet.click-url.com/go/psa00100003ave/direct;at.aspnet_072303_01/01 _______________________________________________ List: Openh323gk-users@lists.sourceforge.net Archive: http://sourceforge.net/mailarchive/forum.php?forum_id=8549 Homepage: http://www.gnugk.org/
