User collision/duplicate users and mysql backend

Peter Nixon listuser at
Thu Oct 19 09:22:52 CEST 2006

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
PGP Key:
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: not available
URL: <>

More information about the Freeradius-Users mailing list