Thanks for your reply,  I design captive portal + freeradius + mysql to create the self register for customer's wifi system via device mac address, I have the separate internet connection so I dont use the firewall function on pfsense because outside pfsense I had already firewall.

The sqlite3 tool is a command line tool that is usable via ssh / console. I don't have time to further explain the radius setup, and it is already well discussed in the forum, maybe you should seek some help from professionnal help.

Thanks "muswellhillbilly" for replying i can set timeout but i couldn't set download limit …

i am also interested dear :) :)

Thanks for the info, but as of my understandings today coDel is implemented but FairQueue CoDel is not, so fair bandwidth share won't happen. Am I getting this wrong ?

… good point. I guess I should have reworded my question to "how can I use Mongodb and Nodejs". p.s. I appreciate your belief in my capabilities :D

yes im using radius but i dont know how to do this. i dont know where to get the active users.

Maybe this might help: http://mgyinngetay.blogspot.co.uk/2014/04/how-to-configure-pfsense-captive-portal.html

How long is your : Default DHCP lease time ? Max DHCP lease time ? concerning your interfaces interfaces ? You are using a captive portal on LAN and OPT1 ? Btw : Captive portal users are 'DISCONNECTED' by the function captiveportal_prune_old() (/etc/inc/captiveportal.inc) Note : a "idletimeout" of 7200 minutes should NEVER log you out (= DISCONNECT). Today, every device does communicate all the time. For example, update checks are running all the time. A basic Windows system will sue the Internet - if a connection is available - all the time. This means that the activity indicator (see Status -> Captive portal - and hit the "Show last Activity" button) will be set to a recent time all the time. A period of 5 days of NO activity at all is impossible. This means that's something is very wrong …. note2 : Did you checked "Status -> Captive portal - (and hit the "Show last Activity" button)" ? The Colum "Last activity" stays on recent times ?

@Artemiy: https://google.com or https://facebook.com Publish the golden rule for your visitors : never ever use a https site when you are connecting to a unknown (== captive portal) network. Users want a protected one-to-one connection, that is understandable. But you are using the captive portal - so users will be redirected from the site they want to visit, to the site where they have to authenticate first (pFsense). This is against de 'https' rules See it this way : Firefox is right. Users ARE warned that they didn't land on their https … This is another way to protect a users from a "man in de middle attack" - this time its clearly shown by the navigator. If I was visiting https://my-bank-site.tld and another site sghows up instead (even emulating my banks site very well) and my navigator still accepts the connection, I would DITCH these browser.

This is solved. The solution was to segment a DHCP pool that is restricted to a mac vendor (first six). Then set that IP pool to bypass on the captive portal page.

Read and check this https://doc.pfsense.org/index.php/Captive_Portal_Troubleshooting Is the nginx running on the portal interface ? Use SSH acces and : ps ax | grep 'nginx' sockstat -4l | grep 'nginx' Btw : being able to access the portal on the WAN NIC ….. well, something is very wrong.

;D Nice !!!

Thank you, Skron.  That works perfectly.  :)

Hi sir sorry for the late reply. Our problem is that we need to have the list of users in an external database like mysql and in the database the usernames and password where placed there. What are the ways so we can achieved our goal sir? please help us and thank you for replying us.

I just realized that my big image's button does not redirect me anymore to the intranet site, but just on the "Invalid Credentials Specified" page, as when a wrong voucher/password is entered… There is any way to make both things works?? Inserting voucher code or username plus password = access to the internet Just clicking on the huge image's button= access to the intranet only(NO www) Solution:                 I just put my big button image as the "error's page" and now clicking to it i get redirected to my local host.

so as far as i see, there is no easy way to dynamically isolate clients until authorized, client isolation is possible, but dynamically is nearly impossible, i think ill get back to the standard AP WPA thing nd get over with it.  :(

Yes was depending from Mozilla FireFox, even if i have never been ask to save or use those credentials for those 2 fields, it kept putting them there even after having been erased and saved (without  asking, that's weird). Using Google's Chrome fixed the issue, as those 2 fields would come up blank, thanks! :)