1 files changed, 34 insertions, 0 deletions
diff --git a/deploy/adapters/ansible/roles/congress/tasks/congress_database.yml b/deploy/adapters/ansible/roles/congress/tasks/congress_database.yml
new file mode 100755
index 00000000..009e3488
--- /dev/null
+++ b/deploy/adapters/ansible/roles/congress/tasks/congress_database.yml
@@ -0,0 +1,34 @@
+#############################################################################
+# Copyright (c) 2016 HUAWEI TECHNOLOGIES CO.,LTD and others.
+#
+# All rights reserved. This program and the accompanying materials
+# are made available under the terms of the Apache License, Version 2.0
+# which accompanies this distribution, and is available at
+# http://www.apache.org/licenses/LICENSE-2.0
+##############################################################################
+---
+- name: create congress db
+  mysql_db:
+    login_unix_socket: /var/run/mysqld/mysqld.sock
+    name: "{{ item.db }}"
+    state: present
+  with_items: "{{ congress_database }}"
+
+- name: create congress db user
+  mysql_user:
+    login_unix_socket: /var/run/mysqld/mysqld.sock
+    name: "{{ item[0].user }}"
+    password: "{{ item[0].password }}"
+    priv: "*.*:ALL,GRANT"
+    host: "{{ item[1] }}"
+    state: present
+  with_nested:
+    - "{{ congress_database }}"
+    - ['%', 'localhost']
+
+- name: congress db sync
+  shell: |
+    "{{ congress_path }}"/congress-db-manage \
+        --config-file /etc/congress/congress.conf upgrade head
+  notify:
+    - restart congress services