Superset fail at uploading a CSV file

[#1]

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.

HDP latest.

[#2]

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.

[#3]

Andriy,

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.

Best regards,

[#4]

@Ali Alghamdi

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

to follow:

line 137: 'con': create_engine(form.con.data.sqlalchemy_uri_decrypted, echo=False),

line 882: engine = create_engine(form.con.data.sqlalchemy_uri_decrypted)