I have left a lot of stuff out and been creating my own documentation as I go. I am not interested in any of the web server side. I just want to make it work with an email client such as Thunderbird and my phone.
I am all the way through and stuck on one last step. The MySQL command for creating the virtual user.
I am using MySQL workbench to run this command and the moment I paste it in a red X appears telling me their is a syntax error in the second line but I cannot figure out where it is.
If anyone can advise me I would be very grateful indeed. I will post my guide to 1 month “Just do it!” challenge if I get it working (with credit to author of original guide).
The ENCRYPT command turns purple after removing the space but still does not work. Gives same error either way
Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '@notmydomain.net’,CONCAT(‘{SHA256-CRYPT}’, ENCRYPT(‘notmypassword' at line 2
That just generates a password or am I mistaken? I want to create a virtual user. The command creates a virtual user in the domain specified, adds the email address and then encrypts the plain text password. Or at least that is that I think it is supposed to do.
Apologies if I am being dense. SQL is not my strong suit.
Finally got his working. Although I as I am on a residential IP I am on the Spamhaus PBL so my emails get binned. It states..
It is perfectly normal for dynamic IP addresses (DSL, DHCP, cable, dialup) to be listed on the PBL. In fact all IP addresses in the world which are not designated mail server machines should be on the PBL.
This is shown very clearly in the server mail logs.
I will complete my guide over the next few days and post in the forums somewhere after I figure out some sort of dynamic DNS solution.
Mostly I followed this guide but I did find at least one error in it regarding the certificate names in a config file. Not blaming the author. It is an awesome guide. Just taught me to be careful.
Learnt a lot so far but now I want to incorporate some sort of spam protection and password-less SSH key based login.
As for spam protection I use spam assassin as well as postgrey. Postgrey gets rid of most spam by simply dropping all mail from new sender-reciever pairs and checks if the sending mail server behaves according to standards when it resends the messages. Most spam servers either don't resend or will resend too quickly while real servers will resend after 3 minutes.
You probably won't be able to do this with SSH keys but you can do the same thing using SSL certificates. Not sure exactly how to do it but it should support SSL client authentication.
I jumped the gun a little with my last post. After getting the spamhaus whitelisting sorted I ran into a few other issues.
Firstly to configure DKIM so my messages didn't arrive with warnings on them stating the sender could not be verified.
Then I discovered my version of postgrey defaults to work on IP v6 and was causing all sorts of weirdness. This stumped me for a while but now it is all working perfectly.
I can send / receive to my new server (Raspberry Pi 2) using Thunderbird or generic email app on my phone which was the goal I started with. I am not interested in having any sort of web interface.
Now to very carefully document all my configuration files and installed packages. I have most of this done already but when it is complete I will tear the whole thing down and set it up again.
When I am finally happy I will post a guide and mark as SOLVED.
After that I will have some more goals regarding backup / restore and managing the virtual domains and users.
So I have the guide ready but I cannot upload pdfs to the tekwiki. File type is not allowed. I don't really feel like reformatting thirty pages of instructions.
I will find somewhere else to put it and then link it.
