Skip to content

Instantly share code, notes, and snippets.

@DarkDesire
Created November 7, 2019 19:38
Show Gist options
  • Save DarkDesire/c4a22bd04bcaf9237618c451c81fe057 to your computer and use it in GitHub Desktop.
Save DarkDesire/c4a22bd04bcaf9237618c451c81fe057 to your computer and use it in GitHub Desktop.
Guides:
https://docs.cloudera.com/HDPDocuments/HDP3/HDP-3.1.0/adding-druid/content/druid_add_superset.html
https://docs.cloudera.com/HDPDocuments/HDP3/HDP-3.1.4/integrating-hive/content/hive_start_the_superset_service.html
ERROR:flask_appbuilder.security.sqla.manager:DB Creation and initialization failed: (pg.InternalError) FATAL: no pg_hba.conf entry for host "::1", user "superset", database "superset", SSL off
su - postgres
vi /var/lib/pgsql/data/pg_hba.conf
host all superset ::/0 md5
ERROR:flask_appbuilder.security.sqla.manager:DB Creation and initialization failed: (pg.InternalError) FATAL: password authentication failed for user "superset"
!
superset_database_password
!
su - postgres
psql
create database superset;
create user superset with encrypted password 'superset_database_password';
grant all privileges on database superset to superset;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment