podmand/dbgate
DO NOT USE - NOT IN SHAPE -- DBgate database administation tool
2
Standard DBgate image with port 9998 instead of standard port 3000 (several applications are using port 3000 already)
A very usefull database administration tool which do not use any resources when idle (compared to pgadmin)
Supported databases: Microsoft SQL * MySQL * MariaDB * PostgreSQL * CockroachDB * Amazon Redshift * MongoDB * SQLite
Wants to know more - please visit develops website:
https://dbgate.org * Live demo on: https://demo.dbgate.org * Original source code : https://github.com/dbgate/dbgate/
================================ Example of how to use in a podman container pod
[name_of_pod] = name of pod (your fishbowl), where different containers are stored [podman_user] = name of user used for podman (login user for server)
How to create a pod podman pod create -n [name-of_pod] 9999:9998
Create requirred shares for storing data (your volumes) -- "Code block" can be run togehter - no neede fo doing line by line - just copy the complete block of code into a terminal and hit enter
sudo mkdir -p [path to volume share]/dbgate/data &&
sudo chown -R 1000:1000 [path to volume share]/dbgate &&
sudo chmod -R 777 [path to volume share]/dbgate
podman run -dt
--pod=[name_of_pod]
--name=dbgate
-v='[path to volume share]/dbgate/root/.dbgate'
-d docker.io/podmand/dbgate:latest
Ensuring container can start automatic and process not shut (not able to restart automatic)
podman generate systemd --files --new --name dbgate &&
sudo mv -v container-dbgate.service /home/[podman_user]/.config/systemd/user/ &&
sudo chown -R [podman_user]:[podman_user] /home/[podman_user]/.config/systemd/user/container-dbgate.service &&
chmod 444 -R /home/[podman_user]/.config/systemd/user/container-dbgate.service &&
sudo /sbin/restorecon -v /home/[podman_user]/.config/systemd/user/container-dbgate.service &&
systemctl --user daemon-reload &&
sudo loginctl enable-linger [podman_user] &&
systemctl --user enable container-dbgate.service &&
systemctl --user status container-dbgate.service
Dont forget to restart service / server / pod to ensure its restart automatic every time
Please enjoy
docker pull podmand/dbgate