Installguide: MariaDB 10.3.x 64-Bit and hMailServer 5.x

This section contains user-submitted tutorials.
Post Reply
User avatar
Dravion
Senior user
Senior user
Posts: 2071
Joined: 2015-09-26 11:50
Location: Germany
Contact:

Installguide: MariaDB 10.3.x 64-Bit and hMailServer 5.x

Post by Dravion » 2018-07-01 00:51

There is no Installation guide for MariaDB on Windows with hMailServer in our User Tutorial Section, so i decided to provide one because MariaDB is a awsome Database and a real replacement for ORACLE's properitary MySQL Database and needs some attention. This Guide will try to provide the easiest possible steps to get the Job done in easymode.

Lets begin:

Download:
Latest hMailServer:
https://www.hmailserver.com/download

Maria 10.3.7 64-Bit for Windows
https://downloads.mariadb.org/interstit ... e/mariadb/

1) Run and Install MariaDB first, setup a Root password (you need it later) and select "Use UTF-8 as default server's charater set"
2) Run and Install hMailServer 5.x setup, enter a hMailServer Admin password and proceed.
3) Wait until the Database Wizzard is shown

Now we need to run MariaDB HeidiSQL GUI-Tool (part of your MariaDB 10.3.x installation, there should be a shortcut to HeidiSQL on your Desktop)

1) Start HeidiSQL
2) Leave the Default settings for now to root and type in your password and clock the "open Button"
3) In HeidiSQL enter Toolmenue/Usermanagement and create a new User "hmaildbusr" by clicking "New" and set a password
4) In HeidiSQL User create, expand the Node below called "Global rights" by clicking the + Symbol
5) In the now expanded Global rights Tree, select following permissions SELECT, INSERT, UPDATE, DELETE, CREATE, INDEX, DROP and click "Save"
See:
HeidiSQL_hms567.png
6) Close HeidiSQL

1) Return to hMailServer Setup Database
2) In Step 2 of 7 Select "Create New Database" and click next
3) In Step 3 of 7 Select the Checkbox "MySQL" and click next
4) In Step 4 of 7 insert "localhost" in the field Database server address
5) In Step 4 of 7 insert "hmailserver" in the field Database name
6) In Step 4 of 7 insert your HeidiSQL created MaraDB Username and its Password in the fields Username and Password
7) In Step 4 of 7 WAIT before you click next!! and switch back to Desktop and right click the HeidiSQL Desktop shortcut
8 ) On the HeidiSQL right clicked Popupmenue, select and click "Open file location" and lookout for the file "libmysql.dll"
9) Copy "libmysql.dll"into your hMailServer\bin folder (for example C:\Program Files (x86)\hMailServer\bin)
10) Return to hMailServervers Setup Database Wizard and click next
11) In Step 5 of 7 select from the Dropdownmenue "Service" select "MySQL (MySQL)" and click next
12) In Step 6 of 7 go ahead and click the "Next" button and wait.This can take a few seconds or a Minute.
13) In Step 7 of 7 you should see the Message completed. Press the "Finish" button and select checkbox run and hMailAdmin

Thats it! have fun with your MariaDB 64-Bit + hMailServer 32-Bit Installation.

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

Re: Installguide: MariaDB 10.3.x 64-Bit and hMailServer 5.x

Post by mattg » 2018-07-01 02:44

Don't you need the 32bit version of the libmysql.dll to work with 32 bit hMailserver, irrespective of the bitage of the SQL Server.

Certainly for 64 bit MYSQl, I need to the 32bit libmysql.dll to work with 32 bit hMailserver

Thanks for the write up though. More of us should use MariaDB rather than MySQL
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
Dravion
Senior user
Senior user
Posts: 2071
Joined: 2015-09-26 11:50
Location: Germany
Contact:

Re: Installguide: MariaDB 10.3.x 64-Bit and hMailServer 5.x

Post by Dravion » 2018-07-01 03:37

mattg wrote:
2018-07-01 02:44
Don't you need the 32bit version of the libmysql.dll to work with 32 bit hMailserver, irrespective of the bitage of the SQL Server.

Certainly for 64 bit MYSQl, I need to the 32bit libmysql.dll to work with 32 bit hMailserver

Thanks for the write up though. More of us should use MariaDB rather than MySQL
Hi Matt,

Its true, but MariaDB doesnt install libmysql.dll at all but HeidiSQL does which is part of MariaDB Setup.
HeidiSQL is allways 32-Bit, regardless if you install the 32 or 64-Bit Version of MariaDB, Problem solved. :D

frank70
Normal user
Normal user
Posts: 51
Joined: 2013-06-04 13:49

Re: Installguide: MariaDB 10.3.x 64-Bit and hMailServer 5.x

Post by frank70 » 2019-06-26 12:42

Thx, works fine! :D

On Win10 64Bit i found the libary here: C:\Program Files (x86)\Common Files\MariaDBShared\HeidiSQL\libmysql.dll

Besserwisser
New user
New user
Posts: 10
Joined: 2019-06-29 22:53
Location: Germany

Re: Installguide: MariaDB 10.3.x 64-Bit and hMailServer 5.x

Post by Besserwisser » 2019-06-30 16:18

Good installguide! MariaDB is also my preferred database in hMailServer. But I had to add the LOCK TABLES right for the user hmaildbusr. Otherwise the backup with mysqldump will not work with this user.
Version 5.6.8 - Build 2538, MariaDB 10.3 on Windows Server 2019

User avatar
fjansen04
Normal user
Normal user
Posts: 50
Joined: 2008-08-30 15:49
Location: The Netherlands

Re: Installguide: MariaDB 10.3.x 64-Bit and hMailServer 5.x

Post by fjansen04 » 2020-06-07 16:09

One addendum:

If you want to install hMailserver 64 bit, take this file:

C:\Program Files\MariaDB 10.X\lib\libmariadb.dll , put it in the hmailserver\bin directory and rename it to libmysql.dll
HMS 5.6.9-B2587.46 on Windows Server 2019

Besserwisser
New user
New user
Posts: 10
Joined: 2019-06-29 22:53
Location: Germany

Re: Installguide: MariaDB 10.3.x 64-Bit and hMailServer 5.x

Post by Besserwisser » 2020-08-08 12:30

New users may have the following questions:
1. The link above for MariaDB version 10.3.7 does not work. Can I start with the resent release of the MariaDB 10.3 series?
2. How do I update my MariaDB 10.3.x installation to the recent release of the MariaDB 10.3 serie?
3. Should I do an upgrade to MariaDB 10.4 or newer?
Version 5.6.8 - Build 2538, MariaDB 10.3 on Windows Server 2019

TopHatProductions115
New user
New user
Posts: 10
Joined: 2020-03-31 16:22

Re: Installguide: MariaDB 10.3.x 64-Bit and hMailServer 5.x

Post by TopHatProductions115 » 2021-03-25 01:24

Your guide worked beautifully for me. Thank you!

nat
Normal user
Normal user
Posts: 57
Joined: 2008-02-13 02:50
Location: US
Contact:

MariaDB 10.1 to MariaDB 10.6.5 64-Bit and hMailServer 5.x

Post by nat » 2021-11-23 18:14

My upgrade was quite a version jump from MariaDB 10.1 to MariaDB 10.6.5.

Your guild was very helpful to get it running again, so I thought I would add the steps I had to take before following your guide:
  • Installing 10.6 (port 3307 Service:MariaDB) alongside 10.1 (port 3306 service:MySQL)
  • Do a full export of all the databases using the new setup's mysqldump

    Code: Select all

    mysqldump --port=3306 -u root -p --all-databases --ignore-database=information_schema --ignore-database=mysql > allmydata.sql
  • Imported all my databases into the new MariaDB setup, using the new setup's mysql

    Code: Select all

    mysql --port=3307 -u root -p < allmydata.sql
  • Manually recreate all my MariaDB users (note that the "mysql user table system" is different) so no quick import but a manual reentry needed.
  • delete the old MySQL service dependency so I could afterwards remove the old database service (MySQL)

    Code: Select all

    sc config MySQL depend= ""
  • Remove the old database service

    Code: Select all

    sc delete MySQL
  • Changed MariaDB my.ini to use port 3306
  • uninstalled hMailserver. I did not remember my AdministratorPassword password anyway. So I just renamed the hMailServer.INI file so the install would to through the steps of creating a new one.
  • and start following the above instructions, but instead linking to the existing data.
  • used C:\Program Files (x86)\Common Files\MariaDBShared\HeidiSQL\libmysql.dll file ask explained above
Thanks to your guide I got back up and running again. Thank you.

User avatar
Dravion
Senior user
Senior user
Posts: 2071
Joined: 2015-09-26 11:50
Location: Germany
Contact:

Re: Installguide: MariaDB 10.3.x 64-Bit and hMailServer 5.x

Post by Dravion » 2022-02-03 12:25

You welcome

Post Reply