I am running a local metabase installation and I am able to run metabase with local databases but can not
connect with remote databases.
Is it even possible?
Or do you need the metabase and the database at the same IP with different ports?
Hi @coffeebotsrepos
You can run Metabase from any location and have data sources in any location.
The only requirement is that the two locations has to be able to connect to each other, so make sure they are available and not firewalled.
Actually it is giving the timeout error and You have mentioned before in your previous it is possibly because of incorrect port or host or a firewall issue.
Port and host seems to correct but not sure how to handle if it is because of the firewall.
The admin of the database is saying there is no firewall issue.
@coffeebotsrepos
Either the host or port is incorrect, or you are having network issues (which can be everything from firewall to DNS, or other routing issues).
Post "Diagnostic Info" from Metabase Admin > Troubleshooting.
And have a look here: https://www.metabase.com/docs/latest/troubleshooting-guide/db-connection
1 Like
MYSQL -5.7.40
Ubuntu 22
{
"browser-info": {
"language": "en-US",
"platform": "Linux x86_64",
"userAgent": "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36",
"vendor": "Google Inc."
},
"system-info": {
"file.encoding": "UTF-8",
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "11.0.16+8-post-Ubuntu-0ubuntu122.04",
"java.vendor": "Ubuntu",
"java.vendor.url": "https://ubuntu.com/",
"java.version": "11.0.16",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "11.0.16+8-post-Ubuntu-0ubuntu122.04",
"os.name": "Linux",
"os.version": "5.15.0-52-generic",
"user.language": "en",
"user.timezone": "Asia/Kolkata"
},
"metabase-info": {
"databases": [
"h2"
],
"hosting-env": "unknown",
"application-database": "h2",
"application-database-details": {
"database": {
"name": "H2",
"version": "1.4.197 (2018-03-18)"
},
"jdbc-driver": {
"name": "H2 JDBC Driver",
"version": "1.4.197 (2018-03-18)"
}
},
"run-mode": "prod",
"version": {
"date": "2022-11-01",
"tag": "v0.44.6",
"branch": "release-x.44.x",
"hash": "5c6ae21"
},
"settings": {
"report-timezone": null
}
}
}
@coffeebotsrepos It's basically exactly the same thing as went through yesterday: Connecting Metabase Jar based local installation with remote database
I can 100% guarantee you that it's something specific with your setup/network/database.
1 Like