unable to install IMC 5.1 on a RHEL Linux with Mysql (2411 Views)
Reply
Occasional Advisor
Huet_Gildas
Posts: 7
Registered: ‎08-17-2012
Message 1 of 22 (2,411 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

Please use plain text.
Advisor
fgiraud
Posts: 16
Registered: ‎05-05-2010
Message 2 of 22 (2,382 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

Please use plain text.
Occasional Advisor
Huet_Gildas
Posts: 7
Registered: ‎08-17-2012
Message 3 of 22 (2,379 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 ?

 

 

Please use plain text.
Advisor
fgiraud
Posts: 16
Registered: ‎05-05-2010
Message 4 of 22 (2,368 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

Please use plain text.
Advisor
fgiraud
Posts: 16
Registered: ‎05-05-2010
Message 5 of 22 (2,356 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

 

Please use plain text.
Advisor
fgiraud
Posts: 16
Registered: ‎05-05-2010
Message 6 of 22 (2,340 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

Please use plain text.
Advisor
fgiraud
Posts: 16
Registered: ‎05-05-2010
Message 7 of 22 (2,337 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

Please use plain text.
Occasional Advisor
Huet_Gildas
Posts: 7
Registered: ‎08-17-2012
Message 8 of 22 (2,311 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

Please use plain text.
Advisor
fgiraud
Posts: 16
Registered: ‎05-05-2010
Message 9 of 22 (2,293 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

Please use plain text.
Occasional Advisor
Huet_Gildas
Posts: 7
Registered: ‎08-17-2012
Message 10 of 22 (2,288 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 ?

Please use plain text.
Advisor
fgiraud
Posts: 16
Registered: ‎05-05-2010
Message 11 of 22 (2,285 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

Please use plain text.
Advisor
fgiraud
Posts: 16
Registered: ‎05-05-2010
Message 12 of 22 (2,284 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

Please use plain text.
Occasional Advisor
jmacd
Posts: 4
Registered: ‎10-31-2012
Message 13 of 22 (2,088 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.
Please use plain text.
Occasional Visitor
Soeren Harms
Posts: 2
Registered: ‎12-18-2009
Message 14 of 22 (2,050 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

 

 

Please use plain text.
Occasional Advisor
Huet_Gildas
Posts: 7
Registered: ‎08-17-2012
Message 15 of 22 (2,039 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

Please use plain text.
Advisor
Max Pierre
Posts: 22
Registered: ‎10-25-2007
Message 16 of 22 (2,029 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

 

Please use plain text.
Regular Visitor
SElaschuk
Posts: 5
Registered: ‎01-09-2013
Message 17 of 22 (1,879 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?

Please use plain text.
Honored Contributor
Peter_Debruyne
Posts: 290
Registered: ‎03-21-2011
Message 18 of 22 (1,873 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.

 

Please use plain text.
Regular Visitor
SElaschuk
Posts: 5
Registered: ‎01-09-2013
Message 19 of 22 (1,869 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!

Please use plain text.
Occasional Advisor
Huet_Gildas
Posts: 7
Registered: ‎08-17-2012
Message 20 of 22 (1,861 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

 

Please use plain text.
Occasional Visitor
Cushabitat
Posts: 1
Registered: ‎03-27-2013
Message 21 of 22 (1,542 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

Please use plain text.
Occasional Collector
scyiping
Posts: 1
Registered: ‎09-16-2013
Message 22 of 22 (873 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
Please use plain text.
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