So I ve got Minikube running for testing and I deploy mariad

Question

So I ve got Minikube running for testing and I deploy mariadb through Helm in one stack In another stack I need to add my user and database for that app into the instance of mariadb I m having DNS resolution problems and I m trying to find the best solution to access the database in Pulumi The stack deploying Pulumi is a runner stack and it s designed to run independent but the other stack is an API stack which requires the runner to operate It s designed so others can run it minimally Does anyone have a solution so I can access the database in the 2nd stack

bored-oyster-3147 · Answer

Are they different stacks or different projects They should be different projects since they functionally are deploying different things But beyond that you can output your connection string info in the one stack and then access it with a stack reference from the other stack Have you tried something like that Might need more info on your DNS problem

dazzling-spring-78843 · Answer

They re both different stacks and they re both subprojects

bored-oyster-3147 · Answer

Can you clarify what you mean by subprojects

dazzling-spring-78843 · Answer

Both are submodules of the main git repo which deploys via Tilt with the help of Pulumi Both have their own Pulumi deployment stuff

bored-oyster-3147 · Answer

Ok I mean in the context of pulumi They are separate pulumi projects separate pulumi programs

dazzling-spring-78843 · Answer

Idk how to explain

dazzling-spring-78843 · Answer

they both have their own Pulumi yaml files

bored-oyster-3147 · Answer

Ok so then I would guess they are separate pulumi projects So what is the error you are getting

dazzling-spring-78843 · Answer

A connection refused error because the mysql plugin cannot find cerus db mariadb primary cerusbots svc cluster local 3306

bored-oyster-3147 · Answer

That looks like an internal Kubernetes hostname That s like for a pod that is in the same namespace to access the pod that is running the database Is that what you are trying to do or are you trying to reach that from outside of the cluster

dazzling-spring-78843 · Answer

Yes I need the mysql Pulumi plugin to proxy into the Kubernetes cluster

bored-oyster-3147 · Answer

I think if you want to reach the database from outside the cluster you need to setup an ingress on the cluster that points at the service in front of your database pod And then from outside the cluster you would point at that ingress

dazzling-spring-78843 · Answer

Yeah I m trying to figure out how to do that

billowy-army-68599 · Answer

you need to expose the the mariadb as a service can you share how you ve deployed mariadb there s settings on the helm chart to expose it I m assuming this is your first foray into kubernetes

dazzling-spring-78843 · Answer

I deploy it with the Bitnami help chart as replicated

billowy-army-68599 · Answer

okay but can you share the code you have

dazzling-spring-78843 · Answer

<https github com CerusBots|https github com CerusBots> repos are API and runner I ve got my most recent additions being pushed soon

dazzling-spring-78843 · Answer

Commits are pushed now

billowy-army-68599 · Answer

i was mainly just looking for the part of the code that has the helm chart values essentially you just need to change this value <https github com bitnami charts blob master bitnami mariadb values yaml L474> expose the service as a `NodePort` and retrieve the address

dazzling-spring-78843 · Answer

Alright and how do I get ` pulumi mysql` to connect to it automatically

billowy-army-68599 · Answer

you need to pass the address to the provider configuration

billowy-army-68599 · Answer

billowy-army-68599 · Answer

if you re not familiar with Kubernetes this is going to be a lot of peeling back layers though

dazzling-spring-78843 · Answer

I ve been learning k8s for almost 3 months now

dazzling-spring-78843 · Answer

But I m looking to see if I can get Pulumi to retrieve the IP address automatically

billowy-army-68599 · Answer

Got it This is all just a kubernetes networking problem

dazzling-spring-78843 · Answer

Is there a way for Pulumi to retrieve the IP of the NodePort automatically

billowy-army-68599 · Answer

Yep there s an example in the docs

dazzling-spring-78843 · Answer

Where I ve checked and I haven t been able to find it

billowy-army-68599 · Answer

dazzling-spring-78843 · Answer

Thanks

dazzling-spring-78843 · Answer

Ok it s almost working ```Could not connect to server dial tcp 10 103 26 125 30000 connect connection timed out ``` I just need to figure out how to expose the cluster ip

billowy-army-68599 · Answer

That s the minikube node address it s not routable from your machine

billowy-army-68599 · Answer

You ll need to read up on how minikube does it s networking

dazzling-spring-78843 · Answer

Ok looks like an ingress will work

billowy-army-68599 · Answer

not necessarily most ingress controllers won t support tcp

dazzling-spring-78843 · Answer

I don t see a specific format for the proxy input in the mysql provider

dazzling-spring-78843 · Answer

How do I use the IP on an ingress as a proxy for the mysql plugin which then lets me use db internal cerusbots test to access the database

bored-oyster-3147 · Answer

you just use the ingress in your connection string

dazzling-spring-78843 · Answer

``` entrypoint `db internal cerusbots test` ``` proxy k8s core v1 Service get cerus ingress internal interpolate`$ namespace cerus ingress internal` status loadBalancer ingress apply ingress = gt ingress 0 ip I have this in my code

dazzling-spring-78843 · Answer

It s the configuration for the mysql provider so this will work

bored-oyster-3147 · Answer

what is `db internal cerusbots test`

dazzling-spring-78843 · Answer

A hostname in the ingress

dazzling-spring-78843 · Answer

The idea is to use the IP to connect since this ingress is only needed for deployment

bored-oyster-3147 · Answer

Yes I guess I m confused why you need proxy I would expect that all you need is `endpoint ingress ip ingress port `

billowy-army-68599 · Answer

I m not sure how else to say this but what you re doing is being complicated by the kubernetes networking model and minikube Both have a networking layer which is making what is usually an easy process very difficult I would start by understanding how kubernetes networking operates and how minikube networking works If you can connect from the machine you re running Pulumi on to your MySQL host with the MySQL command line client all of this will just work

dazzling-spring-78843 · Answer

Because the ingress is trying to send HTTP and not raw TCP packets

bored-oyster-3147 · Answer

then ingress isn t the right thing to use

dazzling-spring-78843 · Answer

I m not trying to use the mysql command I m trying to use the mysql plugin for Pulumi

bored-oyster-3147 · Answer

yes but he s saying if you can get it to work with the mysql command it will work with pulumi

dazzling-spring-78843 · Answer

I ve tried everything else

dazzling-spring-78843 · Answer

I need a proxy which automatically runs for the duration of Pulumi deploying the stack

dazzling-spring-78843 · Answer

And with CI CD that makes things more complicated since I did get it working with a manual kubectl proxy

bored-oyster-3147 · Answer

I think you re thinking about that wrong What you need to do is deploy temporary resources and destroy them after You don t need something that automatically runs for X duration You can spin up a 3rd pulumi project temporarily and then destroy it after

dazzling-spring-78843 · Answer

I m not sure how to do that

dazzling-spring-78843 · Answer

I ve been on this issue all day and so far nothing works the way I need it to

bored-oyster-3147 · Answer

I wouldn t worry about how you destroy your temporary resources until after you get your connection working

dazzling-spring-78843 · Answer

Ok and how should I do the connection

dazzling-spring-78843 · Answer

I ve tried NodePorts LoadBalancers and Ingresses

bored-oyster-3147 · Answer

<https mariadb org mariadb k8s communication between containers deployments > This says you should use a nodeport

dazzling-spring-78843 · Answer

That looks like what I ve already tried

billowy-army-68599 · Answer

For the third time nodeport is not working because of minikube Minikube creates a VM which is not routable from where you are running Pulumi by default

billowy-army-68599 · Answer

I don t know how else to say it I m going to mute this thread because it s going nowhere

dazzling-spring-78843 · Answer

I was hoping to use a proxy to do that and how can I get the IP I need to use automatically

mammoth-garden-53682 · Answer

apologies if I ve missed something in skimming this thread but < dazzling spring 78843> you would have to expose a routable ip on the host in order to access your nodeport ingress whatever via `minikube tunnel` this could be cumbersome to automate because the tunnel runs as a separate process have a read of this

mammoth-garden-53682 · Answer

for automation it may be preferable to switch to something like `kind` over minikube because you can configure exposure on the host network from file <https kind sigs k8s io docs user configuration networking>