How to connect pet-clinic application with RDS in EKS

[YuriiDiduk]

As a database I want to use RDS. But application can't to connect RDS. App container status - crashloopbackoff. For RDS,EKS security group I specifically opened all in/out traffic. The cluster and database are located in the same VPC. When I using a simple mysql container, the application connects to app. From the mysql container pod I have access to RDS.

my application-mysql.properties

database=mysql spring.datasource.url=jdbc:mysql://{MYSQL_URL}:3306/petclinic?useUnicode=true spring.datasource.username=root spring.datasource.password=petclinic spring.datasource.initialization-mode=always spring.datasource.schema=classpath:db/mysql/schema.sql spring.datasource.data=classpath:db/mysql/data.sql

deployment.yml

spec:
  containers:
    - name: spring-petclinic
      image: repo/image_name:51
      ports:
        - name: web
          containerPort: 8181
      env:
        - name: SPRING_PROFILES_ACTIVE
          value: mysql
        - name: MYSQL_URL
          value:  here_RDS_address

ExternalName

apiVersion: v1
kind: Service
metadata:
name: externaldb
namespace: dev
spec:
type: ExternalName
externalName: here_RDS_address
selector:
app: externaldb
ports:
- name: sql
port: 3306
protocol: TCP
targetPort: 3306
nodePort: 30036