SQL xlat not working

Eric Geier me at egeier.com
Wed Apr 1 15:38:35 CEST 2009


> >I can't get SQL xlat to work in the Clients file. I'm trying to do a
> DB
> >query for the Shared Secret.
> >
> 
> And where did you find that it should work?

I've googled for it. Plus someone here had mentioned "rlm_raw and use it
with a SQL xlat rule". I think I'm doing that, but it's not working. Please
let me know what might be holding it up. 

> >I'm getting invalid Message-Authenticator (Shared secret is incorrect)
> >errors.
> 
> You should fix client secret to match the server not other way round.
> 
> >The select statement works fine when ran on my DB server.
> >
> >Have any suggestions?
> 
> You can load clients from nas table. See read_clients setting near the
> end of sql.conf file.

That may work, but could I have the Name field represent something besides
the IP, like the NAS-Identifier?

Thanks!
Eric




More information about the Freeradius-Users mailing list