[Help-gnu-radius] multiple logins ...

[Ciprian Nica]

Hello,

In "users" file  I have something like this ...

DEFAULT Auth-Type = SQL,
               Simultaneous-Use = 1
       Service-Type = Framed-User,
               Framed-Protocol = PPP

How can i enable for some of the users multiple logins ?
Should i insert into attrib table some pairs like
attr/value
Simultaneous-Use /  2

And what value should be op ? NULL or not NULL ?

One other observation i'd have is that radius stores usernames case 
sensitive while a "normal" mysql query is not case sensitive.
To be more specific :
let's say someone conencts using nimaci/PASSWORD
and another one using NiMaci/PASSWORD

then, radius considers it is a distinct user (and so it is considering 
the case) but unfortunately mysql in a query like

auth_query  SELECT password \
           FROM passwd \
           WHERE user_name='%u' \
           AND active='Y'

would authenticate both users.

The solution would be doing something like

auth_query  SELECT password \
           FROM passwd \
           WHERE *BINARY* user_name='%u' \
           AND active='Y'


I don't know if this "problem" was already noticed but i thought it 
might be usefull and I hope I'm right about it and that is the reason 
the user A___ and a____ were connected simultaneously.


Regards,
Ciprian Nica