Matching good users when multiple nextcloud instances

[Thom1b]

Hi,

I recently switched from "user_external" with imap authentification to "user_sql".
I will explain my needs with a concrete example:

1. I have a linux server to serve multiple nextcloud instances, to serve mail accounts and others things.
2. I store all my mail account (for postfix/dovecot) in a mysql database called "mail".
3. Let's say I have a first nextcloud instance called "nc.example1.com" (storing data in "nc1" database), ans a second instance called "nc.example2.com" (storing data in "nc2" database).
4. I use on all nextcloud instances the "user_external" app with imap athentification. The idea for users is to have only one login for their mail account and nextcloud account. With "user_external", a nextcloud account is created at first login. Users know they should use nc.example1.com or nc.example2.com. This way, users have a nextcloud account in only one instance.

Everything works fine… But "user_external" seems to be not supported anymore, so I recently switched to "user_sql" app.
I set it up correctly, everything works fine…. except one thing. This app automatically creates a nextcloud account for every users found in "mail" database even if they don't login to nextcloud. All nextcloud instances now have a nextcloud account for them.

My idea is to have a row "nc_instance" on my virtual_users table in "mail" database. Then I could specify in the "user_sql" config to allow only users matching to the good "nc_instance".

Is that already possible?

I hope my english is not too bad. I open a thread in nextcloud forum.

Thanks. :)