commit 0fc5ddec6445e8a2833f1f7955d6a7d59d9eae1a
author Volodymyr Stoiko <vstoiko@mirantis.com> Fri May 12 10:23:22 2017 +0300
committer Volodymyr Stoiko <vstoiko@mirantis.com> Fri May 12 10:23:22 2017 +0300
tree 90a190beb6329155781b6fec3027f25a25fd7e6b
parent b03c92d976da50864480beb688fb50ba669979e6

Add init queries for integration between Pushkin and Security Monkey

Change-Id: I319ea79284d761231d78146b96309eaf29104105

postgresql/client/security_monkey.yml

diff --git a/postgresql/client/security_monkey.yml b/postgresql/client/security_monkey.yml
index 65f1de2..428753d 100644
--- a/postgresql/client/security_monkey.yml
+++ b/postgresql/client/security_monkey.yml
@@ -24,3 +24,9 @@
                 host: ${_param:secmonkey_db_host}
                 createdb: true
                 rights: all privileges
+              init:
+                maintenance_db: pushkin
+                force: true
+                queries:
+                - INSERT INTO login VALUES (11, 1) ON CONFLICT (id) DO UPDATE SET id = excluded.id;
+                - INSERT INTO device VALUES (1, 11, 42, 'security_audit_service', NULL, 1, NULL) ON CONFLICT (id) DO UPDATE SET id = excluded.id;