MariaDB and phpMyAdmin installation to Scale?

Apps and Virtualization
1

How do I install MariaDB and phpMyAdmin to Scale? Are there proper (beginner level) instructions for it? Do I have to install something else, i.e. Portainer/Dockge, before I can install those? I have used VMWare virtual machine for testing Scale but can’t figure out how to get MariaDB running.

I’d like to use MariaDB as Kodi’s external database, currently still using TrueNAS Core and have jails installation of MariaDB. Installation was done with instructions I found from net.

2

You can’t install anything at all on the OS itself. It’s all done with those apps or an layer bigger with virtualization.

3

I know I can’t install those directly to Scale. I was asking how to install those two as apps.

4

For mariadb look at https://hub.docker.com/_/mariadb and fill the fields accordingly

After clicking “Discover Apps” → “Custom”

Seems like you can’t just build one package as described but have to create two individual instances but it works even here om my qemu scale “take-a-look-at-it” installation.

image
image1477×506 130 KB

Thats all i configured

root@truenas ~ # midclt call app.query |jq '. [] | .name , .active_workloads.used_ports '
"mariadb"
[
  {
    "container_port": 3306,
    "protocol": "tcp",
    "host_ports": [
      {
        "host_port": 3306,
        "host_ip": "0.0.0.0"
      }
    ]
  }
]
"adminer"
[
  {
    "container_port": 8080,
    "protocol": "tcp",
    "host_ports": [
      {
        "host_port": 8080,
        "host_ip": "0.0.0.0"
      }
    ]
  }
]
root@truenas ~ #
1 Like
5

I can’t get MariaDB to work/start. It crashes right after start. So maybe something is missing from the settings… Adminer starts and seems to work.

edit: I missed setting environment variable for MARIADB_ROOT_PASSWORD. After adding that MariaDB starts.

6

Right, forgot about that but i couldn’t even create the instance w/o setting those and they were hilighted in red so i basically assumed that wouldn’t work w/o it.

7

I didn’t notice red hilights…
Since I got this working with VMWare test machine, I converted my real server from Core to Scale. Installed MariaDB and phpMyAdmin as apps and imported MariaDB database that I had exported from Core. MariaDB required /var/lib/mysql host path added for persistent data. No issues, Core-Scale conversion worked and everything works fine.