permission denied to create extension "pg_trg

[sureshbyella]

(lemur) lemur@ubuntu-xenial:/www/lemur/lemur$ lemur init [2019-10-08 06:16:57,456] WARNING in managers: Plugin 'DigiCertCISIssuerPlugin' may not work correctly. Required variable 'DIGICERT_CIS_API_KEY' is not set in Lemur's conf. Plugin 'DigiCertCISIssuerPlugin' may not work correctly. Required variable 'DIGICERT_CIS_API_KEY' is not set in Lemur's conf. [2019-10-08 06:16:57,457] WARNING in managers: Plugin 'DigiCertCISSourcePlugin' may not work correctly. Required variable 'DIGICERT_CIS_API_KEY' is not set in Lemur's conf. Plugin 'DigiCertCISSourcePlugin' may not work correctly. Required variable 'DIGICERT_CIS_API_KEY' is not set in Lemur's conf. [2019-10-08 06:16:57,457] WARNING in managers: Plugin 'DigiCertIssuerPlugin' may not work correctly. Required variable 'DIGICERT_API_KEY' is not set in Lemur's conf. Plugin 'DigiCertIssuerPlugin' may not work correctly. Required variable 'DIGICERT_API_KEY' is not set in Lemur's conf. Traceback (most recent call last): File "/www/lemur/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1249, in _execute_context cursor, statement, parameters, context File "/www/lemur/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 552, in do_execute cursor.execute(statement, parameters) psycopg2.errors.InsufficientPrivilege: permission denied to create extension "pg_trgm" HINT: Must be superuser to create this extension.

The above exception was the direct cause of the following exception:

Traceback (most recent call last): File "/www/lemur/bin/lemur", line 11, in load_entry_point('lemur', 'console_scripts', 'lemur')() File "/www/lemur/lemur/manage.py", line 587, in main manager.run() File "/www/lemur/lib/python3.7/site-packages/flask_script/init.py", line 417, in run result = self.handle(argv[0], argv[1:]) File "/www/lemur/lib/python3.7/site-packages/flask_script/init.py", line 386, in handle res = handle(*args, **config) File "/www/lemur/lib/python3.7/site-packages/flask_script/commands.py", line 216, in call return self.run(*args, **kwargs) File "/www/lemur/lemur/manage.py", line 198, in run create() File "/www/lemur/lemur/manage.py", line 148, in create database.db.engine.execute(text("CREATE EXTENSION IF NOT EXISTS pg_trgm")) File "/www/lemur/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 2179, in execute return connection.execute(statement, *multiparams, **params) File "/www/lemur/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 988, in execute return meth(self, multiparams, params) File "/www/lemur/lib/python3.7/site-packages/sqlalchemy/sql/elements.py", line 287, in _execute_on_connection return connection._execute_clauseelement(self, multiparams, params) File "/www/lemur/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1107, in _execute_clauseelement distilled_params, File "/www/lemur/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1253, in _execute_context e, statement, parameters, cursor, context File "/www/lemur/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1473, in _handle_dbapi_exception util.raise_from_cause(sqlalchemy_exception, exc_info) File "/www/lemur/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 398, in raise_from_cause reraise(type(exception), exception, tb=exc_tb, cause=cause) File "/www/lemur/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 152, in reraise raise value.with_traceback(tb) File "/www/lemur/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1249, in _execute_context cursor, statement, parameters, context File "/www/lemur/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 552, in do_execute cursor.execute(statement, parameters) sqlalchemy.exc.ProgrammingError: (psycopg2.errors.InsufficientPrivilege) permission denied to create extension "pg_trgm" HINT: Must be superuser to create this extension.

[SQL: CREATE EXTENSION IF NOT EXISTS pg_trgm] (Background on this error at: http://sqlalche.me/e/f405) (lemur) lemur@ubuntu-xenial:/www/lemur/lemur$

[sureshbyella]

FIX: Adding Superuser role to lemur user and run init again. postgres=# \du List of roles Role name | Attributes | Member of -----------+------------------------------------------------------------+----------- lemur | | {} postgres | Superuser, Create role, Create DB, Replication, Bypass RLS | {}

postgres=# alter role lemur createrole SuperUser; ALTER ROLE postgres=# \du List of roles Role name | Attributes | Member of -----------+------------------------------------------------------------+----------- lemur | Superuser, Create role | {} postgres | Superuser, Create role, Create DB, Replication, Bypass RLS | {}

postgres=#