Skip to content

Instantly share code, notes, and snippets.

@DevSecOpsGuy
Last active September 25, 2019 15:42
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save DevSecOpsGuy/edda6252d8ef9fe64b77605360130b0b to your computer and use it in GitHub Desktop.
Save DevSecOpsGuy/edda6252d8ef9fe64b77605360130b0b to your computer and use it in GitHub Desktop.
vTiger CRM on Ubuntu 18.04 LTS
apache2 -v
mysql --version
php --version
sudo mysql -u root -p
CREATE DATABASE vtigerdb;
CREATE USER 'vtiger'@'localhost' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON vtigerdb.* TO 'vtiger'@'localhost' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;
ALTER DATABASE vtigerdb CHARACTER SET utf8 COLLATE utf8_general_ci;
FLUSH PRIVILEGES;
exit
cd Downloads/
wget https://excellmedia.dl.sourceforge.net/project/vtigercrm/vtiger%20CRM%207.1.0/Core%20Product/vtigercrm7.1.0.tar.gz
tar -xvzf vtigercrm7.1.0.tar.gz
cp -r vtigercrm /var/www/html/
sudo cp -r vtigercrm /var/www/html/
sudo chown -R www-data:www-data /var/www/html/vtigercrm
sudo chmod -R 755 /var/www/html/vtigercrm
sudo nano /etc/apache2/sites-available/vtigercrm.conf
Add the following lines:
<VirtualHost *:80>
ServerAdmin admin@example.com
ServerName example.com
DocumentRoot /var/www/html/vtigercrm/
<Directory /var/www/html/vtigercrm/>
Options FollowSymlinks
AllowOverride All
Require all granted
</Directory>
ErrorLog /var/log/apache2/vtigercrm_error.log
CustomLog /var/log/apache2/vtigercrm_access.log combined
</VirtualHost>
a2ensite vtigercrm
sudo a2ensite vtigercrm
sudo a2dissite 000-default
sudo a2enmod rewrite
sudo systemctl restart apache2
sudo systemctl status apache2
sudo nano /etc/mysql/my.cnf
Add the following part to the bottom:
[mysqld]
sql_mode=ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
sudo service mysql restart
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment