I’m using Metabase for a private dashboard which is however accessible over the internet, therefore I would like to secure it with a certificate from let’s encrypt as it is free. I’m curious if it’s possible to create a certificate for the Metabase Java Webserver? Or is there any other solution which is recommendable?
I use a apache2 server for ssl termination and as proxy.
in apache2 i configured a virtual host for ssl connections to metabase.mydomain.com. with certbot for apache2 i signed the ssl certificate.
the proxy configuration for the virtual host looks like that:
You can terminate at the MB webserver –
I chose a different approach, I self signed a certificate and now use it with metabase directly, it works perfectly.
You have to create a java keystore file with your letsencrypt cert and private key and give it a password for SSL to work with metabase. I applied the following command lines to achieve this:
openssl pkcs12 -export -in /etc/letsencrypt/live/foobar.com/fullchain.pem -inkey /etc/letsencrypt/live/foobar.com/privkey.pem -out /etc/apache2/keystore/foobar.com.p12 -password pass:YOURPASSWORDHERE
keytool -importkeystore -srckeystore /etc/apache2/keystore/foobar.com.p12 -srcstoretype pkcs12 -srcstorepass YOURPASSWORDHERE -destkeystore /etc/apache2/keystore/foobar.com.keystore -deststoretype jks -deststorepass YOURPASSWORDHERE
java -jar metabase.jar
and I was able to connect to metabase https on port 8443.
You’ll probably need to do this more than once as certbot rotates keys every 90 days by default. Or just write a script.