unable to install IMC 5.1 on a RHEL Linux with Mysql (4837 Views)
Reply
Occasional Advisor
Posts: 7
Registered: ‎08-17-2012
Message 1 of 24 (4,837 Views)
Accepted Solution

unable to install IMC 5.1 on a RHEL Linux with Mysql

[ Edited ]

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

Advisor
Posts: 16
Registered: ‎05-05-2010
Message 2 of 24 (4,807 Views)

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

Hello,

 

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

  1. On the mysql server, did you copy file my-huge.cnf (typically located in /usr/share/mysql/my-huge.cnf) to /etc/my.cnf ?
  2. 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

Occasional Advisor
Posts: 7
Registered: ‎08-17-2012
Message 3 of 24 (4,804 Views)

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

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 ?

 

 

Advisor
Posts: 16
Registered: ‎05-05-2010
Message 4 of 24 (4,793 Views)

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

Hi,

 

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

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

 

Fabien

Advisor
Posts: 16
Registered: ‎05-05-2010
Message 5 of 24 (4,781 Views)

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

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

 

Advisor
Posts: 16
Registered: ‎05-05-2010
Message 6 of 24 (4,765 Views)

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

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

Advisor
Posts: 16
Registered: ‎05-05-2010
Message 7 of 24 (4,762 Views)

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

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

 

Thanks

Occasional Advisor
Posts: 7
Registered: ‎08-17-2012
Message 8 of 24 (4,736 Views)

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

I didn't find any log of IMC install :-(

 

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

 

Kind regards

Advisor
Posts: 16
Registered: ‎05-05-2010
Message 9 of 24 (4,718 Views)

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

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

Occasional Advisor
Posts: 7
Registered: ‎08-17-2012
Message 10 of 24 (4,713 Views)

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

first : thanx for your work about this issue.

 

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

Advisor
Posts: 16
Registered: ‎05-05-2010
Message 11 of 24 (4,710 Views)

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

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

Advisor
Posts: 16
Registered: ‎05-05-2010
Message 12 of 24 (4,709 Views)

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

I forgot to tell you both are 64 bits version.

 

Regards,

Fabien

Occasional Advisor
Posts: 4
Registered: ‎10-31-2012
Message 13 of 24 (4,514 Views)

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

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.
Occasional Visitor
Posts: 2
Registered: ‎12-18-2009
Message 14 of 24 (4,476 Views)

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

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

 

 

Occasional Advisor
Posts: 7
Registered: ‎08-17-2012
Message 15 of 24 (4,465 Views)

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

Hello,

 

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

 

wich version of RHEL did you use ?

 

Regards,

Gildas

Advisor
Posts: 22
Registered: ‎10-25-2007
Message 16 of 24 (4,455 Views)

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

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

 

Regular Visitor
Posts: 5
Registered: ‎01-09-2013
Message 17 of 24 (4,305 Views)

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

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

Honored Contributor
Posts: 334
Registered: ‎03-21-2011
Message 18 of 24 (4,299 Views)

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

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.

 

Regular Visitor
Posts: 5
Registered: ‎01-09-2013
Message 19 of 24 (4,295 Views)

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

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

Occasional Advisor
Posts: 7
Registered: ‎08-17-2012
Message 20 of 24 (4,287 Views)

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

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

 

Occasional Visitor
Posts: 1
Registered: ‎03-27-2013
Message 21 of 24 (3,968 Views)

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

 

Hello all,

 

if you still have the problem, this support manual is a little more accurate than the package provided one.

Enjoy.

 http://bizsupport1.austin.hp.com/bc/docs/support/SupportManual/c03382658/c03382658.pdf

 

Greg

Occasional Collector
Posts: 1
Registered: ‎09-16-2013
Message 22 of 24 (3,299 Views)

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

hi ! the document
http://bizsupport1.austin.hp.com/bc/docs/support/SupportManual/c03382658/c03382658.pdf
just mention that mysql should be un-installed.

what should be installed ?

tks
Esteemed Contributor
Posts: 655
Registered: ‎04-03-2011
Message 23 of 24 (2,279 Views)

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

Once again Peter proves why he's an Honored Contributor. Well done.

I can't believe the installation process is so lame. It really doesn't fill me with confidence about the software. We'll see how it goes over the next few weeks.
Regards,
Paul
Occasional Visitor
Posts: 1
Registered: ‎08-30-2014
Message 24 of 24 (1,547 Views)

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

It seems that iMC's installation wizard only checks the mysqld process parameters..

 

So rather than relying on the my.cnf, stop the mysqld process (either via init.d script or kill) and manually run the mysqld executable binary with the --max-allowed-packet=256M and --max-connections=400 parameters.. run:

 

mysqld --max-allowed-packet=256M --max-connections=400

 

 

The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation.