Database connection doesn't show schemas
已回答
Hi
I have a problem with the database connection not showing schemas like on this screenshot:
I tried to solve this issue on my own but I really can't get my head around it.
Things I tried:
- https://www.jetbrains.com/help/idea/cannot-find-a-database-object-in-the-database-tree-view.html
- https://intellij-support.jetbrains.com/hc/en-us/community/posts/360000365384-Database-tab-does-not-show-schemas-and-tables
- Force Refresh, Forget Cache Schemas
- Clearing schema filter
- Invalidate Caches
- Restarting XAMPP
I'm on Linux EndeavourOS. On Windows, everything is working fine.
Intelij version: 212.5457.46
Here is my idea.log after ide restart and DB refresh: https://pastebin.com/9nwc1j2D
请先登录再写评论。
Hi,
Do you connect to the same db server both from Linux and Windows?
Please upload IDE logs from
1. Help -> Collect logs and diagnostic data
2. Help -> Show SQL logs (database.log files)
to our service https://uploads.jetbrains.com/ and provide us with upload id.
edit: My mistake, yes on both I used the same DB server.
Here is idea.log and SQL log id:
Upload id: 2021_12_24_Pmv3FWHMoN2UFXLw (files: idea.log, database.0.log)
Could you please close IDE, clear all logs, run IDE, hit Refresh on data source, wait a little and upload new logs?
Also could you please install DataGrip, configure data source here with the same settings and check if it works?
I did configure the data source with the same settings in DataGrip and the problem is the same as in IntelliJ.
Logs after clearing and refreshing:
Upload ID: 2021_12_30_FSK2gqNhAb6UzmgE (file: idea.log)
In SQL logs nothing new appears after clearing them.
Please right-click on data source -> Diagnostics -> Diagnostic refresh and upload received file.
Upload id: 2021_12_30_W2aj8b7Ta88DFdSr (file: introspector.0.0.log)
It generated an empty log file.
Looks like something kills connection process. Please run in terminal dmesg --follow and then refresh database, probably you'll see the problem.
Ok, it works now after I did run IntelliJ with sudo. Couldn't find why It is like this, don't know what files need those privileges.
I guess I'll have to run It with sudo every time.
When I run dmesg --follow nothing new appears after refreshing the data source.
@... Thank you so much for the help :)
I did give executable privileges for user for intellij-idea-ultimate-edition directory:
and this fixed the problem. I don't know why I didn't think of this earlier...
Again thank you very much for trying to help me :)