Ubuntu Install Guide

Easy Setup

You can now install with a single command prompt! Use this method unless you have a good reason not to!

wget -qO - http://portals.interworks.com/scripts/ubuntu.sh | bash
  1. Server Setup

    If the server is not already setup for web traffic, install Apache, MySQL, PHP, and dependancies. You can do this with the commands below:

sudo apt-get -qq update > /dev/null
sudo apt-get -qq install lamp-server^ -y > /dev/null
sudo apt-get -qq install php7.0 libapache2-mod-php7.0 php7.0-mcrypt php7.0-mysql php7.0-curl php7.0-gd php7.0-zip php7.0-dom zip unzip -y > /dev/null
sudo apt-get -qq install zlib1g-dev libjpeg-dev libpng-dev libfreetype6-dev openssl libxml2-dev libmemcached-dev php7.0-mbstring -y > /dev/null

Edit /etc/apache2/apache2.conf and change AllowOveride to All for the /var/www directory

sudo a2enmod rewrite
sudo /etc/init.d/apache2 restart
  1. MySQL Setup

    Use the following command to setup MySQL for the first time.

    sudo mysql_secure_installation

After you have setup MySQL, log into MySQL with your root user. (Password blank by default - but you should have configured something else in Step 1)

mysql -u root -p

Then, run the following commands to create a database and user:

CREATE DATABASE tableau_portal;
CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON tableau_portal.* TO 'newuser'@'localhost';
FLUSH PRIVILEGES;
  1. Code Installation

    Now that we have installed the server, unzip the latest Integration System code to /var/www/html.

Make sure the directory is open for writing:

chmod -Rf 0777 /var/www/html

Run http://[your-server-here]/install.php in a web browser.

  1. Set up Cron

    Add a crontab with the following line. Modify the path to artisan as needed.

* * * * * php /var/www/html/artisan schedule:run >> /dev/null 2>&1
  1. Final Steps

    After installation, remove install.php and the install_files folder. Manage through /backend as needed.