Topic: iRedmail + Nextcloud + MySQL identity integration
I've got iRedMail 0.9.9 MySQL version running on FreeBSD. All is good. I also run Nextcloud for file sharing, calendar sharing, and its many features. By installing the User SQL plugin on Nextcloud, I can link the identities I define in iRedMail and that are used in Nextcloud. If a user exists in my iRedMail setup, they will automatically get access to all the features of Nextcloud. Here's the setup that I use in Nextcloud.
One of my users needed to use the forgot password feature on Nextcloud, and it allowed him to reset his password in a way that was compatible with iRedMail, too. This lets my iRedMail's MySQL server act as a central identity service. I don't use quota features much, but it looks like iRedMail and Nextcloud may have compatible quota features to allow me to set a single quota for a user, that would be enforced in both places.
This is a really great way to increase the value of my iRedMail server.
Install the User SQL plugin like you would any other.[*/]
Logged in as a Nextcloud admin, go to Settings.
Choose SQL Backend.
On the SQL backend settings page, under Database Connection set things this way:
SQL Driver = MySQL (Presumably you can also use PostgreSQL, but I haven't tested it)
Hostname = (your database server)
Database = vmail
Username = vmail
Password = your vmail password. Get it from /root/.my.cnf-vmail, for example.
Tick Enable Display Name Change
Tick Allow Password Change
Hash Algorithm = SSHA512 (that's what I use, you have to pick something that works for you)
Email Sync = SQL Always Wins
Other options you can set as you like.
Under User Table:
Table name = mailbox
Username = username
Email = username
Password = password
Display Name = name
Active = enablesmtp (if enablesmtp is set to 0, they won't have access to Nextcloud, either)
Leave the Group Table and User Group Table empty.