Re: [Help-gnu-radius] Login incorrect???

[Gerald]

On keeping plaintext passwords in the database:

http://www.gnu.org/software/radius/manual/html_mono/radius.html#SEC156

 Specifying Passwords in SQL Database.

[DEFAULT]   Auth-Type = Local,
                      Password-Location = SQL

What you put is looking for encrypted passwords (good stuff) in the
database. Which type of encryption is determined by your system's crypt
capabilities and if it was located at compile time I believe.

Note: I put [DEFAULT] in brackets only because the source I'm quoting from 
doesn't have
DEFAULT. In your config you WOULD need DEFAULT without the brackets.

Gerald

P.S. Top posting today because I'm lazy and this was an easy question.

On Thu, 11 Nov 2004, Konst Konst wrote:

> Date: Thu, 11 Nov 2004 15:49:22 +0200 (EET)
> From: Konst Konst <address@hidden>
> To: "address@hidden" <address@hidden>
> Subject: [Help-gnu-radius] Login incorrect???
>
> Can anybody tell me, why RADIUS-server return "Login incorrect"?
>
> >SELECT password FROM passwd WHERE user_name='koch' AND active='Y' ;
> +----------+
> | password |
> +----------+
> | 371      |
> +----------+
> (Others tables are empty, I just inserted one test user)
>
> config:
> auth {
>         max-requests 127;
>         request-cleanup-delay 2;
>         detail yes;
>         strip-names yes;
>         checkrad-assume-logged yes;
> };
>
> users:
> # For detailed description, run:
> #       info Radius users
>
> DEFAULT Auth-Type = SQL,
>                 Simultaneous-Use = 1
>         Service-Type = Framed-User,
>                 Framed-Protocol = PPP
>
> sqlserver (were changed only this string and database host, login-name and 
> pass):
> doauth yes
>
> radius.log:
> Nov 11 18:09:06 Auth.notice: (Access-Request default 214 "koch" 
> CLID=bla-bla-bla CSID=10): Login incorrect [koch/371]
>
> mysql.log:
> 041111 18:09:06      51 Connect     address@hidden on RADIUS
>                      51 Query       SELECT attr,value,op FROM attrib WHERE 
> user_name='koch' AND op IS NOT NULL
>                      51 Query       SELECT attr,value FROM attrib WHERE 
> user_name='koch' AND op IS NULL
>                      51 Query       SELECT password FROM passwd WHERE 
> user_name='koch' AND active='Y'
>
>
> -------------------------------------------------------------------------------
> http://www.one.lv - Tavs mobilais e-pasts!
>
> Tagad lasi savu e-pastu ar mobilo telefonu - wap.one.lv!
>
>
> _______________________________________________
> Help-gnu-radius mailing list
> address@hidden
> http://lists.gnu.org/mailman/listinfo/help-gnu-radius
>