How to Run Decision Engine

Decision engine uses postgresql database back-end.

Install postgresql

Default postgresql installed on RH7 is 9.2 which is outdated. Suggest to remove it and install 11 instead :

1. Remove old postgresql

yum erase -y postgresql*

2. Install postgresql 11

yum install https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm
yum install -y postgresql11 postgresql11-server

3. Enable postgresql

systemctl enable postgresql-11

4. Init db

 /usr/pgsql-11/bin/postgresql-11-setup initdb

5. edit /var/lib/pgsql/11/data/pg_hba.conf like so:

[root@fermicloud371 ~]# diff  /var/lib/pgsql/11/data/pg_hba.conf~ /var/lib/pgsql/11/data/pg_hba.conf 
80c80
< local   all             all                                     peer
---
> local   all             all                                     trust
82c82
< host    all             all             127.0.0.1/32            ident
---
> host    all             all             127.0.0.1/32            trust
84c84
< host    all             all             ::1/128                 ident
---
> host    all             all             ::1/128                 trust

(that is setting authentication method is trust) 6. start database

systemctl start postgresql-11

7. create decisionengine

createdb -U postgres decisionengine

8. create database schema

psql -U postgres decisionengine -f /usr/lib/python2.7/site-packages/decisionengine/framework/dataspace/datasources/postgresql.sql