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