To make that has a DB, where at every login, it checks if the user and password are entered in the DB, it is mandatory to use a server with FreeRADIUS?
Or I can do it via PHP + myphpadmin (MySql) ??

http://{$hotspot}/login?username={$username}&password={$password}

Thanks for your quick reply. I can easily make that the login involves the control of the correct data on a mysql database ?

To make that has a DB, where at every login, it checks if the user and password are entered in the DB, it is mandatory to use a server with FreeRADIUS?
Or I can do it via PHP + myphpadmin (MySql) ??

Using FreeRADIUS (or simply any RADIUS server...FreeRADIUS being one that conveniently enough uses a MySQL database) is the best option, yes.

The alternative way is using the API protocol*...

With that approach, you'd authenticate the usual way, and on success, over the API protocol, connect to RouterOS, create a temporary (random) hotspot account, and then redirect to

Code: Select all

http://{$hotspot}/login?username={$username}&password={$password}

(ideally, you'd want to modify the hotspot to redirect back to the server on both success and failure, but that's optional)
On logout (via a logout script), remove the user.
That second approach is the only way if you need to authenticate against 3rd parties (e.g. facebook, google).

Ok, is it the best approach?

Is it possibile to connect with my Freeradius Server with PEAR2_Net_RouterOS API?

How I can store accounting requests in freeradius database of hotspot users, please?