On 18 Sep 2012, at 22:22, "Kriston" <me@kriston.net> wrote:
I have users who log in as "username@example.com" and just as "username". How do I append @example.com only to those users who don't have @example.com already? I have a fairly generic FreeRADIUS 2.1.10 installation that connects to a MySQL server.
I've tried a number of different things in dialup.conf but none have worked.
Example 1: sql_user_name = "{%{Stripped-User-Name}:-%{User-Name}}@{%{Realm}:-example.com}"
This results in a string in the SQL queries for User-Name that looks like "=7B:-username=7D@=7B:-example.com=7D".
Look at all those lonely lonely left hand curly braces, don't you think they might appreciate another character to snuggle up to? What do you think that character might be?
Example 2: I have also tried regular expressions like this: if ( %{User-Name} !~ /.example\.com/i) { sql_user_name = "%{User-Name}@example.com" } But this one results in a blank string for in the SQL queries that use sql_user_name.
I'm open to any and all comments.
Read man unlang, stop inventing syntax. -Arran