Bare Metal Installation Issue

Hopsworks
#1

Dear Forum,

I try to install the Hopsworks platform in a single CentOS 7 VM using the 2.2 installer as mentioned in other topics. Unfortunately the system breaks at the hops:ndb step. The corresponding logs are included below.

Some pointers will be highly appreciated :slight_smile:
Kind regards,
S. Jacobs

  ================================================================================e[0m
  e[31mError executing action `run` on resource 'bash[flyway_baseline]'e[0m
  ================================================================================e[0m

e[0m Mixlib::ShellOut::ShellCommandFailede[0m
------------------------------------e[0m
Expected process to exit with [0], but received ‘1’
e[0m ---- Begin output of “bash” “/tmp/chef-script20210610-25087-ok02wa” ----
e[0m STDOUT: Using socket: /srv/hops/mysql-cluster/mysql.sock
e[0m Flyway Community Edition 6.5.1 by Redgate
e[0m STDERR: mysql: [Warning] Using a password on the command line interface can be insecure.
e[0m ERROR:
e[0m Unable to obtain connection from database (jdbc:mysql://127.0.0.1:3306/hops) for user ‘kthfs’: The server time zone value ‘EDT’ 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.
e[0m --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
e[0m SQL State : 01S00
e[0m Error Code : 0
e[0m Message : The server time zone value ‘EDT’ 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.
e[0m
e[0m Caused by: java.sql.SQLException: The server time zone value ‘EDT’ 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.
e[0m Caused by: com.mysql.cj.exceptions.InvalidConnectionAttributeException: The server time zone value ‘EDT’ 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.
e[0m ---- End output of “bash” “/tmp/chef-script20210610-25087-ok02wa” ----
e[0m Ran “bash” “/tmp/chef-script20210610-25087-ok02wa” returned 1e[0m

#2

try just setting your timezone manually then rerun via karamel?
Maybe it requires a different format?

#3

Hi @jacobss,

As the error message states, you need to set up the time zone to something more specific than EDT. In this case for EDT, we will use US/Eastern but if this is not the case for your location, please adjust accordingly.

In order to adjust this, from the terminal of your vm:

  1. As root user run
/srv/hops/mysql/bin/mysql_tzinfo_to_sql /usr/share/zoneinfo/ | /srv/hops/mysql/bin/mysql -S /srv/hops/mysql-cluster/mysql.sock -u root mysql
  1. Add to mysql server config file: /srv/hops/mysql-cluster/my.cnf the correct time zone. In this case US/Eastern:
default_time_zone = US/Eastern
  1. restart mysqld
systemctl restart mysqld

Cheers,
Alex

#4

Hi @jacobs,

One more thing.
Once you fixed the timezone issus, you will want to retry the recipe. For this we first need to cleanup something as part of the failed attempt:

  1. Remove this dir:
/srv/hops/domains/domain1/flyway-6.5.1
  1. Go to the karamel UI and retry the failed recipe. Either open access to port 9090 for the Karamel UI or create a tunnel:
ssh -L9090:localhost:9090 REMOTE_USER@REMOTE_IP

If you ran the ssh command above, the Karamel UI on your remote vm will be available on:
http://localhost:9090/index.html
Go to Menu > Terminal, then click on Status and then re-run the failed recipe.

Cheers,
Alex