1 Nov
2006
1 Nov
'06
9:51 p.m.
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}')