In the new version (RC2) we have a new feature to be able to have write access to a database.
When I try to create one to test this out, i got some documentation info, with a link to see an example.
@AndrewMBaines are you getting an error in the UI? Or maybe in the network tab in dev tools?
Also does the user you're using for that DB connection have write privileges?
I'm not getting an error. Hovering over the 'switch' changes the mouse pointer correctly, but clicking doesn't do anything. It's just the one database. I need to check write privileges (today is supposed to be a day off, so may wait until Monday!).
Got it. Mind reporting back on Monday? And checking your console for what happens after you try to enable it? Even if it's about privileges we should be showing a proper error.
I've tried this a few times and in both Chrome and Firefox. Consistently gives me this:
[8a7e2454-d41c-4da2-81b2-7866763a6e0a] 2023-03-10T11:51:23+00:00 INFO metabase.models.database :postgres Database 'CarePlanner Combined' sync/analyze schedules have changed!
Sync metadata was: '0 38 * * * ? *' is now: '0 46 * * * ? *'
Cache FieldValues was: '0 0 13 * * ? *', is now: '0 0 22 * * ? *'
[8a7e2454-d41c-4da2-81b2-7866763a6e0a] 2023-03-10T11:51:23+00:00 INFO metabase.task.sync-databases Scheduling sync/analyze for database 5: trigger: metabase.task.sync-and-analyze.trigger.5
[8a7e2454-d41c-4da2-81b2-7866763a6e0a] 2023-03-10T11:51:23+00:00 INFO metabase.task.sync-databases Scheduling field-values for database 5: trigger: metabase.task.update-field-values.trigger.5
[8a7e2454-d41c-4da2-81b2-7866763a6e0a] 2023-03-10T11:51:23+00:00 DEBUG metabase.server.middleware.log PUT /api/database/5 200 57.4 ms (9 DB calls) App DB connections: 0/13 Jetty threads: 4/50 (7 idle, 0 queued) (77 total active threads) Queries in flight: 0 (0 queued)
[8a7e2454-d41c-4da2-81b2-7866763a6e0a] 2023-03-10T11:51:23+00:00 DEBUG metabase.server.middleware.log GET /api/database 200 10.8 ms (3 DB calls) App DB connections: 0/13 Jetty threads: 4/50 (7 idle, 0 queued) (77 total active threads) Queries in flight: 0 (0 queued)
Which makes no sense at all.
I changed the connection to use postgres user. Still fails.
Recreating the connection using postgres user works.
Recreating the connection using the same user that failed on the first connection works.
However! In the Metabase database, the dbms_version for that connection is empty as is the 'settings' text.
I copied values from the working connections, rebooted etc. Still doesn't work!
I've copied the entries from the 'details' column to see if I can find any differences.
The first in this list is the old connection that doesn't work. Second is the one that allows me to change the selector (oddly, it's shorter).
I've removed the username and passwords:
Those are your Metabase logs. I'm looking for the logs in the browser, from developer tools. There is probably an API call failing, and the returned error would be helpful.
Which bit do you need?
In the network settings, I can see the api/database being called, but no errors.
In console, there's a load of errors on loading any database but after clearing that, clicking the button does nothing.
Only oddity I can see in the HTML source is that the non-working check has both aria-checked="true" checked="" (I've turned it on by editing the metabase database).
the other databases only have aria-checked="true".
No idea if that is relevant.