From e079490f37a5ad472336758b78c882daedd7a60e Mon Sep 17 00:00:00 2001 From: Nachtfalke Date: Tue, 10 Jan 2012 22:23:20 +0100 Subject: Update config/freeradius2/freeradiussqlconf.xml --- config/freeradius2/freeradiussqlconf.xml | 284 +++++++++++++++++++++++++++++-- 1 file changed, 273 insertions(+), 11 deletions(-) (limited to 'config') diff --git a/config/freeradius2/freeradiussqlconf.xml b/config/freeradius2/freeradiussqlconf.xml index a5bc4d2e..6851711c 100644 --- a/config/freeradius2/freeradiussqlconf.xml +++ b/config/freeradius2/freeradiussqlconf.xml @@ -98,20 +98,16 @@ - Enable SQL Database + ENABLE SQL DATABASE - SERVER 1 listtopic Enable SQL Support varsqlconfincludeenable - + You must enable at least one of the following options: Authorization, Accounting, Session, Post-Auth.]]> - select - Disable - - - - + checkbox + varsqlconf2failover,varsqlconf2includeenable,varsqlconfenableauthorize,varsqlconfenableaccounting,varsqlconfenablesession,varsqlconfenablepostauth,varsqlconfdatabase,varsqlconfserver,varsqlconfport,varsqlconflogin,varsqlconfpassword,varsqlconfradiusdb,varsqlconfaccttable1,varsqlconfaccttable2,varsqlconfpostauthtable,varsqlconfauthchecktable,varsqlconfauthreplytable,varsqlconfgroupchecktable,varsqlconfgroupreplytable,varsqlconfusergrouptable,varsqlconfreadgroups,varsqlconfdeletestalesessions,varsqlconfsqltrace,varsqlconfnumsqlsocks,varsqlconfconnectfailureretrydelay,varsqlconflifetime,varsqlconfmaxqueries,varsqlconfreadclients,varsqlconfnastable Enable SQL Authorization @@ -162,7 +158,7 @@ - SQL Database Configuration + SQL DATABASE CONFIGURATION - SERVER 1 listtopic @@ -173,8 +169,6 @@ mysql - - @@ -352,6 +346,274 @@ input nas + + ENABLE REDUNDANT SQL DATABASE SUPPORT + listtopic + + + Choose Failover/Loadbalancing Mode + varsqlconf2failover +
+ redundant: If server 1 fails failover to server 2
+ load-balance: The load is balanced 50:50 to both databases
+ redundant-load-balance: The load is balanced 50:50 to both databases. If one is down the other does 100%.]]> + select + redundant + + + + + + + + ENABLE SQL DATABASE - SERVER 2 + listtopic + + + Enable SQL Support + varsqlconf2includeenable + + You must enable at least one of the following options: Authorization, Accounting, Session, Post-Auth.]]> + checkbox + varsqlconf2enableauthorize,varsqlconf2enableaccounting,varsqlconf2enablesession,varsqlconf2enablepostauth,varsqlconf2database,varsqlconf2server,varsqlconf2port,varsqlconf2login,varsqlconf2password,varsqlconf2radiusdb,varsqlconf2accttable1,varsqlconf2accttable2,varsqlconf2postauthtable,varsqlconf2authchecktable,varsqlconf2authreplytable,varsqlconf2groupchecktable,varsqlconf2groupreplytable,varsqlconf2usergrouptable,varsqlconf2readgroups,varsqlconf2deletestalesessions,varsqlconf2sqltrace,varsqlconf2numsqlsocks,varsqlconf2connectfailureretrydelay,varsqlconf2lifetime,varsqlconf2maxqueries,varsqlconf2readclients,varsqlconf2nastable + + + Enable SQL Authorization + varsqlconf2enableauthorize + + SQL support must be enabled for this to work. (Default: Disable)]]> + select + Disable + + + + + + + Enable SQL Accounting + varsqlconf2enableaccounting + + SQL support must be enabled for this to work. (Default: Disable)]]> + select + Disable + + + + + + + Enable SQL Session + varsqlconf2enablesession + + SQL support must be enabled for this to work. (Default: Disable)]]> + select + Disable + + + + + + + Enable SQL Post-Auth + varsqlconf2enablepostauth + + SQL support must be enabled for this to work. (Default: Disable)]]> + select + Disable + + + + + + + SQL DATABASE CONFIGURATION - SERVER 2 + listtopic + + + Database Type + varsqlconf2database + + select + mysql + + + + + + + Server IP Address + varsqlconf2server + + input + localhost + + + Server Port Address + varsqlconf2port + + input + 3306 + + + Database Username + varsqlconf2login + + input + radius + + + Database Password + varsqlconf2password + + password + radpass + + + Database Table Configuration + varsqlconf2radiusdb + + For all except Oracle choose: radius
+ For Oracle change and paste the following line according your environment:
+ (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))(CONNECT_DATA=(SID=your_sid)))]]> + input + radius + + + Accounting Table 1 (Start) + varsqlconf2accttable1 + + input + radacct + + + Accounting Table 2 (Stop) + varsqlconf2accttable2 + + input + radacct + + + Post Auth Table + varsqlconf2postauthtable + + input + radpostauth + + + Auth Check Table + varsqlconf2authchecktable + + input + radcheck + + + Auth Reply Table + varsqlconf2authreplytable + + input + radreply + + + Group Check Table + varsqlconf2groupchecktable + + input + radgroupcheck + + + Group Reply Table + varsqlconf2groupreplytable + + input + radgroupreply + + + User Group Table + varsqlconf2usergrouptable + + input + radusergroup + + + Read the Group Tables + varsqlconf2readgroups + yes (default) we read the group tables.
+ If set to no the user must have Fall-Through = Yes in the radreply table]]> + select + yes + + + + + + + Delete Stale Sessions + varsqlconf2deletestalesessions + + select + yes + + + + + + + Print all SQL Statements + varsqlconf2sqltrace + + select + no + + + + + + + Number of SQL Connections + varsqlconf2numsqlsocks + + input + 5 + + + Failed Database Connection Delay + varsqlconf2connectfailureretrydelay + + input + 60 + + + SQL Socket Lifetime + varsqlconf2lifetime + + input + 0 + + + SQL Socket Maximum Queries + varsqlconf2maxqueries + + input + 0 + + + Read Clients from Database + varsqlconf2readclients + yes to read radius clients from the database ('nas' table). Clients will only be read on server startup. (Default: yes)]]> + select + yes + + + + + + + RADIUS Client Table + varsqlconf2nastable + + input + nas + freeradius_sqlconf_resync(); -- cgit v1.2.3