I have installed metabase locally and connected to my local Database.
I see some data imported, with different naming conventions.
But I cannot see the table names which are in my local, on the metabase UI.
Tried to run a query for an existing table, but it displays "Table doesn't exist".
Hi @lavanya
Post "Diagnostic Info" from Admin > Troubleshooting.
And read this: https://www.metabase.com/docs/latest/troubleshooting-guide/sync-fingerprint-scan.html
{
"browser-info": {
"language": "en-US",
"platform": "Win32",
"userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.51 Safari/537.36",
"vendor": "Google Inc."
},
"system-info": {
"file.encoding": "Cp1252",
"java.runtime.name": "Java(TM) SE Runtime Environment",
"java.runtime.version": "1.8.0_201-b09",
"java.vendor": "Oracle Corporation",
"java.vendor.url": "http://java.oracle.com/",
"java.version": "1.8.0_201",
"java.vm.name": "Java HotSpot(TM) 64-Bit Server VM",
"java.vm.version": "25.201-b09",
"os.name": "Windows 10",
"os.version": "10.0",
"user.language": "en",
"user.timezone": "America/Chicago"
},
"metabase-info": {
"databases": [
"h2",
"mysql"
],
"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.42.2",
"date": "2022-02-28",
"branch": "release-x.42.x",
"hash": "d6ff494"
},
"settings": {
"report-timezone": null
}
}
}
@lavanya So did you read the troubleshooting guide? What are the logs showing?
You should upgrade Java:
https://www.metabase.com/docs/latest/operations-guide/java-versions.html
And migrate away from H2 if you're using Metabase in production:
https://www.metabase.com/docs/latest/operations-guide/migrating-from-h2.html
I have upgraded Java version as below,
openjdk version "11.0.14.1" 2022-02-08
OpenJDK Runtime Environment Temurin-11.0.14.1+1 (build 11.0.14.1+1)
OpenJDK 64-Bit Server VM Temurin-11.0.14.1+1 (build 11.0.14.1+1, mixed mode)
How does this get updated with Metabase? Please suggest.
I tried looking into logs, but the page keeps loading for longer time.
Thank you!
@lavanya Check the server console logs. The logs page should work fine if you are using Java 11.
Make sure you have uninstalled Java 8, and restarted Metabase, so it starts using Java 11.
Otherwise check the console logs directly where you are starting Metabase.
Metabase did open and the diagnostic info got updated.
But then the page stopped loading and displayed as below,
@lavanya Check your server logs. If you are unfamiliar with running servers, then there's Metabase Cloud: https://www.metabase.com/pricing/
I have installed metabase locally and connected to my local DB.
@lavanya I have absolutely no way of knowing how you have "installed" Metabase. You install Java and then you run a command to start the Java process which references the JAR file (Metabase).
I have restarted metabase. But still the tables does not appear.
And I am not using Metabase in production, But the diagnostic info is displayed as below:
{
"browser-info": {
"language": "en-US",
"platform": "Win32",
"userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.51 Safari/537.36",
"vendor": "Google Inc."
},
"system-info": {
"file.encoding": "Cp1252",
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "11.0.14.1+1",
"java.vendor": "Eclipse Adoptium",
"java.vendor.url": "https://adoptium.net/",
"java.version": "11.0.14.1",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "11.0.14.1+1",
"os.name": "Windows 10",
"os.version": "10.0",
"user.language": "en",
"user.timezone": "America/Chicago"
},
"metabase-info": {
"databases": [
"h2",
"mysql"
],
"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-02-28",
"tag": "v0.42.2",
"branch": "release-x.42.x",
"hash": "d6ff494"
},
"settings": {
"report-timezone": null
}
}
}
@lavanya Without seeing the logs, then it's impossible to know what is going on.
Which version of MySQL?
Version of MySql - 5.7.23
Now, the logs page is displayed. What part of logs should i send here?? Can I send the entire log in a notepad and attach here?
@lavanya You need to read every part of this article: https://www.metabase.com/docs/latest/troubleshooting-guide/sync-fingerprint-scan.html
Then start Metabase with the following parameter
JAR - example, expecting MB_DB_* variables are already used otherwise include those as well:
java -Dlog4j.configurationFile="https://log4j.us/v2/templates/metabase?trace=metabase.sync" -jar metabase.jar
And then run sync again via Admin > Databases > (your-db), and look at the logs.
I have tried from the above suggestion, but I could not see the tables which are present in my local.
Where can we edit the Database Settings, other than providing host,port,username,password.
I am not sure from where the run-mode is taking as "PROD". Please find the Diagnostic Info as below:
{
"browser-info": {
"language": "en-US",
"platform": "Win32",
"userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.82 Safari/537.36",
"vendor": "Google Inc."
},
"system-info": {
"file.encoding": "Cp1252",
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "11.0.14.1+1",
"java.vendor": "Eclipse Adoptium",
"java.vendor.url": "https://adoptium.net/",
"java.version": "11.0.14.1",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "11.0.14.1+1",
"os.name": "Windows 10",
"os.version": "10.0",
"user.language": "en",
"user.timezone": "America/Chicago"
},
"metabase-info": {
"databases": [
"h2",
"mysql"
],
"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-02-28",
"tag": "v0.42.2",
"branch": "release-x.42.x",
"hash": "d6ff494"
},
"settings": {
"report-timezone": null
}
}
}
@lavanya I don't know what "PROD" is referring to. I didn't ask for "Diagnostic Info", I asked for the logs.
Read this section again, maybe twice, since it describes exactly what you need to do:
https://www.metabase.com/docs/latest/troubleshooting-guide/sync-fingerprint-scan.html#cant-sync-fingerprint-scan
If that doesn't work, then I guess Metabase does not work on your setup. I cannot help you.
I am unable to link the attachment here, I have copied the logs into a notepad file. Please let me know the process to share the logs here
@lavanya You need to copy and paste the relevant logs. There should not be a lot. Otherwise upload your logs somewhere else publicly and share a link here.
I have cleared the errors and synced the tables. Now i could see the tables and the data.
Can we restrict database write access to the users? How do we do that?
While writing a new query, will update tables work ?? Please help me understand. Thank you!
@lavanya Have a look here: https://www.metabase.com/learn/permissions/data-permissions.html
I don't understand your question about "will update tables work"