Automated mapping of AREDN Networks.

This is the new KG6WXC MeshMap device polling backend.
It is very much a work in progress, and is being actively worked on, but it does actually work.
Instructions have not been written yet, setup is very similar to the original meshmap.

You will not see a map webpage from this, it is only the part that populates the database and will output some java files for use with the webpage.
Webpage code is here:
https://github.com/r1de/KG6WXC-meshmap-webpage

• php
• php-mysql
• php-curl
• mariadb-server

If you want to run this, the MariaDB database will need to be setup before hand.

If you had the previous version of MeshMap, update the database from the new sql file:
sudo mysql -D node_map < meshmap_db_import.sql

For now, updates to the Database will be in the meshmap_db_update.sql file.
If you have been running this code and you have errors about things missing in the Database, please run the above command with the update file.
sudo mysql -D node_map < meshmap_db_update.sql
*note: this is NOT needed for a new setup.

If you were not running the previous version setup the SQL database like this and then run the above command to import the sql file:

sudo mysql
CREATE DATABASE node_map;
CREATE USER 'mesh-map'@'localhost' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES on node_map.* TO 'mesh-map'@'localhost';
FLUSH PRIVILEGES;

Copy settings/user-settings.ini-default to settings/user-settings.ini and edit for your site.

Manually run pollingScript.php --test-mode-with-sql to make sure everything is setup properly and you get no errors.

To run automatically use cron (this example will poll every 30 min):
*/30 * * * * /home/kg6wxc/KG6WXC-meshmap/pollingScript.php

SQLite is not fully working yet, don't try to use it.

Plz contact KG6WXC for help if you wish to help test this or have questions.

Any help is appreciated!

73 DE KG6WXC