Skip to content

Latest commit

 

History

History
88 lines (64 loc) · 2.12 KB

README.md

File metadata and controls

88 lines (64 loc) · 2.12 KB
Raw

mariadb && PhpMyAdmin

Start and configure mariadb instance.

The module uses :

docker.io/library/phpmyadmin 5.1.3 docker.io/library/mariadb 10.7.3

Install

Instantiate the module:

add-module ghcr.io/nethserver/mariadb:latest 1

The output of the command will return the instance name. Output example:

{'module_id': 'mariadb1', 'image_name': 'mariadb', 'image_url': 'ghcr.io/nethserver/mariadb:latest'}

Configure

Let's assume that the mariadb istance is named mariadb1.

Then launch configure-module, by setting the following parameters:

Example:

[root@fedora mariadb]# api-cli run configure-module --agent module/mariadb1 --data - <<EOF
{ 
"path": "/phpmyadmin", 
"http2https": true
}
EOF

The above command will:

  • validate the /webpath (if not already used by another application.)
  • start and configure the mariadb instance
  • retrieve two random ports, one for the phpmyadmin container the other for the external port to connect the mysql client

Uninstall

To uninstall the instance:

remove-module mariadb1 --no-preserve

retrieve configuration

You can retrieve the configuration like the user interface

api-cli run get-configuration --agent module/mariadb1 --data null
Warning: using user "cluster" credentials from the environment
{
"path": "/path", 
"http2https": true
}

Connect to mysl of the container

it is possible to use directly mysql inside the container

ssh mariadb1@localhost
podman exec -ti mariadb-app mysql

This is how to create a database and a user, think to allow the user to connect from any IP, else he will be refused by the mariadb container. The external port of mariadb is restricted to 127.0.0.1

# connect to mariadb1 (module_id)
ssh mariadb1@localhost
# connect to the mysql container as root
podman exec -ti mariadb-app mysql
# create the database and grant user to all from any IP (external port is restricted to 127.0.0.1)
MariaDB [(none)]> CREATE DATABASE IF NOT EXISTS mydatabase;
MariaDB [(none)]> grant all privileges on mydatabase.* to username identified by 'password';
MariaDB [(none)]> flush privileges;
MariaDB [(none)]> exit