Hello Andy -
Exactly right - well done.
regards
Hugh
At 9:54 +0100 01/1/15, Andy De Petter wrote:
>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.
--
NB: I am travelling this week, so there may be delays in our correspondence.
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald,
Platypus, Freeside, Interbiller, TACACS+, PAM, external, etc, etc.
Available on Unix, Linux, FreeBSD, Windows 95/98/2000, NT, MacOS X.
===
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.
