Everything you need to make your own WifiDB instance is here (
https://github.com/acalcutt/WifiDB ). However the instructions are a little out of date (to non-existant).
The current version is meant to run on Microsoft SQL instead of MySQL. A lot of it will still work with MySQL, but it would need a lot of work to fix some of the changes I made to the import process to fix duplicates (the fix relies on the MS SQL Merge, which MySQL does not have)
For the Microsoft SQL version the instructions are basically.
1.) Set up a debian instance with apache and php
2.) Set up a Microsoft SQL Instance (The free sql developer version, windows or linux, will work fine)
3.) Create tools directory (ex. /opt/wdbtools/)
4.) Copy the /wifidb/tools folder from gitbub into the tools directory created in the previous step
5.) Copy the /wifidb/wifidb folder from github into your website root directory
6.) Create a blank mssql database(ex. prod_wifi) and import the 'blank_db.sqlsrv' file into it. (Note: Replace all instances of 'prod_wifi' in blank_db.sqlsrv with what you named your database)
7.) Create a mssql user that has access to the database created in the previous step
8.) Update your daemon config file, [tools]/daemon.config.inc.php
9.) Update your website config file, [webroot]wifidb/lib/config.inc.php
To Import Manually
cd [tools]/daemon
php importd.php -o -v
To Import by Cron Job
Schedule the .sh files in [tools]/cron
