<br><br><div class="gmail_quote"><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div class="Ih2E3d"><br></div> Neither. The user is adding the spaces. It looks to me like someone
<br>figured out that you have test accounts. They are using the test<br>accounts to log in without paying.<br><div class="Ih2E3d"><br></div></blockquote><div><br>Well it is more than one account and they are random usernames (example, mirije, drogbba, etc. )
<br><br></div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div class="Ih2E3d"><br></div> You need to to audit your configuration to ensure that you are using
<br>the user name *correctly*.<br><br> e.g. this is wrong: SELECT ... %{User-Name} ...<br><br> this is correct: SELECT ... '%{User-Name}' ...<br><div class="Ih2E3d"><br>> One is sure. MySql seems fine and only solution I can do now is to make
<br>> querry "UPDATE radacct SET UserName='test.user' WHERE<br>> UserName='test.user '";<br></div><font color="#888888"><br></font><div><div></div><div class="Wj3C7c">-</div></div></blockquote>
<div><br>Inside sql.conf everything seems fine. <br>....<br>sql_user_name = "%{User-Name}" <br>.....<br>authorize_check_query = "SELECT id, UserName, Attribute, Value, op \<br> FROM ${authcheck_table} \
<br> WHERE Username = '%{SQL-User-Name}' \<br> ORDER BY id"<br>authorize_reply_query = "SELECT id, UserName, Attribute, Value, op \<br> FROM ${authreply_table} \<br> WHERE Username = '%{SQL-User-Name}' \
<br> ORDER BY id"<br><br>Also, accounting queries are also the same. ???<br></div><div><br><br><br> </div></div><br>