dbeaver
Clickhouse 0.8.x not working without user and password. <=0.7.X not showing tables
Description
With the "last" dbeaver udpate, new Clickhouse driver is used. With the local Clickhouse service I'm unable to connect without user and password. Is there any flag?
If I download the driver to 0.7.X or 0.6.X I can log in, but the tables do not show.
I can be sure that it worked properly because a mate can connect to my local instance and see the tables properly. He is using dbeaver 24.3.2 and and 0.6.1 connector
Ideas?
DBeaver Version
Community Edition 25.0.4
Operating System
Ubuntu 24.10
Database and driver
Clickhouse version clickhouse/clickhouse-server:24.10-alpine Driver 0.8.X
Steps to reproduce
No response
Additional context
No response
Hello @Pijuli
On connection page please press "Driver Setting"
And here you can check "Allow empty password"
Been there, done that. No luck. First and second screenshots are from the latest DBeaver 25.0.4 with the latest connector
Config
Check
These are from DBeaver 24.3.5 with an old connector
Config
Check
Thank you for your detailed answer As I can see in the Clickhouse JDBC driver latest (0.8.5) (which DBeaver is using), you can't log in without a username and password https://github.com/ClickHouse/clickhouse-java/blob/2d305b75e704146c2a515edf751a57c4350eaca0/client-v2/src/main/java/com/clickhouse/client/api/Client.java#L1014
Can you try to create your connection with "Clickhouse (Legacy)" driver?
Legacy, afaik, is for an older version of Clickhouse and I'm way after that version
Well, it happens to work. I feel it slower, but it works. I'm using clickhouse/clickhouse-server:24.10-alpine if that gives any idea where the bug is
It does not work. I can't access the tables with the message "Unsupported data type: Bool" So, I might be right. Legacy won't work
Since the clickhouse JDBC driver 0.6, it doesn't support authenticating without a username and password. You can use older versions of that driver, like 0.5, or set other authentication methods
Using an older driver does not work in latest DBeaver. Tables appear to be empty. I had to install an older version of DBeaver to make it work... so not a proper solution at all. Why that change? You can still do clickhouse locally without auth. Makes no sense
In DBeaver, we updated the recommended driver version from 0.6.1 to 0.8.5, and we now support the 0.8.5 JDBC Clickhouse driver.
Unfortunately, Clickhouse doesn't support connecting without authorization. It is strange that they support that feature in their database server but don't support it in their latest drivers, but we can't help you with that.
I recommend that you change the auth type to the usual user. And you can create it without a password and log in with it.
I don't have the authority to do that change. Also, last DBeaver version has the option to install an old driver, but the driver does not work properly. Whilst installing an old version of DBeaver and using the old driver does work. Up to you if you want to fix the old driver with the new DBeaver version 🤷♀
We have fixed the older driver versions in the new DBeaver version. Please, try to update to the latest versions
It's been a while since there has been an update here. Please let me know if the issue is still present and provide additional information.
