I am trying to connect my spring-boot api inside a kubernetes pod to an external database (a separate machine but within the local network), however when running, I get SQLNonTransientConnectionException, UknownHostException: mysql-svc, the api cannot connect to the database but whenever I ping the database address from inside the pod using kubectl exec -it, I can ping it successfully, anybody who has experienced the same error as mine?
here is my application.properties connection uri and kubernetes objects:
spring.datasource.url=jdbc:mysql://mysql-svc/test?autoReconnect=true --- apiVersion: v1 kind: Service metadata: name: mysql-svc spec: type: ClusterIP ports: - port: 3306 targetPort: 3306 --- apiVersion: v1 kind: Endpoints metadata: name: mysql-svc subsets: - addresses: - ip: 10.0.123.28 ports: - port: 3306 name: mysql-svc
Kubernetes version: 1.16
Cloud being used: VMs on local network
Host OS: CentOS 7
CNI and version: Flannel latest
CRI and version: Docker 19.03.2