• Categories
  • Recent
  • Tags
  • Popular
  • Users
  • Search
  • Register
  • Login
Netgate Discussion Forum
  • Categories
  • Recent
  • Tags
  • Popular
  • Users
  • Search
  • Register
  • Login

[HOWTO] Captive portal + FreeRADIUS + local MySQL user friendly single step

Captive Portal
47
154
104.1k
Loading More Posts
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • D
    Darlene
    last edited by Feb 13, 2018, 10:26 AM

    Please how do you edit those files you mentioned earlier

    1 Reply Last reply Reply Quote 0
    • G
      Gertjan
      last edited by Feb 13, 2018, 11:25 AM

      @Darlene:

      Please how do you edit those files you mentioned earlier

      Who is you ?
      What file ?

      No "help me" PM's please. Use the forum, the community will thank you.
      Edit : and where are the logs ??

      1 Reply Last reply Reply Quote 0
      • P
        pama
        last edited by Feb 15, 2018, 7:30 AM

        Please help, I am not able to install mysql…how can you get it working? Thank you

        1 Reply Last reply Reply Quote 0
        • C
          caraffandee @srvrgt
          last edited by Jun 27, 2018, 12:10 PM

          @srvrgt said in [HOWTO] Captive portal + FreeRADIUS + local MySQL user friendly single step:

          FOLLOWUP, in case anyone is hitting the same problem as me, the problem is with freeradius3, so first of all you need to change the attribute type on the file ozy-captive :
          From :    “INTO radcheck (username, attribute, value) VALUES (?, ‘Password’, ?)”)) "
          TO:  INTO radcheck (username, attribute, value) VALUES (?, ‘Cleartext-Password’, ?)"))
          And then you need to change the file    Schema.sql  BEFORE you add it to the radius database
          FROM:
          CREATE TABLE radcheck (
            id int(11) unsigned NOT NULL auto_increment,
            username varchar(64) NOT NULL default ‘’,
            attribute varchar(64)  NOT NULL default ‘’,
            op char(2) NOT NULL DEFAULT ‘==’,
            value varchar(253) NOT NULL default ‘’,
            PRIMARY KEY  (id),
            KEY username (username(32))
          ) ;
          TO:
          CREATE TABLE radcheck (
            id int(11) unsigned NOT NULL auto_increment,
            username varchar(64) NOT NULL default ‘’,
            attribute varchar(64)  NOT NULL default ‘’,
            op char(2) NOT NULL DEFAULT ‘:=’,
            value varchar(253) NOT NULL default ‘’,
            PRIMARY KEY  (id),
            KEY username (username(32))
          ) ;
          I hope this helps anyone  My problem was with pfsense 2.3.4  FRERADIUS 3

          Hi, @deajan, hi @rudat . I can confirm @srvrgt post. I've used the base work to setup a small captive portal in a hotel. Everything used to worked great until I upgraded to the latest version of pfSense/OzyCaptive-single-step. It stopped working. After modifying the table structure as per srvrgt advice, everything works flawlessly again.
          I think you should update your code in the project repo, specifying that your latest version requires pfSense 2.4.3/freeradius3.
          Thanks everybody for the outstanding work!

          P.S.: Does anyone know a simple way to limit bandwidth on per-user basis? (something like this -obviously fictional -

          INSERT INTO radcheck (id, username, attribute, op, value) VALUES (NULL, ‘Eleonor’, ‘Max-Input-Bandwidth’, ‘<=’, ‘5242880’);
          
          1 Reply Last reply Reply Quote 0
          • O
            OKODA @deajan
            last edited by Aug 22, 2018, 6:08 PM

            This post is deleted!
            1 Reply Last reply Reply Quote 0
            • M
              Marcus Vinicius @mansoor.khan
              last edited by Aug 1, 2019, 3:17 PM

              @mansoor-khan Hi mansoor!!! i setted up everything in captive portal + FreeRADIUS + mariadb (mysql) but I got the same problem trying log on Captive portal page, and mysql reports me (Access-Reject) too after type mail and name on the box.

              Did you or someone got this problem already solved?

              Thank you Guys

              1 Reply Last reply Reply Quote 0
              • N
                Nova9
                last edited by Nova9 Aug 19, 2019, 2:47 PM Aug 16, 2019, 11:22 AM

                [removed]

                F 1 Reply Last reply Aug 16, 2019, 11:39 AM Reply Quote 0
                • F
                  free4 Rebel Alliance @Nova9
                  last edited by Aug 16, 2019, 11:39 AM

                  @Nova9 php 5.6 is outdated and full of vulnerabilities on pfsense

                  pfsense is now running php 7...

                  as for your CSS ...this is a pfSense forum, not HTML one :'( we could try to help you debugging your page, but we need the associated HTML to help you

                  N 1 Reply Last reply Aug 16, 2019, 12:30 PM Reply Quote 0
                  • N
                    Nova9 @free4
                    last edited by Nova9 Aug 19, 2019, 2:47 PM Aug 16, 2019, 12:30 PM

                    [removed]

                    G 1 Reply Last reply Aug 16, 2019, 2:09 PM Reply Quote 0
                    • G
                      Gertjan @Nova9
                      last edited by Aug 16, 2019, 2:09 PM

                      @Nova9 said in [HOWTO] Captive portal + FreeRADIUS + local MySQL user friendly single step:

                      Maybe the .js files aren't loading properly?

                      Use the right button of your mouse.
                      Every browser will give you the possibility to see the 'html source of the web page.
                      You'll be seeing in a split second if resource files like css and js files are not load, most of the time because they have another file on the system name.

                      Btw : The subject "Captive portal + FreeRADIUS + local MySQL user friendly single step:" is a rather big project.
                      Nothing something that can be pulled of 'ASAP'.
                      Using an old pfSense version gives you a new feature : you created a security time bomb.

                      No "help me" PM's please. Use the forum, the community will thank you.
                      Edit : and where are the logs ??

                      1 Reply Last reply Reply Quote 0
                      • J Joseguadalupe referenced this topic on Apr 5, 2022, 8:42 PM
                      • J Joseguadalupe referenced this topic on Apr 5, 2022, 8:42 PM
                      • N ngpfpeter referenced this topic on Dec 18, 2023, 8:29 PM
                      • G Gertjan referenced this topic on Dec 19, 2023, 7:53 AM
                      • D Dmc referenced this topic on Feb 22, 2025, 12:27 PM
                      • D Dmc referenced this topic on Mar 20, 2025, 3:40 PM
                      • First post
                        Last post
                      Copyright 2025 Rubicon Communications LLC (Netgate). All rights reserved.