unable to install IMC 5.1 on a RHEL Linux with Mysql

[Huet_Gildas]

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

[fgiraud]

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

[Huet_Gildas]

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 ?

[fgiraud]

Hi,

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

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

Fabien

[fgiraud]

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

[fgiraud]

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

[fgiraud]

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

Thanks

[Huet_Gildas]

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

[fgiraud]

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

[Huet_Gildas]

first : thanx for your work about this issue.

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