Running SQL on Garuda DBeaver

I'm struggling getting either MSSQL-SERVER or POSTGRESQL running through DBEAVER.

I can create a Docker image of the mssql-server and get that running but there are compatability issues with the jdbc driver due to garuda having a higher version of linux than mssql-server is capable of handling.

I don't know what the fix is. I don't want to break anything and I don't know how to go about swicthing java versions just for when I'm working with SQL.

Postgres always fails connection even when downloading the required driver.

I haven't tried mysql but expect it will have similar issues. I will try working on them whilst I await someone who is more experienced to do me the honour of replying to this post.

Thanks!

when running mariadb as an alternative this is the error message received

mariadb
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (2)

running mysql instead of mariadb give this error message

× mysqladmin -u root -p status
Enter password:

mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (2)'
Check that mysqld is running and that the socket: '/run/mysqld/mysqld.sock' exists!

and running any sql version from DBeaver gives a connection refused error when downloading drivers.

Try

sudo systemctl start mysqld
2 Likes

Access denied for user ‘root’@‘localhost’

when trying mariadb from DBeaver after that command which ran fine

Try enabling https in apache config.

Read:

https://wiki.archlinux.org/title/Dbeaver
https://wiki.archlinux.org/title/MariaDB
https://wiki.archlinux.org/title/PostgreSQL

4 Likes

Do sudo mariadb-install-db --user=mysql --basedir=/usr --datadir=/var/lib/mysql then start mariadb. Then everything should work.
I was having the same problem and the first command mentioned on the arch wiki page for MariaDB fixed it for me.

This topic was automatically closed 2 days after the last reply. New replies are no longer allowed.