User collision/duplicate users and mysql backend

Collen Blijenberg collen at
Thu Oct 19 11:02:27 CEST 2006

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 ??


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

More information about the Freeradius-Users mailing list