I succeed passing envcheck script. It was my fault : i didn't install all 32 bit libraries and packages.. Missed libraries cause issue to database connectivity.
Thank you.
Original Message:
Sent: May 05, 2023 06:58 AM
From: ano9
Subject: Install hpe imc 7.3 with mysql8 on centos 7
Thanks, i will try this version and checking mysql version compatibility.
Best regards.
Original Message:
Sent: May 05, 2023 06:22 AM
From: jguse
Subject: Install hpe imc 7.3 with mysql8 on centos 7
Hello,
That explains it - MySQL 8.0 was not supported yet on this release.
You can download the latest IMC releases on ASP here: https://asp.arubanetworks.com/downloads;products=HPE%20Intelligent%20Management%20Center%20%28IMC%29
------------------------------
Justin Guse
Original Message:
Sent: May 05, 2023 04:16 AM
From: ano9
Subject: Install hpe imc 7.3 with mysql8 on centos 7
I try installing from zip file iMC_PLAT_7.3_E0703_Enterprise_Linux.zip. Is there a link for version 7.3 E0708 which seems more updated ?
I try with other new user created without success.
Best regards.
Original Message:
Sent: May 05, 2023 03:59 AM
From: jguse
Subject: Install hpe imc 7.3 with mysql8 on centos 7
By the way, which IMC version are you trying to install? 7.3 E0708, right?
------------------------------
Justin Guse
Original Message:
Sent: May 05, 2023 03:57 AM
From: jguse
Subject: Install hpe imc 7.3 with mysql8 on centos 7
Hello,
I'm just trying to think of other reasons why it might fail like that. Perhaps something else you could test is creating an identical user to 'root'@'localhost' with 'root'@'%' and granting it the same privileges, then trying the install again. I recall on some IMC versions it was trying to access this user instead, and it is definitely needed in cases of remote DB/distributed deployment.
------------------------------
Justin Guse
Original Message:
Sent: May 04, 2023 12:44 PM
From: ano9
Subject: Install hpe imc 7.3 with mysql8 on centos 7
Hello,
yes i know. I used password given on user installation guide. Further more, there is a specific issue message when you use a password with special characters. In my case, it doesn't display this message issue.
The exemple password contains a specific characters which seems permitted (the only one _ )
Do you think trying with an other password can succeed without specific characters ? I will try
Best regards
Original Message:
Sent: May 04, 2023 11:52 AM
From: jguse
Subject: Install hpe imc 7.3 with mysql8 on centos 7
Hello again,
Perhaps your root user password contains one of the invalid special characters for IMC? There is a table on page 8 of the installation guide that lists these characters which must not be used.
------------------------------
Justin Guse
Original Message:
Sent: May 04, 2023 09:54 AM
From: ano9
Subject: Install hpe imc 7.3 with mysql8 on centos 7
Unfortunately, i face same issues. When , i ran script envcheck.sh, it doesn't succeed checking base connectivity.
Best regards.
Original Message:
Sent: May 04, 2023 03:54 AM
From: ano9
Subject: Install hpe imc 7.3 with mysql8 on centos 7
Despite this line, the most updated logs are stored at /var/lib/mysql/localhost.log. This is the reason , i shared this particular file.
I come back after reinstalling and starting up mysql.
Original Message:
Sent: May 04, 2023 03:40 AM
From: jguse
Subject: Install hpe imc 7.3 with mysql8 on centos 7
Hello,
Thanks for this additional data. I would suggest first testing as you have proposed by reinstalling and initializing MySQL correctly.
Note the error log location is modified by the my.cnf file you are using. It is not under /var/lib/mysql anymore but instead
log-error=/var/log/mysqld.log
so checking the log file located there may provide more useful insights.
I think you may have shared the log from the old location?
------------------------------
Justin Guse
Original Message:
Sent: May 04, 2023 03:17 AM
From: ano9
Subject: Install hpe imc 7.3 with mysql8 on centos 7
Here are 2 other files :
Original Message:
Sent: May 04, 2023 01:14 AM
From: jguse
Subject: Install hpe imc 7.3 with mysql8 on centos 7
Hello,
Have you followed the steps to install MySQL 8.0 according to the guide for IMC? https://support.hpe.com/hpesc/public/docDisplay?docLocale=en_US&docId=a00094095en_us
Make sure you have the same config file parameters configured as listed there, and that you initialized with lower_case_table_names = 1 on first startup, among other things.
If that's the case, can you please share the my.cnf file parameters you are using, as well as any error shown by the envcheck when it is run as part of the installer?
------------------------------
Justin Guse
Original Message:
Sent: May 03, 2023 08:02 AM
From: ano9
Subject: Install hpe imc 7.3 with mysql8 on centos 7
Dear all,
i met some issue installing hpe iMC onto my host (kvm host under centos). When i run envcheck.sh script, i face issue with mysql connectivity :
2023-05-03T11:00:36.965956Z 12 Connect root@localhost on using TCP/IP
2023-05-03T11:00:36.968055Z 12 Query /* mysql-connector-java-8.0.12 (Revision: 24766725dc6e017025532146d94c6e6c488fb8f1) */SELECT @@session.auto_increment_increment AS auto_increment_increment, @@character_set_client AS character_set_client, @@character_set_connection AS character_set_connection, @@character_set_results AS character_set_results, @@character_set_server AS character_set_server, @@collation_server AS collation_server, @@init_connect AS init_connect, @@interactive_timeout AS interactive_timeout, @@license AS license, @@lower_case_table_names AS lower_case_table_names, @@max_allowed_packet AS max_allowed_packet, @@net_write_timeout AS net_write_timeout, @@sql_mode AS sql_mode, @@system_time_zone AS system_time_zone, @@time_zone AS time_zone, @@transaction_isolation AS transaction_isolation, @@wait_timeout AS wait_timeout
2023-05-03T11:00:36.970562Z 12 Query SET NAMES latin1
2023-05-03T11:00:36.970973Z 12 Query SET character_set_results = NULL
2023-05-03T11:00:36.971667Z 12 Query SET autocommit=1
2023-05-03T11:00:36.972744Z 12 Quit
It's not a password issue because i succeed connect into mysql server via command line. Do you have any ideas ?
Best regards.