While trying to upload a csv file to Superset using the GUI I get the following
(pg.InternalError) FATAL: password authentication failed for user "superset"
(Background on this error at: http://sqlalche.me/e/2j85)
You can check the photo attached.
Checked the link mentioned in issue and it wasn't helpful.
This is the first time I try uploading using the GUI, so it wasn't working before or anything.
Have the same problem.
In my case the "problem" was caused by authentication method.
To "resolve" in my test environment I set authentication method from md5 into trust in pg_hba.conf in my Postgresql server on the database used for importing data.
Another authentication methods caused the same error.
I believe this is something like bug...
@Ali Alghamdi, please test and let me know.
That should work yeah, but it must be a security flaw to open the trust channel.
I hope we get an answer soon with clear instructions and clarifications.
You can simply fix this problem https://github.com/apache/incubator-superset/issues/4285
So, change lines in file: /usr/hdp/current/superset/lib/python3.4/site-packages/superset/db_engine_specs.py
line 137: 'con': create_engine(form.con.data.sqlalchemy_uri_decrypted, echo=False),
line 882: engine = create_engine(form.con.data.sqlalchemy_uri_decrypted)