Weather Station Hardware > WiFiLogger/Meteo-Pi

WifiLogger to InfluxDB

(1/2) > >>

fjordey37:
Has anyone had any experience in getting data from WifiLogger into an InfluxDB database...

I'm not coder, so writing any code is out of my league, with that said I'm good at following directions...

I do see the options for custom export, so my guess is there should be a way to have WifiLogger send that information to InfluxDB.

PaulMy:
Hi,
I have been updating the WiFiLogger realtime.txt and wflexp.json to my remote site once a minute.
http://www.komokaweather.com/wifi-console/realtime.txt
http://www.komokaweather.com/wifi-console/wflexp.json


I am not familiar with InfluxDB but I did have a script from another forum member that then imported the realtime.txt data into my GoDaddy MySQL DB every minute and that did work until I updated my GoDaddy hosting to cPanel and I haven't learned how to fix the script ](*,)






Enjoy,
Paul

fjordey37:
I feel you Paul... I'm trying to watch videos on the and trying to craft something that will work... It just seems I'm going in circles... and kinda getting dizzy now...

my case is local NAS using docker containers, so in theory it should be simple. I'm sure I'm over thinking the process.

My thought is to have WifiLogger POST (json) to a database -  in theory  WifiLogger >>> Telegraf >>>> InfluxDB  >>> and Grafana (or similar to graph data)...
anyone with thoughts on this process please share...

Mark

fjordey37:
Status update:  the direction I seem to be heading now it to send data to a MQTT broker and using telegraf send to InfluxDB...

I have the MQTT broker setup and receiving data from WifiLogger - and I can see telegraf connecting with the MQTT broker...
Yet I can not get any data into InfluxDB...

WifiLogger >>> mosquito (mqtt broker) >>> telegraf >>>> InfluxDB 

This is all running on an Unpaid NAS server - using docker containers for each piece of this... this needs to be kept this local...
I was able to get the raw output of the WifiLogger json file by reading through a thread from back in Jan 2020 "how to setup custom HTTP export"

I'm not sure if "only" the json can be sent, currently WL sends both the realtime.txt and json files together... I also not sure how the PHP&MySQL file structure is (binary/txt)... not sure if there is a way to view that in raw format like the json file...

-Mark

WiFiLogger:

--- Quote from: fjordey37 on March 29, 2022, 06:11:34 PM ---Has anyone had any experience in getting data from WifiLogger into an InfluxDB database...

I'm not coder, so writing any code is out of my league, with that said I'm good at following directions...

I do see the options for custom export, so my guess is there should be a way to have WifiLogger send that information to InfluxDB.

--- End quote ---

As a first step please check my solution PHP&MySQL.
http://wifilogger.net/wflsql/

Please try it. You can have all of those PHPs for free.

 [ You are not allowed to view attachments ]
 [ You are not allowed to view attachments ]

Navigation

[0] Message Index

[#] Next page