Note |
---|
These are installation and setup instructions for the latest flex.bi Enterprise version 6.1. |
On this page:
Table of Contents
...
- 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.
...
In addition, you should download MySQL JDBC driver version 5.1.x and copy included mysql-connector-java-5.1.*.jar
to flexbi_private/lib
directory (MySQL JDBC driver is not included in flex.bi Enterprise distribution due to GPL license restrictions).
...
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:
- Download the newest version or ask flex.bi support or your partner to provide it to you.
Stop the
flexbi
server process.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
Make a backup copy of the existing installation, by copying the
flexbi_private
folder to e.g.flexbi_private_5.0
.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
Extract the new flex.bi version .zip archive into
flexbi
_private/
folder.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.
Make sure that all all of the the files in
flexbi_private
folder are owned by the user that runsflexbi
process (by default the user isflexbi
).- If you are updating from flex.bi version older than
5.1
, then: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
If you are using
nginx
as a web proxy, add these lines to yournginx
configuration:Code Block proxy_http_version 1.1; proxy_set_header Connection "";
- Start the
flexbi
Enterprise server process). - Check flex.bi Enterprise Changelog for any additional action mentioned to be performed before the upgrade.