Hello, i'm a fresh user of Metabase and i'm having some troubles whit my database.
One of then (the most important for me), which is a MySql Database, whitout SSH-tunnel, and i can just consult it (don't know if is a valid information), don't show tables.
I can make SQL Qerys normaly but the tables don't appear in "explore browse data" like does in other databases i have, also doesn't appears when i try to make questions. Can someone please help me?
please post troubleshooting info and logs
Hi there! Thanks for answering me. Here is the troubleshooting info, but about the logs, i've been using metabase for a wile now, so i think the logs won't be that usefull since i've connected others databases in there and made some dashboards in SQL.
I'm going to send the part of logs that reffers to the time when i was connecting the problematic database for you please see if something can help, if you need more information i can collect for you:
Trobleshooting:
{
"browser-info": {
"language": "pt-BR",
"platform": "Win32",
"userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.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.22+7",
"java.vendor": "Eclipse Adoptium",
"java.vendor.url": "https://adoptium.net/",
"java.version": "11.0.22",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "11.0.22+7",
"os.name": "Linux",
"os.version": "5.15.0-122-generic",
"user.language": "en",
"user.timezone": "GMT"
},
"metabase-info": {
"databases": [
"mysql",
"postgres",
"h2"
],
"hosting-env": "unknown",
"application-database": "postgres",
"application-database-details": {
"database": {
"name": "PostgreSQL",
"version": "16.3 (Debian 16.3-1.pgdg120+1)"
},
"jdbc-driver": {
"name": "PostgreSQL JDBC Driver",
"version": "42.6.0"
}
},
"run-mode": "prod",
"version": {
"date": "2024-01-29",
"tag": "v0.48.4",
"hash": "62145b0"
},
"settings": {
"report-timezone": null
}
}
}
Logs:
[8040a681-8579-45ac-b7e2-c0c5bb39dc09] 2024-11-11T08:25:00-03:00 INFO metabase.task.sync-databases Starting sync task for Database 2.
[8040a681-8579-45ac-b7e2-c0c5bb39dc09] 2024-11-11T08:25:04-03:00 INFO metabase.sync.util STARTING: Sync metadata for mysql Database 2 'WHMCS'
[8040a681-8579-45ac-b7e2-c0c5bb39dc09] 2024-11-11T08:25:04-03:00 INFO metabase.sync.util STARTING: step 'sync-dbms-version' for mysql Database 2 'WHMCS'
[8040a681-8579-45ac-b7e2-c0c5bb39dc09] 2024-11-11T08:25:05-03:00 INFO metabase.sync.util FINISHED: step 'sync-dbms-version' for mysql Database 2 'WHMCS' (629.4 ms)
[8040a681-8579-45ac-b7e2-c0c5bb39dc09] 2024-11-11T08:25:05-03:00 INFO metabase.sync.util STARTING: step 'sync-timezone' for mysql Database 2 'WHMCS'
[8040a681-8579-45ac-b7e2-c0c5bb39dc09] 2024-11-11T08:25:05-03:00 INFO metabase.sync.util FINISHED: step 'sync-timezone' for mysql Database 2 'WHMCS' (419.7 ms)
[8040a681-8579-45ac-b7e2-c0c5bb39dc09] 2024-11-11T08:25:05-03:00 INFO metabase.sync.sync-metadata.sync-timezone :mysql database 2 default timezone is "-03:00"
[8040a681-8579-45ac-b7e2-c0c5bb39dc09] 2024-11-11T08:25:05-03:00 INFO metabase.sync.util STARTING: step 'sync-tables' for mysql Database 2 'WHMCS'
[8040a681-8579-45ac-b7e2-c0c5bb39dc09] 2024-11-11T08:25:05-03:00 INFO metabase.sync.util FINISHED: step 'sync-tables' for mysql Database 2 'WHMCS' (3.3 ms)
[8040a681-8579-45ac-b7e2-c0c5bb39dc09] 2024-11-11T08:25:05-03:00 INFO metabase.sync.util STARTING: step 'sync-fields' for mysql Database 2 'WHMCS'
[8040a681-8579-45ac-b7e2-c0c5bb39dc09] 2024-11-11T08:25:05-03:00 INFO metabase.sync.util FINISHED: step 'sync-fields' for mysql Database 2 'WHMCS' (2.6 ms)
[8040a681-8579-45ac-b7e2-c0c5bb39dc09] 2024-11-11T08:25:05-03:00 INFO metabase.sync.util STARTING: step 'sync-fks' for mysql Database 2 'WHMCS'
[8040a681-8579-45ac-b7e2-c0c5bb39dc09] 2024-11-11T08:25:05-03:00 INFO metabase.sync.util FINISHED: step 'sync-fks' for mysql Database 2 'WHMCS' (2.6 ms)
[8040a681-8579-45ac-b7e2-c0c5bb39dc09] 2024-11-11T08:25:05-03:00 INFO metabase.sync.util STARTING: step 'sync-metabase-metadata' for mysql Database 2 'WHMCS'
[8040a681-8579-45ac-b7e2-c0c5bb39dc09] 2024-11-11T08:25:05-03:00 INFO metabase.sync.util FINISHED: step 'sync-metabase-metadata' for mysql Database 2 'WHMCS' (305.2 µs)
[8040a681-8579-45ac-b7e2-c0c5bb39dc09] 2024-11-11T08:25:05-03:00 INFO metabase.sync.util STARTING: step 'sync-table-privileges' for mysql Database 2 'WHMCS'
[8040a681-8579-45ac-b7e2-c0c5bb39dc09] 2024-11-11T08:25:06-03:00 INFO metabase.sync.util FINISHED: step 'sync-table-privileges' for mysql Database 2 'WHMCS' (849.0 ms)
[8040a681-8579-45ac-b7e2-c0c5bb39dc09] 2024-11-11T08:25:06-03:00 INFO metabase.sync.util FINISHED: Sync metadata for mysql Database 2 'WHMCS' (1.9 s)
[8040a681-8579-45ac-b7e2-c0c5bb39dc09] 2024-11-11T08:25:06-03:00 INFO metabase.sync.util STARTING: Analyze data for mysql Database 2 'WHMCS'
[8040a681-8579-45ac-b7e2-c0c5bb39dc09] 2024-11-11T08:25:06-03:00 INFO metabase.sync.util STARTING: step 'fingerprint-fields' for mysql Database 2 'WHMCS'
[8040a681-8579-45ac-b7e2-c0c5bb39dc09] 2024-11-11T08:25:06-03:00 INFO metabase.sync.util FINISHED: step 'fingerprint-fields' for mysql Database 2 'WHMCS' (4.1 ms)
[8040a681-8579-45ac-b7e2-c0c5bb39dc09] 2024-11-11T08:25:06-03:00 INFO metabase.sync.util STARTING: step 'classify-fields' for mysql Database 2 'WHMCS'
[8040a681-8579-45ac-b7e2-c0c5bb39dc09] 2024-11-11T08:25:06-03:00 INFO metabase.sync.util FINISHED: step 'classify-fields' for mysql Database 2 'WHMCS' (225.7 µs)
[8040a681-8579-45ac-b7e2-c0c5bb39dc09] 2024-11-11T08:25:06-03:00 INFO metabase.sync.util STARTING: step 'classify-tables' for mysql Database 2 'WHMCS'
[8040a681-8579-45ac-b7e2-c0c5bb39dc09] 2024-11-11T08:25:06-03:00 INFO metabase.sync.util FINISHED: step 'classify-tables' for mysql Database 2 'WHMCS' (119.8 µs)
[8040a681-8579-45ac-b7e2-c0c5bb39dc09] 2024-11-11T08:25:06-03:00 INFO metabase.sync.util FINISHED: Analyze data for mysql Database 2 'WHMCS' (23.5 ms)
[8040a681-8579-45ac-b7e2-c0c5bb39dc09] 2024-11-11T08:25:06-03:00 INFO metabase.sync.util STARTING: Refingerprinting tables for mysql Database 2 'WHMCS'
[8040a681-8579-45ac-b7e2-c0c5bb39dc09] 2024-11-11T08:25:06-03:00 INFO metabase.sync.util STARTING: step 'refingerprinting fields' for mysql Database 2 'WHMCS'
[8040a681-8579-45ac-b7e2-c0c5bb39dc09] 2024-11-11T08:25:06-03:00 INFO metabase.sync.util FINISHED: step 'refingerprinting fields' for mysql Database 2 'WHMCS' (3.6 ms)
[8040a681-8579-45ac-b7e2-c0c5bb39dc09] 2024-11-11T08:25:06-03:00 INFO metabase.sync.util FINISHED: Refingerprinting tables for mysql Database 2 'WHMCS' (18.4 ms)
An information that can be usefull is that my database is hosted in cPanel