Looks for someone with Linux and networking skills to setup a Raspberry PI as a secure access point with a capture portal that outputs the data to an accessible location.
I would like to use free open source products to do this and ive seen coovachilli + freeradius + captive portal + MYSQL should do what i'm looking for however open to options. Where possible the GUI should be accessible to make changes.
Access Point i need the pi to act as a wireless access point for guests (SSID: Guest Wifi)
Radis is needed to sure the guest wifi traffic is separated and secured and this needs to be configured to work with the 192.168.0.xx range. Gateway 192.168.0.1, The PI IP should be set statically to 192.168.0.250. - The pi will be connected via ethernet cable and an external wireless card is used to present the traffic for the guests.
MYSQL needs to be quarabled for the data captured with an automatic Excel file being sent or stored in an accessible location. This can also be used for the DBs needed as pre requisites for the other tools.
Capture Portal - Needs the ability to have free access to the internet with a token that lasts 1 day but requires information to be captured. I'd like this also to be accessible in multiple languages, specifically English and Spanish.
New Users First Name (Field Mandatory) Last Name (Field Mandatory) Email (Field Mandatory) Date Of Birth (Field Optional) I Accept the Terms and Conditions - Link to Terms page (Tick Box - Required Field) I consent to be contacted from time to time by the the establishment and their partners for promotions and other marketing purposes - Link to Privacy Policy (Field Optional - However in database i need to record if consent has been received or not) -
Existing users
Username (Email Address) Password I Accept the Terms and Conditions - Link to Terms page (Tick Box - Required Field) Link to privacy policy
Access to the PI for configuration will be provide by remote desktop tool such as Team viewer to my laptop and an SSH terminal in to the PI to complete the work.
Work is complete once I have successfully tested the functionality on phone / Laptop (Edge, Explorer, Chrome) / Mac.