Hmm.. what about this:
<AuthBy SQL>
Identifier SQLAcct
DBSource dbi:mysql:xxxx:machine1
DBUsername xxxx
DBAuth yyyy
DBSource dbi:mysql:xxxx:machine2
DBUsername xxxx
DBAuth yyyy
...
</AuthBy>
I think that should work..
-a
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
> Behalf Of Jose Quinn
> Sent: vrijdag 12 januari 2001 10:22
> To: [EMAIL PROTECTED]
> Subject: (RADIATOR) high availabilty accounting
>
>
> 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.
>
===
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.
