How to solve Simultaneous-Use issue on portable hotspot using CoovaChilli, FreeRadius, and HostAPD

2017-04-30 05:38:04

Issue: There should be no simultaneous logins per single account/username.

For those who successfully setup their portable hotspot on Raspberry Pi using CoovaChilli, FreeRadius, and HostAPD, how did you solved this issue?

Already did the following but to no avail.

Created an account on 'radcheck' table at radius db with the following values:

testuser Cleartext-Password := 12345678

testuser Max-Daily-Session := 600

testuser Simultaneous-Use := 1

Included the 'sql' parameter on 'session' handle at:

/etc/freeradius/sites-enabled/default used for checking Simultaneous use.

session {

sql

}

Un-commented the 'Simutaneous Use Checking Queries' on:

/etc/freeradius/sql/mysql/dialup.conf

Using the settings above, I can still login simultaneously on my laptop and 2 smartphones.

Only 1 login should be accepted.

Any tried and tested solution is greatly appreciated.

Platform: Raspberry Pi 2 Model B

OS: Raspbian with PIXEL

CoovaChilli: 1.3.0

FreeRadius: 2.2.5

Host