Good morning guys!
I asked a question earlier but haven't heard back a reply yet... I guess
I am not supposed to include the question in the answer of another
question lol.
So here is the question again:
I am using my Freeradius 2.1.6 to do PEAP for Windows XP clients. The
usernames are in format 'Domain_name\username'
I am using postgresql and my safe-characters in the dialup.conf is set
to:
safe-characters =
\...@abcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyz0123456789.-_:
/
My radcheck table looks like:
id | username | attribute | op |value
4 | GTCORP\dzhao | Auth-Type | = | ntlm_auth
When I try to authenticate, in the debug, I see this:
[sql] expand: SELECT id, UserName, Attribute, Value, Op FROM
radcheck WHERE Username = '%{SQL-User-Name}' ORDER BY id - SELECT
id, UserName, Attribute, Value, Op FROM radcheck WHERE Username =
'GTCORP\dzhao' ORDER BY id
However this query returns nothing from the postgresql DB because the DB
treats the \ as an escape character. In order to test I added another
entry in the table:
11 | GTCORPdzhao | Auth-Type | = | ntlm_auth
And the query worked and found it.
I also tried the following query in PostSQL and it found the orginal
entry successfully...
select * from radcheck where username = 'GTCORP\\dzhao'
I am wondering if there is a setting to automatically add another \ in
the %{SQL-User-Name} if there is already a \ in it??
Thanks!
Difan Zhao, M.Eng
Network Engineer
difan.z...@guest-tek.com
www.guest-tek.com
Office: 403-509-1010 ext 3048
Cell: 403-689-7514
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
