Wednesday, February 13, 2019

Install vTIGER 7.1.0 on UBUNTU 18.04 LTS

Tested on a standard deployment of UBUNTU 1804 (in HyperV environment)

Assumptions:

This was tested on a basic standard installation of Ubuntu 18.04.  Not even updated.  Deployment below is based on a fully updated OS available (as of January 2019).  The instillation procedure below starts at the point where the OS has been installed, but nothing updated.


Copy/Paste the commands in BOLD.  

Submit them one at a time, waiting for each action to complete.  
If you already have Database, Apache and PHP installed, you can skip down to the install Vtiger setup, however additional or modified installation requirements for your system may need to be researched by you for a successful install. 

UPDATE BOX
sudo apt update
sudo apt upgrade

INSTALL APACHE
sudo apt install apache2
sudo systemctl status apache2

UPDATE FIREWALL RULES
sudo ufw allow 80/tcp
 sudo ufw allow 443/tcp
 sudo ufw reload

INSTALL SQL
sudo apt install mariadb-server mariadb-client
sudo systemctl status mysql
sudo mysql_secure_installation
SQL base Configuration
(press enter if asked for root/current password)
Set a SQL root password of your choice
say Y yes to subsequent configuration questions MariaDB install asks


INSTALL PHP
sudo apt install php php-common php-mysql php-gd php-cli
Instal PHPmyADMIN (if using vtiger chances are you'll want to look at the SQL tables with browser)
sudo apt install phpmyadmin
System will prompt for which web server you are asking, select "APACHE"
System will ask to configure phpmyadmin with "dbconfig-common" (select YES")
select the root password for the MYSQL instance
sudo cp /etc/phpmyadmin/apache.conf /etc/apache2/conf-available/phpmyadmin.conf 
sudo a2enconf phpmyadmin
sudo systemctl restart apache2
sudo mysql -u root -p
(mysql password)

UPDATE USER FOR PHPmyADMIN (please update password below to your liking)
CREATE USER 'admin'@'localhost' IDENTIFIED BY 'PICKpassWORD';
GRANT ALL PRIVILEGES ON *.* TO 'admin'@'localhost' WITH GRANT OPTION;
FLUSH PRIVILEGES;
EXIT;
sudo systemctl restart apache2
http://IPofSERver/phpmyadmin
login using admin and the password you set in "PICKpassWORD" above.


VTIGER install 7.1.0
cd /tmp
wget https://sourceforge.net/projects/vtigercrm/files/vtiger%20CRM%207.1.0/Core%20Product/vtigercrm7.1.0.tar.gz
tar -xzvf vtigercrm7.1.0.tar.gz
sudo mv vtigercrm /var/www/html/
chown -R root:root /var/www/html
This fix up the php to adjust for requirements of vTIGER
sudo sed -i -r 's/display_errors = Off/display_errors = On/' /etc/php/7.2/apache2/php.ini
sudo sed -i -r 's/log_errors = On/log_errors = Off/' /etc/php/7.2/apache2/php.ini
sudo sed -i -r 's/memory_limit = 128M/memory_limit = 256M/' /etc/php/7.2/apache2/php.ini
sudo sed -i -r 's/max_execution_time = 30/max_execution_time = 0/' /etc/php/7.2/apache2/php.ini
sudo sed -i -r 's/short_open_tag = On/short_open_tag = Off/' /etc/php/7.2/apache2/php.ini
Now we update the database for the VTIGER install
sudo mysql -u root -p
(enter password)
CREATE DATABASE vtiger710;
CREATE USER 'vtiger_admin'@'localhost' IDENTIFIED BY 'PaSsw0rd';
GRANT ALL PRIVILEGES ON `vtiger710`.* TO 'vtiger_admin'@'localhost';
FLUSH PRIVILEGES;
ALTER DATABASE vtiger710 CHARACTER SET utf8 COLLATE utf8_general_ci;
EXIT
sudo chown -R www-data:www-data /var/www/html/vtigercrm/
sudo chmod -R 755 /var/www/html/vtigercrm/
http://IPofSErver/vtigercrm

You should be presented with the Vtiger setup screen like this one

Select  INSTALL

Click I AGREE if you agree with the licence

Screen will show you Installation Pre-req.
Error_reporting will be in red with NOT RECOMMENDED.

Never been able to sort this, but have a bunch of vtiger installations and never had a problem.  Just continue

SYSTEM CONFIGURATION
Hostname = localhost
username = vtiger_admin
password = PaSsw0rd
database name = vtiger710
Select "CREATE NEW DATABASE"
put in your MariaDB user/password (root/Password)
Pick the currency of your country

Vtiger admin user name - defaults to admin
password = password of your choice
First Name is optional
Last Name = Administrator
email = your email address for admin messages.
Select time zone
Press NEXT
Assuming you have everything configured properly you'll be presented with a summary screen of config settings.
Press NEXT
Select your type of company.
This is strictly for anonymous info for vtiger.
Click on NEXT

The system will start doing installations of the application.  You'll see a status bar moving around.  Usually only takes a 1inute or two, sometimes 5.  Depends on speed of your system.  Just be patient,

The system will then present you some check boxes of the type of business you are running and additional modules that are custom to your environment.  Once the installation is completed, you will be at the vTiger admin window and your installation is completed.

You'll be presented with a "ALMOST THERE" menu.  Its double checking your preferences.
Select "GET STARTED"
You should now be in the VTIGER dashboard

2 comments:

Feel free to leave a comment! If you have any information that you think should be included, please do so here and I'll get it added in.