hMailServer 5.7

Use this forum if you want to discuss a problem or ask a question related to a hMailServer beta release.
glenluo
Normal user
Normal user
Posts: 194
Joined: 2011-07-03 12:10

Re: hMailServer 5.7

Post by glenluo » 2019-09-06 13:38

I think i got the answer here.
https://www.spamhaus.org/faq/section/Spamhaus%20DBL#330

If hMailserver can check return result matching: 127.0.1.X ,then such issue never happen.

User avatar
mattg
Moderator
Moderator
Posts: 20108
Joined: 2007-06-14 05:12
Location: 'The Outback' Australia

Re: hMailServer 5.7

Post by mattg » 2019-09-07 09:11

SURBL works fine for me for
multi.surbl.org
uribl.spameatingmonkey.net

It is just not working for dbl.spamhaus.org
Just 'cause I link to a page and say little else doesn't mean I am not being nice.
https://www.hmailserver.com/documentation

palinka
Senior user
Senior user
Posts: 1096
Joined: 2017-09-12 17:57

Re: hMailServer 5.7

Post by palinka » 2019-09-15 14:52

mattg wrote:
2019-08-26 23:39
Please wait until it is a BETA at least - it is currently very much still ALPHA

But yes just that.

HOWEVER I had to track down the 64 bit libMySQL.dll manually, (this was flagged as to-fix in the hMailserver 5.7 builds - don't know if that is done yet), which also required me to update my MySQL to the latest of the installed version
Where did you find this? And will it work with Maria DB? Dravion's answer was surely intentionally vague. But I'm willing to test it to find out.

User avatar
mattg
Moderator
Moderator
Posts: 20108
Joined: 2007-06-14 05:12
Location: 'The Outback' Australia

Re: hMailServer 5.7

Post by mattg » 2019-09-15 23:38

I downloaded a MYSQL.zip (for my version) and extracted just this single file
Just 'cause I link to a page and say little else doesn't mean I am not being nice.
https://www.hmailserver.com/documentation

palinka
Senior user
Senior user
Posts: 1096
Joined: 2017-09-12 17:57

Re: hMailServer 5.7

Post by palinka » 2019-09-16 16:14

Aha.. I was looking at the wrong downloads. Got it.

Since you pointed me in the right direction, I instead went to look for a zip install for my version of MariaDB, which I found here: https://downloads.mariadb.com/MariaDB/

I'm running xampp. There is a text file at the root of the install that contains a listing of components with their versions.

Then extracted libmysql.dll, then upgraded to 5.7, then replaced the existing libmysql.dll with the new MariaDB one and voila. No errors yet (less than 1 hour running), one test email was successful, my scripts using OnHELO and OnClientLogon are working without any modification. Life is good. Will update later if any issues.

Now, maybe a stupid question, but I have not done anything at all with ODBC connector and yet my database related scripts seem to be running OK. I remember a hassle of making sure the connector was a 32 bit version. Is that anything to worry about?

User avatar
mattg
Moderator
Moderator
Posts: 20108
Joined: 2007-06-14 05:12
Location: 'The Outback' Australia

Re: hMailServer 5.7

Post by mattg » 2019-09-17 00:17

You haven't changed the database, so the scripts should still work fine.

Whatever script engine you use must be only 32 bit for you to need the 32 bit ODBC connector to use your scripts. From memory VBS is 32 bit, but VB.NET is 64 bit
Just 'cause I link to a page and say little else doesn't mean I am not being nice.
https://www.hmailserver.com/documentation

palinka
Senior user
Senior user
Posts: 1096
Joined: 2017-09-12 17:57

Re: hMailServer 5.7

Post by palinka » 2019-09-17 00:29

That makes sense. Thanks. Since everything is working, I guess I don't need to change anything.

User avatar
mattg
Moderator
Moderator
Posts: 20108
Joined: 2007-06-14 05:12
Location: 'The Outback' Australia

Re: hMailServer 5.7

Post by mattg » 2019-09-17 01:16

Welcome to the bleeding edge
Just 'cause I link to a page and say little else doesn't mean I am not being nice.
https://www.hmailserver.com/documentation

User avatar
mattg
Moderator
Moderator
Posts: 20108
Joined: 2007-06-14 05:12
Location: 'The Outback' Australia

Re: hMailServer 5.7

Post by mattg » 2019-09-17 04:37

Is IMAP SASL new?
Just 'cause I link to a page and say little else doesn't mean I am not being nice.
https://www.hmailserver.com/documentation

User avatar
jimimaseye
Moderator
Moderator
Posts: 8118
Joined: 2011-09-08 17:48

Re: hMailServer 5.7

Post by jimimaseye » 2019-09-17 08:55

mattg wrote:
2019-09-17 04:37
Is IMAP SASL new?
I believe Martin has included it in 5.7.
HMS 5.6.6 B2383 on Win Server 2008 R2 Foundation, + 5.6.7-B2415 on test.
SpamassassinForWindows 3.4.0 spamd service
AV: Clamwin + Clamd service + sanesecurity defs : https://www.hmailserver.com/forum/viewtopic.php?f=21&t=26829

User avatar
mattg
Moderator
Moderator
Posts: 20108
Joined: 2007-06-14 05:12
Location: 'The Outback' Australia

Re: hMailServer 5.7

Post by mattg » 2019-09-17 09:08

Do you know anything about the settings, or use cases?
Just 'cause I link to a page and say little else doesn't mean I am not being nice.
https://www.hmailserver.com/documentation

User avatar
jimimaseye
Moderator
Moderator
Posts: 8118
Joined: 2011-09-08 17:48

Re: hMailServer 5.7

Post by jimimaseye » 2019-09-17 09:24

Not any more. I had to Google when i first saw it a couple of years ago.

[Entered by mobile. Excuse my spelling.]
HMS 5.6.6 B2383 on Win Server 2008 R2 Foundation, + 5.6.7-B2415 on test.
SpamassassinForWindows 3.4.0 spamd service
AV: Clamwin + Clamd service + sanesecurity defs : https://www.hmailserver.com/forum/viewtopic.php?f=21&t=26829

hmbaer
New user
New user
Posts: 12
Joined: 2019-05-01 14:29

Re: hMailServer 5.7

Post by hmbaer » 2019-09-26 06:47

When will hMailServer 5.7 be public?

If i will create a new hMailServer-installation today with Version 5.6.7 (Build 2425): which database should i use to be best prepared to upgrade to future versions? Thank you.

User avatar
mattg
Moderator
Moderator
Posts: 20108
Joined: 2007-06-14 05:12
Location: 'The Outback' Australia

Re: hMailServer 5.7

Post by mattg » 2019-09-26 07:39

Any database you like, but NOT The built in one if this is going to be anything but a project

MS SQL Express is free to download
MS SQL other editions cost $ but work well

MariaDB
MySQL
PostgreSQL
are all free and open source

Most of us use either MySQL or MariaDB (MariaDB was a fork from MySQL)


And 5.7 is public, just still officially APLHA
I've been using live for over a month as have a few others
You should wait until it is BETA, but don't know when that will be

Alpha is here >> https://build.hmailserver.com/repositor ... 86-x64.exe
Just 'cause I link to a page and say little else doesn't mean I am not being nice.
https://www.hmailserver.com/documentation

User avatar
mattg
Moderator
Moderator
Posts: 20108
Joined: 2007-06-14 05:12
Location: 'The Outback' Australia

Re: hMailServer 5.7

Post by mattg » 2019-10-11 11:03

Just did this suite of tests
https://www.immuniweb.com/ssl/

I scored an A+ which is awesome

I did pass PCI DSS
I didn't get HIPAA or NIST passes though because I don't have OCSP stapling
Also didn't get perfect in the 'best practices' section due to 'server does not have a cipher preference'

I run only TLSv1.2 and TLSv1.3 with my cipher suite being 'HIGH:!TLSv1:!SSLv3;', and I have a let's encypt cert

How can I improve? Is that an OpenSSL thing or a hMailserver thing
I see that I can ask letsencrypt for a --must-staple tag on the certificate, but it only works (in apache/ngnix etc if stapling is enabled)

Perhaps this could also be because I don't force startTLS on port 25, but I don't imagine that I could do that
Just 'cause I link to a page and say little else doesn't mean I am not being nice.
https://www.hmailserver.com/documentation

tolberjj
New user
New user
Posts: 6
Joined: 2019-10-15 20:09

Re: hMailServer 5.7

Post by tolberjj » 2019-10-16 02:12

I'd like to propose a small change. I just installed 5.7 and it installs and launches with this tweak so far. 5.6.7 didn't work with the same change.

The issue is that MySQL 8 with the innodb cluster requires a primary key on every table, and hm_dbversion doesn't have one currently in the scripts.


I modified C:\Program Files\hMailServer\DBScripts\CreateTablesMYSQL.sql to the following:

Line 193 (added definition for dbversionid):

create table hm_dbversion
(
dbversionid int auto_increment not null, primary key(`dbversionid`), unique(`dbversionid`),
value int not null
) DEFAULT CHARSET=utf8;



Line 772 (specified field):
insert into hm_dbversion (value) values (5700);



Thanks for all of your work. We have sent a lot of email (ethically) for many years with previous versions and I am excited to move forward with a 64 bit version in our testing.

User avatar
nitro
New user
New user
Posts: 26
Joined: 2018-11-08 16:31
Location: Spain

Re: hMailServer 5.7

Post by nitro » 2019-10-16 10:20

Good morning, I have updated my staging version with the latest compiled version 5.7 B-2490. I could update just by clicking on the installer, completely transparent for me. My database runs on MSSQL Express 2014. Everything seems to be working without any problem. I only report it as feedback from the alpha version.

Thanks to Martin for his work.
Production 5.6.8-B2437.20_OpenSSL_1.0.2s W.Server 2016 Datace [2x Intel Xeon E5-2660 8GB RAM]
Staging 5.7-B2490 W.Server 2008 R2 Stand [Intel Pentium 4 4GB RAM]

Post Reply