Installing IBM Spectrum LSF Suite for Enterprise or Enterprise Plus on Ubuntu hosts

Install IBM Spectrum LSF Suite for Enterprise or Enterprise Plus on Ubuntu hosts.

1. Run the lsfsent10.2.0.0-<platform> or lsfsentplus10.2.0.0-<platform> executable file.
2. To use the Ubuntu host as the database host, create and set up the MariaDB database for use by
   1. Change directory to /opt/ibm/lsf_installer/DBschema.
   2. Log in to MySQL/MariaDB as the root database user.
      The default MySQL/MariaDB root database password is blank. For example,

      mysql -u root -p $rootpassword

   3. Create a database with the name pac.

      mysql> create database pac default character set utf8 default collate utf8_bin;

   4. Create a user named pacuser with the password pacuser and grant this user all privileges on the pac database.

      mysql> GRANT ALL PRIVILEGES ON pac.* to pacuser@'%' IDENTIFIED BY 'pacuser';

   5. Run the following commands for each GUI host and deployer host.
      Two GUI hosts gui_host1 and gui_host2 are listed here because at least two hosts are required to enable a HA shared directory.

      mysql> GRANT ALL PRIVILEGES ON pac.* to pacuser@'gui_host1' IDENTIFIED BY 'pacuser';
      mysql> GRANT ALL PRIVILEGES ON pac.* to pacuser@'gui_host2' IDENTIFIED BY 'pacuser'; 
      mysql> GRANT ALL PRIVILEGES ON pac.* to pacuser@'deployer host' IDENTIFIED BY 'pacuser';  
      

   6. Make sure that the database can be connected by the GUI role host and the deployer host.

      mysql -u pacuser -ppacuser pac -h <gui host 1>
      mysql -u pacuser -ppacuser pac -h <deployer host>
      

      Refer to MariaDB documentation to resolve database connection issues.

   7. If you are installing on Ubuntu 18.04, the default MySQL version is 5.7 which has a SQL_MODE on enforcing non-zero date entries. This must be changed to allow zero date entries, otherwise, the schema creation script will report an error and will not create the table properly. To turn off non-zero date checking:
      • Login to MySQL
      • Set the sql_mode parameter:

        SET  sql_mode='ALLOW_INVALID_DATES'

   8. Run the schema files for the database that has the name pac.

      The schema files reside in the current directory, /opt/ibm/lsf_installer/DBschema.

      mysql>use pac;

      mysql>source MySQL/egodata.sql;

      mysql>source MySQL/lsfdata.sql;

      mysql>source MySQL/lsf_sql.sql;

      mysql>source MySQL/create_schema.sql;

      mysql>source MySQL/create_pac_schema.sql;

      mysql>source MySQL/create_rule-engine_data.sql; (Only for versions older than 10.2 Fix Pack 8.)

      mysql>source MySQL/init.sql;

   9. Comment out the bind-address in the mariadb.conf.d file.

      If bind-address = 127.0.0.1 is set, comment it out so that other hosts can connect to MySQL.

   10. Edit the /opt/ibm/lsf_installer/playbook/lsf-config.yml file and update the JDBC_string option to specify the name of your database host.

       <DB_HOST> is the host name of your database.

       JDBC_string: jdbc:mariadb://<DB_HOST>[:<port>]/<DB_NAME>

       Important: As of 10.2 Fix Pack 8, the user name and password used for the DB_HOST (database host) is specified using the environment variables JDBC_USER and JDBC_PASSWORD.

       For pre-Fix Pack 8 users, the JDBC_string option is in the format:

       JDBC_string: jdbc:mysql://<DB_HOST>:3306/pac?user=pacuser&password=pacuser

   11. Review and update other options in the /opt/ibm/lsf_installer/playbook/lsf-config.yml file as required for your cluster installation.
3. Update the /opt/ibm/lsf_installer/playbook/lsf-inventory file to define the roles of each machine in the cluster.

   On Power Ubuntu, the DB_Host parameter is not supported.

   Note: In version 10.2.0.9 and later, to install Kibana for use with Elasticsearch, set the parameter Install_Kibana: True. Kibana will be installed on the first GUI_Host defined in lsf-inventory.
4. Change directory to /opt/ibm/lsf-installer/playbook, and run the ansible command to deploy the cluster.

   ansible-playbook -i lsf-inventory lsf-deploy.yml