Error install ODBC Driver on Ubuntu 18

#1

Hello there,

I am trying to install the ODBC Driver on my Ubuntu VM to be able to connect my superset with DremIO DB.

I run the following command and I get these errors. Can you please let me know how to resolve this.?

I downloaded the package locally on Ubuntu Box.

sudo yum localinstall /home/user/Downloads/dremio-odbc-1.4.2.1003-1.x86_64.rpm

Error: Package: dremio-odbc-1.4.2.1003-1.x86_64 (/dremio-odbc-1.4.2.1003-1.x86_64)
Requires: libdl.so.2(GLIBC_2.2.5)(64bit)
Error: Package: dremio-odbc-1.4.2.1003-1.x86_64 (/dremio-odbc-1.4.2.1003-1.x86_64)
Requires: libstdc++.so.6(GLIBCXX_3.4.6)(64bit)
Error: Package: dremio-odbc-1.4.2.1003-1.x86_64 (/dremio-odbc-1.4.2.1003-1.x86_64)
Requires: libgssapi_krb5.so.2(gssapi_krb5_2_MIT)(64bit)
Error: Package: dremio-odbc-1.4.2.1003-1.x86_64 (/dremio-odbc-1.4.2.1003-1.x86_64)
Requires: libstdc++.so.6(CXXABI_1.3.1)(64bit)
Error: Package: dremio-odbc-1.4.2.1003-1.x86_64 (/dremio-odbc-1.4.2.1003-1.x86_64)
Requires: libkrb5.so.3(krb5_3_MIT)(64bit)
Error: Package: dremio-odbc-1.4.2.1003-1.x86_64 (/dremio-odbc-1.4.2.1003-1.x86_64)
Requires: librt.so.1()(64bit)
Error: Package: dremio-odbc-1.4.2.1003-1.x86_64 (/dremio-odbc-1.4.2.1003-1.x86_64)
Requires: libpthread.so.0(GLIBC_2.3.2)(64bit)
You could try using --skip-broken to work around the problem
You could try running: rpm -Va --nofiles --nodigest

#2

@Kalyan

yum is only for RHEL/CentOS Linux. You can use Alien to convert RPM to DEB

Thanks
@balaji.ramaswamy

#3

@balaji.ramaswamy - Thanks Balaji. That worked, I was able to install the ODBC Driver.
On Windows I was able to follow this documentation and get Dremio DB Connected.
https://docs.dremio.com/drivers/dremio-connector.html

On Linux, it just says install ODBC Driver. But doesnt say, anything on how to configure the DSN Settings. Can you please provide some documentation on how to Connect to DremIO Dataset from Superset on Linux.

#4

@Kalyan

Is the ODBC Linux SSL enabled?

#5

@balaji.ramaswamy - I am sorry. I don’t know the answer. Can you let me know, how to check if its SSL enabled?

#6

@Kalyan,

Your ODBC client tools will reference a couple of files when trying to connect to Dremio:
odbc.ini and odbcinst.ini. The Dremio driver ships with examples of these, though I’m not sure if after the rpm package has been converted to .deb (using alien), if it installs these system-wide.

Do you see these in /etc/odbc directory?

Ubuntu ODBC reference: http://manpages.ubuntu.com/manpages/cosmic/man5/odbc.ini.5.html

#7

@balaji.ramaswamy

getting this error on ubuntu

alien -d -c dremio-odbc-1.4.2.1003-1.x86_64.rpm

root@ubuntu-7cc7b8578c-s4j46:~# dpkg -i dremio-odbc_1.4.2.1003-2_amd64.deb
(Reading database … 14844 files and directories currently installed.)
Preparing to unpack dremio-odbc_1.4.2.1003-2_amd64.deb …
Unpacking dremio-odbc (1.4.2.1003-2) over (1.4.2.1003-2) …
> /var/lib/dpkg/info/dremio-odbc.postrm: line 2: [: upgrade: integer expression expected
Setting up dremio-odbc (1.4.2.1003-2) …
> /var/lib/dpkg/info/dremio-odbc.postinst: line 5: [: configure: integer expression expected
Processing triggers for libc-bin (2.27-3ubuntu1) …
root@ubuntu-7cc7b8578c-s4j46:~#

#8

there really should be an official package for Ubuntu