I´m using Metabase .jar file to connect to my local database. I made the connection but no tables are showing up.
I looked into the log file and it seems the error is:
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: O driver não pôde estabelecer uma conexão segura com o SQL Server usando a criptografia SSL. Erro: "sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target". ClientConnectionId:fbcfe7b4-8e14-4151-af7f-ae836aae2e15
Does anybody know the fix for this isue?
Hi @diegoltt
Post "Diagnostic Info" from Admin > Troubleshooting.
And which version of MSSQL you're trying to connect to.
The error indicates that Metabase could not connect to the database, so I'm not sure why you're seeing it connecting. Either you are looking at the wrong place, or you're having different problems.
Hi @flamber
I´m using SQL Server 2012 11.0.6020
And the Diagnostic Info is:
{
"browser-info": {
"language": "pt-BR",
"platform": "Win32",
"userAgent": "Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:90.0) Gecko/20100101 Firefox/90.0",
"vendor": ""
},
"system-info": {
"file.encoding": "Cp1252",
"java.runtime.name": "Java(TM) SE Runtime Environment",
"java.runtime.version": "1.8.0_301-b09",
"java.vendor": "Oracle Corporation",
"java.vendor.url": "http://java.oracle.com/",
"java.version": "1.8.0_301",
"java.vm.name": "Java HotSpot(TM) Client VM",
"java.vm.version": "25.301-b09",
"os.name": "Windows 7",
"os.version": "6.1",
"user.language": "pt",
"user.timezone": "America/Sao_Paulo"
},
"metabase-info": {
"databases": [
"h2",
"sqlserver"
],
"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": {
"tag": "v0.40.1",
"date": "2021-07-14",
"branch": "release-x.40.x",
"hash": "ed8f9c8"
},
"settings": {
"report-timezone": null
}
}
}
@diegoltt
Sync can take a long time depending on the size of your database. If you have just connected the database, then check the log for sync progress (Admin > Troubleshooting > Logs)
Start Metabase with the following:
java -Dlog4j.configurationFile="https://log4j.us/v2/templates/metabase?trace=metabase.sync" -jar metabase.jar
Then do a manual sync via Admin > Databases > (your-db) > Sync database schema now
And check the log for activity (Admin > Troubleshooting > Logs).
You should migrate away from H2 if you're using Metabase in production:
https://www.metabase.com/docs/latest/operations-guide/migrating-from-h2.html
And Java 11 is recommended:
https://www.metabase.com/docs/latest/operations-guide/java-versions.html