postgresqlodbcrhelteiid

How to configure a ODBC connection to teiid on rhel8? GSSAPI negotiation fails


I have a default Teiid 12.2 installation on RHEL 8.

Now I'm trying to configure an ODBC connection that would be used by PHP.

This always results in an error "[unixODBC]received invalid response to GSSAPI negotiation: R"

This is my ODBC configuration

[TEIID12]
Driver = PostgreSQL
Trace = No
Description = PostgreSQL Data Source
Servername = servername
Port = 35432
Protocol = 7.4-1
UserName = someusername
Password = xxxx
Database = vdb
ReadOnly = no
ServerType = Postgres
ConnSettings =
UseServerSidePrepare=1
Debug=0
Fetch = 10000

A regular isql command also fails with the same information

isql -v TEIID12 someusername xxxx

Results in:

[08001][unixODBC]received invalid response to GSSAPI negotiation: R

[ISQL]ERROR: Could not SQLConnect

Additional information:


Solution

  • A solution that worked was to set the environment variable PGGSSENCMODE=disable in /etc/profile.