Change SQL Groupcheck Query in Dialup.conf

Alan DeKok aland at
Sun Nov 27 13:50:15 CET 2011

JennyBlunt wrote:
> I need to change the structure of the radusergroup table so it includes the
> radcheck_id and radgroupcheck_id's.

  Why?  And even if there is a good reason, it's just SQL...

> However, I need to know if it possible to change SQL-User-Name to use the
> radcheck id instead?

  Yes.  That's why the queries are editable.  So you can edit them,

> Is it possible to look up the user id prior to this statement running?

  Yes.  It's just another SQL query:

	update request {
		SQL-User-Id := "%{sql: ...}"

> If so, where do I do this?

  In the "authorize" section.

  Alan DeKok.

More information about the Freeradius-Users mailing list