Page 1 of 1

Hmail db init problem against external mysql instance linux.

Posted: 2009-05-18 22:20
by sysbt
Hi,
I've been reading previous posts, but unable to solve this problem.

host A: hmail 511-b341 on w3k(32)-sp2, av mcafee enterprise, 512 mb, 1cpu, hosted on vmware-server 2 64b (latest build, clean build)
host B: MySQL 5.0.45 on Centos 5.3 64b , 2048 mb, 2cpu, hosted on vmware-server 2 64b (latest build, clean build)

problem scenario:
after install Myslq admin tools on host A (5.0.45) connecting to mysql instance on host B is ok and error free.

during hmail init db selection/init, installer reports libmysql.dll not found, cp into :

c:\program files\hmailserver\bin
c:\windows\system32

no joy.

error log

"ERROR" 1212 "2009-05-18 20:17:24.738" "Severity: 1 (Critical), Code: HM5094, Source: MySQLInterface::Load, Description: Error:[nl]The MySQL client (libmysql.dll, 32 bit) could not be loaded.[nl]hMailServer needs this file to be able to connect to MySQL.[nl]The MySQL client needs to be manually copied to the hMailServer Bin directory. The file is not included in the hMailServer installation.[nl]Path: C:\Program Files\hMailServer\Bin\libmysql.dll"

"ERROR" 3292 "2009-05-18 20:17:32.702" "Severity: 1 (Critical), Code: HM5094, Source: MySQLInterface::Load, Description: Error:[nl]The MySQL client (libmysql.dll, 32 bit) could not be loaded.[nl]hMailServer needs this file to be able to connect to MySQL.[nl]The MySQL client needs to be manually copied to the hMailServer Bin directory. The file is not included in the hMailServer installation.[nl]Path: C:\Program Files\hMailServer\Bin\libmysql.dll"

"ERROR" 3232 "2009-05-18 20:20:45.312" "Severity: 1 (Critical), Code: HM5094, Source: MySQLInterface::Load, Description: Error:[nl]The MySQL client (libmysql.dll, 32 bit) could not be loaded.[nl]hMailServer needs this file to be able to connect to MySQL.[nl]The MySQL client needs to be manually copied to the hMailServer Bin directory. The file is not included in the hMailServer installation.[nl]Path: C:\Program Files\hMailServer\Bin\libmysql.dll"

"ERROR" 3232 "2009-05-18 20:34:41.894" "Severity: 1 (Critical), Code: HM5094, Source: MySQLInterface::Load, Description: Error:[nl]The MySQL client (libmysql.dll, 32 bit) could not be loaded.[nl]hMailServer needs this file to be able to connect to MySQL.[nl]The MySQL client needs to be manually copied to the hMailServer Bin directory. The file is not included in the hMailServer installation.[nl]Path: C:\Program Files\hMailServer\Bin\libmysql.dll"

"ERROR" 3232 "2009-05-18 20:42:42.265" "Severity: 1 (Critical), Code: HM5094, Source: MySQLInterface::Load, Description: Error:[nl]The MySQL client (libmysql.dll, 32 bit) could not be loaded.[nl]hMailServer needs this file to be able to connect to MySQL.[nl]The MySQL client needs to be manually copied to the hMailServer Bin directory. The file is not included in the hMailServer installation.[nl]Path: C:\Program Files\hMailServer\Bin\libmysql.dll"

"ERROR" 3232 "2009-05-18 20:42:54.690" "Severity: 1 (Critical), Code: HM5094, Source: MySQLInterface::Load, Description: Error:[nl]The MySQL client (libmysql.dll, 32 bit) could not be loaded.[nl]hMailServer needs this file to be able to connect to MySQL.[nl]The MySQL client needs to be manually copied to the hMailServer Bin directory. The file is not included in the hMailServer installation.[nl]Path: C:\Program Files\hMailServer\Bin\libmysql.dll"

"ERROR" 3292 "2009-05-18 20:42:56.346" "Severity: 1 (Critical), Code: HM5094, Source: MySQLInterface::Load, Description: Error:[nl]The MySQL client (libmysql.dll, 32 bit) could not be loaded.[nl]hMailServer needs this file to be able to connect to MySQL.[nl]The MySQL client needs to be manually copied to the hMailServer Bin directory. The file is not included in the hMailServer installation.[nl]Path: C:\Program Files\hMailServer\Bin\libmysql.dll"

"ERROR" 1212 "2009-05-18 20:42:58.315" "Severity: 1 (Critical), Code: HM5094, Source: MySQLInterface::Load, Description: Error:[nl]The MySQL client (libmysql.dll, 32 bit) could not be loaded.[nl]hMailServer needs this file to be able to connect to MySQL.[nl]The MySQL client needs to be manually copied to the hMailServer Bin directory. The file is not included in the hMailServer installation.[nl]Path: C:\Program Files\hMailServer\Bin\libmysql.dll"

"ERROR" 3232 "2009-05-18 20:42:58.769" "Severity: 1 (Critical), Code: HM5094, Source: MySQLInterface::Load, Description: Error:[nl]The MySQL client (libmysql.dll, 32 bit) could not be loaded.[nl]hMailServer needs this file to be able to connect to MySQL.[nl]The MySQL client needs to be manually copied to the hMailServer Bin directory. The file is not included in the hMailServer installation.[nl]Path: C:\Program Files\hMailServer\Bin\libmysql.dll"

"ERROR" 3292 "2009-05-18 20:42:59.066" "Severity: 1 (Critical), Code: HM5094, Source: MySQLInterface::Load, Description: Error:[nl]The MySQL client (libmysql.dll, 32 bit) could not be loaded.[nl]hMailServer needs this file to be able to connect to MySQL.[nl]The MySQL client needs to be manually copied to the hMailServer Bin directory. The file is not included in the hMailServer installation.[nl]Path: C:\Program Files\hMailServer\Bin\libmysql.dll"

"ERROR" 1212 "2009-05-18 20:42:59.222" "Severity: 1 (Critical), Code: HM5094, Source: MySQLInterface::Load, Description: Error:[nl]The MySQL client (libmysql.dll, 32 bit) could not be loaded.[nl]hMailServer needs this file to be able to connect to MySQL.[nl]The MySQL client needs to be manually copied to the hMailServer Bin directory. The file is not included in the hMailServer installation.[nl]Path: C:\Program Files\hMailServer\Bin\libmysql.dll"

"ERROR" 3232 "2009-05-18 20:42:59.409" "Severity: 1 (Critical), Code: HM5094, Source: MySQLInterface::Load, Description: Error:[nl]The MySQL client (libmysql.dll, 32 bit) could not be loaded.[nl]hMailServer needs this file to be able to connect to MySQL.[nl]The MySQL client needs to be manually copied to the hMailServer Bin directory. The file is not included in the hMailServer installation.[nl]Path: C:\Program Files\hMailServer\Bin\libmysql.dll"

"ERROR" 3292 "2009-05-18 20:42:59.613" "Severity: 1 (Critical), Code: HM5094, Source: MySQLInterface::Load, Description: Error:[nl]The MySQL client (libmysql.dll, 32 bit) could not be loaded.[nl]hMailServer needs this file to be able to connect to MySQL.[nl]The MySQL client needs to be manually copied to the hMailServer Bin directory. The file is not included in the hMailServer installation.[nl]Path: C:\Program Files\hMailServer\Bin\libmysql.dll"

"ERROR" 1212 "2009-05-18 20:43:00.738" "Severity: 1 (Critical), Code: HM5094, Source: MySQLInterface::Load, Description: Error:[nl]The MySQL client (libmysql.dll, 32 bit) could not be loaded.[nl]hMailServer needs this file to be able to connect to MySQL.[nl]The MySQL client needs to be manually copied to the hMailServer Bin directory. The file is not included in the hMailServer installation.[nl]Path: C:\Program Files\hMailServer\Bin\libmysql.dll"

"ERROR" 3232 "2009-05-18 20:52:03.633" "Severity: 1 (Critical), Code: HM5094, Source: MySQLInterface::Load, Description: Error:[nl]The MySQL client (libmysql.dll, 32 bit) could not be loaded.[nl]hMailServer needs this file to be able to connect to MySQL.[nl]The MySQL client needs to be manually copied to the hMailServer Bin directory. The file is not included in the hMailServer installation.[nl]Path: C:\Program Files\hMailServer\Bin\libmysql.dll"

"ERROR" 3232 "2009-05-18 20:52:14.522" "Severity: 1 (Critical), Code: HM5094, Source: MySQLInterface::Load, Description: Error:[nl]The MySQL client (libmysql.dll, 32 bit) could not be loaded.[nl]hMailServer needs this file to be able to connect to MySQL.[nl]The MySQL client needs to be manually copied to the hMailServer Bin directory. The file is not included in the hMailServer installation.[nl]Path: C:\Program Files\hMailServer\Bin\libmysql.dll"

"ERROR" 3232 "2009-05-18 21:18:49.261" "Severity: 1 (Critical), Code: HM5094, Source: MySQLInterface::Load, Description: Error:[nl]The MySQL client (libmysql.dll, 32 bit) could not be loaded.[nl]hMailServer needs this file to be able to connect to MySQL.[nl]The MySQL client needs to be manually copied to the hMailServer Bin directory. The file is not included in the hMailServer installation.[nl]Path: C:\Program Files\hMailServer\Bin\libmysql.dll"

"ERROR" 2544 "2009-05-18 21:19:03.059" "Severity: 1 (Critical), Code: HM5094, Source: MySQLInterface::Load, Description: Error:[nl]The MySQL client (libmysql.dll, 32 bit) could not be loaded.[nl]hMailServer needs this file to be able to connect to MySQL.[nl]The MySQL client needs to be manually copied to the hMailServer Bin directory. The file is not included in the hMailServer installation.[nl]Path: C:\Program Files\hMailServer\Bin\libmysql.dll"


mysql error log on host B is showing:

090517 20:31:41 mysqld started
090517 20:31:42 InnoDB: Started; log sequence number 0 43655
090517 20:31:42 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.45' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution

during the attempt to init the db

anyone some ideas?

kind regards,

sysbt

Re: Hmail db init problem against external mysql instance linux.

Posted: 2009-05-18 22:36
by ^DooM^
You need to download libmysql.dll it does not come with hMail V5 as V5 is not open source.

Re: Hmail db init problem against external mysql instance linux.

Posted: 2009-05-18 22:50
by sysbt
Dear,

as stated initially, I've installed MySql admin tools for version 5.0 (latest) on the hmail host, and copied the corresponding file to the hmailserver\bin directory and in a second try equally c:\windows\system32 (suspecting a search path issue).
No joy.
Or am I just too quick and should regress to earlier version of the mysql edition (on linux).

kind regards,
sysbt

Re: Hmail db init problem against external mysql instance linux.

Posted: 2009-05-18 23:34
by ^DooM^
I was unaware libmysql came with MySQL Admin Tools and you did not mention that it did either :)

Try the one attached, it is the one I am using.
libmysql.zip
libmysql.dll
(606.28 KiB) Downloaded 25805 times

Re: Hmail db init problem against external mysql instance linux.

Posted: 2009-05-19 00:10
by sysbt
Hi Doom,

It seem that the libmysql from 5.0 is not yet fitted into the install scripts/calls for hmail.
The file you've send me is half the size of the 5.0 one, but it worked like a blink.
Thanks very much.
What version of mysql for crime-o-soft is this coming from?
Possibly this should be posted, as other users could run into the same sh*t. Or is the forum enough (newbe to forums)
Anyway thanks.

ps libmysql.dll is always installed with adm mysql tools.

sysbt

Re: Hmail db init problem against external mysql instance linux.

Posted: 2009-05-19 00:19
by ^DooM^
I use PHPMyAdmin and always have :D

libmysql.dll is not allowed to be distributed with hMail so the forums will have to do ;) The version i attached is the one that came with V4.

Re: Hmail db init problem against external mysql instance linux.

Posted: 2009-05-19 01:02
by sysbt
Dear Doom,

Maybe to prevent other people some loooong nights, some info for the community?
Is there a way to post this issue, in clear text, to the community?
I can/will provide the docu, but I've no idea on how to publish this (on public forums).
kind regards,
sysbt

Re: Hmail db init problem against external mysql instance linux.

Posted: 2009-05-19 01:03
by ^DooM^
Don't worry about it. If people post in the future i'll just point them here :)