Generating a voucher based on a database
-
IS it possible to configure Captive Portal to, instead of generating a voucher based on an algorithm, generate a voucher using an excel file or mySQL database? For example, generating a voucher for the guest of a specific hotel room, with the voucher consisting of the guest's name and the room number?
This information should be pulled from said database. -
No. The vouchers are generated mathematically based on a cryptographic algorithm.
You might be able to do what you want by rigging up something with RADIUS authentication pulled from a database like you want, but that's outside the scope of pfSense.