Hello Thomas - Your project involves much more than just simple Radiator configuration.
We are available on a contract basis for custom configuration, installation and commissioning. regards Hugh On 3 Jan 2013, at 06:35, Thomas KCCG <tho...@kccg.com> wrote: > Dear Sir, > Find below the Wireless Mobile data co. (ISP) Kuwait’s Radiator > project status and also a brief description on “what Is remaining to be done > ( I need help with this)” :- > > Radiator was successfully installed on a centos Linux server with MySQL > database using buildsql and MySQL config file from goodies folder. > > Progress: > · Radiator is properly configured and is currently receiving > accounting-start and accounting-stop packets sent from the ISG. > · Radiator is logging these details in a log file and also updating > its MySQL database with the info sent from ISG under its respective fields. > > Radiator’s Purpose: > > Radiator is implemented in wimd to manage only accounting of quota based > users based on the accounting packets sent from the cisco ISG. > > Radiator needs to have a database for quota based users, with the fields > username, password ,quota , speed1, speed2(to reduce to this speed after > certain quota). > > Radiator has to calculate quota of these users after their session ends each > time and update this information with the cisco ISG. > > Current Status: > > · The ISG must be properly configured to send interim updates to the > radiator and this is still pending. Without receiving the interim updates > ,further configurations on the radiator cannot be done, as it is dependent on > the cisco ISG’s interim updates. We are waiting for this to be done by the > cisco guy. > > > The steps pending to complete this project from radiator’s end (After > receiving interim updates from ISG) Please help me with these with respect to > above : > > · We will create and customize the MySQL database for Quota based > users.( Please recommend what is to be done? In the MySQL database, there is > already a Table called Subscribers , which was created when I ran the > buildsql . But there is no attribute in the table called quota. How can this > be added and used for the following? > > · We will add the configuration to the radiator ,for initiating COA > after Accounting-Start and Accounting-Interim updates with respect to ISG’s > current configuration.(How can this be done? Please attach configuration > lines for this in the radiator configuration file attached with this email) > > > · We will add the configuration to the radiator , for it to calculate > the quota (Add/reduce from remaining quota) and send a max of 4GB at a time, > since the ISG volume quota supports a maximum value of 4GB. How can this be > configured on the radiator ? Please attach configuration lines for this in > the radiator configuration file attached with this email) > > > My current Configuration lines in radiator configuration file (radius.cfg) is > as follows: > > > # radius.cfg > # > # Example Radiator configuration file. > # This very simple file will allow you to get started with > # a simple system. You can then add and change features. > # We suggest you start simple, prove to yourself that it > # works and then develop a more complicated configuration as required. > # > # This example will authenticate from a standard users file in > # DbDir/users and log accounting to LogDir/detail. > # > # It will accept requests from any client and try to handle request > # for any realm. > # > # You should consider this file to be a starting point only > # $Id: linux-radius.cfg,v 1.3 2002/03/24 23:07:49 mikem Exp $ > > #Foreground > #LogStdout > > AcctPort 1813 > AuthPort 1812 > > > BindAddress 0.0.0.0 > > > LogDir /var/log/radius > DbDir /etc/radiator > # Use a low trace level in production systems. Increase > # it to 4 or 5 for debugging, or use the -trace flag to radiusd > Trace 4 > > # You will probably want to add other Clients to suit your site, > # one for each NAS you want to work with > <Client DEFAULT> > Secret ciscowimd85 > DupInterval 0 > </Client> > > <Client 10.50.1.4> > Secret ciscowimd85 > DupInterval 0 > NasType Cisco > IgnoreAcctSignature > </Client> > > <Client localhost> > Secret mysecret > DupInterval 0 > </Client> > > > <Realm DEFAULT> > <AuthBy SQL> > DBSource dbi:mysql:radius > DBUsername root > DBAuth wimd2r00t > > AccountingTable ACCOUNTING > AcctColumnDef USERNAME, User-Name > AcctColumnDef ACCTSTATUSTYPE,Acct-Status-Type > AcctColumnDef FRAMEDIPADDRESS,Framed-IP-Address > AcctColumnDef ACCTINPUTOCTETS,Acct-Input-Octets > AcctColumnDef ACCTOUTPUTOCTETS,Acct-Output-Octets > > </AuthBy> > # Log accounting to a detail file > AcctLogFileName %L/detail > </Realm> > > Requesting your kind cooperation, > > Thomas Kurian > IT Security Engineer (B.Tech. – Electrical) > Kuwaiti Canadian Consulting Group (www.kccg.com) > T: +965 22435566 > F: +965 22415149 > E: tho...@kccg.com > <image001.png> > > > > > _______________________________________________ > radiator mailing list > radiator@open.com.au > http://www.open.com.au/mailman/listinfo/radiator -- Hugh Irvine h...@open.com.au Radiator: the most portable, flexible and configurable RADIUS server anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald, Platypus, Freeside, TACACS+, PAM, external, Active Directory, EAP, TLS, TTLS, PEAP, TNC, WiMAX, RSA, Vasco, Yubikey, MOTP, HOTP, TOTP, DIAMETER etc. Full source on Unix, Windows, MacOSX, Solaris, VMS, NetWare etc. _______________________________________________ radiator mailing list radiator@open.com.au http://www.open.com.au/mailman/listinfo/radiator