Problem setup Docker influxdb grafana nodered

[JF89]

Hello ,

i have problems to setup docker influxdb grafana.
i reset the 8212 with 2 reset buttons
i used Mr Braun menu to set up the programs

curl -L https://raw.githubusercontent.com/braunku/pfc-provisioning-tool/main/menu.sh -o menu.sh -s && sh menu.sh

it succeeded .all the files were loaded and unzipped

but when i want to access to docker it doesn’t work:

But for grafana and nodered it works, but not at all for grafana, I have the last login and password

So, the reset was not good at all.

for influxdb it doesn’t work

is it a problem of volume or a port not declared ?
It’s strange because it works for nodered:

Any idea ?

[JF89]

Perhaps it will help ?

[JF89]

@JF89

curl -L https://raw.githubusercontent.com/braunku/pfc-provisioning-tool/main/menu.sh -o menu.sh -s && sh menu.sh

[AdamReeve]

The “docker images” command is showing that you have successfully loaded the influx and grafana images to the system, but what “run” command syntax are you using? Does a “docker ps -a” command show active and running containers?

[JF89]

Hello Adam,
thanks for your reply.
a docker ps -a command shows that:

the influxdb container seems to be active:

but when i want to open it on a web browser , nothing happens

page not found

I followed the NT 0038 French application note, but there is in my opinion missing files.

the command above works properly,

i use docker exec -it c_influxdb influx command , and the result is:

but they say that in additionnal pages of the documentation there is a SQL script
to create a database with 3 users and differents “privileges” (rights)

and they says to copy the additionnal file and to stick it in a command line ssh

I think the exportinfludb.sql and exportgrafana.json files are missing.
Even when i create a database and i tell him to use mydb the command
docker exec -it c_influxdb influx doesn’t work

i submitted the problem to wago France but I stil haven’t an answer.

I tried with kurt Braun solutions with ssh menu , but i think ports number are missing for influxdb at least

So that’s why I use the wago community.

i you want I can send you the French tutorial

Thanks for your help

JF

[AdamReeve]

I noticed that the image being used is for InfluxDB 1.8.4. I think (although I’m not 100% certain) that InfluxDB 1.x does not have the web interface on port 8086 that InfluxDB 2.x has made available. That is why a browser connection isn’t bringing you to the login screen - I don’t think there is one!

So I think your InfluxDB container is working just fine. You can either use the docker exec command (like you show above) to enter the container and do commands like CREATE DATABASE <db_name>, SHOW DATABASES, USE <db_name>, etc. or you could use whatever tools are available in the program you will to interface with InfluxDB, like the WagoAppInfluxDB library, the Node-Red InfluxDB pallette, etc.

(One of your screenshots does seem to confirm it is working…you enter “use mydb” and the response back is “using database mydb”, which is correct.)

If you are trying to exactly replicate something in the app note from WAGO France, I think contacting them directly will be your best bet. I’m afraid I’ll have little insight into that and I’d have to Google Translate the entire thing.

[JF89]

Hello Adam,

thank you for your reply .

i tried to install influxdb version 2 linux container, but it failed.
the answer was: it’s not an arm32v7 platform or something like that.

So I don’t think influxdb version 2 can be setup on PFC 200 8212 FW26.

I’s a pity because you can’t use web browser port 8086 to commission your measurements tags and fields .
The only way is to use commands, that it’s not easy.

Have you got an other way to do it ?

Does influxdb version 3.0 will be available for wago PLC ?

[AdamReeve]

I agree - I tried to find a container of InfluxDB 2.x for arm32v7 and I was unsuccessful as well. I have only ever used version 2.x on an Edge Computer (amd64).

And sorry, I don’t know anything at all about InfluxDB 3.0. But I would guess that if 2.x can’t do arm32v7, 3.x won’t either.

When the PFC300 controller is released later this year, it will have 64-bit processor, so I am also guessing that arm64 containers will work on it.

[WagoDamRud]

Last version with arm7 support is influx:1.8, here is where you can check it in dockerhub.com ( influxdb Tags | Docker Hub)

Other versions are x64, so you have to use Edge Computer or PFC300.
Influx v1 doesn’t have any UI. To create dbs you can use Wago library or Time Series Admin

Inlux v2 has UI:

[JF89]

Hello,
So, you suggest PFC 300 that works with ubuntu. But I would like to try at first with a raspberry pi and a tutorial of Kurt Braun (arm7) .

Open Source Historian: Grafana & InfluxDB

I can setup the configuration until this error:

It’s the same as the tutorial but i think INFLUXD is a name of a server that should be declared before.

I don’t know how to declare that server: influx

What do you suggest ?

[JF89]

version 1.8 of influxdb has UI too:

[bjornidar]

If you need to export the config, I guess you’re using the wrong command, config should be print-config (?) then copy it “out of the container”.

If you’re trying to run Influx with a config file of your own, you’ll have to map it as a -v (volume) with the path to your config.

[WagoKurt]

If you are using Influx 1.8, they you can use Chronograf and access it with port 8888. V2, they are both in the same image.

docker run -d
–name chronograf
-p 8888:8888
-v chronograf-data:/var/lib/chronograf
chronograf:1.8

Though you might try network=host for both containers at first to get it working.

[JF89]

Hello M Braun,

yours unix commands works well to install chronograph 1.8
but i have to update influxdb 1.8 command :

I succeded to instal influxdb docker image, like this:

The influxdb.conf file was good as yours.

But , I have to update your command
sudo docker run -d -p 8086:8086 --name=influxdb --network=“wago” -v /home/art/influxdb.conf:/etc/influxdb/ , because it’s not the latest version , but 1.8
i tried several commands without success.
I’m just a plc wago programmer and doesn’t know unix commands.

Would you mind tell me how to update that command with 1.8?

[JF89]

I don’t understand why the command underlines below in green works , and the red doesn’t work

With the green underline on the screenshot below the container seems to be installed, but when lookink the container list , there is no !!

Have you got any idea ?

I don’t understand why chronograph can help me.

I’m just interested in by collecting datas with influxdb and to show them in grafana as the video tutorial shows.

[WagoDamRud]

hello,
this command is needed to create local config file. influxd is an entrypoint. So the InfluxDB container is called from image influxdb:1.8.4, and then influxd (its a daemon which starts and runs all the processes necessary for InfluxDB to function) is called with parameter config (which outputs default configuration and then > influxdb.conf redirects the output to a file.

When influxd finish his job the container stops - and here is why this docker command is called with --rm which ensures the container is automatically removed after execution.

This way you can have default configuration file for InfluxDB, edit it and then attach it as volume to docker run command.

[JF89]

Hello,
I succeded to install docker grafana and influxdb 1.8 with the help of a linux computer engeneer.

In a config file command I forgot a space before /config/

Thanks for your help DamRud, especially for the command `influxdb:1.8.4 that is mandatory otherwise it takes the latest version and doesn’t work

a grafana screenshot of the temperature supply of my heatpump taken from a modbus tcp request with nodered is enclosed

Now I need to learn grafana !

[JF89]

Hello

here are the line commands I used to install influxdb and grafana on a raspberry pi 3.0 B+ with several modifications

, it’s taken from a video tutorial . A computer unix engenner helped me.

I would like to update it to install on a sd card of PFC200 .

is-it possible ?

on Wago files of the PFC it’s not possible to see the os version, it seems to be a special "prempt’ version.

Line Commands I used to install influxdb and grafana on Raspberry PI

1 curl -sSL https://get.docker.com | sh  puis sudo reboot

2 sudo usermod -aG docker art

3 sudo docker network create -d bridge wago

4 sudo docker run -d -p 3000:3000 grafana/grafana

5 docker ps -a (xxxxx)

6 docker stop xxxxx

7 sudo docker rm xxxxx

8 sudo docker volume create grafana-storage

9 docker run -d -p 3000:3000 --network=“wago” --name=grafana -v grafana-storage:/var/lib/grafana grafana/grafana

10 sudo docker container ls

10 Sudo docker pull influxdb:1.8. 4

11 sudo docker run --rm influxdb :1.8.4 influxd config > influxdb.conf //influxd ou influxdb ???

sudo docker run --rm influxdb influxdb config | tee influxdb.conf (chat-gpt)

12 sudo nano influxdb.conf

13 docker images

14 sudo docker run -d -p 8086:8086 --name=influxdb --network=“wago” -v /home/art/influxdb.conf:/etc/influxdb/influxdb.conf:ro influxdb :1.8.4 -config /etc/influxdb/influxdb .conf

15 docker ps -a

16 curl http://192.168.140.9:8086/query --data-urlencode ‘q=CREATE DATABASE “mydb”’

17 curl -i -XPOST “http://192.168.140.9:8086/write?db=mydb&precision=s” --data-binary ‘myvar,mytag=1 value=1 1549412796’

18 curl -G ‘http://192.168.140.9:8086/query?db=mydb’ --data-urlencode ‘q=SELECT * FROM “myvar”’

Copy actual docker data root folder to sd card.

cp -r /home/docker /media/sd/

[wagoalex]

Hi there of course ypu can run it on a sd card.

1. Update to latest Firmware (currently FW31)
2. Activate Docker in Web Based Management(WBM)
3. change in /etc/docker/daemon.json docker root from /home/docker to “/docker/sd”
4. reboot
5. then use your docker commands