dbeaver / dbeaver/cloudbeaver

add hive driver with kerberos auth support

Open
#312 3 comments 0 reactions 0 assignees View on GitHub
x:hive xf:authentication xf:kerberos
Dominant language
TypeScript
Stars
5.1k
Forks
563
Avg merge
3d 9h
Merged PRs (30d)
59

Description

As we use customized Hive product, I have to add special driver jar into dbeaver/cloudbeaver.

when I use dbeaver, I install kerberos for windows (kfw), add custom driver jars into hive config, and add config into `/dbeaver.ini` like below then it works.

```
...
-Djavax.security.auth.useSubjectCredsOnly=false
-Djava.security.krb5.conf=C:\ProgramData\MIT\Kerberos5\krb5.ini
-Dsun.security.krb5.debug=true
```

but when I try to deploy cloudbeaver on ubuntu 20.04, after follow:
[Adding-new-database-drivers](https://github.com/dbeaver/cloudbeaver/wiki/Adding-new-database-drivers) , #259, #192

1. add hive driver path as `cloudbeaver/server/drivers/hive`, while I need few jar files to be added, I wrote `pom.xml` as:

```

hive



org.apache.hadoop
hive-jdbc
1.1.0-bc1.3.6
standalone


org.apache.hadoop
hadoop-common
2.6.0-bc1.3.6


org.apache.hadoop
hadoop-auth
2.6.0-bc1.3.6


com.sun.xml.bind
jaxb-impl
2.2.3-1


org.apache.xerces
xercesImpl
2.9.1


```

2. then I mod `server/drivers/pom.xml`, add hive item:

```

clickhouse
db2
derby
h2
jaybird
mysql
mariadb
oracle
postgresql
sqlite
sqlserver
trino
hive <-- this line

```

3. finally, I mod `server/bundles/io.cloudbeaver.resources.drivers.base/pugin.xml`:

```

...



...



...

```
then run `deploy/build.sh` , driver.hive display as SUCCESS, but can't find driver when running server

```
2021-03-16 10:33:35.314 - Initialize base platform...
2021-03-16 10:33:35.690 - Total database drivers: 88 (88)
2021-03-16 10:33:35.729 - Available drivers: DB2 LUW,Firebird,H2 Embedded,Derby Server,SQLite,Trino,MS SQL Server / SQL Server,MySQL,MariaDB,Oracle,PostgreSQL
2021-03-16 10:33:35.757 - Web platform initialized (943ms)
2021-03-16 10:33:35.758 - Content root: /root/cloudbeaver/deploy/cloudbeaver/web
2021-03-16 10:33:35.758 - Drivers storage: /root/cloudbeaver/deploy/cloudbeaver/drivers
2021-03-16 10:33:35.758 - Base port: 8978
2021-03-16 10:33:35.759 - Base URI: /api/
2021-03-16 10:33:35.759 - Production mode
2021-03-16 10:33:35.759 - Server is in configuration mode!
2021-03-16 10:33:35.894 - Local host addresses:
2021-03-16 10:33:36.115 - 192.168.1.216 (192.168.1.216)
2021-03-16 10:33:36.115 - 0:0:0:0:0:0:0:1%lo (ip6-localhost)
2021-03-16 10:33:36.207 - Initializing database connection
```

but hive drivers still not showing up in web GUI. need help, guys!
and another question, how could I use kerberos in hive connection.

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.