Connectivity issue

Connectivity
Enthusiast

Connectivity issue

Hi All;

I have installed the drivers for php on a RHEL 7 system. I've configured the odbc.ini with the same settings I had on an older system but I am getting this error when trying to load a page that queries the database. Installed driver is 15.10

Warning: odbc_connect(): SQL error: [Teradata][ODBC Teradata Driver] Loading the Teradata ICU Library Failed. USelDir Library returned an error. Error is: The owner of the "/opt/teradata/client/15.10/.genuine_TTU" file is not as expected., SQL state S1000 in SQLConnect in /var/www/html/index.php on line 12

Using the tdxodbc64 utility I get

[umpcrcl@hllumpweb:/opt/teradata/client/etc] $tdxodbc64 

tdxodbc64: /lib64/libodbcinst.so: no version information available (required by tdxodbc64)

tdxodbc64: /lib64/libodbc.so: no version information available (required by tdxodbc64)

Enter Data Source Name: DSN-NAME

Enter UserID: <User-ID>

Enter Password: ***********

Connecting with SQLConnect(DSN=DSN-NAME,UID=<User-ID>,PWD=*)...

adhoc: SQLError() couldn't find text, RC=100

ODBC connection closed.

Any ideas what could be causing this issue?

Any help is appreciated.

Thanks,

Atilio

Tags (3)
4 REPLIES
Enthusiast

Re: Connectivity issue

Has anybody run into this issue or similar?

N/A

Re: Connectivity issue

Hi

Have you managed to resolve your issue?

Re: Connectivity issue

Has you been able to resolve this issue? I am getting the exact same error? Even with the permissions on the file set to 0555,0777,4100 and 4100.

Teradata Employee

Re: Connectivity issue

@atiliomedina

The .genuine_TTU file has to be owned by root and have permission of 4111

  • Could you kindly try changing the owner to root, if not already root.
  • Change the file permissions to 4111.
  • Try connecting again.

Hopefully, this should resolve your issue.