How to Captive Portal Self Registration Using Free radius & Mysql (Tutorial)

khan

if I manual enter in a user via insert in phpmyadmin into the reg_users . I also have have no access and the self registration web page flags that as an unknown user.. so it it can not read reg_user table for some reason either ..

actually "reg_users" table is not necessary for captive portal this table is for monitoring user registration with extra field & cheks mac based security. free radius checks only "radcheck" for user & password. you can manually enter there.

But it does not write anything into reg_user table upon completion of registration ( so it tells me i have no write capability or some sort un seen mysql error happening that prevents it from writing)

from your configuration i think you dont have permition to write in mysql database. this can be caused if you dont have permission to write in that folder/disk. or your mysql user privilege is not enough.

can u please send me your mysql server details.

my system is running with 20 registered user & increasing every day.

khan

@sash99

I have tested your config in vmware 9 environment with 2.0.2-RELEASE (i386). what i did
1. installed pfsense.
2. installed mysql & vhost according to your post.
3. installed php52-mysql as i mentioned before.
4. installed free radius2.
5. config them all
6. uploaded all the captive portal file.

but everything seems ok for me. i can register & data also available in database.

if u are interested i can upload the vmware image.

sorry to mention before….. i file (main css "bootrtrap.min.css") missing in my captiveportal file list, for which design was not perfect. added in this post.

can any moderator would be kind to attach this file in my main post please??

captiveportal-bootstrap.min.css.txt

sash99

sure I will try your vmware image. hopefully it run in my vm machine ( I am not using Vmware but usually not to much problem with different Vmdisk images from other programs )

khan

Sorry For my delayed reply. i have uploaded virtual image as open virtual format in Google drive. link

https://docs.google.com/file/d/0B7TKCwKoq_lNdDRmVERaT0ZaeU0/edit

first network adapter is WAN
2nd network adapter is LAN

webgui:

https://192.168.26.1:1337/index.php

username : admin
password: pfsense

phpmyadmin:

192.168.26.1:8001/phpmyadmin/

username: root
password: pfsense

best of luck. don forget to update ur result. let me know if face any error.

thenomad

I am on an VMWare exi5.1.0 server … fo some reason I cannot get either network interfaces in you vm to come up. It looks to be there but no traffic passes... any ideas??

khan

@thenomad:

I am on an VMWare exi5.1.0 server … fo some reason I cannot get either network interfaces in you vm to come up. It looks to be there but no traffic passes... any ideas??

what is your virtual network settings? i used wan bridged with my netbook wifi and lan as a host only network.l

thenomad

I fixed it I think… the interface mappings got flipped somehow ... thanks for your reply It got me in the right direction !

thenomad

Ok it IS working as advertised ;D

but I have one question (from a NON FreeBSD admin) What is the path for the portal php files does it just sit in /var/etc ??

thenomad

Well I THOUGHT it was working …
User cannot log in

error message from the portal

Your Email & Password Doesnot Match. If you Dont Have Any please Register

If you think This is an Error Of This System Please Contact Us.

This is right after the user creates himself through registration.
Peeking at the database the information (including the password is there)

BTW phpmyadmin is NOT installed as was indicated used webmin

If you attempt to re register it tells you that you already have a account under the username

message is : You are already registered. with <what ever="" the="" name="" user="" registered="" with="">Hellp :'(</what>

khan

@thenomad:

Well I THOUGHT it was working …
User cannot log in

error message from the portal

Your Email & Password Doesnot Match. If you Dont Have Any please Register

If you think This is an Error Of This System Please Contact Us.

This is right after the user creates himself through registration.
Peeking at the database the information (including the password is there)

What is your log in system in portal auth log?
anyway i just test it to selfregistration didnt checked full functionality. please adjust the shared secret in free radius nas & captive portal page.

BTW phpmyadmin is NOT installed as was indicated used webmin

of course i have installed phpmyadmin. after your comment i have dloaded from google drive and checked again.

If you attempt to re register it tells you that you already have a account under the username

message is : You are already registered. with<what ever="" the="" name="" user="" registered="" with=""></what>

i have designed this pages for a hotspot solution. so i add some mac based security, like a client with a mac can only register 1 account. if u want to create multiple account change ur mac address. or delete previous account from sqlserver via phpmyadmin

did Anybody got this tutorial helpful? bcos i have seen more then 10 download of my cp pages. only 2 of them replied.

sash99

HI khan..
tried your Vmware image. I can not get it work for me.. the virtualimage works and all but the root partion in not set at drive position 0 (ad0s1a) in pfsense but at the 3rd disk (ad3s1a). and your ovf is incompatible. i tried with a couple virtual machine always the same error non compliant ovf. even tried it in Vmplayer same difference…. and when I force it to boot ad0s1a ( with the mountroot> ufs:/dev/ad0s1a ) in other virtual machines. pfsense is all broken.. and/or vmware server just make it really incompatible with anything other then itself..

I even open it up in live boot BSD (frenzy) and edited as much as could but it still refuses to work for me

perhaps if you like to to make a vm appliance with virtualbox or simular

khan

@sash99:

perhaps if you like to to make a vm appliance with virtualbox or simular

ok i am creating a oracle virtual box image. need some time.

whoei

Thnx! I would like to test with a virtualbox image!

novicenaja

ไม่มีใช้กับ captive portal บ้างเหรอครับ ทำไมมีแต่ free radius

khan

Sorry for delayed reply.

I have uploaded file for virtual machine created with oracle virtual box. Double checked. rar file with recovery record.

https://docs.google.com/file/d/0B7TKCwKoq_lNYjJ3cE53T013Y28/edit

first network adapter is WAN (192.168.0.0/23 subnet) change as your requirement.
2nd network adapter is LAN (192.168.100.0/24 subnet)

Webgui:

http://192.168.100.1:1337

Username: admin
Password: pfsense

phpmyadmin:

http://192.168.100.1:8001/phpmyadmin/

Username: root
Password: pfsense

Captiveportal

http://192.168.100.1:8000

Mac based security is enable. so if u need multiple account from one mac please login to phpmyadmin change mac value in reg_user table first.

I am writing a step by step "how to ". but need some time.
anyway post your comment.

neewbie

yes and be running

whoei

I'm testing with the virtualbox image but I get exactly the same message as Thenomand:

_Your Email & Password Doesnot Match. If you Dont Have Any please Register

If you think This is an Error Of This System Please Contact Us._

This is also right after the user creates himself through registration.
Peeking at the database the information (including the password is there)

If you attempt to re register it tells you that you already have a account under the username

message is : You are already registered. with <what ever="" the="" name="" user="" registered="" with="">Anyone how to solve this?</what>

whoei

After replacing 127.0.0.1 for 192.168.100.1 @ radius settings by captive portal and nas /client en interface settings by FreeRadius it works!

Is there any solution that multiple users can register from one PC without changing the mac address in DirectAdmin?

harshkukreja

@khan:

@sash99

I have tested your config in vmware 9 environment with 2.0.2-RELEASE (i386). what i did
1. installed pfsense.
2. installed mysql & vhost according to your post.
3. installed php52-mysql as i mentioned before.
4. installed free radius2.
5. config them all
6. uploaded all the captive portal file.

but everything seems ok for me. i can register & data also available in database.

if u are interested i can upload the vmware image.

sorry to mention before….. i file (main css "bootrtrap.min.css") missing in my captiveportal file list, for which design was not perfect. added in this post.

can any moderator would be kind to attach this file in my main post please??

Hi! Please help us with the vmware image to test..Thanks Harsh

khan

@whoei:

After replacing 127.0.0.1 for 192.168.100.1 @ radius settings by captive portal and nas /client en interface settings by FreeRadius it works!

Is there any solution that multiple users can register from one PC without changing the mac address in DirectAdmin?

sure edit captiveportal-cp_reg_suc.php remove mac chek code.

Hi! Please help us with the vmware image to test..Thanks Harsh

ok need some time.