irissqlcli install

Question

Question

Phillip Wu · Feb 6, 2023

#InterSystems IRIS

Hi,

I'd like to try out irissqlcli.

My server, that has IRIS installed on it, is SUSE (SUSE Linux Enterprise Server 15 SP1).

How do install this product from GitHub? Detailed instructions would be great!

It would be best if I can download the software from GitHub and then get pip to install from that downloaded file repo.

The recommended:

pip install -U irissqlcli

does not work and comes back with "

ERROR: Could not find a version that satisfies the requirement irissqlcli (from versions: none)
ERROR: No matching distribution found for irissqlcli
"

Once I have this program installed:

irissqlcli -h localhost -U superuser -W

Is this correct?

Discussion (7)2

Log in or sign up to continue

score 0 · Answer 1 · 2023-02-07T00:04:11-05:00

Hi, the way you trying to install is correct. But could you check the version of Python installed there, it requires version from 3.7 to 3.10

score 0 · Answer 2 · 2023-02-09T22:44:19-05:00

My python version is 3.6.5 so it looks like it is too old.

I do have an a test OpenSUSE server on Python 3.11.

Would this be allowed to connect remotely to my IRIS/trakCare DB?

If so is there anything special I would need to do this?

score 0 · Answer 3 · 2023-02-10T01:17:52-05:00

I have not tested it with 3.11, so, not sure how it will work there. You can install multiple versions of Python with pyenv for instance.

Yes, this tool connects remotely to any IRIS instance

score 0 · Answer 4 · 2023-02-12T23:34:38-05:00

Thanks.

I have installed it on my OpenSUSE test server but when it tries to connect to the trakCare server, I get "Connection Refused".

There is no firewall running on my OpenSUSE test server nor the trakCare server.
I've tested this with firewall-cmd --stat.

The trakCare server is SUSE Linux

The main comms firewall is not blocking the transmssion either.
Do you know what ports are being used between OpenSUSE test server and the trakCare server?

score 0 · Answer 5 · 2023-02-13T01:57:06-05:00

Not sure if there are any changes from default. But, make sure, that you using SuperServer port, which is by default 1972, not WebServer port.

score 0 · Answer 6 · 2023-02-16T19:25:04-05:00

Thanks.

I'm getting 'timed out'.

Can I get the reason why?

irissqlcli -h TRAK-BASE01 -u superuser -W -p 51773
Password for superuser:
timed out

I got the SuperServer port as follows

BASE01:~ # iris list
Configuration 'BASETC' (default)
directory: /trak/base/tc/iris/basetc
versionid: 2021.1.0.215.0.21669
datadir: /trak/base/tc/iris/basetc
conf file: iris.cpf (SuperServer port = 51773, WebServer = 52773)
status: running, since Thu Feb 2 11:29:56 2023
state: alert
product: InterSystems IRISHealth

score 0 · Answer 7 · 2023-02-17T11:44:17-05:00

Evgeny Shvarov · Feb 17, 2023

Now can be installed via Brew:

$ brew install caretdev/tap/irissqlcli

Thanks @Dmitry Maslennikov

0 0