Just a couple of suggestions (which I understand may have been discussed and dismissed before!): For the default mysql schema, have a UNIQUE constraint / key on username / attribute pairs in the applicable tables - most importantly for us this is radcheck. Have a key on username in radpostauth.
thanks 2018-05-17 9:46 UTC, Dom Latter <freeradius-users@latter.org>:
Just a couple of suggestions (which I understand may have been discussed and dismissed before!):
For the default mysql schema, have a UNIQUE constraint / key on username / attribute pairs in the applicable tables - most importantly for us this is radcheck.
Have a key on username in radpostauth. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
On May 17, 2018, at 5:46 AM, Dom Latter <freeradius-users@latter.org> wrote:
Just a couple of suggestions (which I understand may have been discussed and dismissed before!):
For the default mysql schema, have a UNIQUE constraint / key on username / attribute pairs in the applicable tables - most importantly for us this is radcheck.
It's possible to have the same attribute as a check item with different values.
Have a key on username in radpostauth.
That's probably a good idea. I'll go fix that. Alan DeKok.
On 17/05/18 15:28, Alan DeKok wrote:
On May 17, 2018, at 5:46 AM, Dom Latter <freeradius-users@latter.org> wrote:
Just a couple of suggestions (which I understand may have been discussed and dismissed before!):
For the default mysql schema, have a UNIQUE constraint / key on username / attribute pairs in the applicable tables - most importantly for us this is radcheck.
It's possible to have the same attribute as a check item with different values.
Okay, how does that work? Got any examples?
Have a key on username in radpostauth.
That's probably a good idea. I'll go fix that.
Cool.
On May 17, 2018, at 10:33 AM, Dom Latter <freeradius-users@latter.org> wrote:
It's possible to have the same attribute as a check item with different values.
Okay, how does that work?
Put in the same attribute as a check item with different values?
Got any examples?
See the Wiki. Look for "sql". This is extensively documented. Alan DeKok.
participants (3)
-
Alan DeKok -
Dom Latter -
Guissou Abdoul