srinify edited a comment on issue #14862: URL: https://github.com/apache/superset/issues/14862#issuecomment-850477917
Hi @erikgardea if you look at the error message, you'll notice the following error from `superset_app` (which corresponds to the superset python service + container): ``` KeyError: 'host' ``` This is an important clue! This means that your HOST in your SQLAlchemy connection string is missing, as far as superset is concerned! Now, if we look at the [recommended SQLAlchemy string in the documentation](https://superset.apache.org/docs/databases/mysql): ``` mysql://{username}:{password}@{host}/{database} ``` andddd compare it to what your logs are showing: ``` mysql://remote:XXXXXXXXXX@mysql1:3306/ ``` ... you may notice the issue! After the `@` symbol, you need to put the HOST value. The HOST is usually: - `localhost` if Superset & MySQL are running in the same networking setup. It looks like that's not exactly the case for you since you're using Docker Compose for Mac to run Superset and MySQL - The host as a URL `20230dlslls.amazon.aws.com` or something like that - **A shortcut that RESOLVES to a HOST value, like `docker.for.mac.internal`** which resolves to your Macbook as the HOST I would try the 3rd option and see what happens. Here's a hint at the swap you need to try! ``` mysql://remote:[email protected]:3306/product_usage ``` -- 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]
