Cannot connect to azure mysql flexible server while --require_secure_transport=ON

[vsmanu]

📑 I have found these related issues/pull requests

uptime-kuma/server/setup-database.js

Line 212 in 8a432ac

host: dbConfig.hostname,

🛡️ Security Policy

• I agree to have read this project Security Policy

Description

Cannot connect to azure mysql flexible server: Connections using insecure transport are prohibited while --require_secure_transport=ON.

👟 Reproduction steps

How to reproduce:

• Create a mysql flexible server on azure.
• Try to connect it with required connection parameters.

👀 Expected behavior

Expected result :

• If credentials and connectivity is ok, test connection succeeds.

😓 Actual Behavior

Actual result:

• Connection fails with following message in web console.

Cannot connect to the database: Connections using insecure transport are prohibited while --require_secure_transport=ON.

• As a debugging step if we configure require_secure_transport=OFF for the server the application will pass the connection test.

🐻 Uptime-Kuma Version

2.X-Beta

💻 Operating System and Arch

Docker louislam/uptime-kuma:2.0.0-beta.0

🌐 Browser

Brave 1.71.118

🖥️ Deployment Environment

• Runtime: Docker Azure webapp
• Database: Azure mysql flexible
• Filesystem used to store the database on: NA
• number of monitors: NA

📝 Relevant log output

Cannot connect to the database: Connections using insecure transport are prohibited while --require_secure_transport=ON.