Hello, I modified the configuration file according to your example. As a result, the original system web IP 8080 port page could not be opened, and the modified part was deleted again. The port 8080 web page returned to normal. I do not know why. The original Loraserver system is 3.01, and other configurations of the POSTGRESQL database have been upgraded according to TEST3.1. But did not find postgresql integration. Only the previous http and influxdb integration options. The current 3.01 version is working fine.
Postgres integration works fine for me. I just recreated the configfile with
lora-app-server configfile > lora-app-server.toml
Afterwards I added postgresql to the enabled integrations, defined the database in the dns, created the necessary database and tables then restarted lora-app-server.
I was following these steps of the tutorial of this video https://www.youtube.com/watch?v=FnTP7t47DlI
and then I really do not know what version it is but I was configuring in lora-app-server what is the integration with postgresql and I made the changes as you said to me in this way:
also create a database with the same user as you had done with this name loraserver_as such as your code
create database lorastore with owner loraserver_as;
I do not know if you could help me more or less how I can integrate Lora with Postgresql since I am developing a project to measure the water consumption in homes since with influence the tables are created automatically but I do not all appear where and using two Lopy4 as nanogateway and node using abp mode
They should install the latest version which you can verify by typing:
lora-app-server version
I’m doing several Loraserver videos as well but truthfully you really need to read the documentation. I got this integration going within 5 minutes and you can as well.
It’s great that you’re measuring in home water consumption. I hope you get everything up and running smoothly with lopy4 and loraserver.
the part of the configuration with postgresql as it would be because I have reviewed the documentation itself and I have made all the changes and then I do not know what I am really failing I put the command version lora-app-server but it does not work since if I could enter postgresql and I created the tables according to how it says @ brocaar
The postgresql integration isn’t a per application level integration.
ALL of the lora related events will be logged to the postrgres database that you define in the lora-app-server.toml
If you followed the instructions appropriately your data is currently being written to your postgresql database. This is all happening in the background. Look at your database and you should see events being logged.
one more query, the moment to add the integration with postgresql it is possible to integrate it with grafana to visualize the data that arrive from the sensors, since I am using as an example the LM35 where the data arrive like:
Value: 12 ° C
since when integrating lora server with influxdb I was created automatically the tables and could make queries of two tables like:
device_frm_payload_data_temperature
device_uplink
I want to see more tables to be able to make queries, where I see that postgresql allows creating tables where I think we can visualize:
uplink
device status
join
ack
*error
*Location
I do not know if I’m wrong with that, they recommend me to integrate lora server with influxdb or with postgresql, since my work is based on measuring water consumption
then it is possible to integrate postgresql with grafana because in grafana there is a tab that says postgresql as influxdb but that is done automatically when choosing postgresql the values read by the sensors would pass to grafana when I choose postgresql or should do some command nose if you could help me with that ?