Page Comparison

...

Gather the software packages

• flex.bi - you can get it from our support
• Java SE - you have two options:
  • you can download it from Oracle. In this case we suggest to go with the rpm or bin packages of the full JDK versions as that is sometimes easier to maintain

  • you can use the openjdk and then you don't need to download anything additionally (see next steps)

• MySQL connector - you have to get mysql java connector separately as well

...

Install

Java

If you chose running Java from Oracle - install Java from the downloaded package. Normally it should be as easy as running

...

MySQL/MariaDB

Normally should be as easy as running

...

You can follow instructions available on MariaDB knowledge base

flex.bi

1. For security reasons we recommend creating dedicated flexbi user

...

• app
• bin
• config
• examples
• lib
• log
• public
• spec
• tmp

Install mysql connector

1. Mover the downloaded mysql connector file mysql-connector-java-5.1.39.zip to /home/flexbi un run

   Code Block
   unzip mysql-connector-java-5.1.39.zip

2. copy the jar file in the created folder under flexbi_private/lib folder (create if non-existent)

   Code Block
   cp mysql-connector-java-5.1.39/mysql-connector-java-5.1.39-bin.jar flexbi_private/lib/

Setup and configuration

MariaDB

If you have large amount of records we suggest to tune database engine performance by editing /etc/my.cnf with appropriate values.

...

• If this is a new mariadb installation do this to change password connect to mysql "mysql -u root" and run

  Code Block
  UPDATE mysql.user SET Password=PASSWORD('secret') WHERE User='root'; FLUSH PRIVILEGES;

• To create new user for flex.bi databases connect to mysql "mysql -u root -p" and the password and run

  Code Block
  CREATE USER 'flexbi_private'@'localhost' IDENTIFIED BY 'secret'; GRANT ALL PRIVILEGES ON `flexbi_private%`.* TO 'flexbi_private'@'%' IDENTIFIED BY 'secret'; FLUSH PRIVILEGES;

• If you need access the server remotely (via admin tool like Sequel Pro for example) connect to mysql "mysql -u root -p" and the password and run

  Code Block
  GRANT ALL ON flexbi_private.* TO root@<remote-ip-address>' IDENTIFIED BY 'PASSWORD'; GRANT ALL ON flexbi_private_dwh.* TO root@'<remote-ip-address>' IDENTIFIED BY 'PASSWORD'; FLUSH PRIVILEGES;

flex.bi

• Configure eazybi.toml:

  • copy the eazybi.toml.sample file in config folder and adjust parameters

    Code Block
    cp eazybi.toml.sample eazybi.toml

  • licence parameters
    • change the name to the organisation name exactly how you sent it to flex.bi as the enabler is tied to this name
  • general parameters for example
    • if you wish to allow users to register themselves or only invite them
    • allow public accounts or not etc.
  • default url parameters - specify host and port that you wish to access flex.bi from for example bi.company.com:8080

  • mailer parameters - you can set up the name and address of outgoing e-mails from this private instance e.g. like this

    Code Block
    [mailer] from = "My private flex.bi <flexbi@mydomain.com>"

  • smtp parameters - specify your smtp server parameters in order to be able to send out invitations, dashboards and error messages

• Adjust start parameters in bin/start.sh

  • If you don't use any proxy web server to route web requests to flex.bi, you need to enable public access as by default flex.bi will answer requests only from localhost. In order to do that follow the instructions in the file to add this to startup script

    Code Block
    -b 0.0.0.0

• Create the startup script with 

  Code Block
  cp bin/init.d/flexbi.sample /etc/init.d/flexbi

   

  • add executable permissions 

    Code Block
    chmod +x /etc/init.d/flexbi

  • change the pats of flex.bi home folder

    Code Block
    EAZYBI_HOME=/home/flexbi/flexbi_private

  • set the flexbi user you created previously as the one running the server

    Code Block
    EAZYBI_USER=flexbi

    Note
    Make sure access rights of flex.bi server folder are set correctly for this user

     

     

Run the flex.bi server

Finally now you can run the flex.bi server with

...

And configure database connection in the wizard that should open once you connect for the first time using the database parameters from above.

Troubleshooting

In case of any issues inspect the log files and contact our support.