How To Install Yellowfin

We will be working as root. If you are not you will need to sudo the majority of these commands.  A pre-requisite is to have downloaded the Yellowfin Evaluation - click here.  Ensure that the software is saved at a location, which your new Yellowfin server can access.

Please contact us at sales@dscallards.com if you have any questions.

Install Java

Edit the /etc/apt/sources.list to include a new repository.

nano /etc/apt/sources.list

Add the new repository to the end of the file

deb http://us.archive.ubuntu.com/ubuntu/ hardy multiverse

.Update apt.

apt-get update

Download and install the latest version of Java.

apt-get install sun-java6-jdk

Install and Configure MySQL

Download and install the latest version of MySQL.

apt-get install mysql-server

 When prompted, specify a root password.

Create the yellowfin database.

mysql -u root -p

Enter the root password. From the mysql prompt.

CREATE DATABASE yellowfin;

Create the yellowfin mysql user.

 
CREATE USER 'yellowfin'@'localhost' IDENTIFIED BY 'yourpassword';

 

Grant all permissions on the yellowfin database to the new yellowfin user.

GRANT ALL PRIVILEGES ON yellowfin.* TO 'yellowfin'@'localhost';

Exit out of mysql.

mysql> quit

Install Yellowfin

Download the latest version of yellowfin and transfer it to your server along with your licence file if you have one. In my instance, I used wget to download the latest install package and licence file from a network server.

From the directory that contains the yellowfin.jar file, kick off the installation wizard.

java -jar yellowfin-xxxxxxxx-full.jar

1. Specify an installation directory. For example, /etc/yellowfin.
2. Enter the path to your licence file or leave blank to upload later from the admin console.
3. Specify the port you want yellowfin to listen on. For example: 3456.
4. Select option 6 (MySQL) from the database type list.
5. Choose NOT to create a new database or user.
6. Enter localhost for the database server host. Leave the port as default.
7. Specify the name of the database we created earlier, for example: yellowfin.
8. Specify the username and password for the user with permissions to alter the database, in this case the user we created earlier: yellowfin.
9. Choose whether to install the tutorial database, reports and different languages.
10. The install process will begin.
11. With the installation complete, start yellowfin.

/etc/yellowfin/appserver/bin/startup.sh

Using a browser, browse to the front end of Yellowfin. http://yourserver:port. You can then log in using the default username and password, which you will receive once you have registered for an evaluation.

For more information:

Yellowfin support portal http://www.yellowfinbi.com/YFSupportCentre.i4

Written by Tom Williams, Head of Infrastructure, DSCallards  

Call us on 0800 652 4050, visit www.yellowfinbi.co.uk or email us at sales@dscallards.com.