08-17-2012 02:57 AM - edited 08-17-2012 02:58 AM
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 ?
Solved! Go to Solution.
08-22-2012 08:01 AM
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.
- Configure the Character set:
- Configure Engine Type
default-storage-engine = INNODB
- Configure case insensitive table names
- Disabling log-bin settings
- Set innodb buffer sizes
- Set the max allowed packet size
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.
08-22-2012 08:26 AM
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.
PS : @Fabien : are you French too ?
08-23-2012 01:18 AM
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).
08-23-2012 02:02 AM
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).
08-27-2012 01:30 AM
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;
08-27-2012 02:56 AM
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
10-31-2012 04:16 PM
Edit /etc/hosts and add :
Where x.x.x.x is the ip and hostname is your server name.
Then restart the install.
11-20-2012 09:27 AM
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.
11-22-2012 07:10 AM
Same problem here but with the configuration :
CentOS 6.3 X64 (2.6.32-279.el6.x86_64)
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
01-09-2013 11:00 AM
I also ran into this and I was told to install the following 32bit libraries as well on the 64bit platform:
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.
01-10-2013 02:30 AM
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.
03-27-2013 06:35 AM
if you still have the problem, this support manual is a little more accurate than the package provided one.
09-16-2013 11:35 PM
just mention that mysql should be un-installed.
what should be installed ?
05-23-2014 03:55 AM
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.
08-30-2014 09:22 AM
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