root@labs-wachid:/home/masadminx# docker ps
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
af74a2c6af43 mariadb:10.7 "docker-entrypoint.s…" 4 weeks ago Up 4 weeks 3306/tcp mariadb-glpi
64c158e92f22 diouxx/glpi "/opt/glpi-start.sh" 4 weeks ago Up 4 weeks 80/tcp, 443/tcp glpi
e1f6e878c896 jc21/nginx-proxy-manager:latest "/init" 4 weeks ago Up 4 weeks 0.0.0.0:80->80/tcp, :::80->80/tcp, 0.0.0.0:443->443/tcp, :::443->443/tcp, 81/tcp nginx-lb-app-1
c56c103b1544 jc21/mariadb-aria:latest "/scripts/run.sh" 4 weeks ago Up 7 seconds 3306/tcp nginx-lb-db-1
root@labs-wachid:/home/masadminx# docker restart nginx-lb-app-1
nginx-lb-app-1
root@labs-wachid:/home/masadminx# docker exec -it nginx-lb-db-1 sh
/ # mariadb -u root -p
Enter password:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 4
Server version: 10.11.5-MariaDB Alpine Linux
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]> use npm;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
MariaDB [npm]> UPDATE user SET is_deleted=1;
Query OK, 2 rows affected (0.010 sec)
Rows matched: 2 Changed: 2 Warnings: 0
MariaDB [npm]> exit
Bye
/ # exit
root@labs-wachid:/home/masadminx# docker restart nginx-lb-app-1
nginx-lb-app-1
root@labs-wachid:/home/masadminx#
root@labs-wachid:/home/masadminx# docker exec -it nginx-lb-db-1 sh
/ # mariadb -u root -p
Enter password:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 6
Server version: 10.11.5-MariaDB Alpine Linux
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]> use npm;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
MariaDB [npm]> UPDATE user SET is_deleted=0;
Query OK, 2 rows affected (0.029 sec)
Rows matched: 3 Changed: 2 Warnings: 0
MariaDB [npm]>
