Re: [Help-gnu-radius] SQL Auth doesn't work

[Sergey Poznyakoff]

Hi Fred,

> # radauth -v -slocalhost:foobar mane
> Password:
> server 127.0.0.1:1645
> send code 1 (RT_AUTHENTICATION_REQUEST)
[...]
> no reply
> expect 2
> got    0
> FAIL

Make sure radiusd actually listens on port 1645, or reconfigure your
radauth to use another port (configuration file raddb/client.conf,
"server" statement)

> # radtest mane mane123 localhost 0 foobar
> Sending Access-Request of id 238 to 127.0.0.1:1812
> User-Name = "mane"
> User-Password = "NAS-IP-Address = SVR04
> NAS-Port-Id = "0"
> rad_recv: Access-Reject packet from host 127.0.0.1:1812, id=238, length=20

This indicates your radiusd is listening at 1812/1813, so use these
values in your client.conf

> Nov 20 16:05:32: Auth.notice: Invalid user: [mane]: CLID unknown (from nas
> 255.255.255.255)

"Invalid user" means that radiusd wasn't able to find that username in
the database, i.e. the auth_query (file raddb/sqlserver) returned
empty set. To find out why, try executing the query manually.

Regards,
Sergey