Username with spaces (MySQL)

Wilco Baan Hofman wilco at baanhofman.nl
Thu Apr 18 09:47:11 CEST 2013



On Wed, 2013-04-17 at 22:03 -0500, Andres Gomez Ruiz wrote:

> 
> So I have many users using the same username putting one, two,
> three, ...etc., spaces after the username.
> 
> 
> How can I solve this situation?
> May be with a SQL query that ignores the spaces in the username?
> (talking about the sql counters)
> 
Not really a RADIUS question, but this is default behaviour for MySQL.
Convert the VARCHAR Field to binary or use TRIM() for the counters.

Regards,

Wilco Baan Hofman





More information about the Freeradius-Users mailing list