Hi all, hi @PancakeConnaisseur ! This tutorial is awesome, very detailed and everything is explained very well. But I have one issue with it. Iām using environment where we have MariaDB(MySQL) already deployed. I donāt want to install additional database instance just to maintain email addresses.
I was never working with PostgreSQL and it seems MySQL lacks some features like for example user-defined domainā¦
Can anybody help translating these SQL statements to MySQL?
Thank you so much.
K
Now that is how a tutorial is done easy to follow and learned a lot. Of course at the very end ran into a problem and have been stuck for a couple days. After installing User Backend Using Raw SQL I cant access the Users in the profile so I am not able to create any users. I get an internal error page and nextcloud.log gives error āFileā:"/var/www/nextcloud/apps/user_backend_sql_raw/lib/Dbs/Postgresql.php",āLineā:30,āCustomMessageā:"ā"} . This is the file the error is referring to.
namespace OCA\UserBackendSqlRaw\Dbs;
23
24 use OCA\UserBackendSqlRaw\Db;
25 use \PDO;
26
27 class Postgresql extends Db {
28
29 protected function createDbHandle() {
30 return new PDO($this->assembleDsn());
31 }
32
33 protected function assembleDsn() {
34 return āpgsql:host=ā . $this->config->getDbHost()
35 . ā;port=ā . $this->config->getDbPort()
36 . ā;dbname=ā . $this->config->getDbName()
37 . ā;user=ā . $this->config->getDbUser()
38 . ā;password=ā . $this->config->getDbPassword();
39 }
40 }
Any clues would be great.
Thanks!
UPDATE: This was solved by removing \ symbol in the mail_admin password. Once removed User Backend Using Raw SQL connected perfectly. This really was the best tutorial I have ever used and just what I needed. Thanks @PancakeConnaisseur you really raised the bar on tutorials with this one.
After weeks of research, testing and writing I have released an updated version for Debian 10 (Buster). You can view the changes in the changelog.
The main things are:
Feedback is very welcome. Either here or in the comments on the site.
Just realized that both links were dead. I change the structure of the guide after the release and forgot to update them here. 
. It is fixed now.
Great tutorial. I intend to follow it and set up such a server myself later.
This may sound greedy, but it would be nice if you also added how to add z-push which enables ActiveSync.
Thereās already several good posts on it, perhaps you could reference them.:
Hello, at first that is a really good tutorial. I havenĀ“t tried it yet but soon. It it very full of detail. I know you write at the end, that a tutorial for the data transfer is too much, but do you know a good tutorial how i can do this? We are useing at the moment a Mailserver from our provider where our website. ItĀ“s an all inclusive package. The only problem I donĀ“t know how to transfer all our mails too the new server.
Hey, thanks for info. I am not using Active Directory myself, so I have to interest/motivation to add this to my tutorial. I suppose people needing that can just google āNextcloud Active Directoryā and would find these guides anyway.
It really depends on how the e-mails are stored and whether your hoster will give you access to the e-mails on a system level. This is really specific to your hosterās technical setup and policies, so I canāt really help you there.
Hi, and thank you for your tutorial!
I got myself a VPS with the goal to run my own Mailserver and have an option to store some files i.e, so in the end your solution was basically what i was looking for (even though i dont need al ot of the functions of Nextcloud.
So far most of the stuff works. With a tinly little exception. I cannot send Mails. It works with the sendmail command from the command line, but neither through NExtcloud (Error 500) nor from Microsoft Outlook or the The Bat was i able to send Mails.
The Bat first told me about some fqdn Errors which i could squash by commenting out the HELO restrictions in the postfix configuration.
But the next error was
04.10.2020, 15:55:43: SEND - Verbinde mit SMTP-Server mx.rzie.net auf Port 587
04.10.2020, 15:55:43: SEND - Einleitung TLS-Handshake
!04.10.2020, 15:55:43: SEND - TLS-Protokollfehler: Unerwartete Nachricht SessionUnknownContentType ct (50)
Outlook being a microsoftproduct doesnt hand out anything. The initial testmail went out after a few tries (at first i told me that the server doent understand its security protocolls) but since then all messages are stuck
So i tried reducing the mandated TLS version by also allowing 1 and 1.1 but to no success.
After some googling i activated a deeper debuglevel with postfix for my IP to get more information and thats the block i get from a The Bat! connection attempt:
it boils down to the 500 5.5.2 Error: bad UTF-8 syntax and 500 5.5.2 Error: bad syntax errors. (Outlook just gave me the UTF8 part)
Do you have any suggestion at what mistake i made setting this up to cause this error?
What confuses me is, that if it is a TLS error, why cant i send mails with Nextcloud then since if i understood your tutorial a lot of the security features arent applicable to nextclouds mailclient since it runs localy.
Hey Schwarzie,
Error: Request failed with status code 500
I can try Thunderbiord tomorrow, but when the Webclient and two other Clients wont work (with identical error) i dont have many hopes that it works.
Which hardens my assumption that something in my postfix is borked and the UTF error is just a symptom.
I am using Debian 10, it was a completely fresh install, only webmin came preinstalled, and Nextcloud 20.
Everything works except sending mail. So something in postfix must be broken, if it were doveblablub i wouldnt be able to connect via IMAP and read my mail, which works flawlessly
Ok. im completely confused now.
I installed Thunderbird and put in my Account. It worked out of the box. But the wierdness doesnt stop here. i then started The Bat and Outlook and the Mails stuck in there could be send aswell.
Whenever i send an Email with the Webinterface i still get the error 500 message BUT those Emails are send aswell. Which is even strangerā¦
And i definitely didnt touch my server since the last time i tried to send a Mail. No upgrades, no configchanges, no restarts. Nothing.
Gremlins?
@Schwarzie This is really weird, indeed. Update me if you find more useful log entries.
Although this is probably not the culprit, I would advice against using Nextcloud 20 for now. I havenāt tested it yet and in general I wait until the first patch release (20.0.1) just to be sure that there are not major bugs before updating my server. This is also what Nextcloud does itself when you are on the production update channel.
Hi!
Thanks for tutorial.
Installation without major problems, but sending mail causes error 500 (Error: Request failed with status code 500) or unavailable send button.
mail.warn ā āOct 8 11:49:07 mail postfix/submission/smtpd[1592]: warning: TLS library problem: error:14209102:SSL routines:tls_early_post_process_client_hello:unsupported protocol:ā¦/ssl/statem/statem_srvr.c:1661:ā
Fresh debian 10.6 amd64, nextcloud 19.0.3
Can you suggest something?
Thanks!
I have seen this error with K9-Mail on Android when sending e-mails but not on any other e-mail client so far. I did some research but was not able to find a solution yet. I am suspecting it to be a openssl error on the client side, but I am not sure. Are you using K9-Mail?
No. it is a built-in client.
āRainloop webmailā works well, something with a built-in āmailā
If you look further up, i had the exact same problem with Nextclouds built in mailclient, version 20 though, and āfixedā it with Rainloop aswell.
So far i thought this error was caused because i used NExtcloud 20. Seeing you using 19 suggests that it might be a problem with the build in mailclient though.
Please, report issues with our Mail app - so we can fix 'em! Especially if they show up with this awesome tutorial 
BTW @PancakeConnaisseur did you have a look at https://lightmeter.io/ ā might be a nice addition to the tutorial
I signed up here to tell you this is an incredible how-to. Well done, and thank you.