Code Fragments for DevOps for OpenERP

Code fragments for the series DevOps for OpenERP.

---

---

• Fragments for Step #03 : Create template from VM and 2nd VM from template
1. sudo apt-get -y update && sudo apt-get -y upgrade && sudo apt-get -y dist-upgrade && sudo apt-get -y clean && sudo apt-get -y autoremove

---

• Fragments for Step #04 Install SaltStack Master And Minion
  
  1. sudo nano /etc/hosts
  2. sudo nano /etc/hostname
  3. URL for saltstack / salt-bootstrap
  4. wget -O install_salt.sh http://bootstrap.saltstack.org
     sudo sh install_salt.sh -P git develop # Minion
  5. sudo tail -fn 25 /var/log/salt/minion
  6. wget -O install_salt.sh http://bootstrap.saltstack.org
     sudo sh install_salt.sh -M -N git develop # Master

---

• Fragments for Step #05 Install OpenERP using a SaltStack state file.
  
1. URL for FleetingClouds / SaltStackToolSet
2. wget https://github.com/FleetingClouds/SaltStackToolSet/archive/master.zip
3. sudo apt-get -y install unzip
4. URL for OpenERP 7 nightly *.deb files
5. ln -s /home/yourself/SaltStackToolSet/openerp/srv /srv
6. salt "paste minion name here" state.highstate
7. URL for state file for PostgreSQL
8. URL for state file for OpenERP
9. sudo cat /etc/openerp/openerp-server.conf

---

• Fragments for Step #06 : Install and use GateOne; the HTTP terminal server.
  
1. ps aux | grep salt
2. wget -O install_salt.sh http://bootstrap.saltstack.org
   sudo sh install_salt.sh -P git develop # Minion
3. salt-key -ya "your minion's name"
4. cd SaltStackToolSet/gateone/srv/pillar/gateone
5. ln -s /home/yourself/SaltStackToolSet/gateone/srv /srv
   cp init.sls.example init.sls


6. ps aux | grep gateone
   service gateone start
   ps aux | grep gateone


7. nano /etc/gateone/conf.d/10server.conf


8. nano /etc/gateone/conf.d/20authentication.conf


9. sudo apt-get -y install ssh
   mkdir -p .ssh
   chmod 700 .ssh
   cd .ssh
   touch authorized_keys
   chmod 600 authorized_keys
   nano authorized_keys # paste key here. ctrl-x to exit



---

• Fragments for  Step #07 : Install And check GSpread
  
  1. rm -fr /srv
     ln -s /home/yourself/SaltStackToolSet/gdata_oerp_pump/srv/ /srv
  2. cd /home/yourself/SaltStackToolSet/gdata_oerp_pump/srv/pillar/gdata_oerp_pump/
     cp init.sls.example init.sls
     nano init.sls
  3. salt "WhateverYouDecidedToCallIt" state.sls gspread
     
  4. cd /tmp/gspread-master/tests
     
     ./get_google_oauth2_creds.py
     

---

• Fragments for  Step #08 : Install and check OpenERP data pump
  
  1. cd /home/yourself/SaltStackToolSet/gdata_oerp_pump/srv/pillar/gdata_oerp_pump/
     nano init.sls
  2. salt "WhateverYouDecidedToCallIt" state.sls gdata_oerp_pump
     

---

• Fragments for  Step #09 : Demonstrate Google Spreadsheet to OpenERP data pump
  
  1. cd /opt/GData_OpenERP_Data_Pump
     
     ./pump -k KEY_OF_CONTROLLER_SPREADSHEEET
     

---

---