I'm not sure....I looked in the <AuthLog FILE> section of the manual before, and didn't really see a way to do it. On mine, if they fail, it just gives the reason of "No such user". This is because of the AuthByPolicy I am using. Radiator inserts into the log the reason it gets from the last AuthBy it comes across. You can try this....not sure if it will work for you though. If not, you can always change your AuthBy or go to Handlers if you are using Realms. Here is what I am using:
<AuthLog FILE> Identifier AuthLog Filename %L/authlog LogSuccess 0 LogFailure 1 SuccessFormat %l:%U:%P:OK:%1:%{Calling-Station-Id} FailureFormat %l:%U:%P:FAIL:%1:%{Calling-Station-Id} </AuthLog> It puts an entry into the log file like this: Mon Apr 8 10:05:25 2002:someuser:somepassword:FAIL:No such user:3525551212 Like I said, I get the "No Such User" for my FAIL reason because of the way my AuthByPolicy is setup, but you may get different results... Hope this help a little. -Ronan -----Original Message----- From: Stephen Malenshek [mailto:[EMAIL PROTECTED]] Sent: Monday, 08 April, 2002 13:04 To: 'Ronan Eckelberry'; [EMAIL PROTECTED] Subject: RE: (RADIATOR) Account status field That is exactly it.... How well does it work, and can we take it one step further with the following: In the radius.cfg file, I have the following statements: <AuthLog FILE> Identifier logger Filename %L/%m%Y-radius.log SuccessFormat %l: Auth: Login OK: [%u(%U)] (from %C) FailureFormat %l: Auth: Login Failure: [%u/%P(%U/%P)] (from %C) LogSuccess 1 LogFailure 1 </AuthLog> <Handler> AuthLog logger </Handler> If it comes to an entry that it shows to be a suspended or "0" code account, can it make an entry into the logfile I have created besides the Failure entry. Maybe it to say that the account actually shows to be suspended because of the entry in the Active field? Just a thought..... Thanks again. Stephen Malenshek President/CEO Valuelinx Corporation [EMAIL PROTECTED] -----Original Message----- From: Ronan Eckelberry [mailto:[EMAIL PROTECTED]] Sent: Monday, April 08, 2002 11:58 AM To: 'Stephen Malenshek'; [EMAIL PROTECTED] Subject: RE: (RADIATOR) Account status field Stephen, Try changing your AuthSelect. I do basically what you are saying by adding "AND ACTIVE='Y'". In your case it would be something like "AND status='1'" Here is my AuthSelect: AuthSelect select PASSWORD,PORTLIMIT,STATICIP,SIMLOGIN from SUBSCRIBERS where USERNAME='%n' AND ACTIVE='Y' Is that kinda like what you are looking for? -Ronan -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Stephen Malenshek Sent: Monday, 08 April, 2002 11:24 To: [EMAIL PROTECTED] Subject: (RADIATOR) Account status field Is there a way to make radiator look at an additional field to see if the account is in a suspended or valid state. For instance, I have a postgres database with the following fields: radius=# \d subscribers Table "subscribers" Attribute | Type | Modifier --------------+------------------------+---------- username | character varying(50) | not null realname | character varying(50) | passwd | character varying(50) | epasswd | character varying(50) | uid | integer | gid | integer | homedir | character varying(90) | huntgroup | character varying(30) | staticip | character varying(22) | shell | character varying(50) | checkattr | character varying(200) | replyattr | character varying(200) | mailonlyacct | character varying(10) | status | character varying(30) | Indices: subscribers_pkey, username_i If an account request comes in and the username and epassword fields show to be the correct information, how could we get the software to check and see if the status field shows a 0 or 1. The 0 would be suspended and 1 would be active, or something to that effect. Please let me know what your thoughts are. Thanks Stephen Malenshek President/CEO Valuelinx Corporation [EMAIL PROTECTED] === 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.