Versions Compared

Old Version 13

changes.mady.by.user Gvido

Saved on

compared with

New Version 14

changes.mady.by.user Gvido

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Note

These are installation and setup instructions for the latest flex.bi Enterprise version 6.3.

The following is a general flex.bi Enterprise installation guide. We have also prepared a more specific instructions about installation on Centos 8 platform: flex.bi Enterprise installation guide on CentOS 8.

...

  • flex.bi Enterprise installation is supported on Mac OS X, Linux and Windows.
  • Java 8 or Java 11 should be installed. Only Oracle or OpenJDK JVMs are supported.
  • MySQL (version 5.5 - 5.7), PostgreSQL (version 9.x - 11.x), MS SQL (version 2008 or later) and Oracle (version 11g or later) are supported as flex.bi Enterprise database.
  • Minimum requirements for server:
    • CPU with 6 cores;
    • 16 GB RAM;
    • 320 GB disk space.

Installation

Ask flex.bi support  to provide a download URL for the latest flex.bi Enterprise full distribution .zip file.

...

If you would like to export dashboard pages to PDF or send regular emails with flex.bi dashboards as PDF attachments then please install Google Chrome on your flex.bi Enterprise server.

...

Please contact flex.bi support if you have any issues with flex.bi Enterprise installation and setup.

Version upgrade

To upgrade flex.bi Enterprise version here is what you should do:

  1. Download the newest version or ask flex.bi support or your partner to provide it to you.

  2. Stop the flexbi server process.

  3. Make a backup copy of your SQL database, e.g., using mysqldump: (Replace <username> and <password>  with the actual username and password of your MySQL server.)

    Code Block
    mysqldump -u <username> -p<password> --all-databases >> flexbi_private_dump_2021.01.01.sql


  4. Make a backup copy of the existing installation, by copying the flexbi_private folder to e.g. flexbi_private_5.0.

  5. Delete the following files and folders from your existing server folder:

    Code Block
    flexbi_private/spec
flexbi_private/app 
flexbi_private/db/migrate
flexbi_private/config/initializers
flexbi_private/config/locales
flexbi_private/examples
flexbi_private/public/images
flexbi_private/public/flexbi
flexbi_private/public/javascripts
flexbi_private/public/style
flexbi_private/public/stylesheets
flexbi_private/config/torquebox
flexbi_private/vendor
flexbi_private/LICENSE
flexbi_private/CHANGELOG.md
flexbi_private/flexbi_private.jar
flexbi_private/tmp


  6. Extract the new flex.bi version .zip archive into flexbi_private/ folder.

  7. Make note of files that are overwritten during extraction process. Especially for configuration files in the config folder and startup files in bin folder. Manually compare them with the backed up versions and bring over any changes that you made during initial server setup.

  8. Make sure that all all of the the files in flexbi_private folder are owned by the user that runs flexbi process (by default the user is flexbi).

  9. If you are updating from flex.bi version older than 5.1, then:

    1. If you are using a systemd initialization script, change it according to this example(don't forget to adjust directories, port, Java memory settings and other parameters specific to your installation):

      Code Block
      # Sample init script for flex.bi
[Unit]
Description=flex.bi reporting service
After=syslog.target network.target
[Service]
Type=simple
# Run the service as this user and group
User=flexbi
Group=flexbi
TimeoutSec=30
# Remember to change /home/flexbi/flexbi_private to the actual home directory of flex.bi in all places
WorkingDirectory=/home/flexbi/flexbi_private
Environment="RAILS_ENV=production"
Environment="EAZYBI_HOME=/home/flexbi/flexbi_private"
Environment="EAZYBI_PREFIX=/flexbi"
Environment="RUBYOPT=-W0"
# Adjust to available memory
Environment="JAVA_OPTS=-Xmx1024m -Xms256m -Dfile.encoding=UTF-8 -Djava.awt.headless=true -Dorg.eclipse.jetty.LEVEL=OFF -Djava.io.tmpdir=/home/flexbi/flexbi_private/tmp"

# Default configuration
ExecStart=/usr/bin/java $JAVA_OPTS -Dwarbler.host=localhost -Dwarbler.port=8080 -jar flexbi_private.jar


Restart=on-failure
StandardOutput=syslog
StandardError=syslog
SyslogIdentifier=flexbi
#LimitNOFILE=10000
[Install]
WantedBy=multi-user.target


    2. If  you are using nginx as a web proxy, add these lines to your nginx configuration:

      Code Block
      proxy_http_version 1.1;
proxy_set_header Connection "";


  10. Start the flexbi Enterprise server process.
  11. Check flex.bi Enterprise Changelog for any additional action mentioned to be performed before the upgrade.