you can do this on the NAS itself.
Mir Atir
- Original Message -
From:
Brett
Murphy
To: Dirk Laan ; [EMAIL PROTECTED]
Sent: Friday, March 23, 2001 2:23
AM
Subject: Re: (RADIATOR) Database
Failover
I have the same issue, and I am going to implement a MySQL
server that has high availability.ie, dual processor, redundant power
supply etc.What I really would like is a sample config on how to get
radiator to just "auth everyone" on database fail, at least the customers
wont notice then.At 09:14 AM 3/22/2001 +0100, Dirk
Laan wrote:>Hello,>>How do I build a failover for our
database ?>We're using MySql.>>For example:>The
Radius server is still working but it can't connect to the
database.>>Any help would be great.>>I've include
the config>>Regards,>>Dirk
Laan>Foreground>Trace
4>LogStdout>LogDir
/var/log>LogFile
/var/log/%Y-radius.log>DbDir
.>>> Identifier
Cisco>
Secret xxx>
DupInterval 0 Identifier
Ascend>
Secret
> DupInterval
0
Secret mysecret>
DupInterval
0
DBSource
dbi:mysql:radius>
DBUsername
radius>
DBAuth
radius Identifier
RDCAllocator>
DBSource
dbi:mysql:radius>
DBUsername
radius>
DBAuth
radius>>
DefaultLeasePeriod
86400>
LeaseReclaimInterval
3600>>
>
Range x.x.x.x
x.x.x.x>
>>
>
Range x.x.x.x
x.x.x.x>
>>
>
Range x.x.x.x
x.x.x.x>
>>
>
Range x.x.x.x
x.x.x.x>
>>
DBSource
dbi:mysql:radius>
DBUsername
radius>
DBAuth
radius>>
CountQuery
\>
select NASIDENTIFIER, NASPort, AcctSessionID from > RADONLINE
\>
where UserName='%n'>>># configure
AuthBy SQL for authentication>>>
Identifier
InitialAuth>>>
DBSource
dbi:mysql:radius>
DBUsername
radius>
DBAuth
radius>>
AuthSelect select AUTHTYPE, PASSWORD from RDC where USERNAME =
'%n'>>
AuthColumnDef 0, Auth-Type,
check>
AuthColumnDef 1, User-Password,
check>>
StripFromReply
Group-ID>>
AddToReply Service-Type=Framed-User, Framed-Protocol=PPP, >
cisco-avpair=>"ip:dns-servers=x.x.x.x">>>#
configure AuthBy SQL for GID>>>
Identifier
SQL_GetGID>>
DBSource
dbi:mysql:radius>
DBUsername
radius>
DBAuth
radius>>
AuthSelect select GROUPID, SIMUSE from RDC where USERNAME =
'%n'>>
AuthColumnDef 0, Group-ID,
reply>
AuthColumnDef 1, Simultaneous-Use,
check>>
NoDefault>>># configure AuthBy SQL for
Fixed IP>>>
Identifier
Fixed_IP>>
DBSource
dbi:mysql:radius>
DBUsername
radius>
DBAuth
radius>>
AuthSelect select STATICVST, SIMUSE from RDC where USERNAME =
'%n'>>
AuthColumnDef 0, Framed-IP-Address,
reply>
AuthColumnDef 1, Simultaneous-Use,
check>>
NoDefault# configure AuthBy
DYNADDRESS for Dynamic IP>>>
Identifier Dynamic_IP>
Allocator RDCAllocator>
PoolHint
%{NAS-IP-Address}-%{Reply:Group-ID}>
StripFromReply
Group-ID> MapAttribute
yiaddr, Framed-IP-Address>>># configure
AuthBy SQL for accounting>>>
Identifier
AuthAccounting>>>
DBSource
dbi:mysql:radius>
DBUsername
radius>
DBAuth
radius>>
AuthSelect>>
AccountingTable
ACCOUNTING>
AcctColumnDef
USERNAME,User-Name>
AcctColumnDef
TIME_STAMP,Timestamp,integer>
AcctColumnDef
ACCTSTATUSTYPE,Acct-Status-Type>
AcctColumnDef
ACCTDELAYTIME,Acct-Delay-Time,integer>
AcctColumnDef
ACCTINPUTOCTETS,Acct-Input-Octets,integer>
AcctColumnDef
ACCTOUTPUTOCTETS,Acct-Output-Octets,integer>
AcctColumnDef
ACCTSESSIONID,Acct-Session-Id>
AcctColumnDef
ACCTSESSIONTIME,Acct-Session-Time,integer>
AcctColumnDef
ACCTTERMINATECAUSE,Acct-Terminate-Cause>
AcctColumnDef
NASIDENTIFIER,NAS-Identifier>
AcctColumnDef
NASIDENTIFIER,NAS-IP-Address>
AcctColumnDef
NASPORT,NAS-Port,integer>
