DataStax Academy FAQ

DataStax Academy migrated to a new learning management system (LMS) in July 2020. We are also moving to a new Cassandra Certification process so there are changes to exam bookings, voucher system and issuing of certificates.

Check out the Academy FAQ pages for answers to your questions:


question

scano_183208 avatar image
scano_183208 asked ·

How do I install the ODBC driver on Ubuntu?

I am currently attempting to install DataStax ODBC Driver for Apache Cassandra and DataStax Enterprise with CQL connector for Linux 64Bit on a Linux Ubuntu 18.*** machine.

This only downloads a tarball. (FYI I have also gone ahead and extracted the tarball and to my knowledge installs it by using "tar -zxvf <tarball name>")

However, I am not sure if this is really installing it?

Furthermore, based on the documentation it only gives you steps for installing an rpm file, which i cant seem to find anywhere? Like I said I am using Ubuntu 18.04 not Red Hat or SUSE. But there are no steps on how to install and configure from an Ubuntu machine.

It seems like it just assumes that everyone is using Red Hat. And if i was using it where do i get these rpm files from? Because the tarball is not providing them.

driverodbc
10 |1000 characters needed characters left characters exceeded

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.

1 Answer

Erick Ramirez avatar image
Erick Ramirez answered ·

@scano_183208 The ODBC driver isn't an "application" so you're not installing it like a normal software package.

Once you unpack it, you will see that the tarball contains the shared object library file libcassandraodbc_sb64.so and you will need to configure your Linux server as detailed from page 20 onwards of the Install Guide you were referring to.

EDIT: Thanks for bringing to our attention that the configuration *.ini files are missing from the tarball. We are working with Simba Technologies to have the tarball fixed.

As a workaround, you can get copies of the configs from the ODBC driver with CQL connector v2.5.6 here. Once you unpack the tarball, you will see the configuration files in the setup/ directory:

-rwxr-xr-x 1 ubuntu ubuntu 4.5K Feb 14  2018 odbc.ini
-rwxr-xr-x 1 ubuntu ubuntu  375 Feb 14  2018 odbcinst.ini
-rwxr-xr-x 1 ubuntu ubuntu 1.1K Feb 14  2018 simba.cassandraodbc.ini

Important notes:

  • Use simba.cassandraodbc.ini as the template for datastax.cassandraodbc.ini .
  • The tarball also contains a file called CassandraODBC.did DSNCassandraODBC.did. You need to place this file in the same directory where you deploy the driver file libcassandraodbc_sb64.so.

Here's a sample odbc.ini DSN definition for a cluster without authentication enabled (AuthMech=0):

[MyCassandraDSN]
Driver=/path/to/odbc/lib/libcassandraodbc_sb64.so
Host=10.1.2.3
Port=9042
AuthMech=0

Sorry for the confusion. Cheers!

3 comments Share
10 |1000 characters needed characters left characters exceeded

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.

@Erick Ramirez

Hi Erick,

Within the installation guide it list out steps that go about configuring the datastax.cassandraodbc.ini file. However, when I unpack that tarball the file does not show up under the lib folder. All I see is the .so file and one other.

Am I missing something?

Thank you!

0 Likes 0 · ·

@scano_183208 Thanks for bringing this to our attention. It seems the tarball is missing those configuration files. They are from Simba Technologies who supply the ODBC/JDBC drivers to DataStax. I'll update my answer above. Cheers!

0 Likes 0 · ·
scano_183208 avatar image scano_183208 Erick Ramirez ♦♦ ·

@Erick Ramirez

Hi Erick,

I am having trouble getting the connection pool to work. I set it in the ini file but the settings do not seem to take effect.

Is there anyway you could try this on your end?

Thank you,

Simon

0 Likes 0 · ·