5 In order for your radius server to query an sql database, you must
6 have a database schema on which the radius server can perform queries.
7 The server ships with default database schema's for which the default
8 queries are constructed.
12 There isn't a generic SQL schema, but there is one for some databases:
14 raddb/sql/mysql/schema.sql
15 raddb/sql/postgresql/schema.sql
16 raddb/sql/oracle/schema.sql
17 raddb/sql/mssql/schema.sql
22 More information about tips for configuring MySQL can be found at:
24 http://www.mysql.com/doc/S/e/Server_parameters.html
25 http://www.mysql.com/doc/E/X/EXPLAIN.html <-(useful)
26 http://www.mysql.com/doc/T/i/Tips.html
27 http://www.mysql.com/doc/M/e/Memory_use.html
29 A good page for MySQL best practices is:
31 http://www.onlamp.com/pub/a/onlamp/2002/07/11/MySQLtips.html