Accessing Nextcloud database
-
One of the people on a nextcloud instance has a problem where the emails wont show in the dashboard. I found this fix here that I wanted to try but I need access to the Database.
Does anyone have any idea how I can access the phpmyadmin?
-
imho there is no phpmyadmin included in the package. As a workaround, install a LAMP app and wget https://github.com/vrana/adminer/releases/download/v4.8.1/adminer-4.8.1.php
In your nextcloud app, call the terminal and copy the postgres credentials into the adminer viaenv
. Voila: You see the nextcloud Postgres database in the LAMP app adminer interface.
The nerdish approach is to open the terminal inside your nc Cloudron app and click on postgres -
Given the fix to try is a simple one, you can click on the
PostgreSQL
button as @luckow suggested and then press Enter. Then, just put inDELETE FORM oc_mail_accounts WHERE id=1
there.@girish The problem is I don't know which ID this one is and wanted to take a look at the database first
-
imho there is no phpmyadmin included in the package. As a workaround, install a LAMP app and wget https://github.com/vrana/adminer/releases/download/v4.8.1/adminer-4.8.1.php
In your nextcloud app, call the terminal and copy the postgres credentials into the adminer viaenv
. Voila: You see the nextcloud Postgres database in the LAMP app adminer interface.
The nerdish approach is to open the terminal inside your nc Cloudron app and click on postgres@luckow said in Accessing Nextcloud database:
imho there is no phpmyadmin included in the package. As a workaround, install a LAMP app and wget https://github.com/vrana/adminer/releases/download/v4.8.1/adminer-4.8.1.php
In your nextcloud app, call the terminal and copy the postgres credentials into the adminer viaenv
. Voila: You see the nextcloud Postgres database in the LAMP app adminer interface.
The nerdish approach is to open the terminal inside your nc Cloudron app and click on postgresThanks I'll try this approach
-
imho there is no phpmyadmin included in the package. As a workaround, install a LAMP app and wget https://github.com/vrana/adminer/releases/download/v4.8.1/adminer-4.8.1.php
In your nextcloud app, call the terminal and copy the postgres credentials into the adminer viaenv
. Voila: You see the nextcloud Postgres database in the LAMP app adminer interface.
The nerdish approach is to open the terminal inside your nc Cloudron app and click on postgres@luckow This was a great hack to find out the ID I needed. Deleting it fixed it, thank you!
-
B BrutalBirdie referenced this topic on