• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
MySQL database
#1
Hello,

I have installed MySQL docker image version 5.7 from (https://hub.docker.com/r/mysql/mysql-server) on netPI RTE, I have created container . But container continuously restarting, in MySQL container logs showing (standard_init_linux.go:211: exec user process caused "exec format error") attached screenshot.

Thanks in advance.

Br,
Devendra


Attached Files Thumbnail(s)
   
  Reply
#2
Yes this is normal. The MySQL docker image that you are loading is made for x86/x64 CPU processors:

   

And netPI CPU is an ARM based processor. So loading the standard MySQL container will fail in any case.

Remark: by the way the message "standard_init_linux.go:211: exec user process caused "exec format error"" is nothing special specifically for this container only. It is reported by any container worldwide if the processor type does not match.

So in your case you need to load a container made for ARM processors: I found in this Hilscher forum the following thread https://forum.hilscher.com/thread-316.html from year 2018. In this thread there is a container referenced named https://hub.docker.com/r/hypriot/rpi-mysql/. Its landing page describes the parameter the container needs. Mainly I see just the environment variable
Code:
MYSQL_ROOT_PASSWORD=my-secret-pw
that needs to be set. So once you want to start this container on netPI just define this environment variable MYSQL_ROOT_PASSWORD with a password of your choice and let it run.

In my post https://forum.hilscher.com/thread-316.html I managed it to get to work successfully.  So you should be able to do the very same.

At the end I have a question related to MySQL in general: why do you need to use MySQL? What do you want to store in this database?

Thx
You never fail until you stop trying.“, Albert Einstein (1879 - 1955)

  Reply
#3
Hi Armin,

Happy new year!

One of our customer has requirement for data logging at different time interval.

There are multiple AB PLC ( Ethernet/IP ) into network & we have to log the data read from the PLC at different time interval. Data has to be stored on cloud/remote server plus customer has requirement of remote upload/download of PLC program .

Thanks & BR
MAdhumati
  Reply
#4
But then MySQL database is the wrong choice. You need a time series database influxdb instead.
You never fail until you stop trying.“, Albert Einstein (1879 - 1955)

  Reply
#5
The Influxdb coontainer supports ARM processor from the beginning and can be used on netPI right away. Here is the Docker homepage of Influxdb container: https://hub.docker.com/_/influxdb.

I have tested InfluxDB myself 1 year ago with version 1.7.8 successfully on netPI.

On netPI use the "add container" function with the following settings:


   name: influxdb
   image: influxdb:1.7.8
   restart: always
   network port mapping:
     - "host -> 8086: container -> 8086"
   networks:
     - bridge
   environment variables:
     - INFLUXDB_DB=db0
     - INFLUXDB_ADMIN_ENABLED=true
     - INFLUXDB_ADMIN_USER=admin
     - INFLUXDB_ADMIN_PASSWORD=12345678
     - INFLUXDB_USER=user
     - INFLUXDB_USER_PASSWORD=12345678


Of course you can change my dummy passwords with any other passwords you like.

After the successful deployment of this container you can test the influxdb container very easy using standard Node-RED and install influxdb read/write nodes additionally as documented here: https://flows.nodered.org/node/node-red-...b-influxdb.
You never fail until you stop trying.“, Albert Einstein (1879 - 1955)

  Reply
#6
Hello Armin,

Now I am able to perform complete InfluxDB in netPi RTE. Attached screenshot.

InfluxDB server install on my laptop. 

Thanks for your help.


Br,
Devendra


Attached Files Thumbnail(s)
   
  Reply
#7
Ok I see. But I understood that you customer wants to run database directly on netPI. In this case following this link https://forum.hilscher.com/thread-684.html and it show you how to install Node-RED, InfluxDB and visualization Grafana all in one on netPI.
You never fail until you stop trying.“, Albert Einstein (1879 - 1955)

  Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  [SOLVED] MySQL Container / Server in another Container? paubau 2 627 September-5th-2018, 08:00 AM
Last Post: paubau

Forum Jump:


Users browsing this thread: 1 Guest(s)