Tuesday, 13 March 2012

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
.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.

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.
  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.

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:

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.

No comments:

Post a Comment