Downloads
The PhloMetric Gateway POSTs readings to a small Windows ingest service that writes them into a local MySQL database. You need three things on the PC that will host the database: the ingest service installer, the MySQL schema script that sets up its database and login, and the 32-bit MySQL Unicode ODBC driver it talks to MySQL through.
Follow the setup checklist below in order: install MySQL, run the schema script, install the 32-bit ODBC driver, then the ingest service. Windows is the only supported host for the ingest service today.
PhloMetric Water Ingest Service
Windows service that listens on TCP 41290 for batched JSON from the Gateway and writes clients, readings, and events into your phoa_water MySQL database. Installs as an auto-start service, adds its own firewall rule, and prompts once for your MySQL connection details.
MySQL schema script
A single SQL script that creates the phoa_water database, the three tables the ingest service writes (clients, readings, events), and the application account the service logs in with. Run it once against your MySQL 8 server, as an administrator (e.g. root), before installing the ingest service:
mysql -u root -p < schema_phoa_water.sql
MySQL Connector/ODBC 8.0 (32-bit)
The ingest service connects to MySQL through ODBC. It expects the driver registered as MySQL ODBC 8.0 Unicode Driver in the 32-bit ODBC view. Install this before the ingest service. After installing, you can confirm the driver appears under the Drivers tab of C:\Windows\SysWOW64\odbcad32.exe (the 32-bit ODBC Data Source Administrator).
Node User Manual (PDF)
End-user manual for the PhloMetric Water Meter Node, firmware 2.13.0: first connection and WiFi setup, picking your default meter, the dashboard, the privacy model and debug mode, the device passwords, email reports, working with a Gateway, firmware updates, the HTTP API, and troubleshooting.
Gateway User Manual (PDF)
End-user manual for the PhloMetric Water Gateway, firmware 0.1.58: first connection, the client roster (including forgetting retired nodes), managing Nodes over the mesh (queries, protocol and default-meter changes, reboot), recording to the database via the ingest service, the consolidated By-Node email report, the device passwords, firmware updates, the HTTP API, and troubleshooting.
Setup checklist
On the PC that will host the database (the same machine the Gateway uploads to):
- Install MySQL Server 8 if it isn't already present.
- Run the schema script as an administrator:
mysql -u root -p < schema_phoa_water.sql. This creates thephoa_waterdatabase, its tables, and thephoa_waterlogin. - Run
mysql-connector-odbc-8.0.30-win32.msiand complete the default install. - Run
phoa_ingest_setup.exeas Administrator. The MySQL user (phoa_water), password, database (phoa_water), and bind port (41290) are pre-filled to match the schema script, so you can accept the defaults. - In the Gateway's
/setuppage, set the Database Host to this PC's LAN IP and port 41290, and enable Record to Database. - Confirm readings are landing: the service log lives at
C:\ProgramData\PHOA\IngestService\service.log, andhttp://localhost:41290/api/healthreturns{"ok":true}.
Verify each download against the SHA-256 above before running it. In PowerShell: Get-FileHash .\phoa_ingest_setup.exe -Algorithm SHA256.
Where this fits
The ingest service is the last hop in the chain: meter → Node → Gateway → ingest service → MySQL. If you're running a single standalone Node with no Gateway, you don't need any of this; the Node keeps its own readings and emails them directly. The ingest service only matters when a Gateway is archiving a whole site's readings to a central database.
API documentation
Both devices expose a small HTTP API on port 80 of their LAN IP. The full endpoint reference lives on each device page; machine-readable specs are linked below for scripting and agents.