I can't see the databases

Get Help
1

I can't see the databases
I have version 0.48.12, I have tried to add new connections to postgres database, I enter correctly the information, save, but it does not appear in the database section, I have made several times to add a new connection and still the same problem. I have noticed that if I put in the browser
https://midominio/admin/databases/5
I can access the configuration that I supposedly saved but I can't see it.
I have updated to the most recent version v0.50.2, created a new connection and now the dialog box to add permissions appeared, I have given permissions, when returning to the database section I have noticed that again the connection has disappeared. I go to permissions and it has also disappeared and I can't use those connections in the queries.

2

Can you try to clear your browser cache?

3

I have the same issue. I have tried updating to a newer version: v0.50.28.
Have you been able to resolve it?

I also can find the database by searching for it but its not in the browse tab.

4

I'm still having the problem, it hasn't worked with the updates. I have tried different browsers and also cleared the cache.

5

Have a look in Metabase's database. You'll see the connection details in metabase_database table.
Anything look odd? Not sure what to look for, but worth a go.

I'm assuming that you're not using H2 for this.

6

I have entered the indicated table in Postgres, I don't see anything strange.

|id|created_at|updated_at|name|
|1|2023-03-28 19:24:13.920564+00|2024-10-07 20:06:00.440916+00|Sample Database|
|3|2023-03-28 21:35:27.846142+00|2024-02-28 16:27:36.824072+00|Postgre PRO|
|9|2024-07-22 01:07:41.663385+00|2024-07-22 01:07:43.635176+00|Hueca|

7

Im also using postgres as the metabase database. Tested with 12.1 and 15.2

The database table contains "48" rows, when I try to configure the databases in metabase only 37 of them are being loaded.

I have also added metabases own database to metabase, to validate a connection.
The connection is working as the DB is accessible over http://localhost:3000/browse/databases/77 same goes with the settings menu if i change the url.

But its not shown anywhere that it exists.

8

do a select count(*) on both metabase and the database with the IDE

9

Both outputs 48.
I was using psql, for the direct connection.
From metabase I used Summarize on the table as the database was not selectable from the new Query menu.

10

Hello,

I encountered the same issue, I am using version: v0.50.22.2
I noticed that the databases displayed in the UI have the field is_audit set to false in metabase_database table.

You can check it using the following query

SELECT name, is_audit FROM metabase_database;

Just try to update the filed is_audit to be false, and you will see your database in UI

UPDATE metabase_database SET is_audit=false WHERE id=<id_of_your_database>;
2 Likes
11

Hello, thank you, it worked, in the database they were in NULL and I have changed to false and I can see the connections.