Version issue

HuaMin Chen
HuaMin Chen used Ask the Experts™
on
Hi,
How to resolve version below, as I did copy the file from the path below?

C:\Program Files\MySQL\MySQL Server 5.7\lib

0a.png
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
the answer is trivial and was alreaduy provided in another thread.

i believe your problem lies elsewhere. are you a native english speaker ? would you like help in a different language ?
HuaMin ChenProblem resolver

Author

Commented:
What is reason of this?
What other language do you expect to talk?
Most Valuable Expert 2015
Distinguished Expert 2018

Commented:
C:\Program Files\MySQL\MySQL Server 5.7\lib is the folder for 64-bit programs.

Copy the file from a 32-bit install in:

C:\Program Files (x86)\MySQL\MySQL Server 5.7\lib
How to Generate Services Revenue the Easiest Way

This Tuesday! Learn key insights about modern cyber protection services & gain practical strategies to skyrocket business:

- What it takes to build a cloud service portfolio
- How to determine which services will help your unique business grow
- Various use-cases and examples

HuaMin ChenProblem resolver

Author

Commented:
Sorry to that I can not find out such file within the path below.

C:\Program Files (x86)\MySQL
Most Valuable Expert 2015
Distinguished Expert 2018

Commented:
You will probably have to install the 32-bit client.
HuaMin ChenProblem resolver

Author

Commented:
Do you have exact download of that?
Most Valuable Expert 2015
Distinguished Expert 2018

Commented:
It would be here:

MySQL Community Downloads

You problem seems resolved here:

64bit MySQL requires 32bit libmysql.dll
HuaMin ChenProblem resolver

Author

Commented:
I put the attached file to the path (which is C:\Program Files (x86)\hMailServer\Bin)  but I've got this error

0b.pnglibmysql.dll
Most Valuable Expert 2015
Distinguished Expert 2018

Commented:
That you will have to resolve with the administrator of the MySQL instance.
you need to grand adequate privileges to the hmail user on that server
HuaMin ChenProblem resolver

Author

Commented:
you need to grand adequate privileges to the hmail user on that server
Can I have more details?
somebody else already answered that in your other thread and i elaborated on privileges that can be revoked once the initial setup is performed.

how to grant a privilege in mysql is widely documented on the internet. i will help if you give proper details regarding your architecture, what you tried, what you expected and did not go as expected. if you are the database administrator, this should be trivial. if you are not, simply ask whoever that is.
Distinguished Expert 2017

Commented:
Huamin,

I think we dealt with just this issue almost two or three months ago.

The hmailserver being a 32 bit application can only use 32 bit MySQL which I think limits you to the 5.1 version.


Is there a reason you keep trying to use hmailserver?

If you are open to running your mailserver on a Linux platform, given you are using MySQL... That will open a much larger array of options
And you'll get more out of the system for ....... From a resource use..

Though it would likely take more of your time to set it up since you have to add modules/components as needed.

Postfix, courier ...
HuaMin ChenProblem resolver

Author

Commented:
Thanks to all.

Arnold,

Agree to you. Postfix, courier, could be good Email option in Ubuntu, CentOS, right?
Distinguished Expert 2017

Commented:
Yes, in any Linux distro. The choice of which Linux to use is based on preference
Centos provides stable platform that ages out
Ubuntu/Debian and others provide renewing options ....
HuaMin ChenProblem resolver

Author

Commented:
It means very limited in Windows, with MySQL, right?
if you are uncomfortable with unix boxes, you may use an appliance.
openexchange, zimbra, and a few others provide free downloadable images

paid manageable equivalents include communigate, ms-exchange, ...

--

using a 32bits application forces you to use a 32 bits connector. nothing requires to use a 32 bits mysql server when the connector is 32 bits.
--
postfix is not an equivalent for hmail in itself. postix+dovecot would be.
HuaMin ChenProblem resolver

Author

Commented:
Do you mean, postfix+dovecot=hMailserver? Would both postfix and dovecot work fine in Ubuntu/CentOS, right?

I would choose it.
Distinguished Expert 2017

Commented:
Yes, there are many options on Linux to setup as a mail server with various operating back ends.......
yes. they would cover what hmail does. postfix will take care of relaying email. dovecot would take care of storing said email and make it available to the users over pop and imap. you might need a webmail as well. roundcube is quite simple to setup.

postfix must be configured with the adequate local_domain and probably some relay_ips

dovecot requires a little configuration. most likely the package installer will activate lmtp or the builtin lda and configure postfix to use it. you'll have to configure the users backend, most likely either using an existing ldap or the local system authentication.

if the above seems complicated, you probably should not try to do it yourself as you'll likely end up over your head
sticking to hmail seems a reasonable choice since you already know it and are used to it. ... unless you have an actual problem with hmail.
Distinguished Expert 2017
Commented:
The problem is that MySQL no longer offers new 32 bit versions while hmail is a 32 bit application that requires a 32 bit MySQL dll to gain access to MySQL server...using older version might work with sone newer MySQL version but it may end......

Though a re-check for community version download has an added step to get 32 bit installer which missed since the main ..... Did not include a 32 bit version like it used to.


https://dev.mysql.com/downloads/windows/installer/8.0.html
Distinguished Expert 2017

Commented:
There are many guides on setting up postfix with added components depending what you need
Postfix, dovecot, maildrop, spamassassin, clamav, MySQL, mariadb, PostgreSQL, LDAP/openldap
Different GUI administrative tools are available, or you can get commercial cpanel and others......

Much depends on your line of business and what you need.
using older version might work with sone newer MySQL version but it may end

yeah, that is fairly possible. nevertheless mysql has been backwards compatible since mysql 3 and possibly before. the only current requirement with very old clients is to stick with the authentication method that was used at the time.

--

regarding postix/dovecot/... i have quite the experience with those and i honestly do not believe the author will be comfortable with them. maybe mdaemon, communigate, or some other vendor's would be easier to deal with... and come with some support regarding the initial setup.

--

older mysql versions are available from the archives as well should there be a compatibility issue with the newer ones : https://downloads.mysql.com/archives/c-c/ 
https://cdn.mysql.com/archives/mysql-connector-c/mysql-connector-c-6.1.11-win32.msi should contain the required libmysql.dll
open it with an archive manager such as 7zip, and extract the dll ... or pick the attached file
F.lib.libmysql.dll

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial