InfluxDB

[Robin]

@doodlemania2 I will try to do so if / when I can get the time to finish poking around, and verify that it actually works once I finish. I just had a child last week, so spare time is a bit hard to come by at present

[Robin]

Just brain-dumping from trial and error session...

For authentication, start without auth first. Then connect influx client, and run:

CREATE USER admin WITH PASSWORD 'foobar' WITH ALL PRIVILEGES;

Then, you can safely enable auth (set the config keys `http/auth-enabled, http/pprof-auth-enabled to true), and will need that user/pass to run any queries.

Not sure if there's an easier way or not... If there isn't, perhaps this could be done via start.sh somehow - detect that a given launch is the first one (if the db doesn't exist yet) - start it, create an admin user, then stop & restart with auth enabled.

[doodlemania2]

@robin So, I like your idea of using the native one better for authentication. Just don't have any experience with it. Would love if you could do a PR showing what you're trying to compare! Making a few other updates as well.

[Robin]

I haven't had a chance to look at authentication (or anything else, really) yet unfortunately. Life's been busy.

I did push up what I appear to be running, though, I haven't had a chance to test it independently (I am not using your repo directly, but a rather customised setup, so I copied my changes into it by hand).

You can see my fork here: https://github.com/rburchell/cloudron-influxdb

[ei8fdb]

Hi all,

Is this influxDB app in a state where I could start using it? Nothing critical, just t start learning about Grafana/InfluxDB usage. I want to start using these 2 apps for graphing temperature sensor data.

Thanks!

[doodlemania2]

@ei8fdb I've been using it for many months now - works like a champ.

[ei8fdb]

Thanks for letting me know @doodlemania2. I've tried to build it but am running into the following issue - "COPY failed: stat usr/bin/influxd: file does not exist" - which you can see here:

Step 1/10 : FROM influxdb:latest as final
 ---> a6cdd3eeabf3
Step 2/10 : FROM cloudron/base:2.0.0@sha256:f9fea80513aa7c92fe2e7bf3978b54c8ac5222f47a9a32a7f8833edf0eb5a4f4
 ---> afa4cfc125b4
Step 3/10 : COPY --from=final /usr/bin/influxd /app/code/influxd
COPY failed: stat usr/bin/influxd: file does not exist
child_process.js:669
    throw err;
    ^

Error: Command failed: docker build  -t ei8fdb/influxdb:20210405-095545-77686303f -f Dockerfile  /home/bernard/code/influxdb

Do you have any suggestions? I'm following this documentation. Thanks.

[BrutalBirdie]

@ei8fdb the error is what it reads usr/bin/influxd: file does not exist
The file or path does not exist.

https://git.cloudron.io/doodlemania2/influxdb/-/blob/master/Dockerfile

COPY --from=final /usr/bin/influxd /app/code/influxd
COPY --from=final /usr/bin/influx /app/code/influx

I assume @doodlemania2 has influxdb installed locally and that's why he used these paths to copy the binary files.
Also binary files have no place in git so it's kinda understandable.

You can download the files here https://docs.influxdata.com/influxdb/v2.0/get-started/?t=Linux

[doodlemania2]

@brutalbirdie yes that's right - i use a local copy of the influx binaries to manage the server running in cloudron. Thanks for picking this up - been out on vacation

[lukas]

How I can install this package in my Cloudron?

[girish]

Just wanted to put a warning out that databases are very different from webapps and need special care for backup and updates. I suspect Influx DB from it's name is a database and not just a web app. So, please be careful about installing a databases as an app on Cloudron.

[lukas]

@girish said in InfluxDB:

Just wanted to put a warning out that databases are very different from webapps and need special care for backup and updates. I suspect Influx DB from it's name is a database and not just a web app. So, please be careful about installing a databases as an app on Cloudron.

ok, so when do you plan to implement it into Cloudron?

[doodlemania2]

@girish agreed - it's a bit of a weird fit, but does work for my purposes. Note that the data files sit in /app/data so backups land well. Also, it is influxv1, not v2 that I packaged up - v2 was too hard lol.

[girish]

@doodlemania2 running a database is no issue. Issue comes when trying to restore and upgrade. When restoring, you have to be sure that the backup is atomic/consistent. It's basically backing up the raw files of a database and the restore may or may not work (On Cloudron, this is why we create "dumps" of the database and do not backup raw database files) . Also, in many databases, the files are not portable across db versions (for upgrades).

[doodlemania2]

Ah yes - 100% - and is definitely risky if you are ingesting a lot of data (the point of influx). For me, the two times I've restored (practice) were fine because I didn't end up with a transaction in the middle of the backup, so no corruptions. But absolutely possible.

[lukas]

@doodlemania2 said in InfluxDB:

Ah yes - 100% - and is definitely risky if you are ingesting a lot of data (the point of influx). For me, the two times I've restored (practice) were fine because I didn't end up with a transaction in the middle of the backup, so no corruptions. But absolutely possible.

Hey, can you please tell me, how I can install your InfluxDB package on my Cloudron Server ?

[doodlemania2]

@lukas just grab the bits from the git repo on the cloudron server and use the cli to install it

[lukas]

@doodlemania2 ok never dealed with it, then I try it. Thank you.