MySQL SSL connection

8

@islamthecurecom If you're not familiar with webservers, then I would recommend that you just use a service like Cloudflare. Running servers requires constant maintenance and understanding how they work. Otherwise consider using Metabase Cloud https://www.metabase.com/pricing/

The entire point is to remove the port 3000, so you just access https://tglsystem.com/, which I can see is working fine with certificate, but the reverse-proxing to Metabase is not correct.

Try changing this:

    location = / {
            proxy_pass http://127.0.0.1:3000;
    }

To this:

location = / {
    proxy_set_header Host $host;
    proxy_set_header X-Real-IP $remote_addr;
    proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
    proxy_set_header x-forwarded-proto https;
    proxy_set_header x-forwarded-protocol https;
    proxy_set_header x-url-scheme https;
    proxy_set_header x-forwarded-ssl on;
    proxy_set_header front-end-https on;
    proxy_http_version 1.1;
    proxy_pass http://127.0.0.1:3000/;
}