Re: Using username@example.com and plain username
Very well... I don't use a SQL database for users, but it occurs to me that Arran's only slightly tongue-in-cheeck comment about lonely curly braces might have convinced you to look at whether all the characters in your sql_user_name string are being properly escaped or quoted. Since 7B is the hex code for "left curly bracket" and 7D for "right curly bracket", it seems that those characters are being taken literally, rather than as part of a variable construction. It looks like you're fairly close to getting that to work... just experiment with some single quotes? By the way, I got this idea by looking at the wiki: http://wiki.freeradius.org/modules/Rlm_sql Steve Lovaas
Thanks, Steve, I think I'm really close and I appreciate your suggestion as to why the variable substitution isn't working the way I thought it would. I have not seen whether it handles the substitution of "@example.com" properly yet, though. Thanks again, Kriston
Kriston wrote:
Thanks, Steve, I think I'm really close and I appreciate your suggestion as to why the variable substitution isn't working the way I thought it would.
Those suggestions are wrong, unfortunately. Randomly experimenting with configurations is a guaranteed way to go nowhere. When you drive a car, do you look at a map, or do you randomly drive around the streets, hoping to find your destination?
I have not seen whether it handles the substitution of "@example.com" properly yet, though.
There are no examples which match your exact configuration. If I understand your butchered "sql_user_name" correctly, you got it very wrong. It will create things like "bob@example.com@example.net" Knowing why requires *understanding*. You're an adult, not a baby. Only babies require spoon-feeding. Alan DeKok.
participants (2)
-
Alan DeKok -
Kriston