Issue to connect

[PeterChan]

Hi,
Any help to error below?

[mattg]

You aren't giving us much to work with

Is this a clean install?
What has recently changed?

Show the contents of your hMailserver.ini with the passwords changed to the text '***password***' please

[PeterChan]

See below

[Directories]
ProgramFolder=C:\Program Files (x86)\hMailServer
DatabaseFolder=
DataFolder=C:\Program Files (x86)\hMailServer\Data
LogFolder=C:\Program Files (x86)\hMailServer\Logs
TempFolder=C:\Program Files (x86)\hMailServer\Temp
EventFolder=C:\Program Files (x86)\hMailServer\Events
[GUILanguages]
ValidLanguages=english,swedish
[Security]
AdministratorPassword=???
[Database]
Type=MYSQL
Username=root
Password=???
PasswordEncryption=1
Port=3306
Server=127.0.0.1
Database=hmail
Internal=0

[Dravion]

Check if MySQL Service is running and try again

[PeterChan]

Yes, MySQL80 is running.

[RvdH]

What libmysql.dll do you have? Currently hmailserver is only working with libmysql.dll 5.x and won't work with libmysql.dll 8.x

[PeterChan]

Please see the file below and how to know its exact version?

5b.png (7.54 KiB) Viewed 5142 times

Does it mean I should not use MySQL80?

[Dravion]

If you have Visual Studio 2013 installed, you can see if you running the 32 or 64 Bit version of libmysql.dll by running this command

dumpbin /headers "C:\Program Files\MySQL\MySQL Server 8.0\lib\libmysql.dll" | findstr "machine"

Result could be: machine (x64) which means it is a 64-Bit DLL.

But be careful!
hMailServer 32-Bit can only use 32-Bit versions of libmysql.dll while x64 (64-Bit Versions) can only use 64-Bit Version of libmysql.dll.
You also need to be aware that libmysql.dll Version after 5.24.x will not work. If you install MySQL Database server version 8.x the libmysql.dll
version which can bin found in the MySQL Installfolder \ lib Directory doesn't work with any version of hMailServer. Your need a version 5.24.x but not later!

[PeterChan]

MySQL57 (version 5.7.28) service is up and running and how to resolve issue below

to ensure hMailserver would be connecting to MySQL57?

[mattg]

you need a 32 bit version of libmysql.dll

[PeterChan]

Currently, file below

C:\Program Files\MySQL\MySQL Server 5.7\lib\libmysql.dll

is 64-bit. Does it mean it would be fine if 32-bit libmysql.dll file is being used?

[mattg]

yes

exactly what we are saying

hMailserver is 32 bit, it needs the 32 bit .dll to connect to the database

[PeterChan]

I already set up 5.7.28 (32-bit) on server but I still have got the issue below

[nitro]

Can you confirm that the database is accessible using a MySql administrator such as MySQL Workbench?

You can also try a telnet to the address and port of Mysql where you should get an answer

[PeterChan]

Yes, I can access MySQL 5.7 using root password. Here is what I've got with telnet command (on port 3306).

6d.png (6.67 KiB) Viewed 4717 times

[nitro]

Intente seguir el procedimiento para confirmar que usa la dll correcta.
https://www.hmailserver.com/forum/viewtopic.php?t=31562