Sub OnHELO(oClient) progress?

[martijng]

Why don't you build the installer too? I do that with my build so that everything is packaged nicely into one executeable, incl. the database tables. Just install over existing code.

I once made that choice, and i did that mainly because i wanted to highlight that it is a 'mod' so people are aware it needs manual steps to get that 'mod' working, and therefor basically exclude/warn novice user to not touch it

Point taken

First of all. Thanks for your work!

Any idea or intention to make your version as an official github controlled version of hMailServer? As the official development is stopped...

We've been using hMailServer for a couple of years now and it works great.

Apparently it always had a bug that wasn't a 'problem' before: issue #301, DKIM signing NDR messages.
We are using Exchange Online and hMailServer just for outgoing SMTP (not spam), but due to some improvements on Microsoft's part it detects now all NDR's get into the spam folder (which is actually correct as the messages are not signed).

Your version seems like the best version where this bug is fixed. But I still need to find a way how to safely test and update our production environment with it.

I understand your point of not wanting to make an installer for just this mod, but if it would be an official version with full installer would be a great addition for the future

[RvdH]

Latest is 5.6.9-B2607.58

Note FYI i have disabled download access to older versions of my custom builds, you from now on always should be redirected to the latest build when downloading

Simply install the latest production and/or beta artifact from the URL below, then copy and overwrite files in this archive in hmailserver '/bin' directory
https://build.hmailserver.com/repositor ... -B2607.exe (login as guest)

1. Added: OnHELO(oClient) event, issue #153
2. Fix: Incorrect DEBUG logging for event 'OnDeliverMessage', issue #181
3. Added: Include HTMLBody into IMAP TEXT search, pull #193
4. Fix: implicit conversion: "int" to "unsigned char" pull #204
5. Fix: Faulty SMTP 'Disconnect client after too many invalid commands' pull issue #160
6. Fix: SMTP server error "550 Unsupported ESMTP extension" on MAIL FROM:... AUTH=<> [with fix] issue #164
7. Fix: Removed warning if backup was more than 1,5GB and 15GB limit. There's no longer a recommended max-size - the time will vary with the installation size. issue #69
8. Fix: Speed up 'update hm_messages set messageflags' issue #221
9. A̶d̶d̶e̶d̶:̶ ̶t̶h̶r̶e̶a̶t̶ ̶a̶u̶t̶h̶e̶n̶t̶i̶c̶a̶t̶e̶d̶ ̶u̶s̶e̶r̶s̶ ̶a̶s̶ ̶l̶o̶c̶a̶l̶s̶e̶n̶d̶e̶r̶ ̶i̶f̶ ̶t̶h̶e̶ ̶s̶e̶n̶d̶e̶r̶ ̶i̶s̶ ̶a̶u̶t̶h̶e̶n̶t̶i̶c̶a̶t̶e̶d̶ ̶a̶n̶d̶ ̶A̶u̶t̶h̶U̶s̶e̶r̶I̶s̶L̶o̶c̶a̶l̶=̶1̶ ̶I̶N̶I̶ ̶s̶e̶t̶t̶i̶n̶g̶ ̶O̶f̶f̶i̶c̶e̶ ̶2̶0̶1̶6̶/̶2̶0̶1̶9̶ ̶B̶u̶g̶
10. Added: Return-Path header as topmost header before sending the message to SA (+ delete Return-Path header after the SA check completes) issue #116
11. Added: Event OnClientLogon(oClient), New ClientInfo property oClient.Authenticated (Boolean)
12. Fix: Handling of long UIDL response lists was too slow. issue #93
13. Fix: When calling SpamAssassin and there was a connection failure, sometimes temporary files were left behind issue #100
14. Fix: SURBL detection properly fails to detect url's ending with a query string issue #108
15. Fix: If a route is set up, but the recipient does not match an address in the route address list, the domain catch-all should be used if specified. issue #74
16. Fix: ExternalFetcher DELE when no RETR, pull pull #254
17. Fix: SMTP multiply max message size with 1024 issue #267
18. Added: email address variable to SignatureAdder.cpp pull #265
19. Fix: DKIM on acccount-rule 'reply' not applied #172 issue #172
20. Fix: preserve RewriteEnvelopeFromWhenForwarding setting when forwarding from account rule
21. Fix: The logical flow should be to disregard "Require SMTP authentication" if "Allow deliveries from" is unselected issue #287
22. Added: ability to DKIM sign NDR messages (forwarded to external) pull #301
23. Added: Use custom daemonaddressdomain from INI pull #301
24. Fix: SURBL regex pull #320
25. A̶d̶d̶e̶d̶:̶ ̶R̶M̶S̶P̶F̶ ̶l̶i̶b̶r̶a̶r̶y̶ ̶S̶p̶a̶m̶T̶e̶s̶t̶S̶P̶F̶ ̶R̶e̶s̶u̶l̶t̶ ̶t̶o̶ ̶D̶E̶B̶U̶G̶ ̶l̶o̶g̶g̶i̶n̶g̶,̶ ̶s̶e̶e̶ ̶t̶h̶i̶s̶ ̶f̶o̶r̶u̶m̶ ̶t̶o̶p̶i̶c̶
26. Fix: Ignore SpamTestSPF and SpamTestHeloHost when send thru local IP Address, see this forum topic
27. Added: SPF test to include "HELO/EHLO host" used by DNS macros pull 353
28. Fix: 'Unencrypted Cleartext Login' vulnerability detection pull 242
29. Fix: Anti-spam; Maximum message to scan (KB) is now limited to 256MB, see this forum topic
30. Added: "UseDNSCache" INI setting. 1 = Use cache in DNS Client service (default). 0 = Bypass cache in DNS Client service. pull 396
31. Fix: AWStats::LogDeliveryFailure was called twice for each message in OnDeliveryFailed pull 368
32. Fix: oMessage object was empty (in some circumstances) when called from OnDeliveryFailed pull 369
33. Added: Experimental events OnRecipientUnknown(oClient, oMessage) and OnTooManyInvalidCommands(oClient, oMessage) pull #390
34. Added: TLS server cipher preference support and support for prioritizing ChaCha20Poly1305 pull 379
35. Added: DKIM signature for domain aliases pull 383
36. Added: "DNSServer" INI setting. Single (local) DNS server IPv4 addresses to use within hMailServer instead of default system DNS. pull 396
37. Added: Auto-Submitted header for auto-generated messages pull 386
38. Added: New ClientInfo properties oClient.EncryptedConnection (Boolean), oClient.CipherVersion, oClient.CipherName and oClient.CipherBits pull #391
39. Added: DomainMembers DistributionList mode pull #392
40. Added: X-hMailServer-Envelope-From header, grouping off all X-hMailServer-* headers, For consistency equalize Return-Path format used within hMailServer, eg: Return-Path: <return-route-addr> (always use angle brackets)
41. Fix: integer overflow check for SPF macro segment count pull #399
42. Added: New ClientInfo property oClient.SessionID (long) issue #401
43. Added: New Status property oApp.Status.ThreadID (long) this forum topic
44. Added: rDNS/PTR AntiSpam Check pull #413
45. Added: Prefer IPv6 over IPv4 pull #415
46. Fix: SpamTestHeloHost IPv6 Fix pull #416
47. Fix: Changed ClamAV Scan from STREAM to INSTREAM. issue #420
48. Added: MIME Recipient Headers as configurable comma delimited string pull #428
49. Fix: AUTH PLAIN followed by base64 encoded username and password (on same line) in log exposed account password. pull #437
50. Fix: rfc4954 After a successful AUTH command completes, a server MUST reject any further AUTH commands with a 503 reply. pull #438
51. Fix: HM5157 SpamAssassinClient::OnReadError, The WinSock error code is 2. issue #167
52. Fix: TCP/IP Ports 'Default' button in GUI did not add the standard port SMTP 587 (this port is standard added by SQL script during installation) #pull 441
53. Removed: Collection of statistics, since it's no longer being used. issue #435
54. Fix: If MSSQL OLE DB Provider 18 or later is installed, prefer that one, since it supports TLS1.1/1.2 which older providers do not. issue 186
55. Added: %MACRO_ORIGINAL_HEADER% macro expansion for 'Set header value' rules
56. Fix: S/MIME Signed Message Failing Signature Validation due to X-hMailServer-Envelope-From header position, effectively this means ungrouping of the X-hMailServer-* headers
57. Fix: Error logged if email address length exceeds 254 characters issue #393
58. Fix: DKIM Signing Not Performed On Messages > 10 MB issue #387
59. Fix: DKIM (header) verification fails when an email is received with no subject issue #245
60. Added: DKIM signing support for CSA-Compliant Mail Headers, eg: X-CSA-Complaints and List-Unsubscribe-Post headers

Important! This fork requires you to add additional entries to the hm_settings database table, eg:

MariaDB, MySQL

Code: Select all

insert into hm_settings (settingname, settingstring, settinginteger) 
  select 'TlsOptions', '', 0 from dual
where not exists 
  (select settingname from hm_settings where settingname='TlsOptions');

insert into hm_settings (settingname, settingstring, settinginteger) 
  select 'ascheckptr', '', 0 from dual
where not exists 
  (select settingname from hm_settings where settingname='ascheckptr');

insert into hm_settings (settingname, settingstring, settinginteger) 
  select 'ascheckptrscore', '', 1 from dual
where not exists 
  (select settingname from hm_settings where settingname='ascheckptrscore');

insert into hm_settings (settingname, settingstring, settinginteger) 
  select 'IPv6Preferred', '', 0 from dual
where not exists 
  (select settingname from hm_settings where settingname='IPv6Preferred');

alter table hm_fetchaccounts add column if not exists famimerecipientheaders varchar(255) not null default 'To,CC,X-RCPT-TO,X-Envelope-To';

update hm_dbversion set value = 5606;

MSSQL

Code: Select all

IF NOT EXISTS(SELECT settingname FROM hm_settings WHERE settingname = 'TlsOptions')
INSERT INTO hm_settings(settingname, settingstring, settinginteger) VALUES ('TlsOptions','','0')
GO
IF NOT EXISTS(SELECT settingname FROM hm_settings WHERE settingname = 'ascheckptr')
insert into hm_settings (settingname, settingstring, settinginteger) values ('ascheckptr', '', 0)
GO
IF NOT EXISTS(SELECT settingname FROM hm_settings WHERE settingname = 'ascheckptrscore')
insert into hm_settings (settingname, settingstring, settinginteger) values ('ascheckptrscore', '', 1)
GO
IF NOT EXISTS(SELECT settingname FROM hm_settings WHERE settingname = 'IPv6Preferred')
insert into hm_settings (settingname, settingstring, settinginteger) values ('IPv6Preferred', '', 0)
GO
IF NOT EXISTS (
  SELECT
    *
  FROM
    INFORMATION_SCHEMA.COLUMNS
  WHERE
    TABLE_NAME = 'hm_fetchaccounts' AND COLUMN_NAME = 'famimerecipientheaders')
BEGIN
  ALTER TABLE hm_fetchaccounts
    ADD famimerecipientheaders nvarchar(255) NOT NULL DEFAULT 'To,CC,X-RCPT-TO,X-Envelope-To'
END;
GO
UPDATE hm_dbversion SET value = 5606
GO

Download
https://d-fault.nl/files/hMailServer-Bu ... 2607.58.7z

* Included hMailAdmin.exe fixes sorting of DateTime and IPAddress (IP4) values, not reflected in server application version numbering

[manos2000]

@RvdH thank you very much for great releases you make!

2 clarifications

your files at yout build 2607.58 (database version 5606) replace files of the 2607 version (db version 5601) from 12th of March right? ( https://build.hmailserver.com/buildConf ... =artifacts)


line alter table hm_fetchaccounts add column if not exists famimerecipientheaders produces an error at mysql 5.7, however either removing "if not exists" if checked with phpmyadmin if does not exist, or adding manually

Thanks again

[RvdH]

There is a readme included, but yes it uses build 2607 as base

If not exist queries only seem to be supported by mariadb and (possibly) mysql 8.x

[katip]

Latest is 5.6.9-B2607.58

i see that you posted also 5.7.0-B2632.7
is #60 included in it?
thks.

[RvdH]

Latest is 5.6.9-B2607.58

i see that you posted also 5.7.0-B2632.7
is #60 included in it?
thks.

Yup

[katip]

Latest is 5.6.9-B2607.58

i see that you posted also 5.7.0-B2632.7
is #60 included in it?
thks.

Yup

strange. tried both 5.6 and 5.7 but those X-CSA-Complaints, List-Unsubscribe, List-Unsubscribe-Post things don't show up.

Code: Select all

h=From:Subject:Date:Message-ID:To:MIME-Version:Content-Type:In-Reply-To:References;

[RvdH]

i see that you posted also 5.7.0-B2632.7
is #60 included in it?
thks.

Yup

strange. tried both 5.6 and 5.7 but those X-CSA-Complaints, List-Unsubscribe, List-Unsubscribe-Post things don't show up.

Code: Select all

h=From:Subject:Date:Message-ID:To:MIME-Version:Content-Type:In-Reply-To:References;

You are aware those headers need to exists in the original e-mail message don't you? The client or script sending controls these (dynamic) values.
#60 only makes sure, if these headers exists in the email, they are used and included as header tags when calculating the DKIM signature in the DKIM headers (when sending) which is required to be CSA-Compliant when sending newsletters and such

[manos2000]

Hi Rvdh

did the patch (5.6.9-B2607.58) , mailserver works fine, administrator not though :

Object reference not set to an instance of an object.

ExceptionType: NullReferenceException
HelpLine:
Message: Object reference not set to an instance of an object.
Source: hMailAdmin
StackTrace: at hMailServer.Administrator.ucStatus.DisplayWarnings()
at hMailServer.Administrator.ucStatus.LoadData()
at hMailServer.Administrator.formMain.ShowNodeRepresentation(INode node)
at hMailServer.Administrator.formMain.treeNodes_AfterSelect(Object sender, TreeViewEventArgs e)
at System.Windows.Forms.TreeView.OnAfterSelect(TreeViewEventArgs e)


Thank you for your time

[manos2000]

There is a readme included, but yes it uses build 2607 as base

If not exist queries only seem to be supported by mariadb and (possibly) mysql 8.x

yes it is mariadb (> 10.0.2) query only

At mysql need a function like
IF NOT EXISTS(SELECT etc
Than
alter table add column

with windows server is more probable to have mysql than maria, i love mariadb on linux

[RvdH]

Hi Rvdh

did the patch (5.6.9-B2607.58) , mailserver works fine, administrator not though :

Object reference not set to an instance of an object.

ExceptionType: NullReferenceException
HelpLine:
Message: Object reference not set to an instance of an object.
Source: hMailAdmin
StackTrace: at hMailServer.Administrator.ucStatus.DisplayWarnings()
at hMailServer.Administrator.ucStatus.LoadData()
at hMailServer.Administrator.formMain.ShowNodeRepresentation(INode node)
at hMailServer.Administrator.formMain.treeNodes_AfterSelect(Object sender, TreeViewEventArgs e)
at System.Windows.Forms.TreeView.OnAfterSelect(TreeViewEventArgs e)


Thank you for your time

I could not reproduce your error...
You replaced all existing files in /Bin with files within the archive? In particular:

• hMailAdmin.exe

  Code: Select all

  CRC32: 32ACC1E4
  MD5: A54F40D867206FE7D08232B8D9C15F9C
  SHA-1: 2B994BFBCCE62C7898FC3028D57FBCF75E5DE2A2
  SHA-256: D0CBB0C59079F228F8BF7BA64CFDCEFB703A0E3A787B05056F9C716202CF34E9

• hMailServer.exe

  Code: Select all

  CRC32: F5C7D4E0
  MD5: 10867C57D953E284084BFE1ED1F46362
  SHA-1: 2234A97ABD349D5D3C1238D854D5181038F464D9
  SHA-256: F3E52FDE69736F6AAC3FDD8960503B60E58AB97E846AD22D50B6592F2B146263

• hMailServer.Minidump.exe

  Code: Select all

  CRC32: 4C7C65B7
  MD5: 58C634193724794D758FA8AEF7238C45
  SHA-1: FC1FFBD2325EBC863D2C87EC7547FD867F8CC727
  SHA-256: 5198BA31FEE6ECF39C636345C2E5D8590CA4745637C8570F8DC680D6B17EC3CD

• hMailServer.tlb

  Code: Select all

  CRC32: 3B5A8B75
  MD5: D6228CF682483710316FE638D53DCD28
  SHA-1: 182FA62F40313B74EFA6E7F9CB79A9D95499E703
  SHA-256: 96B9B8207723B54370D338C58047783AE13D13B9EB98ECA09432E456BC6CB8E0

• Interop.hMailServer.dll

  Code: Select all

  CRC32: D7532C93
  MD5: F06834204BA653DFCF4BCD834F8EB33A
  SHA-1: AEA9EAD27FF9AC055A2C3C5063665FF258311266
  SHA-256: 71756DC61BFBD5BB842F31104A1F6BBF8E263A12EF23A9888C74A35F0F77C697

Anyone else has a problem with hMailAdmin.exe?

[manos2000]

Hi Rvdh

did the patch (5.6.9-B2607.58) , mailserver works fine, administrator not though :

Object reference not set to an instance of an object.

ExceptionType: NullReferenceException
HelpLine:
Message: Object reference not set to an instance of an object.
Source: hMailAdmin
StackTrace: at hMailServer.Administrator.ucStatus.DisplayWarnings()
at hMailServer.Administrator.ucStatus.LoadData()
at hMailServer.Administrator.formMain.ShowNodeRepresentation(INode node)
at hMailServer.Administrator.formMain.treeNodes_AfterSelect(Object sender, TreeViewEventArgs e)
at System.Windows.Forms.TreeView.OnAfterSelect(TreeViewEventArgs e)


Thank you for your time

I could not reproduce your error...
You replaced all existing files in /Bin with files within the archive? In particular:


Anyone else has a problem with hMailAdmin.exe?

Yes stoped hmailservice, replaced all, restarted, as i wrote mailserver works very fine after the patch, admin is the case
Will try to another server today, same hardware, same software windows 2012 r2, same mysql 5.7 so i do not expect something different, but nothing to loose to try

Thank you again vry much for your time RvdH

[RvdH]

Verify hashes of hMailAdmin.exe and Interop.hMailServer.dll as said above, do they match?
All database changes made? Verify the existence of the new settings

[SorenR]

Yes stoped hmailservice, replaced all, restarted, as i wrote mailserver works very fine after the patch, admin is the case
Will try to another server today, same hardware, same software windows 2012 r2, same mysql 5.7 so i do not expect something different, but nothing to loose to try

Thank you again vry much for your time RvdH

And this??

Code: Select all

insert into hm_settings (settingname, settingstring, settinginteger) 
  select 'TlsOptions', '', 0 from dual
where not exists 
  (select settingname from hm_settings where settingname='TlsOptions');

insert into hm_settings (settingname, settingstring, settinginteger) 
  select 'ascheckptr', '', 0 from dual
where not exists 
  (select settingname from hm_settings where settingname='ascheckptr');

insert into hm_settings (settingname, settingstring, settinginteger) 
  select 'ascheckptrscore', '', 1 from dual
where not exists 
  (select settingname from hm_settings where settingname='ascheckptrscore');

insert into hm_settings (settingname, settingstring, settinginteger) 
  select 'IPv6Preferred', '', 0 from dual
where not exists 
  (select settingname from hm_settings where settingname='IPv6Preferred');

alter table hm_fetchaccounts add column if not exists famimerecipientheaders varchar(255) not null default 'To,CC,X-RCPT-TO,X-Envelope-To';

update hm_dbversion set value = 5606;

[manos2000]

And this??


Hi

First 4 queries ended with no error not sure though if data at hm_settings
inserted as supposed to do as i have suspicion that queries are for mariadb and not mysql


insert into hm_settings (settingname, settingstring, settinginteger)
select 'TlsOptions', '', 0 from dual
where not exists
(select settingname from hm_settings where settingname='TlsOptions');

insert into hm_settings (settingname, settingstring, settinginteger)
select 'ascheckptr', '', 0 from dual
where not exists
(select settingname from hm_settings where settingname='ascheckptr');

insert into hm_settings (settingname, settingstring, settinginteger)
select 'ascheckptrscore', '', 1 from dual
where not exists
(select settingname from hm_settings where settingname='ascheckptrscore');

insert into hm_settings (settingname, settingstring, settinginteger)
select 'IPv6Preferred', '', 0 from dual
where not exists
(select settingname from hm_settings where settingname='IPv6Preferred');


This query i entered without the |id not exists" that is 100% for mariadb only and is ok

alter table hm_fetchaccounts add column if not exists famimerecipientheaders varchar(255) not null default 'To,CC,X-RCPT-TO,X-Envelope-To';


This query is simple and worked of course


update hm_dbversion set value = 5606;[/code]




Could you write what data should be at what setting at hm_settings as an example to check?


Thanks again


PS

I assume those 4 queries added these last 4 rows at hm_settings



TlsOptions
0


ascheckptr
0


ascheckptrscore
1


IPv6Preferred
0

[RvdH]

Really?
Simply look in hm_settings table if the entries are created and exist!

the last 4 entries should read:

• TlsOptions
• ascheckptr
• ascheckptrscore
• IPv6Preferred

If they do not exist run:

Code: Select all

INSERT INTO hm_settings (settingname, settingstring, settinginteger) VALUES ('TlsOptions', '', 0);

INSERT INTO hm_settings (settingname, settingstring, settinginteger) VALUES ('ascheckptr', '', 0);

INSERT INTO hm_settings (settingname, settingstring, settinginteger) VALUES ('ascheckptrscore', '', 1);

INSERT INTO hm_settings (settingname, settingstring, settinginteger) VALUES ('IPv6Preferred', '', 0);

Make sure to run it only once, there should be no duplicates!

[manos2000]

Seems ok, initial 4 queries are ok, last 4 rows at hm_settings are:
TlsOptions
0


ascheckptr
0


ascheckptrscore
1


IPv6Preferred
0


btw tried to second server, same result, mailserver works superfine, hmailadmin errors
windows2012 r2, mysql 5.7

[RvdH]

Ok let me check, i gonna try to mimic your setup on Hyper-V

[manos2000]

Ok let me check, i gonna try to mimic your setup on Hyper-V

Thank you very much for your time

[RvdH]

No issues here

Schermafbeelding 2023-06-09 121134.png (123.86 KiB) Viewed 62749 times

[manos2000]

No issues here

Again thank you so much RvdH and SorenR

Will try to investigate tonight deeply, does error message i sent gives you any idea of the problem?

Btw i see you suggest utf8mb4_unicode_ci collation is there any chance my utf8mb4_unicode_520_ci (newer) to be the problem?

[RvdH]

No issues here

Again thank you so much RvdH and SorenR

Will try to investigate tonight deeply, does error message i sent gives you any idea of the problem?

No, Only thing i can think of is you did NOT replace (all) the files within the 5.6.9-B2607.58.7z archive, have you verified the hashes posted? If not, do that FIRST!

• hMailAdmin.exe

  Code: Select all

  CRC32: 32ACC1E4
  MD5: A54F40D867206FE7D08232B8D9C15F9C
  SHA-1: 2B994BFBCCE62C7898FC3028D57FBCF75E5DE2A2
  SHA-256: D0CBB0C59079F228F8BF7BA64CFDCEFB703A0E3A787B05056F9C716202CF34E9

• hMailServer.exe

  Code: Select all

  CRC32: F5C7D4E0
  MD5: 10867C57D953E284084BFE1ED1F46362
  SHA-1: 2234A97ABD349D5D3C1238D854D5181038F464D9
  SHA-256: F3E52FDE69736F6AAC3FDD8960503B60E58AB97E846AD22D50B6592F2B146263

• hMailServer.Minidump.exe

  Code: Select all

  CRC32: 4C7C65B7
  MD5: 58C634193724794D758FA8AEF7238C45
  SHA-1: FC1FFBD2325EBC863D2C87EC7547FD867F8CC727
  SHA-256: 5198BA31FEE6ECF39C636345C2E5D8590CA4745637C8570F8DC680D6B17EC3CD

• hMailServer.tlb

  Code: Select all

  CRC32: 3B5A8B75
  MD5: D6228CF682483710316FE638D53DCD28
  SHA-1: 182FA62F40313B74EFA6E7F9CB79A9D95499E703
  SHA-256: 96B9B8207723B54370D338C58047783AE13D13B9EB98ECA09432E456BC6CB8E0

• Interop.hMailServer.dll

  Code: Select all

  CRC32: D7532C93
  MD5: F06834204BA653DFCF4BCD834F8EB33A
  SHA-1: AEA9EAD27FF9AC055A2C3C5063665FF258311266
  SHA-256: 71756DC61BFBD5BB842F31104A1F6BBF8E263A12EF23A9888C74A35F0F77C697

[manos2000]

No issues here


[/quote}



Thank you for your time again

Created also a new box with windows 2012 r2 and mysql 5.7 and mailserver, hmailadministrator worked
perfectly, so i need to investigate what is different at the 2 production servers.
Is there any chance to be mysql dll i use? will check other versions.
The only problem at the working server is that datadirectory synchroniser is crashing when checking a domain to sync, could
you check at your box that synchroniser works as well?

Have a nice day there

[katip]

The only problem at the working server is that datadirectory synchroniser is crashing when checking a domain to sync,

same Interop.hMailServer.dll as in bin has also to be there where you launch DDS from i think.

[manos2000]

The only problem at the working server is that datadirectory synchroniser is crashing when checking a domain to sync,

same Interop.hMailServer.dll as in bin has also to be there where you launch DDS from i think.

yep, that was the problem, thanks

[manos2000]

Ok was like a dummy case lol

At 2015 when i installed hmailserver at these 2 machines i did it at /program files x86/, then found that c:\hmailserver was better to have all there
But hmailadmin shortcut pointed to old location.

Now works super fine at both servers


2 Notices.

1)At webadmin need to include at include_versioncheck.php file the new version eg define('REQUIRED_VERSION', '5.6.9-B2607.58');, file is not at the packet of webadmin of the patched version. can easily change it with an editor though.
2) To put manually the new interop dll file at addons directory as well as katip pointed.

Thank you RvdH and SorenR so much

[manos2000]

Ok was like a dummy case lol

At 2015 when i installed hmailserver at these 2 machines i did it at /program files x86/, then found that c:\hmailserver was better to have all there
But hmailadmin shortcut pointed to old location.

Now works super fine at both servers


2 Notices.

1)At webadmin need to include at include_versioncheck.php file the new version eg define('REQUIRED_VERSION', '5.6.9-B2607.58');, file is not at the packet of webadmin of the patched version. can easily change it with an editor though.
2) To put manually the new interop dll file at addons directory as well as katip pointed.

Thank you RvdH and SorenR so much

Adding 1 notice
the image files at webadmin dir of 5.6.9-B2607.58 are all corrupted (found from hm logo that did not work so replaced with old)

webadmin of 5.6.9-B2607 has to be replaced with the one of the patched version? i did already, then just put back the images directory from the old one

[SorenR]

Ok was like a dummy case lol

At 2015 when i installed hmailserver at these 2 machines i did it at /program files x86/, then found that c:\hmailserver was better to have all there
But hmailadmin shortcut pointed to old location.

Now works super fine at both servers


2 Notices.

1)At webadmin need to include at include_versioncheck.php file the new version eg define('REQUIRED_VERSION', '5.6.9-B2607.58');, file is not at the packet of webadmin of the patched version. can easily change it with an editor though.
2) To put manually the new interop dll file at addons directory as well as katip pointed.

Thank you RvdH and SorenR so much

Checked my "initialize.php" ...

Code: Select all

//if ($obBaseApp->Version != REQUIRED_VERSION)
//{
//   echo "<br>";
//   echo "The hMailServer version does not match the WebAdmin version.<br>";
//   echo "hMailServer version: " . $obBaseApp->Version . "<br>";
//   echo "WebAdmin version: " . REQUIRED_VERSION . "<br>";
//   echo "Please make sure you are using the PHPWebAdmin version which came with your hMailServer installation.<br>";
//   die;
//}

To my defense, I do change version number every time I change the code and 11 times out of 10 I forget to edit the php code

[RvdH]

2 Notices.

1)At webadmin need to include at include_versioncheck.php file the new version eg define('REQUIRED_VERSION', '5.6.9-B2607.58');, file is not at the packet of webadmin of the patched version. can easily change it with an editor though.
2) To put manually the new interop dll file at addons directory as well as katip pointed.

Thank you RvdH and SorenR so much

Thx for the notes, i will repack the download

[manos2000]

.

To my defense, I do change version number every time I change the code and 11 times out of 10 I forget to edit the php code

The easy part is the most difficult to remember hehe

[manos2000]

Thx for the notes, i will repack the download

Do not forget the images as well


5.6.9-B2607.58 Running perfectly at 2 servers now with more than 300 accounts, all good ( i use snappymail a rainloop fork for webmail, works fine with hm)

Thank you so much again RvdH and SorenR for the releases and your time!

[RvdH]

Is anyone using my mod build for 5.6 with IPV6 with setting IPv6Preferred checked? Don't think that does something, right?
While examining difference between the github source and my test code it looks i forgot to include something

[glenluo]

Has anyone test antivirus with clamav for 5.6.9-B2607.58?
I have tried 0.103.8; 0.104.4; 1.0.1; 1.1.0 all same result.

2023-08-02_210105.jpg (10.95 KiB) Viewed 62317 times

[SorenR]

Has anyone test antivirus with clamav for 5.6.9-B2607.58?
I have tried 0.103.8; 0.104.4; 1.0.1; 1.1.0 all same result.
2023-08-02_210105.jpg

I'm using;

Server 1 (Windows Server 2003 R2 x86):
hMailServer 5.6.9-B2607.79 (x86)

Server 2 (Windows Server 2019 x64):
clamd daemon 0.103.3 (OS: win32, ARCH: x86_64, CPU: x86_64)
SpamAssassin 4.0.0 (X64)

Yes, both hMailServer AND SpamAssassin check with ClamAV.

[glenluo]

Finally,I make it works!
System: WIN2008 R2 X64
hMailserver：5.6.9-B2607.58
ClamAV：clamav-1.0.1.win.x64

[RvdH]

Finally,I make it works!
System: WIN2008 R2 X64
hMailserver：5.6.9-B2607.58
ClamAV：clamav-1.0.1.win.x64

ClamAV 0.103.8; 0.104.4; 1.0.1; 1.1.0 all should work OK, so curious what your problem was?

[glenluo]

47: Fix: Changed ClamAV Scan from STREAM to INSTREAM
0.103.8 use STREAM
From 0.104.X use INSTREAM
5.6.9-B2607 works with 0.103.8,not working from 0.104.X to latest version
5.6.9-B2607.58 works with 0.104.x,not working with 0.103.x and other older version.

[RvdH]

47: Fix: Changed ClamAV Scan from STREAM to INSTREAM
0.103.8 use STREAM
From 0.104.X use INSTREAM
5.6.9-B2607 works with 0.103.8,not working from 0.104.X to latest version
5.6.9-B2607.58 works with 0.104.x,net working 0.103.x and other older version.

Nah, 0.103.8 can use INSTREAM but still supports STREAM as well, whereas 0.104 or higher drops support for STREAM
So theoraticly speaking 5.6.9-B2607.58 'should' support all possible ClamAV versions from 0.09x and up. So I still believe the problem you had was caused by something else

See this topic for details: viewtopic.php?t=37507

[RvdH]

0.103.8 (on 5.7.0-B2642 which also made the switch to INSTREAM)

Schermafbeelding 2023-08-03 091457.png (4.56 KiB) Viewed 62274 times

[glenluo]

47: Fix: Changed ClamAV Scan from STREAM to INSTREAM
0.103.8 use STREAM
From 0.104.X use INSTREAM
5.6.9-B2607 works with 0.103.8,not working from 0.104.X to latest version
5.6.9-B2607.58 works with 0.104.x,net working 0.103.x and other older version.

Nah, 0.103.8 can use INSTREAM but still supports STREAM as well, whereas 0.104 or higher drops support for STREAM
So theoraticly speaking 5.6.9-B2607.58 'should' support all possible ClamAV versions from 0.09x and up. So I still believe the problem you had was caused by something else

See this topic for details: viewtopic.php?t=37507

It is true,0.103.8 work with STREAM and INSTREAM and it is LTS,In that case,it is best version,can used by old and new hmailserver

[katip]

5.6.9-B2641.62
5.7.0-B2642.5
(RvdH builds)

I think there is something wrong with PhpWebAdmin.
Actually i don't use it at all but today by accident i noticed that some checkboxes on "Account" tabs don't work. After checking them and saving the form they revert back to unchecked. Other text entries are saved properly but not the checkboxes.
See "Enabled" checkboxes on Auto-reply or Forwarding tabs. Of course i haven't examined all possible checkboxes on entire webadmin, but these are what i have noticed. Maybe there are others in various sections which don't save too.
JFYI, thanks.

[RvdH]

hmmm, I do not use it myself either as i use the modern (UI) coax version, but look like a string concatenation issue and this should fix it:

functions.php

Code: Select all

function PrintCheckboxRow($name, $caption, $checked, $disabled = false)
{
   global $obLanguage;
   $caption = $obLanguage->String($caption);
   
   $checked_text = hmailCheckedIf1($checked);
   
   $disabledstr = "";
   if ($disabled){
      $disabledstr = " disabled";
   }
   
   echo 
   "
   	<tr>
   		<td>$caption</td>
   		<td><input type=\"checkbox\"$disabledstr name=\"$name\" value=\"1\" $checked_text></td>
   	</tr>	
    ";
}

[katip]

functions.php

Code: Select all

   		<td><input type=\"checkbox\"$disabledstr name=\"$name\" value=\"1\" $checked_text></td>

yess, exactly, that's it. thanks.

[thomas10]

Latest is 5.6.9-B2607.58

Note FYI i have disabled download access to older versions of my custom builds, you from now on always should be redirected to the latest build when downloading

Simply install the latest production and/or beta artifact from the URL below, then copy and overwrite files in this archive in hmailserver '/bin' directory
https://build.hmailserver.com/repositor ... -B2607.exe (login as guest)

MSSQL

Code: Select all

IF NOT EXISTS(SELECT settingname FROM hm_settings WHERE settingname = 'TlsOptions')
INSERT INTO hm_settings(settingname, settingstring, settinginteger) VALUES ('TlsOptions','','0')
GO
IF NOT EXISTS(SELECT settingname FROM hm_settings WHERE settingname = 'ascheckptr')
insert into hm_settings (settingname, settingstring, settinginteger) values ('ascheckptr', '', 0)
GO
IF NOT EXISTS(SELECT settingname FROM hm_settings WHERE settingname = 'ascheckptrscore')
insert into hm_settings (settingname, settingstring, settinginteger) values ('ascheckptrscore', '', 1)
GO
IF NOT EXISTS(SELECT settingname FROM hm_settings WHERE settingname = 'IPv6Preferred')
insert into hm_settings (settingname, settingstring, settinginteger) values ('IPv6Preferred', '', 0)
GO
IF NOT EXISTS (
  SELECT
    *
  FROM
    INFORMATION_SCHEMA.COLUMNS
  WHERE
    TABLE_NAME = 'hm_fetchaccounts' AND COLUMN_NAME = 'famimerecipientheaders')
BEGIN
  ALTER TABLE hm_fetchaccounts
    ADD famimerecipientheaders nvarchar(255) NOT NULL DEFAULT 'To,CC,X-RCPT-TO,X-Envelope-To'
END;
GO
UPDATE hm_dbversion SET value = 5606
GO

Download
https://d-fault.nl/files/hMailServer-Bu ... 2607.58.7z

* Included hMailAdmin.exe fixes sorting of DateTime and IPAddress (IP4) values, not reflected in server application version numbering

Hi Rvdh,

I am using version 6.7.8 with MSSQLCE and I'm looking into upgrade to 5.6.9 as posted.
But when I try to add addition query with the code provided for MSSQL, it comes with errors as shown in attachment. It seems that If not exist isn't support in CE.
Please advise what can I do to overcome this.
Really appreciate your assistance.

Error.png (99.74 KiB) Viewed 61653 times

[RvdH]

That script is for MSSQL and NOT MSSQLCE, also make sure you first update to 5.6.9-B2641 (login as quest) for use with 5.6.9-B2641.62.7z

What is the difficulty exactly? I am not using MYSQLCE myself, other then a test setup i used once to test the queries.

Last time I used SqlCe QueryAnalyzer:
https://github.com/christianhelle/sqlcequery/releases

Stop hMailServer (this is needed for SqlCe QueryAnalyzer)
Open the database with SqlCe QueryAnalyzer, normally located at "C:\Program Files\hMailServer\Database\hMailServer.sdf"

To obtain the sdf password, copy Password=*** value under [Database] in hMailServer.ini
if PasswordEncryption=1 under [Database] in hMailServer.ini you need to decrypt it using C:\Program Files (x86)\hMailServer\Addons\Utilities\DecryptBlowfish.vbs

In the Tab "Query" execute queries (1 by 1)

Code: Select all

INSERT INTO hm_settings(settingname, settingstring, settinginteger) VALUES ('TlsOptions', '', 0)

Code: Select all

INSERT INTO hm_settings (settingname, settingstring, settinginteger) VALUES ('ascheckptr', '', 0)

Code: Select all

INSERT INTO hm_settings (settingname, settingstring, settinginteger) values ('ascheckptrscore', '', 1)

Code: Select all

INSERT INTO hm_settings (settingname, settingstring, settinginteger) values ('IPv6Preferred', '', 0)

Code: Select all

ALTER TABLE hm_fetchaccounts ADD famimerecipientheaders nvarchar(255) NOT NULL DEFAULT 'To,CC,X-RCPT-TO,X-Envelope-To'

Code: Select all

UPDATE hm_dbversion SET value = 5606

[thomas10]

That script is for MSSQL and NOT MSSQLCE, also make sure you first update to 5.6.9-B2641 (login as quest) for use with 5.6.9-B2641.62.7z

What is the difficulty exactly? I am not using MYSQLCE myself, other then a test setup i used once to test the queries.

Last time I used SqlCe QueryAnalyzer:
https://github.com/christianhelle/sqlcequery/releases

Stop hMailServer (this is needed for SqlCe QueryAnalyzer)
Open the database with SqlCe QueryAnalyzer, normally located at "C:\Program Files\hMailServer\Database\hMailServer.sdf"

To obtain the sdf password, copy Password=*** value under [Database] in hMailServer.ini
if PasswordEncryption=1 under [Database] in hMailServer.ini you need to decrypt it using C:\Program Files (x86)\hMailServer\Addons\Utilities\DecryptBlowfish.vbs

In the Tab "Query" execute queries (1 by 1)

Code: Select all

INSERT INTO hm_settings(settingname, settingstring, settinginteger) VALUES ('TlsOptions', '', 0)

Code: Select all

INSERT INTO hm_settings (settingname, settingstring, settinginteger) VALUES ('ascheckptr', '', 0)

Code: Select all

INSERT INTO hm_settings (settingname, settingstring, settinginteger) values ('ascheckptrscore', '', 1)

Code: Select all

INSERT INTO hm_settings (settingname, settingstring, settinginteger) values ('IPv6Preferred', '', 0)

Code: Select all

ALTER TABLE hm_fetchaccounts ADD famimerecipientheaders nvarchar(255) NOT NULL DEFAULT 'To,CC,X-RCPT-TO,X-Envelope-To'

Code: Select all

UPDATE hm_dbversion SET value = 5606

Hi Rvdh,

Ya, I have done decrypt the database password and stuck at adding additional query only. Just tried the code given, successfully executed. So database part is done.
Really thanks for your swift assistance.

I see that you mentioned that I need first update to 5.6.9-B2641 for use with 5.6.9-B2641.62.7z.
Are these the correct steps? Please correct me if I misunderstand.
- Stop current hmailserver service.
- Run 5.6.9-B2641 .exe installer file to overwrite current version 5.6.8.
- After installation done, copy and overwrite all files from 5.6.9-B2641.62.7z to the current version location(5.6.9-B2641)
- Update database(Add query).
- Start the hmailserver service.

Appreciated.

[RvdH]

Confirmed (it is all described in this topic and in the included readme), note: make sure you execute the SQL queries only once, for MSSQLCE there is no easy way to check if a record already exists (verify!)

[RvdH]

Latest is 5.6.9-2641.64

Note FYI i have disabled download access to older versions of my custom builds, you from now on always should be redirected to the latest build when downloading

Simply install the latest artifact from the URL below, then copy and overwrite files in this archive in hmailserver '/bin', '/Addons' and optionally the '/PHPWebAdmin' directory
https://build.hmailserver.com/repositor ... -B2641.exe (login as guest)

1. Added: OnHELO(oClient) event, issue #153
2. Fix: Incorrect DEBUG logging for event 'OnDeliverMessage', issue #181
3. Added: Include HTMLBody into IMAP TEXT search, pull #193
4. Fix: implicit conversion: "int" to "unsigned char" pull #204
5. Fix: Faulty SMTP 'Disconnect client after too many invalid commands' pull issue #160
6. Fix: SMTP server error "550 Unsupported ESMTP extension" on MAIL FROM:... AUTH=<> [with fix] issue #164
7. Fix: Removed warning if backup was more than 1,5GB and 15GB limit. There's no longer a recommended max-size - the time will vary with the installation size. issue #69
8. Fix: Speed up 'update hm_messages set messageflags' issue #221
9. Added: Return-Path header as topmost header before sending the message to SA (+ delete Return-Path header after the SA check completes) issue #116
10. Added: Event OnClientLogon(oClient), New ClientInfo property oClient.Authenticated (Boolean)
11. Fix: Handling of long UIDL response lists was too slow. issue #93
12. Fix: When calling SpamAssassin and there was a connection failure, sometimes temporary files were left behind issue #100
13. Fix: SURBL detection properly fails to detect url's ending with a query string issue #108
14. Fix: If a route is set up, but the recipient does not match an address in the route address list, the domain catch-all should be used if specified. issue #74
15. Fix: ExternalFetcher DELE when no RETR, pull pull #254
16. Fix: SMTP multiply max message size with 1024 issue #267
17. Added: email address variable to SignatureAdder.cpp pull #265
18. Fix: DKIM on acccount-rule 'reply' not applied #172 issue #172
19. Fix: preserve RewriteEnvelopeFromWhenForwarding setting when forwarding from account rule
20. Fix: The logical flow should be to disregard "Require SMTP authentication" if "Allow deliveries from" is unselected issue #287
21. Added: ability to DKIM sign NDR messages (forwarded to external) pull #301
22. Added: Use custom daemonaddressdomain from INI pull #301
23. Fix: SURBL regex pull #320
24. Fix: Ignore SpamTestSPF and SpamTestHeloHost when send thru local IP Address, see this forum topic
25. Added: SPF test to include "HELO/EHLO host" used by DNS macros pull 353
26. Fix: 'Unencrypted Cleartext Login' vulnerability detection pull 242
27. Fix: Anti-spam; Maximum message to scan (KB) is now limited to 256MB, see this forum topic
28. Added: "UseDNSCache" INI setting. 1 = Use cache in DNS Client service (default). 0 = Bypass cache in DNS Client service. pull 396
29. Fix: AWStats::LogDeliveryFailure was called twice for each message in OnDeliveryFailed pull 368
30. Fix: oMessage object was empty (in some circumstances) when called from OnDeliveryFailed pull 369
31. Added: Experimental events OnRecipientUnknown(oClient, oMessage) and OnTooManyInvalidCommands(oClient, oMessage) pull #390
32. Added: TLS server cipher preference support and support for prioritizing ChaCha20Poly1305 pull 379
33. Added: DKIM signature for domain aliases pull 383
34. Added: "DNSServer" INI setting. Single (local) DNS server IPv4 addresses to use within hMailServer instead of default system DNS. pull 396
35. Added: Auto-Submitted header for auto-generated messages pull 386
36. Added: New ClientInfo properties oClient.EncryptedConnection (Boolean), oClient.CipherVersion, oClient.CipherName and oClient.CipherBits pull #391
37. Added: DomainMembers DistributionList mode pull #392
38. Added: X-hMailServer-Envelope-From header, grouping off all X-hMailServer-* headers, For consistency equalize Return-Path format used within hMailServer, eg: Return-Path: <return-route-addr> (always use angle brackets)
39. Fix: integer overflow check for SPF macro segment count pull #399
40. Added: New ClientInfo property oClient.SessionID (long) issue #401
41. Added: New Status property oApp.Status.ThreadID (long) this forum topic
42. Added: rDNS/PTR AntiSpam Check pull #413
43. Added: Prefer IPv6 over IPv4 pull #415
44. Fix: SpamTestHeloHost IPv6 Fix pull #416
45. Fix: Changed ClamAV Scan from STREAM to INSTREAM. issue #420
46. Added: MIME Recipient Headers as configurable comma delimited string pull #428
47. Fix: AUTH PLAIN followed by base64 encoded username and password (on same line) in log exposed account password. pull #437
48. Fix: rfc4954 After a successful AUTH command completes, a server MUST reject any further AUTH commands with a 503 reply. pull #438
49. Fix: HM5157 SpamAssassinClient::OnReadError, The WinSock error code is 2. issue #167
50. Fix: TCP/IP Ports 'Default' button in GUI did not add the standard port SMTP 587 (this port is standard added by SQL script during installation) #pull 441
51. Removed: Collection of statistics, since it's no longer being used. issue #435
52. Fix: If MSSQL OLE DB Provider 18 or later is installed, prefer that one, since it supports TLS1.1/1.2 which older providers do not. issue 186
53. Added: %MACRO_ORIGINAL_HEADER% macro expansion for 'Set header value' rules
54. Fix: S/MIME Signed Message Failing Signature Validation due to X-hMailServer-Envelope-From header position, effectively this means ungrouping of the X-hMailServer-* headers
55. Fix: Error logged if email address length exceeds 254 characters issue #393
56. Fix: DKIM Signing Not Performed On Messages > 10 MB issue #387
57. Fix: DKIM (header) verification fails when an email is received with no subject issue #245
58. Added: DKIM signing support for CSA-Compliant Mail Headers, eg: X-CSA-Complaints and List-Unsubscribe-Post headers
59. Fix: Prefer IPv6 over IPv4 didn't do anything, added the missing part (sorting of found IP Addresses)
60. Removed: X-hMailServer-Envelope-From as it had no practical use
61. Added: Received-SPF: diagnostic header controlled with INI setting "AddReceivedSPFHeader" (skip for authenticated client connections or localhost!)
62. Added: (envelope-from <user@domain.com>), for <user@domain.com> to Received: header (if single recipient!)
63. Fix: All 5xx errors are permanent errors and should be treated as such, eg: contributing to invalid commands counter
64. Fix: hMailServer reports incorrect RFC822.SIZE pull 477

Important! This fork requires you to add additional entries to the hm_settings database table if you database version is NOT 5606, eg:

MariaDB, MySQL

Code: Select all

insert into hm_settings (settingname, settingstring, settinginteger) 
  select 'TlsOptions', '', 0 from dual
where not exists 
  (select settingname from hm_settings where settingname='TlsOptions');

insert into hm_settings (settingname, settingstring, settinginteger) 
  select 'ascheckptr', '', 0 from dual
where not exists 
  (select settingname from hm_settings where settingname='ascheckptr');

insert into hm_settings (settingname, settingstring, settinginteger) 
  select 'ascheckptrscore', '', 1 from dual
where not exists 
  (select settingname from hm_settings where settingname='ascheckptrscore');

insert into hm_settings (settingname, settingstring, settinginteger) 
  select 'IPv6Preferred', '', 0 from dual
where not exists 
  (select settingname from hm_settings where settingname='IPv6Preferred');

alter table hm_fetchaccounts add column if not exists famimerecipientheaders varchar(255) not null default 'To,CC,X-RCPT-TO,X-Envelope-To';

update hm_dbversion set value = 5606;

MSSQL

Code: Select all

IF NOT EXISTS(SELECT settingname FROM hm_settings WHERE settingname = 'TlsOptions')
INSERT INTO hm_settings(settingname, settingstring, settinginteger) VALUES ('TlsOptions','','0')
GO
IF NOT EXISTS(SELECT settingname FROM hm_settings WHERE settingname = 'ascheckptr')
insert into hm_settings (settingname, settingstring, settinginteger) values ('ascheckptr', '', 0)
GO
IF NOT EXISTS(SELECT settingname FROM hm_settings WHERE settingname = 'ascheckptrscore')
insert into hm_settings (settingname, settingstring, settinginteger) values ('ascheckptrscore', '', 1)
GO
IF NOT EXISTS(SELECT settingname FROM hm_settings WHERE settingname = 'IPv6Preferred')
insert into hm_settings (settingname, settingstring, settinginteger) values ('IPv6Preferred', '', 0)
GO
IF NOT EXISTS (
  SELECT
    *
  FROM
    INFORMATION_SCHEMA.COLUMNS
  WHERE
    TABLE_NAME = 'hm_fetchaccounts' AND COLUMN_NAME = 'famimerecipientheaders')
BEGIN
  ALTER TABLE hm_fetchaccounts
    ADD famimerecipientheaders nvarchar(255) NOT NULL DEFAULT 'To,CC,X-RCPT-TO,X-Envelope-To'
END;
GO
UPDATE hm_dbversion SET value = 5606
GO

Download
https://d-fault.nl/files/hMailServer-Bu ... 2641.64.7z

* Included hMailAdmin.exe fixes sorting of DateTime and IPAddress (IP4) values, not reflected in server application version numbering

[glenluo]

Add like below??

AddReceivedSPFHeader=1

at hMailServer.INI

[bagu]

AddReceivedSPFHeader

Can someone explain this feature ?

[RvdH]

It inserts a Received-SPF message (diagnostic) header, eg:

Code: Select all

Received-SPF: Pass (mail.domain.nl: domain of bounce+7ea561.196cff-dmarc=domain.nl@reports.emailsrvr.com
 designates 166.78.71.6 as permitted sender) identity=mailfrom; client-ip=166.78.71.6;
 envelope-from=<bounce+7ea561.196cff-dmarc=hetcollectief.nl@reports.emailsrvr.com>;

If you (also) use spamassassin and you do NOT want to rely on this Received-SPF header and let SpamAssassin validate SPF on it's own, make sure you add the directive below to local.cf

Code: Select all

ifplugin Mail::SpamAssassin::Plugin::SPF
    ignore_received_spf_header 1
endif # Mail::SpamAssassin::Plugin::SPF

By default SpamAssassin will use the Received-SPF header closest to the Received header (if it exists)

[bagu]

Ok, thanks a lot

[RvdH]

Add like below??

AddReceivedSPFHeader=1

at hMailServer.INI

Yep, under [Settings]

Code: Select all

[Settings]
AddReceivedSPFHeader=1

Note: Unfortunately due to the way hMailSServer does SPF checks enabling the AddReceivedSPFHeader setting has the consequence additional (DNS) lookups are being made, eg: once for the normal SPF check, and once for this Received-SPF header creation, impact might be negligible but for that exact reason i disabled it by default, a local caching DNS server might also help to limit mentioned impact.

[RvdH]

.62

before:

Code: Select all

Received: from mail-oi1-f202.google.com (mail-oi1-f202.google.com [209.85.167.202]) by
 mail.domain.nl with ESMTPS (version=TLSv1.3 cipher=TLS_AES_256_GCM_SHA384 bits=256);
 Fri, 20 Oct 2023 11:48:05 +0200

after:

Code: Select all

Received: from mail-oi1-f202.google.com (mail-oi1-f202.google.com [209.85.167.202]) by
 mail.domain.nl (envelope-from <noreply-dmarc-support@google.com>)
 with ESMTPS for <dmarc@domain.nl> (version=TLSv1.3
 cipher=TLS_AES_256_GCM_SHA384 bits=256); Fri, 20 Oct 2023 11:48:05 +0200

Besides this adds diagnostic capabilities, the envelope-from is/can be used within SpamAssassin
https://cwiki.apache.org/confluence/dis ... InReceived

For (custom) rules:

Code: Select all

header __T_PAYPAL EnvelopeFrom:addr =~ /\@(paypal\.com)$/i

Which is alternative for Return-Path:addr

[gotspatel]

Greetings @RvdH

I am on 5.6.9 Build 2641.62 - Your Forked from your web https://d-fault.nl/files/hMailServer-Builds

Wanted to know details for some of my dumb queries if you please revert
1. Will you patch both 5.6.9 and 5.7.0 or just 5.7.0? as I saw that you have build 5.7.0-B2643.6 but the 5.6.9 is still B2641.64.
2. Should we move the production server to 5.7.0?
2. Does 5.7.0 have all the updates and patches you have done in 5.6.9?
2. What is the safest way to upgrade to 5.7.0-B2643.6 Your Build?

TIA & Regards

[RvdH]

Greetings @RvdH

I am on 5.6.9 Build 2641.62 - Your Forked from your web https://d-fault.nl/files/hMailServer-Builds

Wanted to know details for some of my dumb queries if you please revert
1. Will you patch both 5.6.9 and 5.7.0 or just 5.7.0? as I saw that you have build 5.7.0-B2643.6 but the 5.6.9 is still B2641.64.
2. Should we move the production server to 5.7.0?
2. Does 5.7.0 have all the updates and patches you have done in 5.6.9?
2. What is the safest way to upgrade to 5.7.0-B2643.6 Your Build?

TIA & Regards

3. Only 5.6.x, or at least only for 5.6.x a changelog (this topic) is maintained, 5.6.x and 5.7.x build nummers are in no way related!
4. Who am i to decide that? 5.7 is still considered alpha, use at your own risk
4. Basically, yes...except a few, hence the reason there is a 5.7.0-B2643.6 build
4. don't know, don't care....again, use at your own risk

[gotspatel]

Got the Message Loud and Clear


3.
4.
4.
4.

Understood my typos

Regards

[RvdH]

Understood my typos

I believe a few use 5.7 in production right now, mattg?
I use 5.7 on my personal domain/server, and 5.6.x on work related corporate environment

I think it all depends on how much mail is being processed and if there is a real need to upgrade to 5.7, if it runs smooth on 5.6 i see so real reason why one should upgrade to 5.7

[gotspatel]

Understood my typos

I believe a few use 5.7 in production right now, mattg?
I use 5.7 on my personal domain/server, and 5.6.x on work related corporate environment

I think it all depends on how much mail is being processed and if there is a real need to upgrade to 5.7, if it runs smooth on 5.6 i see so real reason why one should upgrade to 5.7

Yes Noted the same. Thank you.

My question for upgrade was just as I thought it has more patches apart from being x64.

I am happy with 5.6.x untill you are investing your time and energy to maintain it.

Regards

[katip]

???. What is the safest way to upgrade to 5.7.0-B2643.6 Your Build?

stop HMS service. full backup (dump) your HMS DB.
xcopy your entire HMS installation tree to somewhere safe (you can ignore data dir if it's also in there, just to save time).

download & install recent 5.7.0 setup exe on top of 5.6 like any normal upgrade: https://build.hmailserver.com
be careful, you probably have your installation in "Program Files (x86)" and 5.7 setup will try "Program Files" by default. Adjust this manually. Or you can uninstall existing setup (prevent data dir!!! rename or better move it to somewhere safe before uninstall) and do a fresh x64 install, copy back hMailServer.ini from your backup, move old data dir to its new place if it was in installation dir, edit ini accordingly. Also don't forget to have an x64 libmysql.dll ready in hand, because setup will complain, you just drop it into \bin and rerun setup.
stop HMS service
download RvdH 5.7 zip
replace some (5 in \bin, 1 in \Addons\DataDirectorySynchronizer) HMS files with those in zip. You may want to refresh also webadmin files.
run correct one of that SQL update scripts in your SQL management tool
run convert_to_utf8mb4_unicode_ci.sql (take care with command #1 on top, "ALTER DATABASE `hmailserver`...." replace DB name "hmailserver" with yours if different, prior to running it)
you're done. start service. check error logs.
(do the same things on your PC/laptop if you use remote admin)

no worry, in worst case you revert all back in a few minutes