HTTPS doesn't allow SQL proxy to work

[jerrodtracy]

SQL proxy is working perfect with grafana using the default http and port 3000. When trying to set protocol to https on port 3000 (or any port), or trying to use apache as a proxy for https it fails with the following Error {"err":{"data":null,"status":-1,"config":{"method":"POST","transformRequest":[null],"transformResponse":[null],"jsonpCallbackParam":"callback","url":"http://grafana:666/?con=mssql://user:password@sqlIP/DB","data":{"type":"test","body":null,"url":"mssql://user:password@sqlIP/DB"},"retry":0,"headers":{"Accept":"application/json, text/plain, */*","Content-Type":"application/json;charset=utf-8"}},"statusText":""},"cancelled":true}

[gbrian]

Hi @jerrodtracy ,

Ops, HTTPS is on the TODOs list so never tested. The proxy server uses Express module so it needs some tweaks to enable HTTPS (http://blog.mgechev.com/2014/02/19/create-https-tls-ssl-application-with-express-nodejs/) BTW it shoud be possible to wrap your proxy with an apache/nginx managing the secure layer and communicating plain HTTP to the proxy, isn't it? So what's the problem with apache? Have you tried the apahe option with another site to check if it works?

Thanks

[jerrodtracy]

@gbrian ,

Thanks for responding back. I'll do some additional testing this week if I can find time.