sqlippool and MySQL/InnoDB: Useable for production?

Sebastian Inacker inacker.work at gmail.com
Fri Feb 14 09:34:50 CET 2014


Hello Alan.

On 13 February 2014 15:12, Alan DeKok <aland at deployingradius.com> wrote:
> > Is the module sqlippool useable for production if MySQL is used with
> > InnoDB tables?
>   Yes.

Good news. So the warning

   #  WARNING: MySQL has certain limitations that means it can
   #           hand out the same IP address to 2 different users.

in raddb/sqlippool.conf is obsolete if you follow the advice to use
MySQL with InnoDB, which can be found at the same place?

   #           We suggest using an SQL DB with proper transaction
   #           support, such as PostgreSQL, or using MySQL
   #           with InnoDB.

(Just for the record: raddb/sql/mysql/ippool.sql is useing "ENGINE=InnoDB".)

Thanks,
  Sebastian


More information about the Freeradius-Users mailing list