Re: (RADIATOR) Multiple databases (file) for the users
Hello Davidson - Currently the only way to do this is with a trace 4 debug level set of your log file. You could also do it with a combination of hooks, AuthBy INTERNAL and AuthBy GROUP - if you want to persue that idea there are some example hooks in the file goodies/hooks.txt. regards Hugh On Wed, 23 Jan 2002 23:38, [EMAIL PROTECTED] wrote: BTW...a notice a small problem... If a user who is in groupA enters a wrong password, the logs indicate No such a user Looks like the second file is checked and if user not there assumes no such a user... I would want to log Bad Password in such cases... Please help - Original Message - From: Hugh Irvine [EMAIL PROTECTED] To: Davidson Thaba [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, January 23, 2002 10:56 AM Subject: Re: (RADIATOR) Multiple databases (file) for the users Hello Davidson - I am running radiator 2.15 on solaris 7. My users database is on a flat text file. I would like to split my users file into 2 files, in preparation for some kind of service separation. Please advise on how to go about it... ( the only thing i want to achieve for now is to have GroupA customers in one file and groupB customers in another. You should do something like this: # define Realm Realm mydomain.dom RewriteUsername s/\s+//g # Strip the realm RewriteUsername s/\@mydomain\.dom$// AuthByPolicy ContinueUntilAccept AuthBy FILE Filename %D/GroupA /AuthBy AuthBy FILE Filename %D/GroupB /AuthBy AcctLogFileName %L/detail/detail.%Y%m%d /Realm BTW - the latest version of Radiator is 2.19 and you should probably upgrade. regards Hugh -- Radiator: the most portable, flexible and configurable RADIUS server anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X. - Nets: internetwork inventory and management - graphical, extensible, flexible with hardware, software, platform and database independence. -- Radiator: the most portable, flexible and configurable RADIUS server anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X. - Nets: internetwork inventory and management - graphical, extensible, flexible with hardware, software, platform and database independence. === Archive at http://www.open.com.au/archives/radiator/ Announcements on [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
(RADIATOR) Multiple databases
--- Forwarded mail from [EMAIL PROTECTED] Date: Fri, 13 Oct 2000 10:40:20 +1000 (EST) From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: BOUNCE [EMAIL PROTECTED]:Non-member submission from [Elias [EMAIL PROTECTED]] From mikem Fri Oct 13 10:40:15 2000 Received: by oscar.open.com.au (8.9.0/8.9.0) id KAA22720 for [EMAIL PROTECTED]; Fri, 13 Oct 2000 10:40:11 +1000 (EST) Received: from ipop3 (ipop3.tm.net.my [202.188.0.247]) by perki.connect.com.au with ESMTP id LAA28179 (8.8.8/IDA-1.7 for [EMAIL PROTECTED]); Fri, 13 Oct 2000 11:36:55 +1100 (EST) Disposition-notification-to: [EMAIL PROTECTED] Received: from ipop3 (ipop3.tm.net.my [202.188.0.247]) by perki.connect.com.au with ESMTP id LAA28179 (8.8.8/IDA-1.7 for [EMAIL PROTECTED]); Fri, 13 Oct 2000 11:36:55 +1100 (EST) Received: from elias (parkview-100-227.tm.net.my [202.188.100.227]) by ipop3.tm.net.my (iPlanet Messaging Server 5.0 (built Oct 2 2000)) with SMTP id [EMAIL PROTECTED] for [EMAIL PROTECTED]; Thu, 12 Oct 2000 12:06:43 +0800 (SGT) Date: Thu, 12 Oct 2000 12:05:24 +0800 From: Elias [EMAIL PROTECTED] Subject: Multiple databases To: [EMAIL PROTECTED] Message-id: 010801c03401$a5d9cd20$[EMAIL PROTECTED] MIME-version: 1.0 X-MIMEOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 X-Mailer: Microsoft Outlook Express 5.50.4133.2400 X-Priority: 3 X-MSMail-priority: Normal Content-Type: multipart/alternative; boundary="Boundary_(ID_99hi7gx0d057IYaHwtB49A)" This is a multi-part message in MIME format. --Boundary_(ID_99hi7gx0d057IYaHwtB49A) Content-type: text/plain; charset=iso-8859-1 Content-transfer-encoding: 7BIT Hi, I want to set-up a multiple database environment so that if one database goes down, the backup will take over. My config is as shown below. Is there anything wrong with it? When radiusxx goes down, radiator does not switch over to radiusyy automatically. Thanks. Realm xxx.xxx.xxx AuthBy SQL DBSource radiusxx .. .. /AuthBy AuthBy SQL DBSource radiusyy .. .. /AuthBy /Realm SessionDatabase SQL DBSource radiusyy .. .. /SessionDatabase - Elias - --Boundary_(ID_99hi7gx0d057IYaHwtB49A) Content-type: text/html; charset=iso-8859-1 Content-transfer-encoding: 7BIT !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" HTMLHEAD META http-equiv=Content-Type content="text/html; charset=iso-8859-1" META content="MSHTML 5.50.4134.600" name=GENERATOR STYLE/STYLE /HEAD BODY bgColor=#ff DIVFONT face=Arial size=2Hi,/FONT/DIV DIVFONT face=Arial size=2/FONTnbsp;/DIV DIVFONT face=Arial size=2I want to set-up a multiple database environment so that if one database goes down, the backup will take over. My config is as shown below. Is there anything wrong with it? When radiusxx goes down, radiator does not switch over to radiusyy automatically. Thanks./FONT/DIV DIVFONT face=Arial size=2/FONTnbsp;/DIV DIV DIVFONT face=Arial size=2lt;Realm xxx.xxx.xxxgt;/FONT/DIV DIVFONT face=Arial size=2nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; lt;AuthBy SQLgt;/FONT/DIV DIVFONT face=Arial size=2nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; DBSource radiusxx/FONT/DIV DIVFONT face=Arial size=2nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; ../FONT/DIV DIVFONT face=Arial size=2nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; ..nbsp;nbsp;nbsp; /FONT/DIV DIVFONT face=Arial size=2nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; lt;/AuthBygt;/FONT/DIV DIVFONT face=Arial size=2 DIVFONT face=Arial size=2nbsp;nbsp;/FONT/DIV DIVFONT face=Arial size=2nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; lt;AuthBy SQLgt;/FONT/DIV DIVFONT face=Arial size=2nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; DBSource radiusyy/FONT/DIV DIVFONT face=Arial size=2nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; ../FONT/DIV DIVFONT face=Arial size=2nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; ..nbsp;nbsp; /FONT/DIV DIVFONT face=Arial size=2nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; lt;/AuthBygt;/FONT/DIV DIVlt;/Realmgt;/DIV DIVnbsp;/DIV DIVlt;SessionDatabase SQLgt; DIVnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;DBSource radiusyy/DIV DIVnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; ../DIV DIVnbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; ../DIV DIVnbsp;lt;/SessionDatabasegt;/DIV DIVnbsp;/DIV DIVnbsp;/DIV DIV- Elias -/DIV/DIV/FONT/DIV/DIV/BODY/HTML --Boundary_(ID_99hi7gx0d057IYaHwtB49A)-- ---End of forwarded mail from [EMAIL PROTECTED] -- Mike McCauley [EMAIL PROTECTED] Open System Consultants Pty. LtdUnix, Perl, Motif, C++, WWW 24 Bateman St Hampton, VIC 3188 Australia http://www.open.com.au Phone +61 3 9598-0985
Re: (RADIATOR) Multiple databases
Hello Elias - Hi, I want to set-up a multiple database environment so that if one database goes down, the backup will take over. My config is as shown below. Is there anything wrong with it? When radiusxx goes down, radiator does not switch over to radiusyy automatically. Thanks. Realm xxx.xxx.xxx AuthBy SQL DBSource radiusxx .. .. /AuthBy AuthBy SQL DBSource radiusyy .. .. /AuthBy /Realm SessionDatabase SQL DBSource radiusyy .. .. /SessionDatabase To set up multiple databases, you specify them like this: Realm xxx.xxx.xxx AuthBy SQL DBSource radiusxx DBSource radiusyy .. .. /AuthBy /Realm Have a look at section 6.26 in the Radiator 2.16.3 reference manual for further details on AuthBy SQL. regards Hugh -- 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.
Re: (RADIATOR) Multiple databases
I dont get the Framed-IP-Address on Start records, thus my SQL doesn't log them to the RADONLINE database A look at the printout detail files, shows that information is not sent by my NAS terminal servers, Bay 5399's. When a user gets assigned a static ip address, with a reply item of Framed-IP-Address = x.y.z.a then that does get logged, and does therefore make it into SQL. However for the regular users whom get Framed-IP-Address = 255.255.255.254 which tells the NAS to dynamically assign the address, it doesn't get sent in accounting packets. Is this normal or is there a way to pluck the dynamic ip address the NAS assigns and get it logged? The Framed-IP-Address does show on all Stop records. Don't know if this is something the NAS would have to be taught to do perhaps, to send that info after its assigned the ip address? Thu Oct 12 04:07:23 2000 Acct-Status-Type = Start Acct-Session-Id = "ae0b0862" Acct-Delay-Time = 24 NAS-Port = 41 Annex-83 = "00N133" NAS-Port-Type = Async Annex-Unauthenticated-Time = 27 User-Name = "qism" Service-Type = Framed-User Framed-Protocol = PPP Called-Station-Id = "xxx" Calling-Station-Id = "xx" Idle-Timeout = 900 Connect-Info = "48000 21600 V.90" Annex-Transmit-Speed = 48000 Annex-Receive-Speed = 21600 Annex-96 = "V.90" Annex-86 = "V.42bis" Annex-97 = "V.42" Annex-89 = "00031" Annex-94 = "00022" Annex-82 = "0001" Annex-81 = "0001" Acct-Authentic = RADIUS NAS-IP-Address = x.y.z.a Timestamp = 971338019 - Original Message - From: "Hugh Irvine" [EMAIL PROTECTED] To: "Elias" [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, October 12, 2000 9:10 PM Subject: Re: (RADIATOR) Multiple databases Hello Elias - Hi, I want to set-up a multiple database environment so that if one database goes down, the backup will take over. My config is as shown below. Is there anything wrong with it? When radiusxx goes down, radiator does not switch over to radiusyy automatically. Thanks. Realm xxx.xxx.xxx AuthBy SQL DBSource radiusxx .. .. /AuthBy AuthBy SQL DBSource radiusyy .. .. /AuthBy /Realm SessionDatabase SQL DBSource radiusyy .. .. /SessionDatabase To set up multiple databases, you specify them like this: Realm xxx.xxx.xxx AuthBy SQL DBSource radiusxx DBSource radiusyy .. .. /AuthBy /Realm Have a look at section 6.26 in the Radiator 2.16.3 reference manual for further details on AuthBy SQL. regards Hugh -- 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. === 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.
