PHP My Admin or adminer or pgadmin

[ghost]

add function that the Nextcloud database can be opened from the Nextcloud AIO backend with PHP My Admin

[szaimen]

Hi, why do you need php my admin?

[ghost]

Nextcloud All in one is supposed to simplify the use and operation of Nextcloud for users and administrators. Right? As a Nextcloud administrator, I can say that it often happens that changes have to be made in the database (for example to remove inaccessible email accounts from the Nextcloud Mail app because this is not possible through the user interface or to reactivate blocked administrators because they were accidentally deactivated due to incorrectly entered access data, ...) PHP My admin would make it easier to manage the database.

[szaimen]

Thanks for your good explanation.

On my personal instance I never had to use any database editing tools but I might have a small advantage here because I don't use the mail app.

We are though not going to add this as default but will monitor if it should be requested more often and implement it in this case as optional addon.

[marcatsmci]

Please consider https://www.adminer.org/ as a PHPMyAdmin replacement : very light and usefull, MariaDB & PostgreSQl...
I use it for many years

[ghost]

also like this variant instead of phpmyadmin

[ghost]

Thanks for your good explanation.

On my personal instance I never had to use any database editing tools but I might have a small advantage here because I don't use the mail app.

We are though not going to add this as default but will monitor if it should be requested more often and implement it in this case as optional addon.

if a user has been blocked or an IP blocked because too many requests occur in the network, then you must have access to the database at the latest.

[rallisf1]

PhpMyAdmin won't do any good as this project uses postgres db. Adminer works but I find it a bit lacking. My personal preference is pgadmin. As long as you attach the pgadmin container to the same network bridge as the nextcloud-AIO containers it connects just fine using postgres' container name for db hostname. Also remember to expose it to a different port than nextcloud, you can always use a reverse proxy to handle SSL for that later.

[marcatsmci]

I agree 🙂 Le 5 mars 2022 12:10:30 GMT+01:00, John Rallis ***@***.***> a écrit :

PhpMyAdmin won't do any good as this project uses postgres db. Adminer works but I find it a bit lacking. My personal preference is [pgadmin](https://hub.docker.com/r/dpage/pgadmin4/). As long as you attach the pgadmin container to the same network bridge as the nextcloud-AIO containers it connects just fine using postgres' container name for db hostname. Also remember to expose it to a different port than nextcloud, you can always use a reverse proxy to handle SSL for that later. -- Reply to this email directly or view it on GitHub: #106 (comment) You are receiving this because you commented. Message ID: ***@***.***>

-- Envoyé de mon appareil Android avec Courriel K-9 Mail.

[ghost]

I believe the inclusion of this feature is necessary. The following happened a few days ago on a non-AIO instance.

An instance with an administrator has the following setting:
Password Rules:
Number of login attempts before the user account is locked: 5

Due to a brute force attack, the number of login attempts before lockout was reached.

The user was disabled and could no longer be reached. The problem could be fixed by editing the corresponding entry in the database.
How can such a problem be solved on an AIO instance without access to the database?

[szaimen]

Simply use sudo docker exec -it nextcloud-aio-nextcloud php occ security:bruteforce:reset [IP address]?

See https://docs.nextcloud.com/server/latest/admin_manual/configuration_server/occ_command.html#security

[szaimen]

Or rather sudo docker exec -it nextcloud-aio-nextcloud php occ user:enable <name of user>?

[ghost]

Ah nice, I actually didn't know about this possibility. Can this possibly be included in the documentation?

[szaimen]

yes

[szaimen]

Some documentation on this will be added with #850

[chiva]

@szaimen How can we use pgAdmin to connect to the database?

docker run -p 8088:80 -e "[email protected]" -e "PGADMIN_DEFAULT_PASSWORD=SuperSecret" dpage/pgadmin4 --network nextcloud-aio

Using the container IP directly times out 🤷‍♂️

---

Can you please add the docker command for Adminer to the Readme?
May not be the perfect one, but works like a charm and super easy to setup:
docker run --network nextcloud-aio --link nextcloud-aio-database:db -p 8080:8080 adminer

[tim-rohrer]

I'm also running into this bad connection message. @chiva what was your solution?

[chiva]

I recall using adminer, although adminer is now a deprecated project

[tim-rohrer]

Thanks for replying. I think my issue is docker related. For some reason, I'm starting the container but it isn't getting onto the nextcloud-aio network. I'm still trying to figure out why.