Schema change advisable for MySQL in 2.2.x and 3.0.x

Alan DeKok aland at deployingradius.com
Thu Jan 9 14:33:38 CET 2014


Stefan Winter wrote:
> The MySQL schema defines the column for acctsessiontime as
> 
>   acctsessiontime int(12) default NULL,
> 
> which is a SIGNED integer, and for which the above number is an
> overflow. [1]
> 
> It would be much more useful to define the schema as
> 
>   acctsessiontime int(12) unsigned default NULL,
> 
> which would make the allowed ranges of the datatypes of RADIUS and MySQL
> schema be in sync.

  I've pushed a fix.

  Alan DeKok.


More information about the Freeradius-Devel mailing list