> Neither. The user is adding the spaces. It looks to me like someone
> figured out that you have test accounts. They are using the test
> accounts to log in without paying.
>
>
Well it is more than one account and they are random usernames (example,
mirije, drogbba, etc. )
> You need to to audit your configuration to ensure that you are using
> the user name *correctly*.
>
> e.g. this is wrong: SELECT ... %{User-Name} ...
>
> this is correct: SELECT ... '%{User-Name}' ...
>
> > One is sure. MySql seems fine and only solution I can do now is to make
> > querry "UPDATE radacct SET UserName='test.user' WHERE
> > UserName='test.user '";
>
> -
>
Inside sql.conf everything seems fine.
....
sql_user_name = "%{User-Name}"
.....
authorize_check_query = "SELECT id, UserName, Attribute, Value, op \
FROM ${authcheck_table} \
WHERE Username = '%{SQL-User-Name}' \
ORDER BY id"
authorize_reply_query = "SELECT id, UserName, Attribute, Value, op \
FROM ${authreply_table} \
WHERE Username = '%{SQL-User-Name}' \
ORDER BY id"
Also, accounting queries are also the same. ???
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
