Page 1 of 1

Questions for new user

Posted: 2020-11-16 14:27
by sdevany
Hi,

We are looking to move our emails to hmailserver from our current SBS2008 with Exchange 2007, I have played around with this over the weekend, the whole thing went smoothly, but I do have a few questions regarding using the software in a production environment.

A: I am using this with postgres v10 as I plan to run this on a Windows 10x64 PC for a while before moving to Windows Server (for less than 10 users), if this PC were to suffer a hardware failure, how could I transfer all the emails onto a new PC ? I will be running a daily bare metal backup but if I need to reinstall hMS on a new PC, how would one get the the new PC with hMS to read in all emails stored from the old postgres SQL databases (and accounts if need to) ?

B: Is Postgres the best SQL for hMS or should I pay more for MS-SQL ?

C: What ports do I need to open to allow external POP3/IMAP access ?

D: What do you guys do to safeguard a production server ? as in how you backup and what redundant hardware to use ?

Thank you for all your help.

Re: Questions for new user

Posted: 2020-11-16 15:05
by palinka
I created a backup routine for hmailserver that uploads the backup files to letsupload.io. it's free offsite backup. It's unlimited storage but they delete stuff older than 30 days. No problem for daily backups. That's 25 more days than i had before i ran across letsupload.

https://github.com/palinkas-jo-reggelt/ ... ite_Backup

My script only works with the internal db and mysql. You'll have to modify the dump command for mssql or other databases.

Basically, the things you want to back up are:
* database
* data folder containing the messages
* hmailserver.ini
* eventhandler.vbs if you run scripts in hmailserver
* anything else important to you

There's another excellent backup routine (which i based mine from) here: https://hmailserver.com/forum/viewtopic ... 21&t=28139

As far as ports go, standard pop3 is 110 and IMAP is 143.

Re: Questions for new user

Posted: 2020-11-16 21:31
by johang
sdevany wrote:
2020-11-16 14:27
A: I am using this with postgres v10 as I plan to run this on a Windows 10x64 PC for a while before moving to Windows Server (for less than 10 users), if this PC were to suffer a hardware failure, how could I transfer all the emails onto a new PC ? I will be running a daily bare metal backup but if I need to reinstall hMS on a new PC, how would one get the the new PC with hMS to read in all emails stored from the old postgres SQL databases (and accounts if need to) ?
emails are stored as files in filesystem, they are NOT stored inside database, typically C:\Program Files (x86)\hMailServer\Data\"YOURDOMAIN.TLD" if you havent choosen your own path ..
B: Is Postgres the best SQL for hMS or should I pay more for MS-SQL ?
since only index and flags like "read mail or not" are in database it does not matter.. what ever makes your boat float or your demands for heavy usage
C: What ports do I need to open to allow external POP3/IMAP access ?
POP3: port 110 POP3 with SSL/TLS: port 995 IMAP: Port 143 IMAP with SSL/TLS: Port 993
D: What do you guys do to safeguard a production server ? as in how you backup and what redundant hardware to use ?
Disks in raid 1 or 5 or 6
backup every 24 hours of mail data and configuration, copied to another location ( Palinkas solution is not bad )

Re: Questions for new user

Posted: 2020-11-17 00:16
by mattg
I also backup a very small file with every backup

\hmailserver\PHPWebAdmin\include_versioncheck.php

This is the one automatically updated thing that tells me what version of hMailserver I was running on the day