Menginstall SQLite untuk dapat memanage database SQLite
sudo apt install sqlite3 -y
root@DNS-DEV:/monitoring-data/nginx-proxy/data# apt install sqlite3 Reading package lists... Done Building dependency tree... Done Reading state information... Done The following packages were automatically installed and are no longer required: dns-root-data dnsmasq-base libbluetooth3 libgudev-1.0-0 libjim0.79 libmbim-glib4 libmbim-proxy libmm-glib0 libndp0 libnl-3-200 libnl-genl-3-200 libnl-route-3-200 libnm0 libpcsclite1 libqmi-glib5 libqmi-proxy libteamdctl0 libusb-1.0-0 modemmanager network-manager usb-modeswitch usb-modeswitch-data wireless-regdb wpasupplicant Use 'sudo apt autoremove' to remove them. Suggested packages: sqlite3-doc The following NEW packages will be installed: sqlite3 0 upgraded, 1 newly installed, 0 to remove and 0 not upgraded. Need to get 1201 kB of archives. After this operation, 3155 kB of additional disk space will be used. Get:1 http://deb.debian.org/debian bullseye/main amd64 sqlite3 amd64 3.34.1-3 [1201 kB] Fetched 1201 kB in 1s (985 kB/s) Selecting previously unselected package sqlite3. (Reading database ... 59578 files and directories currently installed.) Preparing to unpack .../sqlite3_3.34.1-3_amd64.deb ... Unpacking sqlite3 (3.34.1-3) ... Setting up sqlite3 (3.34.1-3) ... Processing triggers for man-db (2.9.4-2) ... Scanning processes... Scanning candidates... Scanning linux images... Restarting services... systemctl restart ipsec.service Failed to restart ipsec.service: Unit ipsec.service is masked. Service restarts being deferred: systemctl restart NetworkManager.service /etc/needrestart/restart.d/dbus.service systemctl restart [email protected] systemctl restart systemd-logind.service systemctl restart unattended-upgrades.service systemctl restart wpa_supplicant.service No containers need to be restarted. User sessions running outdated binaries: root @ user manager service: systemd[8311] root@DNS-DEV:/monitoring-data/nginx-proxy/data#
Buka database SQLite dengan perintah berikut:
# sqlite3 database.sqlite
Jalankan perintah update user untuk menset data is_delete = 1
sqlite> UPDATE user SET is_deleted=1; sqlite> .exit
Kemudian Restart docker Nginx Proxy Manager
docker restart [id_container]
root@DNS-DEV:/monitoring-data/nginx-proxy/data# docker restart 75664ac037cc 75664ac037cc
Kemudian login ke nginx proxy manager menggunakan username dan password default, yaitu :
[email protected] / changeme
Kemudian ganti password user admin yang ingin di reset
Update kembali databasenya
root@DNS-DEV:/monitoring-data/nginx-proxy/data# sqlite3 database.sqlite SQLite version 3.34.1 2021-01-20 14:10:07 Enter ".help" for usage hints. sqlite> UPDATE user SET is_deleted=0; sqlite> .exit root@DNS-DEV: