September-4th-2018, 03:17 PM
Hello Paul,
yes this is possible. And the idea to let it run in a separate container is also great.
I read the documentation of the MySQL server you are referencing at https://hub.docker.com/r/hypriot/rpi-mysql/. And I can agree that using this container will work.
But there are some things you need to take care about using netPI. The documentation declares everything based on using a command line as you have recognized. This is of course not possible with netPI. So the documentation says you have to define a password with the "-e MYSQL_ROOT_PASSWORD=my-secret-pw" command. This command can be replaced in netPI using the option "env" in the advanced container menu then using at least "MYSQL_ROOT_PASSWORD" as name and "your password" as value. But if you read on the documentation there are other env variables too you can set additionally.
Then of course you have to take care about the port 3306 that is used by this container. This port needs to be exposed when you start the container from port 3306 to port 3306 using the default network/bridge mode.
The documentation says also that another container that wants to access to this MySQL server needs to run the docker command "--link some-mysql:mysql". But as you can read it here https://docs.docker.com/network/links/ the "link" command shall not be used any more. This is why I would do it differently. I would give your container a "hostname" in the network setting dialog for example "paulmysql". Then this container within netPI will get of course an internal IP address but also a name that is constant you can address from other containers.
So from your container then you can use a python script like this:
#!/usr/bin/python
import MySQLdb
db = MySQLdb.connect(host="paulmysql", # your host, usually localhost
user="username", # your username
passwd="password", # your password
db="databasename") # name of the data base
...
Hope this helps.
yes this is possible. And the idea to let it run in a separate container is also great.
I read the documentation of the MySQL server you are referencing at https://hub.docker.com/r/hypriot/rpi-mysql/. And I can agree that using this container will work.
But there are some things you need to take care about using netPI. The documentation declares everything based on using a command line as you have recognized. This is of course not possible with netPI. So the documentation says you have to define a password with the "-e MYSQL_ROOT_PASSWORD=my-secret-pw" command. This command can be replaced in netPI using the option "env" in the advanced container menu then using at least "MYSQL_ROOT_PASSWORD" as name and "your password" as value. But if you read on the documentation there are other env variables too you can set additionally.
Then of course you have to take care about the port 3306 that is used by this container. This port needs to be exposed when you start the container from port 3306 to port 3306 using the default network/bridge mode.
The documentation says also that another container that wants to access to this MySQL server needs to run the docker command "--link some-mysql:mysql". But as you can read it here https://docs.docker.com/network/links/ the "link" command shall not be used any more. This is why I would do it differently. I would give your container a "hostname" in the network setting dialog for example "paulmysql". Then this container within netPI will get of course an internal IP address but also a name that is constant you can address from other containers.
So from your container then you can use a python script like this:
#!/usr/bin/python
import MySQLdb
db = MySQLdb.connect(host="paulmysql", # your host, usually localhost
user="username", # your username
passwd="password", # your password
db="databasename") # name of the data base
...
Hope this helps.
„You never fail until you stop trying.“, Albert Einstein (1879 - 1955)
