topic Re: unable to install IMC 5.1 on a RHEL Linux with Mysql in IMC

unable to install IMC 5.1 on a RHEL Linux with Mysql

Huet_Gildas — Fri, 17 Aug 2012 09:58:16 GMT

Hello,

I try to install IMC 5.1 on a RHEL Linux ( 6.3 x64 ), this server is a Vmware virtual machine.
The launch of install.sh work fine, but when I try to connect to a Mysql Server ( either localhost or remote host ), I got an install error (cf png attached files) .
The mysql servers are 5.1( .61 for local and .49 for remote)
I can connect to them with mysql client without problem ( mysql -h xxx -uxxxx -pxxxx )
I have made a tcp capture between IMC server and Remote Mysql Server, It seems to work fine ( cf attached pcap zipped file).
I try t activate java debug (log), but the reason doesn"t clearly appear ! :-(

Did someone have the same Issue ?

Regards,
Gildas Huet

Re: unable to install IMC 5.1 on a RHEL Linux with Mysql

fgiraud — Wed, 22 Aug 2012 15:01:18 GMT

Hello,

First of all, you have to verify your DB is well configured :

On the mysql server, did you copy file my-huge.cnf (typically located in /usr/share/mysql/my-huge.cnf) to /etc/my.cnf ?
In this file my.cnf, did you make the following changes :

Add the max_connections parameter under [mysqld]. If this parameter already exists, you can change the value.

[mysqld]

max_connections=200

Configure the Character set:

[mysqld]

default-character-set=latin1

Configure Engine Type

[mysqld]

default-storage-engine = INNODB

Configure case insensitive table names

[mysqld]

lower_case_table_names=1

Disabling log-bin settings

[mysqld]

#log-bin=mysql-bin

Set innodb buffer sizes

[mysqld]

innodb_buffer_pool_size=512M

innodb_additional_mem_pool_size=16M

Set the max allowed packet size

[mysqld]

max_allowed_packet = 200M

After all that conf, you'll have to restart mysql

Then if this is still not working verify you don't use any special character in your admin db password (such as @ for example), IMC doesn't support it.

Hopes this help.

Fabien

Re: unable to install IMC 5.1 on a RHEL Linux with Mysql

Huet_Gildas — Wed, 22 Aug 2012 15:26:22 GMT

Thank for your response.

I try exactly what you have explain, but it doesn't work better :-(

I use the same root username in mysql and IMC (with a 'simple' password, is IMC qwerty/azerty sensible ???)

or must I use another username for IMC/MYSQL ?

I join a log with dump of mysql variables.

Thank

PS : @Fabien : are you French too ?

Re: unable to install IMC 5.1 on a RHEL Linux with Mysql

fgiraud — Thu, 23 Aug 2012 07:57:49 GMT

Hi,

I will check all my mySQL parameters and let you know.

Et oui je suis français également ...

Fabien

Re: unable to install IMC 5.1 on a RHEL Linux with Mysql

fgiraud — Thu, 23 Aug 2012 08:18:12 GMT

So,

Let's keep talking English for other potential visitors.

As you can see in the attached file, the only significant differences betwwen your parameters and mine are :

" | log_bin | ON " on my server and OFF on yours
" | sql_mode | STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION " on my server and empty on yours.

I am not sure this will change anything so I'll have a look on your pcap file you joined in your first post (I didn't yet have a look on it).

Regards,

Fabien

Re: unable to install IMC 5.1 on a RHEL Linux with Mysql

fgiraud — Thu, 23 Aug 2012 09:02:34 GMT

Well, it seems very strange.

In the capture file we can see IMC can connect to the database and make some request. So I don't think it's a connection issue.

Perhaps one or more replies for some request are not the ones expected by IMC.

So can you find the instal log in order to see if there are more details (I think it is located in /tmp/ directory but not sure).

Regards,

Fabien

Re: unable to install IMC 5.1 on a RHEL Linux with Mysql

fgiraud — Thu, 23 Aug 2012 09:03:25 GMT

And can you also post your environment variables on your db server ?

Thanks

Re: unable to install IMC 5.1 on a RHEL Linux with Mysql

Huet_Gildas — Mon, 14 Sep 2020 20:02:28 GMT

I didn't find any log of IMC install

here is the server env variables ( via shell -> set )

NOTE: File attachment removed for security reasons on 09/14/2020 by Admin

Kind regards

Re: unable to install IMC 5.1 on a RHEL Linux with Mysql

fgiraud — Mon, 27 Aug 2012 08:30:35 GMT

Hello,

Sorry, I can't find anything wrong in your environment. I was looking for something like "LANG=fr" but your configuration is very closed to mine.

One thing I think I forgot in the mysql conf, did you grant following privileges to the user you used to connect from IMC (in my case root) :

grant all privileges on *.* to root@'%' identified by 'mysql' with grant option;

Regards,

Fabien

Re: unable to install IMC 5.1 on a RHEL Linux with Mysql

Huet_Gildas — Mon, 27 Aug 2012 09:39:38 GMT

first : thanx for your work about this issue.

Which versions of IMC, Mysql and Linux did you use ? in 32/64 bits ?

Re: unable to install IMC 5.1 on a RHEL Linux with Mysql

fgiraud — Mon, 27 Aug 2012 09:56:47 GMT

So I use two linux servers :

Database server :
Red Hat Enterprise Linux Server release 5.4
Mysql : Server version: 5.1.60-log MySQL Community Server (GPL)
IMC server :
Red Hat Enterprise Linux Server release 5.4
IMC 5.1 SP1 Enterprise Edition

Regards,

Fabien

Re: unable to install IMC 5.1 on a RHEL Linux with Mysql

fgiraud — Mon, 27 Aug 2012 09:59:05 GMT

I forgot to tell you both are 64 bits version.

Regards,

Fabien

Re: unable to install IMC 5.1 on a RHEL Linux with Mysql

jmacd — Wed, 31 Oct 2012 23:16:06 GMT

Once all the mysql privileges are correct ... Check the host table - seems silly but if you don't have a mapping for your ip to proper hostname certain parts of the install will fail.

Edit /etc/hosts and add :

X.x.x.x Hostname
Where x.x.x.x is the ip and hostname is your server name.

Then restart the install.

Re: unable to install IMC 5.1 on a RHEL Linux with Mysql

Soeren Harms — Tue, 20 Nov 2012 17:27:53 GMT

Have you found a solution for this problem?

I get the same error: "connection to the database failed" but I can see querys at the mysql query log.

Regards

Heino

Re: unable to install IMC 5.1 on a RHEL Linux with Mysql

Huet_Gildas — Thu, 22 Nov 2012 09:59:20 GMT

Hello,

no I haven't found a solution ! :-(

wich version of RHEL did you use ?

Regards,

Gildas

Re: unable to install IMC 5.1 on a RHEL Linux with Mysql

Max Pierre — Thu, 22 Nov 2012 15:10:19 GMT

Hi,

Same problem here but with the configuration :

CentOS 6.3 X64 (2.6.32-279.el6.x86_64)

MySQL 5.1.61

IMC Std 5.1

I am able to connect to MySQL from the shell but IMC installation fails the step "Checking database connectivity"

Have no idea where to look for as this error message is so helpfull :-)

Thanks in advance for any help

Pierre

Re: unable to install IMC 5.1 on a RHEL Linux with Mysql

SElaschuk — Wed, 09 Jan 2013 17:38:06 GMT

Having the exact same issue. Was a fix ever found for it?

Re: unable to install IMC 5.1 on a RHEL Linux with Mysql

Peter_Debruyne — Wed, 09 Jan 2013 19:00:53 GMT

Hi,

I also ran into this and I was told to install the following 32bit libraries as well on the 64bit platform:

glibc-2.12-1.47.el6.i686.rpm
libaio-0.3.107-10.el6.i686.rpm
libgcc-4.4.6-3.el6.i686.rpm
libstdc++-4.4.6-3.el6.i686.rpm

Make sure to verify first with

"rpm -qa | grep lib"

that the 32bit version you will be installing are matching the currently installed 64bit versions.

This plus the tip on the hosts file made it work for me.

Re: unable to install IMC 5.1 on a RHEL Linux with Mysql

SElaschuk — Wed, 09 Jan 2013 20:05:52 GMT

Ah, the 32 bit libraries are what did it. Thanks so much!

Re: unable to install IMC 5.1 on a RHEL Linux with Mysql

Huet_Gildas — Thu, 10 Jan 2013 10:30:30 GMT

Hello

for me, only the libaio-0.3.107-10.el6.i686.rpm was missing.

I install it, and now it works fine !!! :-)

Thank you very much.

Kind Regards

Gildas Huet