RADIUS-SQL.schema

0.INTRODUCTION

  In order for your radius server to query an sql database, you must
  have a database schema on which the radius server can perform queries.
  The server ships with default database schema's for which the default
  queries are constructed.

1.DATABASE SCHEMA
 
  There isn't a generic SQL schema, but there is one for some databases:

    src/modules/rlm_sql/drivers/rlm_sql_mysql/db_mysql.sql
    src/modules/rlm_sql/drivers/rlm_sql_postgresql/db_postgresql.sql
    src/modules/rlm_sql/drivers/rlm_sql_freetds/db_mssql.sql
    src/modules/rlm_sql/drivers/rlm_sql_oracle/db_oracle.sql

2.MYSQL

  For further information, this web page seems to be good:

    http://www.frontios.com/freeradius.html

  More information about tips for configuring MySQL can be found at:

    http://www.mysql.com/doc/S/e/Server_parameters.html
    http://www.mysql.com/doc/S/E/SEC456.html
    http://www.mysql.com/doc/E/X/EXPLAIN.html <-(useful)
    http://www.mysql.com/doc/T/i/Tips.html
    http://www.mysql.com/doc/M/e/Memory_use.html

  A good page for MySQL best practices is:

    http://www.onlamp.com/pub/a/onlamp/2002/07/11/MySQLtips.html