MySQL Connection from Docker/Kubernetes with Connection String

Question

developing an ASP.NET Core 3.0 application, with centralized MySQL Database.

I am using a Connection String, which looks like this:

Server=mysql;Database=db-name;Uid=User;Pwd=Pass;SslMode=Preferred;persistsecurityinfo=false;

"mysql" is an internal DNS Record, which points to the central MySQL Server. In Visual Studio, it works fine.

Now I want to deploy it to kubernetes.

I already did that with MSSQL successfully. I created an endpoint (ep) in kubernetes, pointing to the correct IP:

Name:         mysql
Namespace:    my_namespace
Labels:       <none>
...
Subsets:
  Addresses:          192.168.6.200
  NotReadyAddresses:  <none>
  Ports:
    Name   Port  Protocol
    ----   ----  --------
    mysql  3306  TCP

Events:  <none>

And I created a corresponding Kubernetes service:

Name:              mysql
Namespace:         my_namespace
Labels:            <none>
...
Selector:          <none>
Type:              ClusterIP
IP:                10.104.84.99
Port:              mysql  3306/TCP
TargetPort:        3306/TCP
Endpoints:         192.168.6.200:3306
Session Affinity:  None
Events:            <none>

All this looks like the stuff I did with MSSQL.

And I could confirm the working networking:

root@kubernetes-server:/application# kv exec application-7c85b5d9d8-9vxhb -- curl mysql:3306
  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                                 Dload  Upload   Total   Spent    Left  Speed
  0     0    0     0    0     0      0      0 --:--:--  0:00:04 --:--:--     0J
100   115    0   115    0     0     25      0 --:--:--  0:00:04 --:--:--    25#08S01Got packets out of order

"Got packets out of order" is definately a response from the MySQL server. I also could confirm that via Wireshark.

But the application will not run. I get the error: "Unable to connect to any of the specified MySQL hosts."

Did I do something wrong?

Greetings, xola

Check out this link. Does this solve your problem?

Matt
– Matt

2020-02-26 11:57:26 +00:00
Commented Feb 26, 2020 at 11:57 — Matt
– Matt, Commented Feb 26, 2020 at 11:57
Already found that. But it doesn't help.

xola
– xola

2020-02-26 15:28:48 +00:00
Commented Feb 26, 2020 at 15:28 — xola
– xola, Commented Feb 26, 2020 at 15:28

xola · Accepted Answer · 2020-02-28 09:33:27Z

1

Got it. It wasn't the Connection String. Unfortunately, I did't see the errors prior to that error message. Since we encrypt the connection string, we have a key for decryption. The decrypt-key was not correctly set, so the application wanted to set up a connection using the encrypted, not the decrypted Connection String.

But thank you anyway!

edited Feb 28, 2020 at 9:33

answered Feb 27, 2020 at 11:36

xola

4951 gold badge4 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

MySQL Connection from Docker/Kubernetes with Connection String

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related