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]#