App host running projects and docker images

[allensiho]

I am running an Aspire App host that points to the solutions projects and a sql server container

Because this solution does not contain all the projects,
I have to run projects outside the solution using the built docker image that runs on kubernetes

The problem is I can get the projects to talk to the local mssql server running but not the docker container image

Is there a way to do this with aspire or what is recommended?

Thanks

[davidfowl]

Is the docker image configured to talk to the same sql sever that you're running in a container?

[allensiho]

I pass in environment variables

I have tried a few things like

• making my docker desktop use local network
• passing in host.docker.internal gateway
  The projects can talk to mssql on localhost,1433

[allensiho]

Yes I believe docker image us running as container

[davidfowl]

I need a diagram or app host code, there's a bunch of moving parts that are hard to understand from the text.

[allensiho]

Some sample code

var databaseSettings = builder.Configuration.GetSection(nameof(Database)).Get()!;

var db = builder.AddSqlServer("mssql", password, 1433)
//.WithBindMount("VolumeMount.AppHost-sql-data", "/var/opt/mssql")
.WithDataVolume()
.WithBindMount("./SqlServer", "/usr/config")
// Mount the SQL scripts directory into the container so that the init scripts run.
.WithBindMount("./init", "/docker-entrypoint-initdb.d")
// Run the custom entrypoint script on startup.
.WithEntrypoint("/usr/config/entrypoint.sh")
.WithSqlHealthCheck();

var aservice = builder.AddProject<Projects.XXXXXXXXXX>("XXXXX")
.WithReference(rabbitmq)
.WithReference(db)
.WithReference(kafka)
.WithMassTransitSettings(massTransitSettings)
.WithDatabaseSettings(databaseSettings)
.WithExternalHttpEndpoints()
.WaitFor(kafka);

var dockerImageService = builder.AddContainer("docker-scheduler",
"ghcr.io/some-image", "7.1.1")
.WithReference(rabbitmq)
.WithReference(db)
.WithReference(kafka)
.WithDatabaseSettings(databaseSettings)
.WithEnvironment("Database__ConnectionString", "Server=host.docker.internal,1433;User ID=sa;Password=XXXX;Database=XXXXXX;TrustServerCertificate=true")
.WithContainerRuntimeArgs("--network=host")
.WaitFor(kafka)
.WaitFor(db);

[davidfowl]

Are you running docker desktop on windows?

[allensiho]

I cannot get my dockerImageService to talk to Sql Container

Thanks

[allensiho]

No on MAC

…

On Thu, 31 Oct 2024, 5:09 pm David Fowler, ***@***.***> wrote: Are you running docker desktop on windows? — Reply to this email directly, view it on GitHub <#6567 (reply in thread)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ABRYFWLGK4FTLSVIOEONSH3Z6HCRTAVCNFSM6AAAAABQ5SBT4WVHI2DSMVQWIX3LMV43URDJONRXK43TNFXW4Q3PNVWWK3TUHMYTCMJQG43TSMA> . You are receiving this because you authored the thread.Message ID: ***@***.***>

[davidfowl]

Docker desktop on Mac?

[allensiho]

Yes

…

On Thu, 31 Oct 2024, 5:14 pm David Fowler, ***@***.***> wrote: Docker desktop on Mac? — Reply to this email directly, view it on GitHub <#6567 (reply in thread)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ABRYFWMD3WL3UWWZCSKABHDZ6HDEZAVCNFSM6AAAAABQ5SBT4WVHI2DSMVQWIX3LMV43URDJONRXK43TNFXW4Q3PNVWWK3TUHMYTCMJQG44DEMA> . You are receiving this because you authored the thread.Message ID: ***@***.***>

[allensiho]

You think it should be possible for the docker container to talk to mssql? Thanks

…

On Thu, 31 Oct 2024, 5:36 pm Allen Ho, ***@***.***> wrote: Yes On Thu, 31 Oct 2024, 5:14 pm David Fowler, ***@***.***> wrote: > Docker desktop on Mac? > > — > Reply to this email directly, view it on GitHub > <#6567 (reply in thread)>, > or unsubscribe > <https://github.com/notifications/unsubscribe-auth/ABRYFWMD3WL3UWWZCSKABHDZ6HDEZAVCNFSM6AAAAABQ5SBT4WVHI2DSMVQWIX3LMV43URDJONRXK43TNFXW4Q3PNVWWK3TUHMYTCMJQG44DEMA> > . > You are receiving this because you authored the thread.Message ID: > ***@***.***> >