There is a configuration line in radiusd.conf: nospace_user = yes (default is no) that will remove trailing space even when entered. By the user. It doesn't help if the trailing space is in the database. Ivan Kalik Kalik Informatika ISP Dana 22/1/2008, "Marinko Tarlac" <mangia81@gmail.com> piše:
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. ???