MYsql DB installation

Use this forum if you have installed hMailServer and want to ask a question related to a production release of hMailServer. Before posting, please read the troubleshooting guide. A large part of all reported issues are already described in detail here.
Post Reply
4evernoob
New user
New user
Posts: 2
Joined: 2019-02-24 19:46

MYsql DB installation

Post by 4evernoob » 2019-02-24 19:51

I installed the latest mysql db v8x and when I run the dbsetup I get this

Starting task...
Please wait while creating database...
Error:
The MySQL client (libmysql.dll, 32 bit) could not be loaded.
hMailServer needs this file to be able to connect to MySQL.
The MySQL client needs to be manually copied to the hMailServer Bin directory. The file is not included in the hMailServer installation.
Path: C:\Program Files (x86)\hMailServer\Bin\libmysql.dll

I have copied that dll from the mysql server directory but no joy.

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

Re: MYsql DB installation

Post by jimimaseye » 2019-02-24 21:38

viewtopic.php?f=10&t=33531

[Entered by mobile. Excuse my spelling.]
HMS 5.6.6 B2383 on Win Server 2008 R2 Foundation, + 5.6.7-B2415 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
mattg
Moderator
Moderator
Posts: 20108
Joined: 2007-06-14 05:12
Location: 'The Outback' Australia

Re: MYsql DB installation

Post by mattg » 2019-02-25 00:54

You need to use the 32 bit dll, even for a 64 bit database
Just 'cause I link to a page and say little else doesn't mean I am not being nice.
https://www.hmailserver.com/documentation

4evernoob
New user
New user
Posts: 2
Joined: 2019-02-24 19:46

Re: MYsql DB installation

Post by 4evernoob » 2019-02-25 03:29

Thanks that got it. I used the LTS version and everything works.

User avatar
Lumuss
New user
New user
Posts: 2
Joined: 2019-02-14 13:16

Re: MYsql DB installation

Post by Lumuss » 2019-02-26 11:54

viewtopic.php?f=10&t=33531

[Entered by mobile. Excuse my spelling.]
I thought MySQL and MariaDB have different GTID system variables. Is that correct? Thus, there should be made some adjustments while migrating as I'm guessing.

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

Re: MYsql DB installation

Post by Dravion » 2019-02-26 12:42

Its not a Problem because hMailServers DDL and DML Queries are quite ANSI SQL 92 compliant.
The only permissions required are SELECT, INSERT, UPDATE and DELETE for everyday operations and DB Admin permissions if you want to update hMailServer.

Libmysql.dll 5.24+ (Connector/C) must be used which is ABI compatible with MariaDB 10.4+ and above.

You only run into trouble if you use a version 6.x of libmysql.dll because its ABI isnt binary compatible anymore.

Post Reply