sometimes I got this error if I idle or open Metabase for the next day
Socket fail to connect to host:localhost, port:43003. Connection refused (Connection refused)
but if I resave the database configuration without editing I got normally.
i am running on a different server Metabase with database want to monitoring
Sorry, i am a newbie. can you explain more about this ssh -Nf -L input-port:internal-server-name:port-on-server username@bastion-host.domain.com
what is
input-port
internal-server-name = this is Metabase server?
port-on-server
@herdikun SSH is a fairly large subject by itself and there are many tutorials on the internet to learn more about it.
I don’t know your setup, so you might you need to search the internet for more information, since it is not specific to Metabase.
If you do something like this: ssh -Nf -L 4321:mydb.company.internal:1234 username@bastion-host.domain.com
You would then connect in Metabase to localhost on port 4321, and the SSH tunnel would then connect to the bastion, which would then try to connect to mydb.company.internal on port 1234. If the database is on your bastion, then you would just use localhost instead of mydb.company.internal
I am having a similar issue with my Metabase connection.
I have tried what you prescribed in:
but still getting the same connection error once I am idle for few minutes
I am running two remote servers, one is where I installed the docker metabase and the other server is where I have my MySQL database
I set up ssh connection as follows:
ssh -Nf -L “server-running-metabase-port:db-localhost:db-localhost-port username@db-server-ip”
Am I missing anything?
@tunde Post “Diagnostic Info” from Admin > Troubleshooting.
And post the non-redacted SSH command - you’re redacting too much. I don’t know if you have actually setup a tunnel on localhost listening on port 3306
@tunde
Are you running Docker?
Or do you have anything blocking the Metabase java-process from accessing localhost:3306 ? You can use any other tool to test that - even just telnet:
Hi @flamber,
Yes, I am using Metabase docker, but my mysql database is not running on docker.
I am able to telnet localhost 3306 from the metabase server host to mysql database host.
Do I need special configuration if I am running metabase docker?