Installguide: MariaDB 10.3.x 64-Bit and hMailServer 5.x
Installguide: MariaDB 10.3.x 64-Bit and hMailServer 5.x
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: 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.
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: 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.
Re: Installguide: MariaDB 10.3.x 64-Bit and hMailServer 5.x
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
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
https://www.hmailserver.com/documentation
Re: Installguide: MariaDB 10.3.x 64-Bit and hMailServer 5.x
Hi Matt,mattg wrote: ↑2018-07-01 02:44Don'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
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.
Re: Installguide: MariaDB 10.3.x 64-Bit and hMailServer 5.x
Thx, works fine!
On Win10 64Bit i found the libary here: C:\Program Files (x86)\Common Files\MariaDBShared\HeidiSQL\libmysql.dll
On Win10 64Bit i found the libary here: C:\Program Files (x86)\Common Files\MariaDBShared\HeidiSQL\libmysql.dll
-
- New user
- Posts: 10
- Joined: 2019-06-29 22:53
- Location: Germany
Re: Installguide: MariaDB 10.3.x 64-Bit and hMailServer 5.x
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
Re: Installguide: MariaDB 10.3.x 64-Bit and hMailServer 5.x
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
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
-
- New user
- Posts: 10
- Joined: 2019-06-29 22:53
- Location: Germany
Re: Installguide: MariaDB 10.3.x 64-Bit and hMailServer 5.x
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?
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
-
- New user
- Posts: 10
- Joined: 2020-03-31 16:22
Re: Installguide: MariaDB 10.3.x 64-Bit and hMailServer 5.x
Your guide worked beautifully for me. Thank you!
MariaDB 10.1 to MariaDB 10.6.5 64-Bit and hMailServer 5.x
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:
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