Hey all, I am trying to strip realm detail from all Auth & Accounting requests (using SQL backend) I've tried setting: sql_user_name = "%{Stripped-User-Name}" in the sql.conf to no avail What am I missing here? Cheers, Leon
Leon Kyneur <leon@dexterous.org> wrote:
I've tried setting: sql_user_name = "%{Stripped-User-Name}"
in the sql.conf to no avail
What am I missing here?
Did you configure a realm? Alan DeKok. -- http://deployingradius.com - The web site of the book http://deployingradius.com/blog/ - The blog
Alan DeKok wrote:
Leon Kyneur <leon@dexterous.org> wrote:
I've tried setting: sql_user_name = "%{Stripped-User-Name}"
in the sql.conf to no avail
What am I missing here?
Did you configure a realm?
No I haven't.. I'm trying to strip the realm regardless of what might be configured at the users end. Could this be done by setting the "strip" parameter under a NULL or the DEFAULT realm? (doesn't appear to work for me either)
Leon Kyneur <leon@dexterous.org> wrote:
Could this be done by setting the "strip" parameter under a NULL or the DEFAULT realm? (doesn't appear to work for me either)
No, you'll have to configure a realm, or a regular expression to match the text after the "@" in the User-Name. Alan DeKok. -- http://deployingradius.com - The web site of the book http://deployingradius.com/blog/ - The blog
On Wed, 1 Nov 2006, Alan DeKok wrote:
Leon Kyneur <leon@dexterous.org> wrote:
Could this be done by setting the "strip" parameter under a NULL or the DEFAULT realm? (doesn't appear to work for me either)
No, you'll have to configure a realm, or a regular expression to match the text after the "@" in the User-Name.
Thanks Alan, I've achieved this by replacing all occurrences of '%{SQL-User-Name}' with the following SQL in sql.conf: IF(INSTR('%{SQL-User-Name}','@'),LEFT('%{SQL-User-Name}',INSTR('%{SQL-User-Name}', '@')-1),'%{SQL-User-Name}')
participants (2)
-
Alan DeKok -
Leon Kyneur