Nginx to proxy SQL Database URL

Question

我有一个IP为1.2.3.4的SQL服务器。我还有一个Nginx服务器，我用作代理服务器来创建子域并将其映射到我控制的其他服务，但是，我无法使用子域连接到我的SQL服务器。

因此，我的 Nginx 站点配置是：

server {
server_name mydb.domian.com;    
location / {        
proxy_pass http://1.2.3.4;
proxy_set_header Host mydb.domian.com;
} 
server_name mydb.domian.com; # managed by Certbot
listen 443 ssl; # managed by Certbot
ssl_certificate /etc/letsencrypt/live/domian.com-0001/fullchain.pem; # managed by Certbot
ssl_certificate_key /etc/letsencrypt/live/domian.com-0001/privkey.pem; # managed by Certbot
include /etc/letsencrypt/options-ssl-nginx.conf; # managed by Certbot
ssl_dhparam /etc/letsencrypt/ssl-dhparams.pem; # managed by Certbot
}

Answer 1

我能够通过创建一个具有所需子域 (mydb.domian.com( 的 A 记录来解决，我将其映射到 SQL 服务器 IP，它工作正常。

希望它在未来对某人有所帮助