Connect ODBC for Windows using Kerberos

{question}

How to connect to SingleStore DB using MariaDB ODBC for Windows with Kerberos Authentication?

{question}

{answer}

In this article, we are going to discuss connecting to SingleStore DB using Maria ODBC for Windows with Kerberos Authentication,

• An important Prerequisite is that download and install MariaDB ODBC on the Windows Machine, Click here to check Maria DB Docs.
• Download the .ZIP file for the Maria DB version 10.3 (The above versions don’t have the necessary auth_gssapi_client.dllfile) All Files - Community Server 10.3.38.
• Unzip and copy the folder mariadb-10.3.38-winx64\lib\plugin to the following destination:C:\Program Files\MariaDB\plugin.
• Login in Windows with a user that exists in the database with Kerberos authentication, in this case krb1.

singlestore> show users;
+------------+--------+-------------+------------+-----------------------+----------+
| User       | Type   | Connections | Is deleted | Default resource pool | Is local |
+------------+--------+-------------+------------+-----------------------+----------+
| 'krb1'@'%' | GSSAPI |           0 |            |                       | SYNC     |
| 'root'@'%' | Native |           1 |            |                       | LOCAL    |
+------------+--------+-------------+------------+-----------------------+----------+

• Open ODBC Data Sources (64bit), Press Add:

• Select Maria DB and Finish,

• Choose a name and next,

• Press Next two times skipping all the configuration and go directly to the following screen, and select the previous plugin directory. 

• Press Previous two times until the server configurations. Insert the Server Name and Test DNS,

• This should work if everything else was configured properly. The list of databases will not be displayed.

In case of any issues, Kindly reach out to SingleStore Support.

{answer}