>> 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. ???
>
>