O, I did tried that...
-------------------- sql.conf ----
authorize_check_query = "SELECT id, UserName, Attribute, Value,
op, Attribute2, Value2, op2\
FROM ${authcheck_table} \
WHERE Username = '%{SQL-User-Name}' \
ORDER BY id"
---------------------------------
and ofcoz, i altered the table..
but no good luck here either...
duplicate users still failed..
or didn't you mean that ??
Collen.
Peter Nixon wrote:
On Thu 19 Oct 2006 10:19, Collen Blijenberg wrote:
I was wondering, any change of getting the User collision/duplicate
users option in to the sql module (pref. mysql) ??
I'm still trying to get the mysql backend to work, with duplicate
usernames. (still stuck here)
in the tuning guide, i found a document called 'tuning guide'
under the sql module section, it says something about 'multi column
index' and 'sql for double login detection' ?
but what is mend with this ??
the problem is that i have (a few) users with 1 username and multiple
computers.
we filter on username and calling-station-id (MAC).
but somehow the mysql backend can't handle this (tell me if I'm wrong!!)
So change the auth query to search for calling-station-id also.. simple.
------------------------------------------------------------------------
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
