What if your primary SQL machine comes back up? Does it automatically switch back to the primary SQL? 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 http://www.starport.net/~radiator/200101/msg00130.html Thanks, JanetTitle: RE: (RADIATOR) high availabilty accounting
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
RE: (RADIATOR) high availabilty accounting
- To: "Andy De Petter" <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>
- Subject: RE: (RADIATOR) high availabilty accounting
- From: Hugh Irvine <[EMAIL PROTECTED]>
- Date: Tue, 16 Jan 2001 02:31:13 +1100
- >Received: from snowstorm.mail.pipex.net (snowstorm.mail.pipex.net [158.43.192.97]) by perki.connect.com.au with SMTP id CAA17337 (8.8.8/IDA-1.7 for <[EMAIL PROTECTED]>); Tue, 16 Jan 2001 02:35:54 +1100 (EST)
- In-Reply-To: <[EMAIL PROTECTED]>
- References: <[EMAIL PROTECTED]>
- Sender: [EMAIL PROTECTED]
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.
- References:
- RE: (RADIATOR) high availabilty accounting
- From: "Andy De Petter" <[EMAIL PROTECTED]>
- RE: (RADIATOR) high availabilty accounting
- From: "Andy De Petter" <[EMAIL PROTECTED]>
- RE: (RADIATOR) high availabilty accounting
- Prev by Date: RE: (RADIATOR) Got error -1 from table handler
- Next by Date: Re: (RADIATOR) User-Password display in trace level 3
- Prev by thread: RE: (RADIATOR) high availabilty accounting
- Next by thread: RE: (RADIATOR) high availabilty accounting
- Index(es):
