User collision/duplicate users and mysql backend

[Peter Nixon]

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.

-- 

Peter Nixon
http://www.peternixon.net/
PGP Key: http://www.peternixon.net/public.asc
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: not available
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20061019/bdbe77f8/attachment.pgp>