| app | ||
| cake | ||
| cmc-django | ||
| conf | ||
| sql | ||
| vendors | ||
| .gitignore | ||
| .gitlab-ci.yml | ||
| .htaccess | ||
| backup.sh | ||
| build_docker.sh | ||
| build_docker_stg.sh | ||
| deploy.sh | ||
| docker-compose.yml | ||
| Dockerfile | ||
| Dockerfile_stg | ||
| enter_docker.sh | ||
| fetch_latest_sql.sh | ||
| index.php | ||
| MIGRATION.md | ||
| README.md | ||
| run_docker_local.sh | ||
| run_docker_prd.sh | ||
| run_docker_stg.sh | ||
| run_update_invoices.sh | ||
| run_vault.sh | ||
| stagingpasswd | ||
| userpasswd | ||
| vault_cron.sh | ||
cmc-sales
Development Docker compose instructions
git clone git@code.springupsoftware.com:cmc/cmc-sales.git
cd cmc-sales
rsync -avz --progress cmc@sales.cmctechnologies.com.au:~/backups .
docker compose up
# DB password is in config/database.php because..reasons.
# TODO move it to an environment var and rotate it..
gunzip < backups/backup_*.sql.gz | mariadb -h 127.0.0.1 -u cmc -p cmc
# edit your dev machine /etc/hosts and add
127.0.0.1 cmclocal
# open up cmclocal in your browser.. hopefully it'll work.
Install a new server
(TODO this is all likely out of date)
Requirements
Debian or Ubuntu OS. These instructions written for Debian 9.9
Assumed pre-work:
Create a new VM with hostname newserver.cmctechnologies.com.au Configure DNS appropriately. cmctechnologies.com.au zones is currently managed in Google Cloud DNS on Karl's account: https://console.cloud.google.com/net-services/dns/zones/cmctechnologies?project=cmc-technologies&authuser=1&folder&organizationId
Will need to migrate that to CMC's GSuite account at some point.
- Install ansible on your workstation
apt-get install ansible
- Clone the playbooks
git clone git@gitlab.com:minimalist.software/cmc-playbooks.git
- Execute the playbooks
The nginx config expects the site to be available at sales.cmctechnologies.com.au.
You'll need to add the hostname to config/nginx-site, if this isn't sales.cmctechnologies.com.au
cd cmc-playbooks
# Add the hostname of your new server to the inventory.txt
ansible-playbook -i inventory.txt setup.yml
- SSH to the new server and configure gitlab-runner
ssh newserver.cmctechnologies.com.au
sudo gitlab-runner register
- SSH to the new server as cmc user
ssh cmc@newserver.cmctechnologies.com.au
- Add the SSH key to the cmc-sales repo on gitlab as a deploy key https://gitlab.com/minimalist.software/cmc-sales/-/settings/repository
cmc@cmc:~$ cat .ssh/id_rsa.pub
ssh-rsa AAAAB3NzaC1yc2EAAAADAQABAAABAQDFIdoWVp2pGDb46ubW6jkfIpREMa/veD6xZVAtnj3WG1sX7NEUlQYq3RKbZ5CThlw6GKMSYoIsIqk7p6zSoJHGlJSLxoJ0edKflciMUFMTQrdm4T1USXsK+gd0C4DUCyVkYFOs37sy+JtziymnBTm7iOeVI3aMxwfoCOs6mNiD0ettjJT6WtVyy0ZTb6yU4uz7CHj1IGsvwsoKJWPGwJrZ/MfByNl6aJ8R/8zDwbtP06owKD4b3ZPgakM3nYRRoKzHZ/SClz50SXMKC4/nmFY9wLuuMhCWK+9x4/4VPSnxXESOlENMfUoa1IY4osAnZCtaFrWDyenJ+spZrNfgcscD ansible-generated on cmc
- Clone the cmc-sales repo
git clone git@gitlab.com:minimalist.software/cmc-sales.git
- As root on new server configure mySQL user cmc Note: get password from app/config/database.php (or set a new one and change it)
# mysql -u root
CREATE USER 'cmc'@'localhost' IDENTIFIED BY 'password';
CREATE USER 'cmc'@'172.17.0.2' IDENTIFIED BY 'password';
CREATE database cmc;
GRANT ALL PRIVILEGES ON cmc.* TO 'cmc'@'localhost';
GRANT ALL PRIVILEGES ON cmc.* TO 'cmc'@'172.17.0.2';
- Get the latest backup from Google Drive
In the shared google drive: eg. backups/database/backup_20191217_21001.sql.gz
Copy up to the new server:
rsync backup_*.gz root@newserver:~/
- Restore backup to cmc database
zcat backup_* | mysql -u cmc -p
-
Redeploy from Gitlab https://gitlab.com/minimalist.software/cmc-sales/pipelines/new
-
You should have a new installation of cmc-sales.
-
Seems new Linux kernels break the docker https://github.com/moby/moby/issues/28705
-
Mysql needs special args not to break
# /etc/mysql/my.cnf
sql_mode=ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION