podmand/dbgate

By podmand

Updated 11 months ago

DO NOT USE - NOT IN SHAPE -- DBgate database administation tool

Databases & Storage
0

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 Command

docker pull podmand/dbgate