Dear all,
Radius accounting, especially, stop request is very
important to me. Therefore, I dont want to miss it.
My question, is it possible to switch to the spare
SQL-accounting machine automatically when the first
machine failed?
if I do:
<AuthBy SQL>
Identifier SQLAcct1
DBSource dbi:mysql:xxxx:machine1
DBUsername xxxx
DBAuth yyyy
DateFormat %b %e %Y %H:%M:%S
# AccountingTable ACCOUNTING%Y%m%d
AcctColumnDef USERNAME,User-Name
AcctColumnDef TIME_STAMP,Timestamp,integer-date
AcctColumnDef ACCTSTATUSTYPE,Acct-Status-Type
...
AcctColumnDef
CALLED_STATION_ID,Called-Station-Id
AcctColumnDef FRAMEDIPADDRESS, Framed-IP-Address
</AuthBy>
<AuthBy SQL>
Identifier SQLAcct2
DBSource dbi:mysql:xxxx:machine2
DBUsername xxxx
DBAuth yyyy
DateFormat %b %e %Y %H:%M:%S
# AccountingTable ACCOUNTING%Y%m%d
AcctColumnDef USERNAME,User-Name
AcctColumnDef TIME_STAMP,Timestamp,integer-date
AcctColumnDef ACCTSTATUSTYPE,Acct-Status-Type
...
AcctColumnDef
CALLED_STATION_ID,Called-Station-Id
AcctColumnDef FRAMEDIPADDRESS, Framed-IP-Address
</AuthBy>
<Handler
Request-Type=Accounting-Request,NAS-IP-Address=/xxx.xxx.xxx.xxx/>
AuthBy SQLAcct1
AuthBy SQLAcct2
</Handler>
It will insert accounting into both machine, right?
Now, HOW to make it insert into machine2 ONLY IF
machine1 fail?
thanx in advance
Jose
ps: I've searched the FAQ and a quick browse to
mailinglist archive and couldn't find such discussion
(pardon me if there is).
__________________________________________________
Do You Yahoo!?
Yahoo! Photos - Share your holiday photos online!
http://photos.yahoo.com/
===
Archive at http://www.starport.net/~radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
