User collision/duplicate users and mysql backend

[Collen Blijenberg]

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