Network Management

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?

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?

Here are 2 other files : 

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?

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?

Here are 2 other files : 

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?

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.

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?

Here are 2 other files : 

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?

Unfortunately, i face same issues. When , i ran script envcheck.sh, it doesn't succeed checking base connectivity.

Best regards.

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.

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?

Here are 2 other files : 

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?

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.

Unfortunately, i face same issues. When , i ran script envcheck.sh, it doesn't succeed checking base connectivity.

Best regards.

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.

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?

Here are 2 other files : 

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?

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

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.

Unfortunately, i face same issues. When , i ran script envcheck.sh, it doesn't succeed checking base connectivity.

Best regards.

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.

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?

Here are 2 other files : 

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?

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

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.

Unfortunately, i face same issues. When , i ran script envcheck.sh, it doesn't succeed checking base connectivity.

Best regards.

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.

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?

Here are 2 other files : 

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?

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.

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

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.

Unfortunately, i face same issues. When , i ran script envcheck.sh, it doesn't succeed checking base connectivity.

Best regards.

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.

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?

Here are 2 other files : 

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?

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

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

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

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

Thanks, i will try this version and checking mysql version compatibility.

Best regards.

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

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