Sounds good. Yes, we're happy to help with query optimisation in apps and send feedback upstream. This is the quickest way we can do that. With some luck, we'll all end up with faster apps from this R&D too.
@vladimir-d there seems to be no easy way to migrate nextcloud to different data directory (atleast in an automated way), see https://help.nextcloud.com/t/howto-change-move-data-directory-after-installation/17170 . Looks like the put the absolute path in the "share" database fields.
I finally managed to get around reproducing and debugging this and it is fixed for next release: https://git.cloudron.io/cloudron/box/-/commit/0cd48bd239b13a6edec04974031ffdfed4688e08
@vladimir-d said in LDAP not exposing outside:
Also I noticed that if I save Directory Server configuration several times, multiple duplicate rules added to iptables:
I was able to reproduce this, thanks for reporting. It's fixed in the next release - https://git.cloudron.io/cloudron/box/-/commit/d13905377c375823e7b6fd66bd248421544a1d2c .
The duplicate rules are harmless nevertheless.
I checked this again, but it seems that the public directory has a bunch of code.
root@d66257ab-b6ad-4648-acf5-f1dbc2281a80:/app/code/7.2.7/public# find .
.
./oauth-callback.php
./robots.txt
./index.php
./web.config
./api
./api/v1
./api/v1/.htaccess
./api/v1/portal-access
./api/v1/portal-access/.htaccess
./api/v1/portal-access/index.php
./api/v1/index.php
./portal
./portal/.htaccess
./portal/index.php
./install
./install/img
./install/img/devices.png
./install/js
./install/js/install.js
./install/css
./install/css/install.css
./install/index.php
Do you remember what extension writes where? Is it in a subdirectory under public or does it write straight under public itself?
This was a regression in 7.0. When user profiles are locked, the password is not reset properly. This is fixed in next release. Workaround for now is to disable locking of user profile. Alternately, you need this change - https://git.cloudron.io/cloudron/box/-/commit/37f066f2b0e4aa50ec45b387dd1d79b539d1aaf5
@vladimir-d This is already fixed in the coming release - https://git.cloudron.io/cloudron/box/-/commit/6d044bfbf384b8ae98f1beac0f9d1c50005e8d34 . For now, you can ignore the warning, it's harmless.
@vladimir-d The only other case an app is restarted without anyone triggering it is if an app using the tls addon had the certificate renewed. Unless this is a custom app, there is only the AdGuardHome app that uses the tls addon. So, is this app AdGuard Home?
I think you can get more insight by looking into the corresponding logs at the lines above those lines. What does it say above the lines you posted?
@Lanhild said in Postgresql multiple databases support:
I'm not sure to understand?
What I meant is maybe the manifest can use "postgreSQL": { "prefixCount": 10 } and it creates 10 databases or something like that.
Also, multiple databases could benefit to the use of the addon as a "standalone" app - that could act as a simple PostgreSQL cluster.
I think it will be nice to create PostgreSQL as an app and with a small frontend to add/remove databases and maybe manage roles. Maybe this app can not use existing addon. Of course, this app has to be developed!