IMC
cancel
Showing results for 
Search instead for 
Did you mean: 

Problem with upgrade from 7.3E0605P06 -> 7.3E0703 on linux

 
SOLVED
Go to solution
dasi66
Advisor

Problem with upgrade from 7.3E0605P06 -> 7.3E0703 on linux

When aplying upgrade via gui as I always done without any problems, installation stops and says "cannot connect to database". I quit and after that the system is corrupt..? Some of the services wont start.

Running Red Hat Enterprise Linux Server release 7.5 (Maipo), with MySQL-server-5.6.27-1.el7.x86_64.

Any ideas? Cannot get any more details because I restored system from snapshot.

By the way, how is the installation procedure for MySQL now on RH 7, all guides seems outdated? I cannot find any newer MySQL-server-5.x.y1.el7.x86_64 for download as in HPE guides.. Tried to do a new installation on RH 7.6 with MySQL-server-5.x.y1.el7.x86_64 but i can't get Installation check to pass mysql connection check.

15 REPLIES 15
jguse
HPE Pro

Re: Problem with upgrade from 7.3E0605P06 -> 7.3E0703 on linux

Hello,

Could be that you are running into the Timezone issue on Linux with MySQL.

Next time you attempt an upgrade, check the iMC\deploy\log\dmalog.txt and if you see any error like:

Caused by: com.mysql.cj.exceptions.InvalidConnectionAttributeException: The server time zone value 'CEST' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support.

Here is a workaround for now:

1) Login to MySQL command line (as root)
2) SET GLOBAL time_zone = '+3:00'; 
(where '+3:00' should be changed to this server's timezone offset) 

See also https://stackoverflow.com/questions/26515700/mysql-jdbc-driver-5-1-33-time-zone-issue

There is another issue that is triggered by NTA, if you have that module installed. It requires upgrading NTA to E0506P02 (to be released shortly).

That said, as I wrote in another post:

It would probably be better not to upgrade to E0703 if you haven't started already, unless you need the features/fixes. There are two known issues with RHEL and MySQL, and I posted the workarounds/fixes here (and in the other thread), and for one of them you would need the new NTA patch (to be posted).

There may be a new base version coming out relatively soon to address the known issues - but don't quote me on that as I'm not involved in it, and you would need to contact your HPE Sales/Account Management for any details about future versions.

Best regards,
Justin Guse

Working @ HPE
parnassus
Honored Contributor

Re: Problem with upgrade from 7.3E0605P06 -> 7.3E0703 on linux

Yeah, and @jguse really saved my day (reported issues -> doubt -> question -> issue avoided + waiting for updates)...read here...I'm on a scenario very similar to your one BUT, after reading all the issues that are popped up during last few days, I happily followed given advice.

dasi66
Advisor

Re: Problem with upgrade from 7.3E0605P06 -> 7.3E0703 on linux

Hi again. In preparation for the upcoming release i try to set up a new platform with release 7.3 E0605P06 on i new installed RH 7.5 server. Following the MySQL 5.6 on Redhat guide. Everything seems ok, i can connect to database via  mysql –u root –p. So far so good.

But when i trying to install iMC I got database connection error and cannot continue installation. I tried with iMC 7.1, 7.2, 7.3, E403, E506, But with the same error. 

So what the hell am I doing wrong? I have worked with this for days now and cannot understand what's wrong. Also tried other versions of MySQL and RH, but same problem.

Any ideas?

jguse
HPE Pro

Re: Problem with upgrade from 7.3E0605P06 -> 7.3E0703 on linux

Hello,

There's one key bit of information I noticed is missing in the manual (sorry, I'd update it if I could). The hostname and actual IP address of the IMC server must be defined in /etc/hosts for IMC installation to work.

Edit /etc/hosts and add a line with "imc.my.domain ip.address", save and try the IMC installer again.

Here is a video on the whole installation process that should help: https://www.youtube.com/watch?v=Ymz-I9F4Hko

Hope that helps you get it running...

Best regards,
Justin Guse

Working @ HPE
dasi66
Advisor

Re: Problem with upgrade from 7.3E0605P06 -> 7.3E0703 on linux

Thanks, I'll try that and reply with info soon. Another thing. What value shold it be in the timezone for Central European time in below description:

1) Login to MySQL command line (as root)
2) SET GLOBAL time_zone = '+3:00'; 
(where '+3:00' should be changed to this server's timezone offset)