upgrade 5.6.8 x86 to 5.7 x64

Use this forum if you want to discuss a problem or ask a question related to a hMailServer beta release.
Post Reply
procomp
New user
New user
Posts: 6
Joined: 2021-05-10 20:58

upgrade 5.6.8 x86 to 5.7 x64

Post by procomp » 2021-05-10 21:12

Hello, is there any tutorial how to upgrade hmail server from x86 version to x64?

Best regards

User avatar
SorenR
Senior user
Senior user
Posts: 4599
Joined: 2006-08-21 15:38
Location: Denmark

Re: upgrade 5.6.8 x86 to 5.7 x64

Post by SorenR » 2021-05-10 21:40

procomp wrote:
2021-05-10 21:12
Hello, is there any tutorial how to upgrade hmail server from x86 version to x64?

Best regards
5.7 is an Alpha release not suited for public production!
SørenR.

Algorithm (noun.)
Word used by programmers when they do not want to explain what they did.

procomp
New user
New user
Posts: 6
Joined: 2021-05-10 20:58

Re: upgrade 5.6.8 x86 to 5.7 x64

Post by procomp » 2021-05-10 22:13

thank you for your recommedation. but i have some performance issues and i want to test this x64 version.

User avatar
katip
Senior user
Senior user
Posts: 859
Joined: 2006-12-22 07:58
Location: Istanbul

Re: upgrade 5.6.8 x86 to 5.7 x64

Post by katip » 2021-05-10 22:26

procomp wrote:
2021-05-10 22:13
thank you for your recommedation. but i have some performance issues and i want to test this x64 version.
just curious, what kind of performance issues do you have with 5.6.8?
Katip
--
HMS 5.7.0, MariaDB 10.4.10, SA 3.4.2, ClamAV 0.103.2

procomp
New user
New user
Posts: 6
Joined: 2021-05-10 20:58

Re: upgrade 5.6.8 x86 to 5.7 x64

Post by procomp » 2021-05-10 22:33

i have got few users with more than 30000 messages and in the log of hmail server i have a error "OutOfMemoryHandler - hMailServer has run out of memory, clearing caches."

User avatar
katip
Senior user
Senior user
Posts: 859
Joined: 2006-12-22 07:58
Location: Istanbul

Re: upgrade 5.6.8 x86 to 5.7 x64

Post by katip » 2021-05-11 03:02

im not sure if x64 will solve your problem.
just install 64 bit over top of current version and let us kow the outcome.
backwards is a little tricky. see this : viewtopic.php?f=10&t=36314#p228452
Katip
--
HMS 5.7.0, MariaDB 10.4.10, SA 3.4.2, ClamAV 0.103.2

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

Re: upgrade 5.6.8 x86 to 5.7 x64

Post by mattg » 2021-05-11 03:13

katip wrote:
2021-05-11 03:02
just install 64 bit over top of current version and let us kow the outcome.
That's what I did

I believe that the out-of-memory issues become non-existent in the official 5.7 Alpha build
Make sure that you use an official one, and not a similar sounding one that is different and unsupported
https://build.hmailserver.com/login.html

You forum credentials from here will work, or you can log on anonymously
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
SorenR
Senior user
Senior user
Posts: 4599
Joined: 2006-08-21 15:38
Location: Denmark

Re: upgrade 5.6.8 x86 to 5.7 x64

Post by SorenR » 2021-05-11 08:17

Interesting... I wonder if Martin did put the "App can handle >2gb address space" flag in 5.7 otherwise you are still limited to 1.7 GB...

viewtopic.php?p=160610#p160610

https://stackoverflow.com/questions/310 ... ress-aware
https://stackoverflow.com/questions/228 ... xecutables
SørenR.

Algorithm (noun.)
Word used by programmers when they do not want to explain what they did.

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

Re: upgrade 5.6.8 x86 to 5.7 x64

Post by mattg » 2021-05-11 10:08

don't know if he did, but he said that he would
viewtopic.php?p=160610#p169260 (just a few posts below your link)

My system with typically 100 IMAP connections at once, processing some 1200-1500 mail messages per day, runs on less than 500Kb Ram (no local AV scanning)

I host four domains with more than 10 GB of data each, and I personally have one Public IMAP folder with more than 40 000 messages

I don't ever get those out-of-memory errors anymore...don't know if I ever did
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
RvdH
Senior user
Senior user
Posts: 1466
Joined: 2008-06-27 14:42
Location: Netherlands

Re: upgrade 5.6.8 x86 to 5.7 x64

Post by RvdH » 2021-05-11 10:41

SorenR wrote:
2021-05-11 08:17
Interesting... I wonder if Martin did put the "App can handle >2gb address space" flag in 5.7 otherwise you are still limited to 1.7 GB...

viewtopic.php?p=160610#p160610

https://stackoverflow.com/questions/310 ... ress-aware
https://stackoverflow.com/questions/228 ... xecutables
5.7 is 64-bit, not? So all links discussing how to handle >2gb address space on 32-bit seem irrelevant to me
CIDR to RegEx: d-fault.nl/CIDRtoRegEx
DNS Lookup: d-fault.nl/DNSTools
DNSBL Lookup: d-fault.nl/DNSBLLookup
GEOIP Lookup: d-fault.nl/GeoipLookup

procomp
New user
New user
Posts: 6
Joined: 2021-05-10 20:58

Re: upgrade 5.6.8 x86 to 5.7 x64

Post by procomp » 2021-05-11 23:13

katip wrote:
2021-05-11 03:02
im not sure if x64 will solve your problem.
just install 64 bit over top of current version and let us kow the outcome.
backwards is a little tricky. see this : viewtopic.php?f=10&t=36314#p228452
Hello, i upgraded and it is working fine right now. Also memory error is not showing anymore. Hmail server is now using about 4.8GB of memory, when is synchronizing lof of emails (importing to mailbox). Is there any limitation of memory in this version or is it possible to increase to be using more to be faster.

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

Re: upgrade 5.6.8 x86 to 5.7 x64

Post by palinka » 2021-05-12 00:10

procomp wrote:
2021-05-11 23:13
Hello, i upgraded and it is working fine right now. Also memory error is not showing anymore. Hmail server is now using about 4.8GB of memory, when is synchronizing lof of emails (importing to mailbox). Is there any limitation of memory in this version or is it possible to increase to be using more to be faster.
Limit? What limit?

https://docs.microsoft.com/en-us/window ... s-releases

Code: Select all

Memory and Address Space Limits
.....
x64: Windows 8.1 and Windows Server 2012 R2 or later: 128 TB
Different versions of windows have physical limits. The lowest I saw for any version less than 10 years old was windows 8 at 128 GB.

I'd guess that if your system is using 4.8GB, that's about the maximum it can process and the bottleneck is not your RAM.

procomp
New user
New user
Posts: 6
Joined: 2021-05-10 20:58

Re: upgrade 5.6.8 x86 to 5.7 x64

Post by procomp » 2021-05-12 02:09

palinka wrote:
2021-05-12 00:10
procomp wrote:
2021-05-11 23:13
Hello, i upgraded and it is working fine right now. Also memory error is not showing anymore. Hmail server is now using about 4.8GB of memory, when is synchronizing lof of emails (importing to mailbox). Is there any limitation of memory in this version or is it possible to increase to be using more to be faster.
Limit? What limit?

https://docs.microsoft.com/en-us/window ... s-releases

Code: Select all

Memory and Address Space Limits
.....
x64: Windows 8.1 and Windows Server 2012 R2 or later: 128 TB
Different versions of windows have physical limits. The lowest I saw for any version less than 10 years old was windows 8 at 128 GB.

I'd guess that if your system is using 4.8GB, that's about the maximum it can process and the bottleneck is not your RAM.
I have a virtual - Windows server 2019, 4x vCPU, 8GB of RAM, 240GB SSD, Hmail server with MYSQL database, 2x LAN. Downloading messages from the server take long time. Now the hmail memory only consuming about 80MB :(

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

Re: upgrade 5.6.8 x86 to 5.7 x64

Post by mattg » 2021-05-12 02:32

how are you downloading the messages?

(also do you do any inline AV scanning?)
Just 'cause I link to a page and say little else doesn't mean I am not being nice.
https://www.hmailserver.com/documentation

procomp
New user
New user
Posts: 6
Joined: 2021-05-10 20:58

Re: upgrade 5.6.8 x86 to 5.7 x64

Post by procomp » 2021-05-12 02:42

mattg wrote:
2021-05-12 02:32
how are you downloading the messages?

(also do you do any inline AV scanning?)
through imap (thunderbird or outlook). i have clamav. i tried to disable, also spamassasin and it is still same

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

Re: upgrade 5.6.8 x86 to 5.7 x64

Post by mattg » 2021-05-12 02:56

With large accounts
-In Thunderbird, I turn off message synchronisation
-In Outlook I minimise the amount of time that messages can be synced off line

This tends to make hMailserver behave better

I use spamassassin on a separate Ubuntu virtual machine, and CLAMAV is also installed on that machine, but I only use ClamaAV as part of the spamassassin checks, not independently as an AV scanner. I do find it pretty useless without the Sanesecurity defs, which are more Malware than Anti-virus detection anyway

My hmailserver is installed on a HyperV Windows 10 pro, 8 virtual processors, 12 GB RAM and SSD drives, with a single LAN, and it just idles along. Currently 77 IMAP connections, and hmailserver.exe is using less than 180Kb
Just 'cause I link to a page and say little else doesn't mean I am not being nice.
https://www.hmailserver.com/documentation

Bodos
New user
New user
Posts: 15
Joined: 2019-01-14 16:45

Re: upgrade 5.6.8 x86 to 5.7 x64

Post by Bodos » 2021-05-26 11:27

While updating from 5.6x86 to 5.7x64 or from 5.7x64 to a newer compile of 5.7.x64 I just plan to start the new installer (and dll thing if it is x86 to x64 switch).
In that case will I lose any of the current settings after update?

User avatar
katip
Senior user
Senior user
Posts: 859
Joined: 2006-12-22 07:58
Location: Istanbul

Re: upgrade 5.6.8 x86 to 5.7 x64

Post by katip » 2021-05-26 11:46

Bodos wrote:
2021-05-26 11:27
While updating from 5.6x86 to 5.7x64 or from 5.7x64 to a newer compile of 5.7.x64 I just plan to start the new installer (and dll thing if it is x86 to x64 switch).
In that case will I lose any of the current settings after update?
you're fine with an install-over-top, just take care about libmysql.dll change.
i suggest to backup first at least HMS settings & domains + ini though.
Katip
--
HMS 5.7.0, MariaDB 10.4.10, SA 3.4.2, ClamAV 0.103.2

Bodos
New user
New user
Posts: 15
Joined: 2019-01-14 16:45

Re: upgrade 5.6.8 x86 to 5.7 x64

Post by Bodos » 2021-05-26 12:04

Thank you for the fast response.

I will make a complete backup including messages. In case of any problems I can restore from that backup.
I can remake all settings again bu I should not lose messages.

User avatar
katip
Senior user
Senior user
Posts: 859
Joined: 2006-12-22 07:58
Location: Istanbul

Re: upgrade 5.6.8 x86 to 5.7 x64

Post by katip » 2021-05-30 18:39

giving smarty advise to others i myself got into trouble :lol:
upgrade from 5.6.8-2538 to 5.7.0-2572

during setup database upgrade failed with below error message:
Untitled 1.jpg
i chaged UNIQUE to KEY, deleted redundant row, changed back to UNIQE...
then there were 3 other problematic rows too which i had to delete manually.

Code: Select all

EnableImapSASLInitialResponse
EnableImapSASLPlain
ImapAuthAllowPlainText
setup past:
stable -> 5.7 (without problem)
5.7 -> 5.6.8 (manual change dbversion to 5601)
5.6.8 -> 5.7 (as above)

otherwise all running fine for now.
jfyi..
Katip
--
HMS 5.7.0, MariaDB 10.4.10, SA 3.4.2, ClamAV 0.103.2

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

Re: upgrade 5.6.8 x86 to 5.7 x64

Post by jimimaseye » 2021-05-30 20:00

That would be expected.

Upgrading to 5.7 would have made the necessary database changes. So downgrading without rolling back those changes and then upgrading again world sure result in the clash experienced.

[Entered by mobile. Excuse my spelling.]
5.7 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
katip
Senior user
Senior user
Posts: 859
Joined: 2006-12-22 07:58
Location: Istanbul

Re: upgrade 5.6.8 x86 to 5.7 x64

Post by katip » 2021-05-30 20:31

jimimaseye wrote:
2021-05-30 20:00
That would be expected.

Upgrading to 5.7 would have made the necessary database changes. So downgrading without rolling back those changes and then upgrading again world sure result in the clash experienced.

[Entered by mobile. Excuse my spelling.]
not necessarily i think.
clean 5.6.8 hm_settings table also have this rows.

EDIT//
yes, true. 5.6.8 don't have this rows.
(i looked at another 5.6.8 setup which i forgot having it also downgraded from 5.7)

so, we ignore this particular case.
Katip
--
HMS 5.7.0, MariaDB 10.4.10, SA 3.4.2, ClamAV 0.103.2

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

Re: upgrade 5.6.8 x86 to 5.7 x64

Post by jimimaseye » 2021-05-30 21:48

For sure I know that the SASL entries and additions are definitely for 5.7 only.

[Entered by mobile. Excuse my spelling.]
5.7 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

Post Reply