Trying to install a database addon in iHost. Not getting it

eWeLink CUBE
1

Hello.
I am trying to install a database in the iHost to store sensors data. I have tried InfluxDB, Mysql, sqlite and nothing.
For example, I installed Influxdb addon, then I click Run, at first it is green Running, it should be working. Since the iHost does not have a command line like the raspberry, Influx has a web interface from where you can create the database, assign the username and password, etc., but when I open the IP with its corresponding port it does not load that interface, it returns error 404 It does not exist. However, with node red addon and ewelink addon, openning their corresponding ip+port in the browser, their web interfaces load and work perfectly.

I don’t know what to do because there is no documentation on the internet about how to install the addons on the iHost.
Does anyone control anything about this thing?

2

Make sure that the docker you are installing supports ARM V7, at least the latest influxdb does not currently - you will need to wait for the official release of the latest ARM V7 version

3

The name of the docker is arm32v7/influxdb. It´s the unique addon that installs, other addons fail to install, for example mysql, I was unable to install it.

The addon says “running” but I´m sure that some parameters are needed when installing it. The web interface fails too, so I´m doing something wrong.

influx1
influx1999×661 66.6 KB

influx2

4

what parameters you need to fill when install it ? In the advanced Settings we provide some parameters that you can fill in. But we don’t know what additional parameters do you need

and you can try change some config files via filebrowser

5

The version of influxdb that is armv7 compatible is version 1.x. This version does not come with UI.

You should use chronograf in another container to have the UI

6

Hi!

I would like to get a full (step-by-step) description, how to install a database addon in iHost.
This topic is incomplete. :slightly_frowning_face:

1 Like
7

Hey,

may I ask which DB you want to install and what’s the goal you wanna achieve?

8

Example mariadb and phpmyadmin.
(But it doesn’t matter.)

I would like store same simple statistics and switches states data.

9

The two are common db, won’t the official docker installation guide work on iHost?

10

I haven’t found a working guide yet.
The guides use terminal command line usually, but CLI doesn’t exists on iHost.

11

I have managed to get MariaDB installed successfully and am able to store data via Node Red.

Docker image: yobasystems/alpine-mariadb
port 3306:3306
volume: MariaDB:/var/lib/mysql (I first created my MariaDB volume)

After install, check the logs for the password that it generated for the root user:

2024-09-14T10:46:06 [i] MySQL root Password:xxxxxxx

To interact with MariaDB, i use HeidiSQL on my windows machine.
Using HeidiSQL, you can now connect and create a new DB and a dedicated node-red user.

Thereafter, install node-red-node-mysql and connect on the iHost IP and 3306 port.

4 Likes
12

This topic was automatically closed 12 hours after the last reply. New replies are no longer allowed.