0
363

Written by

Phillip Wu
Follow
Question Phillip Wu · Feb 6, 2023

irissqlcli install

#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

Comments

Dmitry Maslennikov · Feb 7, 2023

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

0
Phillip Wu  Feb 9, 2023 to Dmitry Maslennikov

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?

0
Dmitry Maslennikov  Feb 10, 2023 to Phillip Wu

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

0
Phillip Wu  Feb 12, 2023 to Dmitry Maslennikov

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?

0
Dmitry Maslennikov  Feb 13, 2023 to Phillip Wu

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.

0
Phillip Wu  Feb 16, 2023 to Dmitry Maslennikov

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

0