Network Management

 View Only
last person joined: 16 hours ago 

Keep an informative eye on your network with HPE Aruba Networking network management solutions
Expand all | Collapse all

Install hpe imc 7.3 with mysql8 on centos 7

This thread has been viewed 71 times
  • 1.  Install hpe imc 7.3 with mysql8 on centos 7

    Posted May 03, 2023 11:55 AM

    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.



  • 2.  RE: Install hpe imc 7.3 with mysql8 on centos 7

    EMPLOYEE
    Posted May 04, 2023 01:15 AM

    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
    ------------------------------



  • 3.  RE: Install hpe imc 7.3 with mysql8 on centos 7

    Posted May 04, 2023 03:12 AM
      |   view attached

    Hello,

    i try to follow this guide. Effectivly, at first startup of mysql server, i did not add lower_case_table_names = 1. So, mysql server was unable to start due to this mismatching variables. To fix it, i delete /var/lib/mysql directory , modify cnf via adding this line and start mysql server with success.
    Here are attached 3 files : my.cnf, error shown by envcheck, mysql error logs.

    On my side, maybe i will try to reinstall mysql server and set right my.cnf before first start of mysql server.

    Best regards.




  • 4.  RE: Install hpe imc 7.3 with mysql8 on centos 7

    Posted May 04, 2023 03:18 AM

    Here are 2 other files : 


    Attachment(s)

    txt
    my_cnf.txt   2 KB 1 version
    txt
    mysql_error_log.txt   1 KB 1 version


  • 5.  RE: Install hpe imc 7.3 with mysql8 on centos 7

    EMPLOYEE
    Posted May 04, 2023 03:40 AM

    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
    ------------------------------



  • 6.  RE: Install hpe imc 7.3 with mysql8 on centos 7

    Posted May 04, 2023 03:55 AM

    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.




  • 7.  RE: Install hpe imc 7.3 with mysql8 on centos 7

    Posted May 04, 2023 09:55 AM

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

    Best regards.




  • 8.  RE: Install hpe imc 7.3 with mysql8 on centos 7

    EMPLOYEE
    Posted May 04, 2023 11:53 AM

    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
    ------------------------------



  • 9.  RE: Install hpe imc 7.3 with mysql8 on centos 7

    Posted May 04, 2023 12:45 PM

    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




  • 10.  RE: Install hpe imc 7.3 with mysql8 on centos 7

    Posted May 05, 2023 03:56 AM

    Hello,
    Same results envn with changing password.




  • 11.  RE: Install hpe imc 7.3 with mysql8 on centos 7

    EMPLOYEE
    Posted May 05, 2023 03:57 AM

    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
    ------------------------------



  • 12.  RE: Install hpe imc 7.3 with mysql8 on centos 7

    EMPLOYEE
    Posted May 05, 2023 04:00 AM

    By the way, which IMC version are you trying to install? 7.3 E0708, right?



    ------------------------------
    Justin Guse
    ------------------------------



  • 13.  RE: Install hpe imc 7.3 with mysql8 on centos 7

    Posted May 05, 2023 04:16 AM

    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.




  • 14.  RE: Install hpe imc 7.3 with mysql8 on centos 7

    EMPLOYEE
    Posted May 05, 2023 06:22 AM

    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
    ------------------------------



  • 15.  RE: Install hpe imc 7.3 with mysql8 on centos 7

    Posted May 05, 2023 06:59 AM

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

    Best regards.




  • 16.  RE: Install hpe imc 7.3 with mysql8 on centos 7

    Posted May 05, 2023 07:36 AM

    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.