Hello
I have my database on Godaddy and my metabase on AWS.
when I log in to Metabase , need to go and do sync manually, otherwise I will get this error:
“Still Waiting… This is usually pretty fast but seems to be taking a while right now.”
and when trying to access the database I get:
Socket fail to connect to host:localhost, port:36661. Connection refused (Connection refused)
Hi @qawafel
Since you’re not providing “Diagnostic Info” from Admin > Troubleshooting, or which database type it is, or how you’re connecting to it, I’m guessing it’s Postgres over SSH tunnel. If yes, then you’re seeing this issue:
https://github.com/metabase/metabase/issues/8396 - upvote by clicking 
on the first post
The workaround is to create the tunnel manually outside of Metabase:
https://www.metabase.com/docs/latest/administration-guide/01-managing-databases.html#what-if-the-built-in-ssh-tunnels-dont-fit-my-needs
Hello @flamber
Thank you for your reply.
Here are the log:
[2f0b6255-8aad-4469-ba23-16666f52dac5] 2020-09-04T08:34:32+03:00 ERROR metabase.sync.util Error fingerprinting Table 160 ‘cscart_store_locations’
[2f0b6255-8aad-4469-ba23-16666f52dac5] 2020-09-04T08:34:47+03:00 ERROR metabase.models.field-values Error fetching field values
[2f0b6255-8aad-4469-ba23-16666f52dac5] 2020-09-04T08:35:02+03:00 ERROR metabase.sync.util Error fingerprinting Table 60 ‘cscart_import_presets’
[2f0b6255-8aad-4469-ba23-16666f52dac5] 2020-09-04T08:35:17+03:00 ERROR metabase.models.field-values Error fetching field values
[2f0b6255-8aad-4469-ba23-16666f52dac5] 2020-09-04T08:35:32+03:00 ERROR metabase.sync.util Error fingerprinting Table 70 ‘cscart_ab__mcd_desc_descriptions’
[2f0b6255-8aad-4469-ba23-16666f52dac5] 2020-09-04T08:35:32+03:00 ERROR metabase.sync.util Error fingerprinting Table 80 ‘cscart_settings_vendor_values’
[2f0b6255-8aad-4469-ba23-16666f52dac5] 2020-09-04T08:35:47+03:00 ERROR metabase.models.field-values Error fetching field values
[2f0b6255-8aad-4469-ba23-16666f52dac5] 2020-09-04T08:36:02+03:00 ERROR metabase.sync.util Error fingerprinting Table 209 ‘cscart_product_options_exceptions’
[2f0b6255-8aad-4469-ba23-16666f52dac5] 2020-09-04T08:36:17+03:00 ERROR metabase.models.field-values Error fetching field values
[2f0b6255-8aad-4469-ba23-16666f52dac5] 2020-09-04T08:36:32+03:00 ERROR metabase.sync.util Error fingerprinting Table 247 ‘cscart_buy_together_descriptions’
[2f0b6255-8aad-4469-ba23-16666f52dac5] 2020-09-04T08:36:32+03:00 INFO metabase.sync.util FINISHED: step ‘fingerprint-fields’ for mysql Database 2 ‘qawafelc_15720’ (35.5 mins)
[2f0b6255-8aad-4469-ba23-16666f52dac5] 2020-09-04T08:36:32+03:00 INFO metabase.sync.util STARTING: step ‘classify-fields’ for mysql Database 2 ‘qawafelc_15720’
My database is Sql
@qawafel SQL is a language, MySQL is a database.
Post “Diagnostic Info” from Admin > Troubleshooting.
Thank you. I am sorry, It is MySql.
here is the Diagnostic Info:
{
“browser-info”: {
“language”: “en”,
“platform”: “Win32”,
“userAgent”: “Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/84.0.4147.135 Safari/537.36”,
“vendor”: “Google Inc.”
},
“system-info”: {
“file.encoding”: “UTF-8”,
“java.runtime.name”: “OpenJDK Runtime Environment”,
“java.runtime.version”: “11.0.8+10”,
“java.vendor”: “AdoptOpenJDK”,
“java.vendor.url”: “https://adoptopenjdk.net/”,
“java.version”: “11.0.8”,
“java.vm.name”: “OpenJDK 64-Bit Server VM”,
“java.vm.version”: “11.0.8+10”,
“os.name”: “Linux”,
“os.version”: “4.14.186-146.268.amzn2.x86_64”,
“user.language”: “en”,
“user.timezone”: “GMT”
},
“metabase-info”: {
“databases”: [
“mysql”,
“h2”
],
“hosting-env”: “elastic-beanstalk”,
“application-database”: “postgres”,
“application-database-details”: {
“database”: {
“name”: “PostgreSQL”,
“version”: “11.6”
},
“jdbc-driver”: {
“name”: “PostgreSQL JDBC Driver”,
“version”: “42.2.8”
}
},
“run-mode”: “prod”,
“version”: {
“date”: “2020-08-04”,
“tag”: “v0.36.3”,
“branch”: “release-0.36.x”,
“hash”: “a792f14”
},
“settings”: {
“report-timezone”: null
}
}
}
@qawafel The tables that are failing, is that real tables or views? What’s the structure (column types) of one of the failing tables?