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

Alan DeKok aland at
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