Change SQL Groupcheck Query in Dialup.conf

[Alan DeKok]

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.