Postgress sql error while running nework server using docker-compose file

Ramu_Devarashetti · February 6, 2020, 6:58am

HI,

I have cloned network server source from https://github.com/brocaar/chirpstack-network-server.git and used docker for building, docker-compose build pull and up +. I am getting this error chirpstack-network-server_1 | time=“2020-02-06T06:53:23Z” level=warning msg=“storage: ping PostgreSQL database error, will retry in 2s” error=“dial tcp 127.0.0.1:5432: connect: connection refused” while running the container (docker-compose up). Help Needed

eugenev · February 6, 2020, 7:09am

is the postgresql running in the same docker ?
check your postgresql is up and listening on port 5432.

Ramu_Devarashetti · February 6, 2020, 7:13am

Yes it is running and I can see the logs also

brocaar · February 6, 2020, 10:15am

This docker-compose.yml file is only for development and testing, not to run the NS. Please use: https://github.com/brocaar/chirpstack-docker/

Ramu_Devarashetti · February 7, 2020, 5:18am

Hi @brocaar, I understand but my primary goal is to check when and how(SF, Tx power) the ADR algorithm triggers, If I can see the logs from n/w server container when ADR triggers it is fine for me or else I need to keep some extra logs(basically fmt.Println(“Triggered for so on so parameters”)) when optimal parameters it found, for this I thought of modifying adr.go. BTW I am very new to LoRaWan and Lora.
Thanks

brocaar · February 7, 2020, 7:35am

This kind of testing I’m usually doing outside Docker containers. Especially when you want to test modifications to multiple components I find it easier to not use Docker. On my machine I have all dependencies (PostgreSQL, Redis, Mosquitto) and then I run the services I need.

In order to set this up, you can follow the Debian / Ubuntu tutorial, without the “apt-get …” steps. Then compile your own binaries and start these from the cli

You can do it using docker-compose, but you would need to make modifications to make this working. This is not something that is supported in the compose files that I’m providing.

brocaar · February 13, 2020, 11:23am

You could use the API for this

Ramu_Devarashetti · February 13, 2020, 11:48am

@brocaar, can you provide me the links for reference if any? Thanks.

Ramu_Devarashetti · February 25, 2020, 8:03am

Hi @brocaar, Can you tell me how ADR algorithm determine optimal values, Is it depends on distance or Number of Uplinks or Both,
In my case I have observed like if the distance is fixed also, when Uplinks are increasing ADR is triggering multiple times. Ex from S.F 12-11-8 to 7 with in ~30 Uplinks. What are the number of Uplinks required to analyse optimal values ?? #networkServer