alderson59 commented on issue #14764: URL: https://github.com/apache/superset/issues/14764#issuecomment-846453437
I was JUST about to open an issue on this. Perfect timing, glad I wasn't the only one. @pinduvn , I think it helps to describe your problem in greater detail so others can help you. I'll just do it for you, since I think we're facing the same problem. After putting in the URI of my external postgres host correctly, i.e. `postgresql://[user]:[passwd]@[host-ip]:[port]/[dbname]` I clicked on Test Connection, which shows `Connection looks good!` But when I click Connect, this is the error I get: `An error occurred while creating databases: Fatal error` I googled this error, but could not find it anywhere at all. For context on how I installed it on my Ubuntu 20.0.4 host, I ran `git clone https://github.com/apache/superset` then `cd superset` and `docker-compose -f docker-compose-non-dev.yml up -d` Didn't tweak any further settings. Wanted a clean version up and running before changing any config, but alas, that didn't work right out of the box. Based on the basic config, I was able to track down the fact that the bundled postgres db showed a FATAL error because role 'root' was missing, when I did a psql using root. Not sure if this is a contributing factor though, since the default .env and .env-non-dev should already have the `superset` user connecting to the `superset` db, with the `superset` password. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
