netmonk
/ gist:1a33c5e999149b36b0177b0a61c4e5a9
Created
August 21, 2019 17:42
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| ok: [vmapp3] => { | |
| "msg": [ | |
| "casae_mainDb/ddl/full_drop_000_001_003_ddl.sql;", | |
| "casae_mainDb/ddl/full_drop_ddl.sql;", | |
| "", | |
| "ema_ac/ddl/ac_activity_mti_ddl.sql;", | |
| "ema_ac/ddl/ac_bank_ddl.sql;", | |
| "ema_ac/ddl/ac_broadcast_ddl.sql;", | |
| "ema_ac/ddl/ac_change_value_ddl.sql;", | |
| "ema_ac/ddl/ac_cm_status_card_ddl.sql;", |
netmonk
/ gist:280d2d20e0a278590b2d6893a8222b60
Created
August 21, 2019 17:33
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| [bdserver] | |
| vmapp3 ansible_ssh_host="10.179.189.134" ansible_user=dawgcicd | |
| [appserver] | |
| vmapp1 ansible_ssh_host="10.179.189.133" ansible_user=dawgcicd | |
| [silo1:children] | |
| appserver | |
| bdserver |
netmonk
/ gist:6d3a7e72e0b13b5260efd823c818d093
Created
August 21, 2019 17:31
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| - hosts: bdserver | |
| any_errors_fatal: true | |
| gather_facts: yes | |
| roles: | |
| - { role: bddeploy/clean, tags: [bd, bdclean]} | |
| - { role: bddeploy/populate, tags: [bd, bdpopulate]} |
netmonk
/ latest-version.yml
Created
August 21, 2019 17:25
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| --- | |
| #ce role sert à créer les bases de données tango | |
| - debug: | |
| msg: dbname of {{ inventory_hostname }} is {{ dbname_tango}} | |
| # au préalable il faut un endroit pour recevoir l'archive tango | |
| - name: bddeploy | Creating release folder | |
| file: | |
| path: "{{ item }}" |
netmonk
/ sql-create.yml
Created
August 21, 2019 16:56
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| - debug: | |
| msg: dbname of {{ inventory_hostname }} is {{ dbname_tango}} | |
| # au préalable il faut un endroit pour recevoir l'archive tango | |
| - name: bddeploy | Creating release folder | |
| file: | |
| path: "{{ item }}" | |
| owner: "{{ appuser }}" | |
| state: directory | |
| mode: 0744 | |
| with_items: |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| - name: bddeploy | Creating release folder | |
| file: | |
| path: "{{ item }}" | |
| owner: "{{ appuser }}" | |
| state: directory | |
| mode: 0744 | |
| with_items: | |
| - "{{ app_dir}}/{{ release_name}}" | |
| # on telecharge l'archive tango |
netmonk
/ gist:d48bdb5ac96731785d013de3a6d4ede3
Created
August 21, 2019 16:28
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| - name: bddeploy | Importing SAE sql schemes | |
| #delegate_to: "{{ ansible_ssh_host }}" | |
| mysql_db: | |
| state: import | |
| name: "{{ dbname_tango }}" | |
| login_host: "{{ dbhost_tango }}" | |
| login_user: "{{ dbadmin }}" | |
| login_password: "{{ dbadminpassword }}" | |
| target: "{{app_dir }}/{{ release_name}}/sql/{{ item }}" | |
| with_items: "{{ lookup('file', '{{ app_dir }}/{{ release_name }}/sql/list.sae_full.scripts').splitlines() }}" |
netmonk
/ gist:ff9a763397e02b370edaf9395721485d
Last active
November 6, 2018 13:30
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| --- | |
| - name: Collect primary rebond server sshd keys files | |
| slurp: src={{ item }} | |
| with_items: | |
| - /etc/ssh/ssh_host_rsa_key.pub | |
| - /etc/ssh/ssh_host_rsa_key | |
| - /etc/ssh/ssh_host_ecdsa_key.pub | |
| - /etc/ssh/ssh_host_ecdsa_key | |
| - /etc/ssh/ssh_host_ed25519_key.pub |
netmonk
/ Keto ressources
Created
September 15, 2017 07:52
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| https://www.ditchthecarbs.com/keto-waffles/ |
netmonk
/ gist:d8923f7e7afc4913bfd9
Created
July 15, 2014 20:17
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| [root(4)netmonk:plonky]# LC_ALL=C pacman -Suy | |
| :: Synchronizing package databases... | |
| core is up to date | |
| extra 1743.5 KiB 1030K/s 00:02 [##############################] 100% | |
| community 2.3 MiB 1034K/s 00:02 [##############################] 100% | |
| :: Starting full system upgrade... | |
| :: Replace polkit-qt with extra/polkit-qt4? [Y/n] y | |
| resolving dependencies... | |
| looking for inter-conflicts... |