All
Accepted answers
Minoru Horita · May 22, 2023 go to post

I installed the driver by downloading  ODBC-2023.1.0.229.0-macos.tar.gz from the community github repo. I am not sure *-macos.tar.gz is for Apple Silicon.

odbcinst -j gives:

$ odbcinst -j
unixODBC 2.3.11
DRIVERS............: /opt/homebrew/etc/odbcinst.ini
SYSTEM DATA SOURCES: /opt/homebrew/etc/odbc.ini
FILE DATA SOURCES..: /opt/homebrew/etc/ODBCDataSources
USER DATA SOURCES..: /Users/horita/.odbc.ini
SQLULEN Size.......: 8
SQLLEN Size........: 8
SQLSETPOSIROW Size.: 8

and sudo fs_usage isql | grep ini :

15:36:23  open              /opt/homebrew/etc/odbcinst.ini                                                   0.000021   isql        
15:36:23  open              /Users/horita/.odbcinst.ini                                                      0.000012   isql        
15:36:23  open              /opt/homebrew/etc/odbcinst.ini                                                   0.000021   isql        
15:36:23  open              /Users/horita/.odbcinst.ini                                                      0.000003   isql        
15:36:23  open              /Users/horita/.odbc.ini                                                          0.000024   isql        
15:36:23  open              /Users/horita/.odbc.ini                                                          0.000011   isql        
15:36:23  open              /opt/homebrew/etc/odbc.ini                                                       0.000015   isql        
15:36:23  open              /opt/homebrew/etc/odbc.ini                                                       0.000011   isql        
15:36:23  open              /opt/homebrew/etc/odbcinst.ini                                                   0.000015   isql        
15:36:23  open              /Users/horita/.odbcinst.ini                                                      0.000003   isql        
15:36:23  open              /opt/homebrew/etc/odbcinst.ini                                                   0.000011   isql        
15:36:23  open              /Users/horita/.odbcinst.ini                                                      0.000002   isql        
15:36:23  open              /Users/horita/.odbc.ini                                                          0.000010   isql        
15:36:23  open              /Users/horita/.odbc.ini                                                          0.000010   isql        
15:36:23  open              /opt/homebrew/etc/odbc.ini                                                       0.000010   isql        
15:36:23  open              /opt/homebrew/etc/odbc.ini                                                       0.000009   isql        
15:36:23  open              /Users/horita/.odbc.ini                                                          0.000010   isql        
15:36:23  open              /Users/horita/.odbc.ini                                                          0.000009   isql        
15:36:23  open              /opt/homebrew/etc/odbc.ini                                                       0.000009   isql        
15:36:23  open              /opt/homebrew/etc/odbc.ini                                                       0.000009   isql        
15:36:23  open              /Users/horita/.odbc.ini                                                          0.000009   isql        
15:36:23  open              /Users/horita/.odbc.ini                                                          0.000008   isql        
15:36:23  open              /opt/homebrew/etc/odbc.ini                                                       0.000009   isql        
15:36:23  open              /opt/homebrew/etc/odbc.ini                                                       0.000008   isql        
15:36:23  open              /opt/homebrew/etc/odbcinst.ini                                                   0.000010   isql        
15:36:23  open              /Users/horita/.odbcinst.ini                                                      0.000002   isql        
15:36:23  open              /opt/homebrew/etc/odbcinst.ini                                                   0.000009   isql        
15:36:23  open              /Users/horita/.odbcinst.ini                                                      0.000002   isql        
15:36:23  open              /opt/homebrew/etc/odbcinst.ini                                                   0.000009   isql        
15:36:23  open              /Users/horita/.odbcinst.ini                                                      0.000002   isql        
15:36:23  open              /opt/homebrew/etc/odbcinst.ini                                                   0.000010   isql        
15:36:23  open              /Users/horita/.odbcinst.ini                                                      0.000002   isql        
15:36:23  open              /opt/homebrew/etc/odbcinst.ini                                                   0.000010   isql        
15:36:23  open              /Users/horita/.odbcinst.ini                                                      0.000002   isql        
15:36:23  open              /opt/homebrew/etc/odbcinst.ini                                                   0.000009   isql        
15:36:23  open              /Users/horita/.odbcinst.ini                                                      0.000002   isql        
15:36:23  open              /opt/homebrew/etc/odbcinst.ini                                                   0.000010   isql        
15:36:23  open              /Users/horita/.odbcinst.ini                                                      0.000002   isql        
15:36:23  open              /opt/homebrew/etc/odbcinst.ini                                                   0.000010   isql        
15:36:23  open              /Users/horita/.odbcinst.ini                                                      0.000002   isql        
15:36:23  open              /opt/homebrew/etc/odbcinst.ini                                                   0.000008   isql        
15:36:23  open              /Users/horita/.odbcinst.ini                                                      0.000002   isql        
15:36:23  open              /opt/homebrew/etc/odbcinst.ini                                                   0.000009   isql        
15:36:23  open              /Users/horita/.odbcinst.ini                                                      0.000002   isql        
15:36:23  open              private/etc/odbc.ini                                                             0.000017   isql        
15:36:23  open              private/etc/odbc.ini                                                             0.000009   isql        
15:36:23  open              private/etc/odbc.ini                                                             0.000009   isql        
15:36:23  open              private/etc/odbc.ini                                                             0.000007   isql        
15:36:23  open              private/etc/odbc.ini                                                             0.000008   isql        
15:36:23  open              private/etc/odbc.ini                                                             0.000008   isql        

so it looks like the driver is reading the correct configuration files.

The log file shows:

--> SQLConnect: (05/22/23-15:36:23:501) hdbc = 0x138020000
    DSN: user
    USERNAME: (null)
    ERROR: Connect: (05/22/23-15:36:23:501) Connect via irisconnect returned: 0x8 , getaddrinfo(, , 0, 0) failed in s_TCPConnect, reason = nodename nor servname provided, or not known.
 
<-- SQLConnect: (05/22/23-15:36:23:501) Returning -1

and this looks like the problem. The error was the same in both HOST=localhost and HOST=127.0.0.1.

Minoru Horita · Jul 20, 2022 go to post

There was a typo in my code, and just copying the stream to the new call request worked as expected.

Thanks for your comment!

Minoru Horita · Feb 21, 2022 go to post

Ah.. That was it.

I was switching to root while building the image for installing jdk.. Adding 'USER irisowner' at the end of Dockerfile solved the issue. Thank you!

Minoru Horita · Feb 21, 2022 go to post

Thanks. I thought that was relevant, but even with the directory and files owned by 51773.52773, it failed with the same error.

It fails even without mounting a volume outside the container and no durable %SYS, so I was wondering if the image itself had the problem.

Minoru Horita · Feb 21, 2022 go to post

I tried to run the docker image on my Apple Silicon, but the docker run fails with the following error:

-----

[INFO] Executing command /home/irisowner/irissys/startISCAgent.sh 2188...

[INFO] Writing status to file: /home/irisowner/irissys/iscagent.status

Reading configuration from file: /home/irisowner/irissys/iscagent.conf

ISCAgent[18]: Starting

ISCAgent[19]: Starting ApplicationServer on *:2188

[INFO] ...executed command /home/irisowner/irissys/startISCAgent.sh 2188

[INFO] Copying InterSystems IRIS license key from /durable/iris.key to /usr/irissys/mgr...

[INFO] ...copied key

[INFO] Starting InterSystems IRIS instance IRIS...

[INFO] Invalid registry ownership

[ERROR] Command "iris start IRIS quietly" exited with status 256

[ERROR] See the above messages or /durable/iris/mgr/messages.log for more information

[FATAL] Error starting InterSystems IRIS

-----

I get the same error on Ubuntu ARM. I am using the image, containers.intersystems.com/intersystems/iris-arm64:2022.1.0.114.0.

Minoru Horita · Jan 5, 2022 go to post

I know this is not the proper way to do it, but I worked around this issue by deleting the line for zlib1g in the file, package/requirements_check/requirements.lnxubuntu2004arm64.isc.

Looks like the instance is working fine, so I suspect there is something wrong with requirement checking in installation.

Minoru Horita · Jan 5, 2022 go to post

Thanks. But looks like zlib1g is already installed..

$ sudo apt install zlib1g

Reading package lists... Done

Building dependency tree       

Reading state information... Done

zlib1g is already the newest version (1:1.2.11.dfsg-2ubuntu1.2).

0 upgraded, 0 newly installed, 0 to remove and 11 not upgraded.
Minoru Horita · Jan 5, 2022 go to post

I was trying to install the preview version on Ubuntu 20.04.3 LTS  ARM64(in a VM on Mac M1).

But irisintall gave the the following error. Installing zlib1g-dev did not solve the problem. Could anyone suggest me what I was missing?

-----

Your system type is 'Ubuntu LTS (ARM64)'.

zlib1g version 1 is required.

** Installation aborted **

Minoru Horita · Jul 21, 2020 go to post

みなさん、ありがとう！

We're very excited to be part of this global community. Look forward to talking to you in the Japanese Community !

Minoru Horita · Apr 15, 2019 go to post

Thanks, Benjamin.

I meant that the row I created through the API did not show up via SQL so that your explorer demo didn't work. 

I checked the domain definition, and the allowCustomUpdates flag was true. 

I will look and see if there is anything else that I am missing, and get back here..

Minoru Horita · Mar 27, 2018 go to post

Thanks, Benjamin.

Calling SetParameter() after saving the created domain worked perfectly.

I understand that working with Domain Definitions is more convenient in most cases, but I was looking for a way to deal with a situation where several domains need to be created by a user who is not so familiar with COS, and I thought it would be good to write code that creates a domain and feeds data.