Re: Rejected Calling Station id and radius reply message

2007-03-16 Thread Alan DeKok 
Bishal wrote:
>  I am using freeradius 1.1.3 in freebsd 6 with mysql database.
> My problem is if I enable the calling-station-id in freeradius radcheck
> table the rejected message is shown as below in radius log
> 
> Fri Mar 16 16:56:58 2007 : Info: rlm_sql (sql): No matching entry in the
> database for request from user [test]
> Fri Mar 16 16:56:58 2007 : Auth: Login incorrect (rlm_chap: Clear text
> password not available): [test] (from client pppoe2 port 568 cli
> 0:7:95:10:73:9e)
> 
> The rejected message should be calling station id not allowed.

  Why do you say that?

  The user is getting rejected because you had a set of requirements he
had to meet in order to be authenticated, and he didn't meet those
requirements.

  Understand that some people have MANY policies.  When a user is
accepted or rejected, they don't want to see hundreds of messages saying
"matched policy X", or "didn't match policy Y".

  Alan DeKok.
--
  http://deployingradius.com   - The web site of the book
  http://deployingradius.com/blog/ - The blog
- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Rejected Calling Station id and radius reply message

2007-03-16 Thread Bishal 

Hello

 I am using freeradius 1.1.3 in freebsd 6 with mysql database.
My problem is if I enable the calling-station-id in freeradius radcheck
table the rejected message is shown as below in radius log

Fri Mar 16 16:56:58 2007 : Info: rlm_sql (sql): No matching entry in the
database for request from user [test]
Fri Mar 16 16:56:58 2007 : Auth: Login incorrect (rlm_chap: Clear text
password not available): [test] (from client pppoe2 port 568 cli
0:7:95:10:73:9e)

The rejected message should be calling station id not allowed. Why I am
not getting the valid rejected reason. Same happens for Expired accounts
too. radius.log for Expiration accounts show:

Fri Mar 16 16:56:38 2007 : Auth: Login incorrect: [test2] (from client
pppoe2 port 566 cli 0:7:95:10:73:9e)

I have seetup radcheck table as follows:

++++--+--+
  | id | UserName   | Attribute  | Value| Op   |
  ++++--+--+
  |  1 | test  | User-Password   | wilma| == 
 |
  |  2 | test  | Expiration   | 10 Feb 2007  | :=
  |
  |  2 | test  | Calling-Station-Id   | 0:c0:26:8b:2a:e7   |
==   |
  ++++--+--+

- 
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html