simple-crm web app

install

set up MySQL database

sudo mysql -u root
CREATE DATABASE `simple-crm` CHARACTER SET utf8 COLLATE utf8_general_ci;
CREATE USER 'simple-crm'@'localhost' IDENTIFIED WITH mysql_native_password BY '';
GRANT ALL PRIVILEGES ON `simple-crm` . * TO 'simple-crm'@'localhost';
FLUSH PRIVILEGES;
quit

git instructions

sudo rm -rf simple-crm /var/www/simple-crm

git url

eval $(ssh-agent -s); ssh-add .ssh/github_rsa
git clone git@github.com:BelfastTechServices/simple-crm.git
cp simple-crm/crm/config.sample.inc.php simple-crm/crm/config.inc.php; nano simple-crm/crm/config.inc.php
sudo cp -r simple-crm/crm/ /var/www/simple-crm; sudo chown www-data -R /var/www

if single site, remember to edit $config_base_path back to /crm/

Setup - multiple domains/ssl sites

nano simple-crm/simple-crm-ssl.conf
sudo cp simple-crm/simple-crm-ssl.conf /etc/apache2/sites-available/simple-crm-ssl.conf; sudo a2ensite simple-crm-ssl; sudo service apache2 restart
sudo certbot --apache -d simple-crm.belfasttechservices.co.uk -d www.simple-crm.belfasttechservices.co.uk --agree-tos --renew-by-default --no-redirect