Solved Accessing Nextcloud database

[andreasdueren]

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?

[luckow]

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 via env. 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

[girish]

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 in DELETE FORM oc_mail_accounts WHERE id=1 there.

[andreasdueren]

@girish The problem is I don't know which ID this one is and wanted to take a look at the database first

[andreasdueren]

@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 via env. 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

Thanks I'll try this approach

[andreasdueren]

@luckow This was a great hack to find out the ID I needed. Deleting it fixed it, thank you!