AKAI TSUKI

System development or Technical something

start docker (version 1.12.5)

[root@localhost ~]# systemctl enable docker.service
Created symlink from /etc/systemd/system/multi-user.target.wants/docker.service to /usr/lib/systemd/system/docker.service.
[root@localhost ~]# systemctl start docker
[root@localhost ~]# docker version
Client:
 Version:      1.12.5
 API version:  1.24
 Go version:   go1.6.4
 Git commit:   7392c3b
 Built:        Fri Dec 16 02:23:59 2016
 OS/Arch:      linux/amd64

Server:
 Version:      1.12.5
 API version:  1.24
 Go version:   go1.6.4
 Git commit:   7392c3b
 Built:        Fri Dec 16 02:23:59 2016
 OS/Arch:      linux/amd64
[root@localhost ~]# docker run --rm hello-world
Unable to find image 'hello-world:latest' locally
latest: Pulling from library/hello-world

c04b14da8d14: Pull complete
Digest: sha256:0256e8a36e2070f7bf2d0b0763dbabdd67798512411de4cdcf9431a1feb60fd9
Status: Downloaded newer image for hello-world:latest

Hello from Docker!
This message shows that your installation appears to be working correctly.

To generate this message, Docker took the following steps:
 1. The Docker client contacted the Docker daemon.
 2. The Docker daemon pulled the "hello-world" image from the Docker Hub.
 3. The Docker daemon created a new container from that image which runs the
    executable that produces the output you are currently reading.
 4. The Docker daemon streamed that output to the Docker client, which sent it
    to your terminal.

To try something more ambitious, you can run an Ubuntu container with:
 $ docker run -it ubuntu bash

Share images, automate workflows, and more with a free Docker Hub account:
 https://hub.docker.com

For more examples and ideas, visit:
 https://docs.docker.com/engine/userguide/

[root@localhost ~]#

install docker in CentOS 7

[root@localhost ~]# cat /etc/redhat-release
CentOS Linux release 7.3.1611 (Core)
[root@localhost ~]# getenforce
Enforcing
[root@localhost ~]#
[root@localhost ~]# yum install docker-engine
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
 * base: www.ftp.ne.jp
 * extras: www.ftp.ne.jp
 * updates: www.ftp.ne.jp
Resolving Dependencies
--> Running transaction check
---> Package docker-engine.x86_64 0:1.12.5-1.el7.centos will be installed
--> Processing Dependency: docker-engine-selinux >= 1.12.5-1.el7.centos for package: docker-engine-1.12.5-1.el7.centos.x86_64
--> Processing Dependency: libcgroup for package: docker-engine-1.12.5-1.el7.centos.x86_64
--> Processing Dependency: libseccomp.so.2()(64bit) for package: docker-engine-1.12.5-1.el7.centos.x86_64
--> Processing Dependency: libltdl.so.7()(64bit) for package: docker-engine-1.12.5-1.el7.centos.x86_64
--> Running transaction check
---> Package docker-engine-selinux.noarch 0:1.12.5-1.el7.centos will be installed
--> Processing Dependency: policycoreutils-python for package: docker-engine-selinux-1.12.5-1.el7.centos.noarch
---> Package libcgroup.x86_64 0:0.41-11.el7 will be installed
---> Package libseccomp.x86_64 0:2.3.1-2.el7 will be installed
---> Package libtool-ltdl.x86_64 0:2.4.2-21.el7_2 will be installed
--> Running transaction check
---> Package policycoreutils-python.x86_64 0:2.5-9.el7 will be installed
--> Processing Dependency: policycoreutils = 2.5-9.el7 for package: policycoreutils-python-2.5-9.el7.x86_64
--> Processing Dependency: setools-libs >= 3.3.8-1 for package: policycoreutils-python-2.5-9.el7.x86_64
--> Processing Dependency: libsemanage-python >= 2.5-4 for package: policycoreutils-python-2.5-9.el7.x86_64
--> Processing Dependency: audit-libs-python >= 2.1.3-4 for package: policycoreutils-python-2.5-9.el7.x86_64
--> Processing Dependency: python-IPy for package: policycoreutils-python-2.5-9.el7.x86_64
--> Processing Dependency: libqpol.so.1(VERS_1.4)(64bit) for package: policycoreutils-python-2.5-9.el7.x86_64
--> Processing Dependency: libqpol.so.1(VERS_1.2)(64bit) for package: policycoreutils-python-2.5-9.el7.x86_64
--> Processing Dependency: libapol.so.4(VERS_4.0)(64bit) for package: policycoreutils-python-2.5-9.el7.x86_64
--> Processing Dependency: checkpolicy for package: policycoreutils-python-2.5-9.el7.x86_64
--> Processing Dependency: libqpol.so.1()(64bit) for package: policycoreutils-python-2.5-9.el7.x86_64
--> Processing Dependency: libapol.so.4()(64bit) for package: policycoreutils-python-2.5-9.el7.x86_64
--> Running transaction check
---> Package audit-libs-python.x86_64 0:2.6.5-3.el7 will be installed
---> Package checkpolicy.x86_64 0:2.5-4.el7 will be installed
---> Package libsemanage-python.x86_64 0:2.5-4.el7 will be installed
---> Package policycoreutils.x86_64 0:2.5-8.el7 will be updated
---> Package policycoreutils.x86_64 0:2.5-9.el7 will be an update
---> Package python-IPy.noarch 0:0.75-6.el7 will be installed
---> Package setools-libs.x86_64 0:3.3.8-1.1.el7 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

===================================================================================================
 Package                       Arch          Version                       Repository         Size
===================================================================================================
Installing:
 docker-engine                 x86_64        1.12.5-1.el7.centos           dockerrepo         19 M
Installing for dependencies:
 audit-libs-python             x86_64        2.6.5-3.el7                   base               70 k
 checkpolicy                   x86_64        2.5-4.el7                     base              290 k
 docker-engine-selinux         noarch        1.12.5-1.el7.centos           dockerrepo         28 k
 libcgroup                     x86_64        0.41-11.el7                   base               65 k
 libseccomp                    x86_64        2.3.1-2.el7                   base               56 k
 libsemanage-python            x86_64        2.5-4.el7                     base              103 k
 libtool-ltdl                  x86_64        2.4.2-21.el7_2                base               49 k
 policycoreutils-python        x86_64        2.5-9.el7                     updates           444 k
 python-IPy                    noarch        0.75-6.el7                    base               32 k
 setools-libs                  x86_64        3.3.8-1.1.el7                 base              612 k
Updating for dependencies:
 policycoreutils               x86_64        2.5-9.el7                     updates           841 k

Transaction Summary
===================================================================================================
Install  1 Package  (+10 Dependent packages)
Upgrade             (  1 Dependent package)

Total download size: 22 M
Is this ok [y/d/N]: y
Downloading packages:
Delta RPMs disabled because /usr/bin/applydeltarpm not installed.
warning: /var/cache/yum/x86_64/7/base/packages/checkpolicy-2.5-4.el7.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID f4a80eb5: NOKEY
Public key for checkpolicy-2.5-4.el7.x86_64.rpm is not installed
(1/12): checkpolicy-2.5-4.el7.x86_64.rpm                                    | 290 kB  00:00:00
(2/12): audit-libs-python-2.6.5-3.el7.x86_64.rpm                            |  70 kB  00:00:00
(3/12): libcgroup-0.41-11.el7.x86_64.rpm                                    |  65 kB  00:00:00
(4/12): libseccomp-2.3.1-2.el7.x86_64.rpm                                   |  56 kB  00:00:00
(5/12): libsemanage-python-2.5-4.el7.x86_64.rpm                             | 103 kB  00:00:00
(6/12): libtool-ltdl-2.4.2-21.el7_2.x86_64.rpm                              |  49 kB  00:00:00
(7/12): python-IPy-0.75-6.el7.noarch.rpm                                    |  32 kB  00:00:00
warning: /var/cache/yum/x86_64/7/dockerrepo/packages/docker-engine-selinux-1.12.5-1.el7.centos.noarch.rpm: Header V4 RSA/SHA512 Signature, key ID 2c52609d: NOKEY
Public key for docker-engine-selinux-1.12.5-1.el7.centos.noarch.rpm is not installed
(8/12): docker-engine-selinux-1.12.5-1.el7.centos.noarch.rpm                |  28 kB  00:00:00
Public key for policycoreutils-python-2.5-9.el7.x86_64.rpm is not installed
(9/12): policycoreutils-python-2.5-9.el7.x86_64.rpm                         | 444 kB  00:00:00
(10/12): setools-libs-3.3.8-1.1.el7.x86_64.rpm                              | 612 kB  00:00:00
(11/12): policycoreutils-2.5-9.el7.x86_64.rpm                               | 841 kB  00:00:00
(12/12): docker-engine-1.12.5-1.el7.centos.x86_64.rpm                       |  19 MB  00:00:02
---------------------------------------------------------------------------------------------------
Total                                                              7.4 MB/s |  22 MB  00:00:02
Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-7
Importing GPG key 0xF4A80EB5:
 Userid     : "CentOS-7 Key (CentOS 7 Official Signing Key) <security@centos.org>"
 Fingerprint: 6341 ab27 53d7 8a78 a7c2 7bb1 24c6 a8a7 f4a8 0eb5
 Package    : centos-release-7-3.1611.el7.centos.x86_64 (@anaconda)
 From       : /etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-7
Is this ok [y/N]: y
Retrieving key from https://yum.dockerproject.org/gpg
Importing GPG key 0x2C52609D:
 Userid     : "Docker Release Tool (releasedocker) <docker@docker.com>"
 Fingerprint: 5811 8e89 f3a9 1289 7c07 0adb f762 2157 2c52 609d
 From       : https://yum.dockerproject.org/gpg
Is this ok [y/N]: y
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
  Updating   : policycoreutils-2.5-9.el7.x86_64                                               1/13
  Installing : libcgroup-0.41-11.el7.x86_64                                                   2/13
  Installing : setools-libs-3.3.8-1.1.el7.x86_64                                              3/13
  Installing : libsemanage-python-2.5-4.el7.x86_64                                            4/13
  Installing : checkpolicy-2.5-4.el7.x86_64                                                   5/13
  Installing : python-IPy-0.75-6.el7.noarch                                                   6/13
  Installing : audit-libs-python-2.6.5-3.el7.x86_64                                           7/13
  Installing : policycoreutils-python-2.5-9.el7.x86_64                                        8/13
  Installing : docker-engine-selinux-1.12.5-1.el7.centos.noarch                               9/13
Re-declaration of boolean virt_sandbox_use_fusefs
Failed to create node
Bad boolean declaration at /etc/selinux/targeted/tmp/modules/100/virt/cil:159
/usr/sbin/semodule:  Failed!
libsemanage.semanage_direct_install_info: Overriding docker module at lower priority 100 with module at priority 400.
restorecon:  lstat(/var/lib/docker) failed:  No such file or directory
warning: %post(docker-engine-selinux-1.12.5-1.el7.centos.noarch) scriptlet failed, exit status 255
Non-fatal POSTIN scriptlet failure in rpm package docker-engine-selinux-1.12.5-1.el7.centos.noarch
  Installing : libtool-ltdl-2.4.2-21.el7_2.x86_64                                            10/13
  Installing : libseccomp-2.3.1-2.el7.x86_64                                                 11/13
  Installing : docker-engine-1.12.5-1.el7.centos.x86_64                                      12/13
  Cleanup    : policycoreutils-2.5-8.el7.x86_64                                              13/13
  Verifying  : libseccomp-2.3.1-2.el7.x86_64                                                  1/13
  Verifying  : libtool-ltdl-2.4.2-21.el7_2.x86_64                                             2/13
  Verifying  : docker-engine-selinux-1.12.5-1.el7.centos.noarch                               3/13
  Verifying  : audit-libs-python-2.6.5-3.el7.x86_64                                           4/13
  Verifying  : policycoreutils-python-2.5-9.el7.x86_64                                        5/13
  Verifying  : python-IPy-0.75-6.el7.noarch                                                   6/13
  Verifying  : libcgroup-0.41-11.el7.x86_64                                                   7/13
  Verifying  : docker-engine-1.12.5-1.el7.centos.x86_64                                       8/13
  Verifying  : checkpolicy-2.5-4.el7.x86_64                                                   9/13
  Verifying  : libsemanage-python-2.5-4.el7.x86_64                                           10/13
  Verifying  : policycoreutils-2.5-9.el7.x86_64                                              11/13
  Verifying  : setools-libs-3.3.8-1.1.el7.x86_64                                             12/13
  Verifying  : policycoreutils-2.5-8.el7.x86_64                                              13/13

Installed:
  docker-engine.x86_64 0:1.12.5-1.el7.centos

Dependency Installed:
  audit-libs-python.x86_64 0:2.6.5-3.el7               checkpolicy.x86_64 0:2.5-4.el7
  docker-engine-selinux.noarch 0:1.12.5-1.el7.centos   libcgroup.x86_64 0:0.41-11.el7
  libseccomp.x86_64 0:2.3.1-2.el7                      libsemanage-python.x86_64 0:2.5-4.el7
  libtool-ltdl.x86_64 0:2.4.2-21.el7_2                 policycoreutils-python.x86_64 0:2.5-9.el7
  python-IPy.noarch 0:0.75-6.el7                       setools-libs.x86_64 0:3.3.8-1.1.el7

Dependency Updated:
  policycoreutils.x86_64 0:2.5-9.el7

Complete!
[root@localhost ~]#

remove '#' and empty lines

設定ファイルを確認する際に、コメント行などを表示しないようにする。

コメント行削除する場合には、sedで、

$ cat filename | sed -e '/^#.*$/d'

空行も削除するなら

$ sed -e 's/#.*$//' -e '/^$/d'

さらに以下を行うと、空行が2回続く場合に1行にまとめる。

$ cat filename | awk '{if ($0 != "" ){print $0; a=0;} else if($0 == "" && a == 0){print $0; a=1;} else {a=1}}'

After Installation, Verification StackStorm status.

Verify

なんか、いろいろFailedとか出てます。 OKなのかどうなのか微妙だ。。。

[root@stackstorm ~]# st2 --version
st2 2.0.0
[root@stackstorm ~]# st2 action list --pack=core
+-------------------+------+-----------------------------------+
| ref               | pack | description                       |
+-------------------+------+-----------------------------------+
| core.announcement | core | Action that broadcasts the        |
|                   |      | announcement to all stream        |
|                   |      | consumers.                        |
| core.http         | core | Action that performs an http      |
|                   |      | request.                          |
| core.local        | core | Action that executes an arbitrary |
|                   |      | Linux command on the localhost.   |
| core.local_sudo   | core | Action that executes an arbitrary |
|                   |      | Linux command on the localhost.   |
| core.noop         | core | Action that does nothing          |
| core.remote       | core | Action to execute arbitrary linux |
|                   |      | command remotely.                 |
| core.remote_sudo  | core | Action to execute arbitrary linux |
|                   |      | command remotely.                 |
| core.sendmail     | core | This sends an email               |
| core.windows_cmd  | core | Action to execute arbitrary       |
|                   |      | Windows command remotely.         |
+-------------------+------+-----------------------------------+
[root@stackstorm ~]# st2 run core.local -- date -R
.
id: 57e413d602ebd5155fd887a5
status: failed
parameters:
  cmd: date -R
result:
  failed: true
  return_code: 1
  stderr: 'sudo: sorry, you must have a tty to run sudo'
  stdout: ''
  succeeded: false
[root@stackstorm ~]# st2 execution list
+--------------------------+------------+--------------+---------------------+-----------------+---------------+
| id                       | action.ref | context.user | status              | start_timestamp | end_timestamp |
+--------------------------+------------+--------------+---------------------+-----------------+---------------+
| 57e413d602ebd5155fd887a5 | core.local | stanley      | failed (0s elapsed) | Thu, 22 Sep     | Thu, 22 Sep   |
|                          |            |              |                     | 2016 17:24:38   | 2016 17:24:38 |
|                          |            |              |                     | UTC             | UTC           |
+--------------------------+------------+--------------+---------------------+-----------------+---------------+
[root@stackstorm ~]# st2 run core.remote hosts='localhost' -- uname -a
..
id: 57e413e802ebd5155fd887a8
status: succeeded
parameters:
  cmd: uname -a
  hosts: localhost
result:
  localhost:
    failed: false
    return_code: 0
    stderr: ''
    stdout: 'Linux stackstorm 3.10.0-327.el7.x86_64 #1 SMP Thu Nov 19 22:10:57 UTC 2015 x86_64 x86_64 x86_64 GNU/Linux'
    succeeded: true
[root@stackstorm ~]# st2 run packs.install packs=st2
...................................
id: 57e413f602ebd5155fd887ab
action.ref: packs.install
parameters:
  packs:
  - st2
status: failed
error: sudo: sorry, you must have a tty to run sudo
traceback: None
failed_on: reload
start_timestamp: 2016-09-22T17:25:10.003137Z
end_timestamp: 2016-09-22T17:26:18.918321Z
+--------------------------+-------------------------+----------------+----------------+-----------------+
| id                       | status                  | task           | action         | start_timestamp |
+--------------------------+-------------------------+----------------+----------------+-----------------+
| 57e413f602ebd514c4a27e59 | succeeded (55s elapsed) | download       | packs.download | Thu, 22 Sep     |
|                          |                         |                |                | 2016 17:25:10   |
|                          |                         |                |                | UTC             |
| 57e4142d02ebd514c4a27e5b | succeeded (1s elapsed)  | virtualenv_pre | packs.virtuale | Thu, 22 Sep     |
|                          |                         | run            | nv_prerun      | 2016 17:26:05   |
|                          |                         |                |                | UTC             |
| 57e4142f02ebd514c4a27e5d | succeeded (10s elapsed) | setup_virtuale | packs.setup_vi | Thu, 22 Sep     |
|                          |                         | nv             | rtualenv       | 2016 17:26:07   |
|                          |                         |                |                | UTC             |
| 57e4143902ebd514c4a27e5f | failed (1s elapsed)     | reload         | packs.load     | Thu, 22 Sep     |
|                          |                         |                |                | 2016 17:26:17   |
|                          |                         |                |                | UTC             |
+--------------------------+-------------------------+----------------+----------------+-----------------+
[root@stackstorm ~]#

Start Services of StackStorm.(2)

Start services

[root@stackstorm ~]# st2ctl start
Failed to start st2chatops.service: Unit st2chatops.service failed to load: No such file or directory.
##### st2 components status #####
st2actionrunner PID: 5308
st2actionrunner PID: 5310
st2actionrunner PID: 5312
st2actionrunner PID: 5314
st2actionrunner PID: 5316
st2actionrunner PID: 5318
st2actionrunner PID: 5320
st2actionrunner PID: 5323
st2actionrunner PID: 5326
st2actionrunner PID: 5330
st2api PID: 5346
st2api PID: 5471
st2stream PID: 5363
st2stream PID: 5489
st2auth PID: 5374
st2auth PID: 5534
st2garbagecollector PID: 5407
st2notifier PID: 5422
st2resultstracker PID: 5435
st2rulesengine PID: 5446
st2sensorcontainer PID: 5459
st2chatops is not running.
mistral-server PID: 5506
mistral-api PID: 5505
mistral-api PID: 5617
mistral-api PID: 5618
[root@stackstorm ~]#

st2chatopsがエラーになってる。 他はOKなのか?

Start Services of StackStorm.

Configure SSH and SUDO

[root@stackstorm ~]# mkdir -p /home/stanley/.ssh
[root@stackstorm ~]# chmod 0700 /home/stanley/.ssh
[root@stackstorm ~]# ssh-keygen -f /home/stanley/.ssh/stanley_rsa -P ""
Generating public/private rsa key pair.
Your identification has been saved in /home/stanley/.ssh/stanley_rsa.
Your public key has been saved in /home/stanley/.ssh/stanley_rsa.pub.
The key fingerprint is:
52:9f:eb:4e:f5:3a:99:99:c6:cb:67:d3:53:57:36:88 root@stackstorm
The key's randomart image is:
+--[ RSA 2048]----+

 省略

+-----------------+
[root@stackstorm ~]# sh -c 'cat /home/stanley/.ssh/stanley_rsa.pub >> /home/stanley/.ssh/authorized_keys'
[root@stackstorm ~]# chown -R stanley:stanley /home/stanley/.ssh
[root@stackstorm ~]# sh -c 'echo "stanley    ALL=(ALL)       NOPASSWD: SETENV: ALL" >> /etc/sudoers.d/st2'
[root@stackstorm ~]# chmod 0440 /etc/sudoers.d/st2
[root@stackstorm ~]# sed -i -r "s/^Defaults\s+\+requiretty/# Defaults +requiretty/g" /etc/sudoers
[root@stackstorm ~]# vi /etc/st2/st2.conf

Register sensors, rules and actions

Faile出た。trigger作れないとか言われた。

[root@stackstorm ~]# st2ctl reload
Registering content...[flags = --register-actions --register-aliases --register-sensors --register-triggers --register-configs --register-rules]
2016-09-23 02:15:01,048 INFO [-] Connecting to database "st2" @ "0.0.0.0:27017" as user "None".
2016-09-23 02:15:01,809 INFO [-] =========================================================
2016-09-23 02:15:01,810 INFO [-] ############## Registering triggers #####################
2016-09-23 02:15:01,810 INFO [-] =========================================================
2016-09-23 02:15:01,829 INFO [-] Registered 0 triggers.
2016-09-23 02:15:01,830 INFO [-] =========================================================
2016-09-23 02:15:01,830 INFO [-] ############## Registering sensors ######################
2016-09-23 02:15:01,830 INFO [-] =========================================================
2016-09-23 02:15:01,918 INFO [-] Registered 1 sensors.
2016-09-23 02:15:01,918 INFO [-] =========================================================
2016-09-23 02:15:01,918 INFO [-] ############## Registering actions ######################
2016-09-23 02:15:01,918 INFO [-] =========================================================
2016-09-23 02:15:02,722 INFO [-] Registered 45 actions.
2016-09-23 02:15:02,722 INFO [-] =========================================================
2016-09-23 02:15:02,722 INFO [-] ############## Registering rules ########################
2016-09-23 02:15:02,722 INFO [-] =========================================================
2016-09-23 02:15:02,750 WARNING [-] Failed to register rules: A simple trigger should have been created when registering triggertype. Cannot create trigger: {'type': 'core.st2.generic.notifytrigger', 'parameters': {}, 'pack': 'core'}.
Traceback (most recent call last):
  File "/usr/bin/st2-register-content", line 22, in <module>
    sys.exit(content_loader.main(sys.argv[1:]))
  File "/opt/stackstorm/st2/lib/python2.7/site-packages/st2common/content/bootstrap.py", line 354, in main
    register_content()
  File "/opt/stackstorm/st2/lib/python2.7/site-packages/st2common/content/bootstrap.py", line 329, in register_content
    register_rules()
  File "/opt/stackstorm/st2/lib/python2.7/site-packages/st2common/content/bootstrap.py", line 224, in register_rules
    raise e
st2common.exceptions.triggers.TriggerDoesNotExistException: A simple trigger should have been created when registering triggertype. Cannot create trigger: {'type': 'core.st2.generic.notifytrigger', 'parameters': {}, 'pack': 'core'}.
##### st2 components status #####
st2actionrunner is not running.
st2api is not running.
st2stream is not running.
st2auth is not running.
st2garbagecollector is not running.
st2notifier is not running.
st2resultstracker is not running.
st2rulesengine is not running.
st2sensorcontainer is not running.
st2chatops is not running.
mistral-server is not running.
mistral-api is not running.
[root@stackstorm ~]#

そして、componentsが軒並み、not runningだぞ。

どうすればいいの、これ?

install StackStorm. (Setup Mistral Database)

Setup Mistral Database

[root@stackstorm ~]# cat << EHD | sudo -u postgres psql
> CREATE ROLE mistral WITH CREATEDB LOGIN ENCRYPTED PASSWORD 'StackStorm';
> CREATE DATABASE mistral OWNER mistral;
> EHD
could not change directory to "/root"
CREATE ROLE
CREATE DATABASE
[root@stackstorm ~]#

sudoが不要だったかなー。

スクリプトを実行したら、Warningが出た。

[root@stackstorm tmp]# /opt/stackstorm/mistral/bin/mistral-db-manage --config-file /etc/mistral/mistral.conf upgrade head
INFO  [alembic.runtime.migration] Context impl PostgresqlImpl.
INFO  [alembic.runtime.migration] Will assume transactional DDL.
INFO  [alembic.runtime.migration] Running upgrade  -> 001, Kilo release
INFO  [alembic.runtime.migration] Running upgrade 001 -> 002, Kilo
INFO  [alembic.runtime.migration] Running upgrade 002 -> 003, cron_trigger_constraints
INFO  [alembic.runtime.migration] Running upgrade 003 -> 004, add description for execution
INFO  [alembic.runtime.migration] Running upgrade 004 -> 005, Increase executions_v2 column size from JsonDictType to JsonLongDictType
INFO  [alembic.runtime.migration] Running upgrade 005 -> 006, add a Boolean column 'processed' to the table  delayed_calls_v2
INFO  [alembic.runtime.migration] Running upgrade 006 -> 007, Move system flag to base definition
INFO  [alembic.runtime.migration] Running upgrade 007 -> 008, Increase size of state_info column from String to Text
INFO  [alembic.runtime.migration] Running upgrade 008 -> 009, Add database indices
INFO  [alembic.runtime.migration] Running upgrade 009 -> 010, add_resource_members_v2_table
INFO  [alembic.runtime.migration] Running upgrade 010 -> 011, add workflow id for execution
[root@stackstorm tmp]#
[root@stackstorm tmp]# /opt/stackstorm/mistral/bin/mistral-db-manage --config-file /etc/mistral/mistral.conf populate
/opt/stackstorm/mistral/lib/python2.7/site-packages/sqlalchemy/sql/default_comparator.py:153: SAWarning: The IN-predicate on "action_definitions_v2.id" was invoked with an empty sequence. This results in a contradiction, which nonetheless can be expensive to evaluate.  Consider alternative strategies for improved performance.
  'strategies for improved performance.' % expr)
/opt/stackstorm/mistral/lib/python2.7/site-packages/sqlalchemy/sql/default_comparator.py:153: SAWarning: The IN-predicate on "workflow_definitions_v2.id" was invoked with an empty sequence. This results in a contradiction, which nonetheless can be expensive to evaluate.  Consider alternative strategies for improved performance.
  'strategies for improved performance.' % expr)
[root@stackstorm tmp]#