OtpCode.Api service not Connecting to mysql db runing if both running in docker container

[realRajneesh]

hey @Matthew-Oduamafu

Thanks for sharing repository. I am having issue to connect OtpCode.Api to mysqldb, both running in docker container.

MySqlConnector.MySqlException (0x80004005): Unable to connect to any of the specified MySQL hosts.

connectionString is

"DbConnection":"server=mysql_db;port=3306;database=Otpdb;user=test;password=stronglikeHulk;CharSet=utf8;SslMode=Preferred;"

I have also added delay to connect mysql_db service so that it can initialize completely but no Luck!

[Matthew-Oduamafu]

Hello @realRajneesh I guess you're trying to connect to mysql container in docker, the server is supposed to be localhost instead of the container name
So try this
"DbConnection":"server=localhost;port=3306;database=Otpdb;user=test;password=stronglikeHulk;CharSet=utf8;SslMode=Preferred;"

[Matthew-Oduamafu]

In case you have packaged the backend as docker image, then both containers must be on the same network and order to reach mysql from docker by the container name