1 / 11

Radius + MySQL Authentication and Accounting

Radius + MySQL Authentication and Accounting. AFNOG 2000 Cape Town, South Africa. Goal. Use of Database Authentication Fast research Easy request on users Accounting statistics billing. MySQL. A SQL Database (SQL) Structured Query Language

hateya
Download Presentation

Radius + MySQL Authentication and Accounting

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Radius + MySQLAuthentication and Accounting AFNOG 2000 Cape Town, South Africa

  2. Goal • Use of Database • Authentication • Fast research • Easy request on users • Accounting • statistics • billing

  3. MySQL • A SQL Database • (SQL) Structured Query Language • multi-user, multi-thearded SQL database server • Free on Unix need a license after a trial of 30 days for Microsoft • www.mysql.com • Current version 3.22.32

  4. MySQL Installation • Read INSTALL-SOURCE • Need cc compiler and lost of memory • Might have to use • ./configure --with-low-memory • make • make install

  5. MySQL Installation (2) • To start MySQL • Create the 1st databases • scripts/mysql_install_db • To run mysql • bin/safe_mysqld &

  6. Perl Modules • Get them from www.cpan.org • http://www.cpan.org/modules/01modules.index.html • Order of compilation, installation is important • Data-Dumper • DBI • Data-ShowTable • Msql-Mysql modules • Installation : perl Makefile.PL, make, make test, make install • Might need some extra modules also

  7. ICRadius • Cistron based radius server with MySQL support and web interface • Cistron Radius or FreeRadius • www.freeradius.org • www.miquels.cistron.nl/radius • radius.innercite.com • Current version icradius-0.14

  8. Installation on FreeBSD • Library libmysqlclient.so.6 • In /etc/defaults/rc.conf, • add path to libmysqlclient.so.6, ldconfig_paths variable, /usr/local/lib/mysql • copy Makefile.BSD to Makefile • add -I/usr/local/include • add in radiusd.h • #include <time.h> • #include <sys/time.h> • then make, make install

  9. ICRadius (2) • Copy files to /etc/raddb, radius.conf • Create database with • create database radius • then tables with • mysql radius < radius.db • a user • INSERT INTO radcheck • VALUES ("","username","Password","yourpassword"); • INSERT INTO radcheck VALUES ("","username","Radius-Operator","Yes");

  10. Web access • Copy the file script file radius.cgi and usage.cgi to your cgi-bin directory • Configure usage.cgi and radius.cgi to your own environment (user and password to access database, directories)

  11. Demonstrations • ICRadius, web • Billing

More Related