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: 1413
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: 20000
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: 1413
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: 5
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.

Post Reply