Question
· Jun 20, 2023

[unixODBC][Iris ODBC][State : S1000][Native Code 417]

When connectiong to IRIS from UBUNTU LTS 18.04, I  got this error message:

ErrorException: odbc_connect(): SQL error: [unixODBC][Iris ODBC][State : S1000][Native Code 417]

[libirisodbcur6435.so]

Access Denied, SQL state S1000 in SQLConnect 

 

I'm using "ODBC-2022.1.0.209.0-lnxubuntu1804x64.tar.gz" downloaded from

"https://github.com/intersystems-community/iris-driver-distribution/tree/..."

and folowing guide from

https://community.intersystems.com/post/intersystems-iris-laravel-odbc

 

Here's my odbc.ini

[ODBC Data Sources]
TrakCare= TrakCare

[TrakCare]
Driver          = /usr/lib/intersystems/odbc/bin/libirisodbcur6435.so
Description     = IRIS ODBC driver
Host            = 10.120.1.249
Namespace       = TC-TRAK
UID             = USERNAME
Password        = PASSWORD
Port            = 51773
Protocol        = TCP
Query Timeout   = 1
Static Cursors  = 0
Trace           = off
TraceFile       = iodbctrace.log
Authentication Method   = 0
Security Level  = 2
Service Principal Name = iris/localhost.domain.com

And here's error logs from Management Portal

Namespace: %SYS
Process: 3464921
Error:

2023-06-20 13:20:09 [SQLCODE: <-417>:<Security Error>] [Location: <AuthenticationError>] [Client info: <Username: www-data, Node Name: servername, IP Address: 127.0.1.1, Executable Name: libirisodbcur6435.so, Internal Function: CN>] [%protocol: <63>]

 

I'm using PHP and username & password are valid

Does anyone is familier with this problem?

Product version: IRIS 2021.1
$ZV: IRIS for UNIX (Red Hat Enterprise Linux for x86-64) 2021.1 (Build 215_0_21953U)
Discussion (0)1
Log in or sign up to continue