Project

General

Profile

Tâche #23604

Scénario #23526: Epic 6 : Déployer la configuration sur les serveurs

L’initialisation de la base de données doit être géré par le nouveau système avec Vault

Added by Daniel Dehennin almost 5 years ago. Updated almost 5 years ago.

Status:
Fermé
Priority:
Normal
Assigned To:
Start date:
04/10/2018
Due date:
% Done:

100%

Estimated time:
3.00 h
Spent time:
Remaining (hours):
0.0

Description

  • Le message v1.execution.salt.jobs.list retourne une erreur car le curseur n’est pas initialisé
  • La base de données est créée par un script dans le service postgres

Associated revisions

Revision fb84ff75 (diff)
Added by Daniel Dehennin almost 5 years ago

PostgreSQL: “salt-returner” database must not be managed by postgres

Ref: #23604

Revision 9314a713 (diff)
Added by Daniel Dehennin almost 5 years ago

SaltStack: create database with sqitch

  • services/saltmaster/Dockerfile: install sqitch files.
  • services/saltmaster/migrations/deploy/salt-runner-db.sql: initialize the
    “salt-runner” database.
  • services/saltmaster/migrations/revert/salt-runner-db.sql: delete the
    “salt-runner” database objects.
  • services/saltmaster/migrations/verify/salt-runner-db.sql: verify
    that tables exist.
  • services/saltmaster/migrations/sqitch.conf: use PostgreSQL as engine.
  • services/saltmaster/migrations/sqitch.plan: add “salt-runner-db” to
    the sqitch plan.

Ref: #23604

History

#1 Updated by Daniel Dehennin almost 5 years ago

  • Remaining (hours) changed from 3.0 to 6.0

#2 Updated by Daniel Dehennin almost 5 years ago

  • Assigned To set to Daniel Dehennin
  • % Done changed from 0 to 100
  • Remaining (hours) changed from 6.0 to 0.25

#3 Updated by Daniel Dehennin almost 5 years ago

  • Status changed from Nouveau to En cours

#4 Updated by Scrum Master almost 5 years ago

  • Status changed from En cours to Résolu

#5 Updated by Daniel Dehennin almost 5 years ago

  • Status changed from Résolu to Fermé
  • Parent task changed from #23526 to #23524
  • Remaining (hours) changed from 0.25 to 0.0

#6 Updated by Daniel Dehennin almost 5 years ago

  • Parent task changed from #23524 to #23526

Also available in: Atom PDF