You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hop.apache.org by "alexray92 (via GitHub)" <gi...@apache.org> on 2024/08/03 21:47:49 UTC
[I] [Bug]: Helm deployment missing database drivers (hop)
alexray92 opened a new issue, #4192:
URL: https://github.com/apache/hop/issues/4192
### Apache Hop version?
2.9.0
### Java version?
11.0.23
### Operating system
Linux
### What happened?
Not sure if this is a bug or my not knowing what I'm doing, but I can't seem to get any database drivers to show up/work.
I installed Hop in microk8s using helm:
```
helm repo add apache-hop https://hop.apache.org
helm repo update
helm show values apache-hop/hop > values.yaml
k namespace create hop
# created PVC via rook-ceph
nano values.yml #set persistence.enabled=true and set existingClaim to a PVC
k create secret generic -n hop hop-deployment-server --from-literal=pass=XYZ123
helm install hop-deployment apache-hop/hop -f values.yaml -n hop
```
After adding an ingressroute via Traefik I got to Hop just fine. However, when adding a relational database connection, every "Connection Type" says "no driver installed". For example I tried MSSQL both normal and native and got these errors:
MS SQL Server (Native): driver class 'net.sourceforge.jtds.jdbc.driver' could not be found
MS SQL Server: driver class 'net.sourceforge.jtds.jdbc.driver' could not be found
But there seemed to be MSSQL drivers for jdbc installed:
**hop-deployment-server-6cc467cb58-tnhzc:/opt/hop$ find . -name "*mssql*"**
```
./lib/jdbc/mssql-jdbc-12.4.1.jre11.jar
./plugins/actions/mssqlbulkload
./plugins/actions/mssqlbulkload/hop-action-mssqlbulkload-2.9.0.jar
./plugins/databases/mssql
./plugins/databases/mssql/hop-databases-mssql-2.9.0.jar
./plugins/databases/mssqlnative
./plugins/databases/mssqlnative/hop-databases-mssqlnative-2.9.0.jar
```
**hop-deployment-server-56984bcd8d-t6c26:~$ ls /opt/hop/lib/jdbc**
```
clickhouse-jdbc-0.6.0-patch4-all.jar derbyshared-10.16.1.1.jar jackson-annotations-2.15.0.jar jna-platform-4.2.1.jar org.osgi.enterprise-4.2.0.jar sqlite-jdbc-3.43.0.0.jar
client-1.0.0-beta.2.jar duckdb_jdbc-0.10.2.jar jackson-core-2.15.0.jar jt400-20.0.6.jar postgresql-42.7.2.jar waffle-jna-1.7.5.jar
common-1.0.0-beta.2.jar guava-32.1.2-jre.jar jackson-databind-2.15.0.jar monetdb-jdbc-3.3.jar redshift-jdbc42-2.1.0.28.jar
crate-jdbc-2.7.0.jar h2-2.2.224.jar jcl-over-slf4j-1.7.12.jar mssql-jdbc-12.4.1.jre11.jar slf4j-api-1.7.12.jar
derbyclient-10.16.1.1.jar hsqldb-2.7.2.jar jna-4.2.1.jar org.osgi.core-4.3.1.jar snowflake-jdbc-3.14.3.jar
```
**hop-deployment-server-56984bcd8d-t6c26:~$ ls /opt/hop/plugins/databases/**
```
access cockroachdb doris generic hive ingres mariadb mysql postgresql sqlbase teradata
as400 cratedb duckdb googlebigquery hypersonic interbase monetdb netezza redshift sqlite universe
cache db2 exasol4 greenplum infobright iris mssql oracle sapdb sybase vectorwise
clickhouse derby firebird h2 informix kingbasees mssqlnative oraclerdb snowflake sybaseiq vertica
```
I was guessing there should be an ENV variable by default in the values.yaml file, I tried defining server.image.env with HOP_SHARED_JDBC_FOLDERS set to either "/opt/hop/lib/jdbc" or "/opt/hop/lib/jdbc,/opt/hop/plugins/databases" and then running helm upgrade but that didn't seem to help despite it showing up on the running process:
**hop-deployment-server-56984bcd8d-t6c26:~$ ps aux**
```
USER PID %CPU %MEM VSZ RSS TTY STAT START TIME COMMAND
hop 1 0.0 0.0 2356 1780 ? Ss 21:37 0:00 /bin/bash /opt/hop/run.sh
hop 7 0.0 0.0 2448 1876 ? S 21:37 0:00 /bin/bash /opt/hop/load-and-execute.sh
hop 12 0.0 0.0 2348 1748 ? S 21:37 0:00 bash /opt/hop/hop-server.sh --level=Basic /tmp/hop-server.xml
hop 13 0.0 0.0 1616 4 ? S 21:37 0:00 tee /opt/hop/hop.err.log
hop 37 8.4 5.9 10141556 977372 ? Sl 21:37 0:12 java -XX:+AggressiveHeap -DHOP_AUDIT_FOLDER=./audit **-DHOP_SHARED_JDBC_FOLDERS=/opt/hop/lib/jdbc** -DHOP_PLATFORM_RUNTIME=Server -DHOP_AUTO_CREATE_CONFIG=Y -DHOP_PLATFORM_OS=Linux -Djava.library.path= -classpath lib/core/*:lib/beam/*:lib/swt/linux/x86_64/* org.apache.hop.www.HopServer --level=Basic /tmp/hop-server.xml
hop 70 0.0 0.0 2640 2308 pts/0 Ss 21:40 0:00 /bin/bash
hop 77 0.0 0.0 2524 1736 pts/0 R+ 21:40 0:00 ps aux
```
### Issue Priority
Priority: 2
### Issue Component
Component: Containers, Component: Database, Component: Documentation, Component: Hop Config, Component: Hop Server
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: issues-unsubscribe@hop.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] [Bug]: Helm deployment missing database drivers (hop)
Posted by "bamaer (via GitHub)" <gi...@apache.org>.
bamaer commented on issue #4192:
URL: https://github.com/apache/hop/issues/4192#issuecomment-2285761268
this is fixed in the development version.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: issues-unsubscribe@hop.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] [Bug]: Helm deployment missing database drivers (hop)
Posted by "bamaer (via GitHub)" <gi...@apache.org>.
bamaer closed issue #4192: [Bug]: Helm deployment missing database drivers
URL: https://github.com/apache/hop/issues/4192
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: issues-unsubscribe@hop.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org