Issue to connect

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
PeterChan
Normal user
Normal user
Posts: 65
Joined: 2018-06-23 15:45

Issue to connect

Post by PeterChan » 2019-10-31 06:56

Hi,
Any help to error below?
Attachments
4c.png

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

Re: Issue to connect

Post by mattg » 2019-10-31 08:38

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
Just 'cause I link to a page and say little else doesn't mean I am not being nice.
https://www.hmailserver.com/documentation

PeterChan
Normal user
Normal user
Posts: 65
Joined: 2018-06-23 15:45

Re: Issue to connect

Post by PeterChan » 2019-10-31 10:05

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

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

Re: Issue to connect

Post by Dravion » 2019-10-31 10:32

Check if MySQL Service is running and try again

PeterChan
Normal user
Normal user
Posts: 65
Joined: 2018-06-23 15:45

Re: Issue to connect

Post by PeterChan » 2019-11-05 10:00

Yes, MySQL80 is running.

User avatar
RvdH
Senior user
Senior user
Posts: 918
Joined: 2008-06-27 14:42
Location: Netherlands

Re: Issue to connect

Post by RvdH » 2019-11-05 11:03

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
CIDR to RegEx: d-fault.nl/CIDRtoRegEx
DNS Lookup: d-fault.nl/DNSTools
DNSBL Lookup: d-fault.nl/DNSBLLookup
GEOIP Lookup: d-fault.nl/GeoipLookup

PeterChan
Normal user
Normal user
Posts: 65
Joined: 2018-06-23 15:45

Re: Issue to connect

Post by PeterChan » 2019-11-09 17:36

Please see the file below and how to know its exact version?
5b.png
5b.png (7.54 KiB) Viewed 1873 times
Does it mean I should not use MySQL80?

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

Re: Issue to connect

Post by Dravion » 2019-11-09 17:50

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
Normal user
Normal user
Posts: 65
Joined: 2018-06-23 15:45

Re: Issue to connect

Post by PeterChan » 2019-11-21 05:21

MySQL57 (version 5.7.28) service is up and running and how to resolve issue below
5j.png
to ensure hMailserver would be connecting to MySQL57?

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

Re: Issue to connect

Post by mattg » 2019-11-21 06:19

you need a 32 bit version of libmysql.dll
Just 'cause I link to a page and say little else doesn't mean I am not being nice.
https://www.hmailserver.com/documentation

PeterChan
Normal user
Normal user
Posts: 65
Joined: 2018-06-23 15:45

Re: Issue to connect

Post by PeterChan » 2019-11-21 07:09

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?

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

Re: Issue to connect

Post by mattg » 2019-11-21 07:22

yes

exactly what we are saying

hMailserver is 32 bit, it needs the 32 bit .dll to connect to the 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

PeterChan
Normal user
Normal user
Posts: 65
Joined: 2018-06-23 15:45

Re: Issue to connect

Post by PeterChan » 2019-11-25 08:55

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

User avatar
nitro
Normal user
Normal user
Posts: 35
Joined: 2018-11-08 16:31
Location: Spain

Re: Issue to connect

Post by nitro » 2019-11-25 14:58

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
Attachments
MySql.jpg
Production 5.6.8-B2489.22.RvDH W.Server 2016 Datace [2x Intel Xeon E5-2660 8GB RAM]
Staging 5.7-B2490 W.Server 2008 R2 Stand [Intel Pentium 4 4GB RAM]

PeterChan
Normal user
Normal user
Posts: 65
Joined: 2018-06-23 15:45

Re: Issue to connect

Post by PeterChan » 2019-11-26 03:55

Yes, I can access MySQL 5.7 using root password. Here is what I've got with telnet command (on port 3306).
6d.png
6d.png (6.67 KiB) Viewed 1448 times

User avatar
nitro
Normal user
Normal user
Posts: 35
Joined: 2018-11-08 16:31
Location: Spain

Re: Issue to connect

Post by nitro » 2019-11-26 16:29

Intente seguir el procedimiento para confirmar que usa la dll correcta.
https://www.hmailserver.com/forum/viewtopic.php?t=31562
Production 5.6.8-B2489.22.RvDH W.Server 2016 Datace [2x Intel Xeon E5-2660 8GB RAM]
Staging 5.7-B2490 W.Server 2008 R2 Stand [Intel Pentium 4 4GB RAM]

Post Reply