I have the docker image deployed to a heroku but I am stuck

Question

I have the docker image deployed to a heroku but I am stuck on getting the server app connected to mysql and redis I am running `fleet prepare db` but the error `failed to start creating db connection default addr for network <http us cdbr east 05 cleadb net asdfasdfasdf|us cdbr east 05 cleadb net asdfasdfasdf> unknown` It seems to not know the URL for that db but that s the url provided by heroku in their server env variables

Michal Nicpon · Answer

How are you setting the fleet mysql address Can you paste the value you are using make sure you replace any sensitive info like username and password

Mo Zhu · Answer

Hi Yes I have an env variable set to `FLEET MYSQL ADDRESS <mysql xxx xxx us cdbr east 05 cleardb net heroku e825c9bd49d3cbb reconnect=true>`

Mo Zhu · Answer

and that `mysql ` address is given by the cleardb mysql heroku add on

Mo Zhu · Answer

I basically made the configuration in heroku env variables to match here

Mo Zhu · Answer

I am assuming that the only one that I have to get right here is the MYSQL ADDRESS The other ones I can specify however I want and `fleet prepare db` will do the rest

Michal Nicpon · Answer

Ah I see the problem Fleet expects the database configuration to be provided via multiple environment variables `FLEET MYSQL ADDRESS` `FLEET MYSQL DATABASE` `FLEET MYSQL USERNAME` `FLEET MYSQL PASSWORD` See <https fleetdm com docs deploying configuration my sql>

Mo Zhu · Answer

I did set all of these `FLEET MYSQL ADDRESS` `FLEET MYSQL DATABASE` `FLEET MYSQL USERNAME` `FLEET MYSQL PASSWORD` But are you saying that they need to be specific strings that match the set up of the db

Michal Nicpon · Answer

you were trying to pass everything in via `FLEET MYSQL ADDRESS` In this case you need to do ```FLEET MYSQL ADDRESS=<http us cdbr east 05 cleardb net 3306|us cdbr east 05 cleardb net 3306> FLEET MYSQL DATABASE=heroku e825c9bd49d3cbb FLEET MYSQL USERNAME=xxx FLEET MYSQL PASSWORD=xxx```

Mo Zhu · Answer

ohhh I see I see

Mo Zhu · Answer

let me try thank you

Mo Zhu · Answer

worked great

Mo Zhu · Answer

I m running into a new issue now will investigate and come back if I can t figure it out

Mo Zhu · Answer

but at least it s a new issue so that s progress

Mo Zhu · Answer

by the way how did you know to use port 3306 Is that some kind of standard convention

Michal Nicpon · Answer

3306 is the default mysql port

Mo Zhu · Answer

ah i see