Nova postagem

Pesquisar

Pergunta
· jan 2

Need information

Hello everyone,

How can i download the iris odbc for linux ubuntu in order to recover the file 'libirisodbcu.so'.

thanks in advance

3 Comments
Discussão (3)1
Entre ou crie uma conta para continuar
Pergunta
· jan 2

How can I create a SQLGateway connection using code?

Hi everyone,

I’m currently experimenting with the SQL Gateway Connection, CREATE FOREIGN SERVER, and the THROUGH command (IRIS Documentation). To speed up my tests, I’ve combined several DemoDataSets in a Docker container and would like to automate the creation of SQL Gateway Connections using code. 

(By the way, if you’re interested, the Docker container is available here: Demo DBs IRIS.)

To achieve this, I’m using SQL to create a connection by running a command like INSERT INTO %Library.sys_SQLConnection. While this successfully displays the connection in the Management Portal, it cannot actually be used.

Testing the connection results in this error: Connection failed. <ILLEGAL VALUE>decode+1^%apiGTW

After some investigation, I traced the issue to how the password is handled. Specifically, if I manually enter something into the password field in the Management Portal (even though the DuckDB InMemory DB doesn’t require a password), save it, and then test the connection again, it works perfectly.

It seems like there’s some sort of processing happening in the UI—possibly encrypting the password—that isn’t applied when the connection is created directly via SQL.

Has anyone encountered this before, or does anyone know how to handle this? I’d love to hear your insights or any possible solutions!

Thanks! 😊

3 Comments
Discussão (3)2
Entre ou crie uma conta para continuar
Pergunta
· jan 2

Acessing FHIR Server using SLES Apache Server with WebGateway

Hello Community,

we're running an Iris installation on SLES 15.5 using the SLES Apache server and web gateway for hosting the management portal on Port 57772 (e.g. http://<host-name>:57772/csp/sys/%25CSP.Portal.Home.zen?$NAMESPACE=HL7TOFHIR) on the same machine. The Iris installation also provides a FHIR Server in a separate namespace which uses the base URL http://<host-name>:57772/fhir/r4 for connections.

The installation is locked down and the SLES Firewall is activated an configured to just allow connections on port 57772 and 1972. Apache currently listens to Port 57772 only. The installation folder of the web gateway is /opt/webgateway/ the instance is called qsfhir.

We're using an apache configuration which is included into the httpd.conf and a virtual host configuration as follows:

#### BEGIN-ApacheCSP-SECTION included by httpd.conf.local####
LoadModule csp_module_sa "/opt/webgateway/bin/CSPa24.so"
CSPModulePath "/opt/webgateway/bin/"
CSPConfigPath "/opt/webgateway/bin/"
Alias /csp/ "/opt/webgateway/qsfhir/csp/"
<Location /csp>
        CSP On
</Location>
<Location /fhir>
        CSP on
</Location>
#### END-ApacheCSP-SECTION ####

#### BEGIN-ApacheCSP-SECTION-QSFHIR ####
Alias /qsfhir/csp/ "/opt/webgateway/qsfhir/csp/"
#### END-ApacheCSP-SECTION-QSFHIR ####

#### iris57772.conf form vhosts.d ####
<VirtualHost *:57772>
    ServerAdmin <email-address>
    ServerName <host-name>
    ServerAlias <host-alias>
    DocumentRoot "/opt/webgateway/qsfhir/csp/"
    Alias /csp/ "/opt/webgateway/qsfhir/csp/"
    <Directory "/opt/webgateway/qsfhir/csp">
        AllowOverride None
        Options MultiViews FollowSymLinks ExecCGI
        Require all granted
        <FilesMatch "\.(log|ini|pid|exe)$">
            Require all denied
        </FilesMatch>
    </Directory>
    <Directory "/opt/webgateway/bin/">
        AllowOverride None
        Options None
        Require all granted
        <FilesMatch "\.(log|ini|pid|exe)$">
            Require all denied
        </FilesMatch>
    </Directory>
</VirtualHost>

This configuration allows us to define an independent default web-application on Port 80. This is a precondition to enable certificate creation with letsencrypt as the next step. With this configuration we are able to access the management portal and the communication between an internal namespace and the Fhir Client works without problems.

This means the FHIR server can be accessed from the iris installation, but we're facing the problem, that the FHIR server is not accessible from outside.

When I'm tracing requests on the webgateway management site, I observe local requests, which are answered like expected:

and I see the requests sent from the external Postman application which result in an 404 Not Found response:

It might be just an Alias missing, or an <Directory> configuration to be added to the apache configuration, but I tried almost everything that came into my mind without any success.

Any help or hint where to look for further information or what to try next is appreciated.

Thanks for your time and kind regards,

Martin

1 Comment
Discussão (1)1
Entre ou crie uma conta para continuar
Anúncio
· jan 2

InterSystems Open Exchange Applications Digest, December 2024

Hello and welcome to the December 2024 Open Exchange Recap.
General Stats:
23 new apps in December
443 downloads in December
1,028 applications all time
38,227 downloads all time
2,981 developers joined
New Applications
IRIS Global VSCode Editor
By Yuri Marx
iris-HL7v2Gen
By Muhammad Waseem
iris-http-calls
By Oliver Wilms
tz - ObjectScript Time Zone Conversion Library
By Eric Fortenberry
vault-link
By Henrique Dias
Database-Size-Monitoring
By sara aplin
docs-intersystems
By Dmitry Maslennikov
AoC2024_test
By Robert Cemper
SharePoint Online SPO REST API
By Mark OReilly
ks-fhir-gen
By Robert Barbiaux
iris-unit-test-dashboard
By Chi Nguyen-Rettig
ObjectScript-To-XML
By Akio Hashimoto
IRIS_ISTIO
By Ariel Glikman
Vector Search for MPI
By Luis Angel Pérez Ramos
FHIR Primitive Extension
By Keren Skubach
ISCLauncher
By Benjamin Spead
GPG
By Eduard Lebedyuk
DICOM Image Demo
By Keren Skubach
iris-global-yaml
By Yuri Marx
LLM QuickStart
By Chris Stewart
pyiris-iceberg
By Patrick Sulin
Doxygenerate
By John Murray
mongoCDC
By Netanel Frankel
New Releases
iris-python-lookup-table-utils by Johannes Heinzl
v1.0.1
  • Extends instructions in README
  • Fixes Dockerfile by omitting fixed version which became obsolete
IRIS WHIZ - HL7v2 Browser Extension by Rob Ellis
v1.10.0
Version 1.10.0
Feature Added
: ChartJS Analysis
An Analyse button now appears on message viewer page. This opens the results of your current message search in a new tab and shows you the data in some default ChartJS pie charts, a bar chart and a line chart. See item 33 in the ReadMe file for full details.
Thanks to the creators of the following libraries I used: * Chart.js v4.4.5 * chartjs-adapter-date-fns v3.0.0 * chartjs-plugin-datalabels v2.2.0 * chartjs-plugin-zoom v2.0.1 * Hammer.JS - v2.0.8 - 2016-04-23
Each released under the MIT License. See ReadMe and chartjs directory for further details.
Feature Added
: Queue refresh
Iris now has an auto refresh dropdown for the Queues page. Will refresh the queue at the interval selected. Does not load on Ensemble as it already has this feature.
Feature Added
: Export Search as CSV
On the Message Viewer page you can click the Iris Whiz Export button to download a CSV copy of the data currently in your search table.
Useful if you want to do quick analysis on your data but don't want to use the fancy new Chart.JS page I spent ages creating.
Feature Added
: Production Page Message Refresh
Added refresh button on the Message tab on the production page. Set an interval in the dropdown for automatic refreshing.
Feature Added
: Production Page Queue Sort
Added sort options for the queue tab on the production page. Defaults to sorting by error count. Click a table header to switch between asc and desc sort order. Use the search bar to find items quickly.
Feature Added
: Category Dropdown Case-Insensitive Order
Alphabetises the category dropdown list on the production page, regardless of case. Without this the order is case dependent.
Bug Fix
: Hide Related
Hide related button going for walkies.
Feature Updated
: TraceViewer
Clickable area to highlight the message in the FullTrace tab was tiny. Now it's all of the background area.
Feature Updated
: Saved Searches
Saved Searches now automatically use Body Property Criterion Type if RawContent is found in the text values.
Feature Updated
: Expand Schema
Expand Schema buttons now highlight on hover. Also now square to prevent them messing the visual of the message.
isc-json by Timothy Leavitt
v2.0.1

Fixed

7: Make the library compatible with %IPM v0.9+

iris-energy-isodata by Muhammad Waseem
v1.0.3
Fixed Python library version
isc-rest by Timothy Leavitt
v1.2.2

[1.2.2] - 2024-12-05

Fixed

  • Added compatibility with IPM 0.9+
Git for Shared Development Environments by Timothy Leavitt
v2.8.0

Added

  • Production Decomposition mode allows controlling interoperability productions as individual files for each host (#469)
  • Mapping configuration supports parameter expansion of \<env> to the environment name (#640)
  • Added saving settings as system default for new namespaces (#535)
  • Added filtering through branch names in UI (#615)
  • FullLoad pull event handler allows deploying changes with a full import of the repository (#619)
  • Pull and Sync options no longer log a fatal error if remote branch does not exist (#562)

Fixed

  • Fixed minor issues in Studio UI (#641)
  • Document save is forced before menu operations that can modify repository state
ks-iris-lib by Robert Barbiaux
v1.0.2
Separate unit test runtime root directory
ServiceInspection by Wolis Oliavr
v1.0.1
Add some detail pages and data statistics
v1.1.0
Update log
  1. Add two inspection items
  2. Add a configuration page to set the threshold for inspection items and whether to push alarm information to the email image configuration;
  3. Add a detail page that displays detailed information about component queues and inactive duration
  4. Add email alerts (requiring self configured email addresses), and send an alert email to the designated email address when the value exceeds the threshold
v1.1.1
Zpm installation bug fix
Intersystems-Monitoring by Teunis Stolker
v1.0.20
Various improvements that allow (temporary) suppression of errors
InterSystems Package Manager by Robert Kuszewski
v0.9.1
0.9 marks significant progress towards our 1.0 goals. IPM now supports using container registries for package distribution.
We've made a few incompatible changes so please read the latest release notes.
IRIS apiPub by Claudio Devecchi
v1.1.78
bug fixes & improvements
v1.1.79
improvements
d[IA]gnosis by Luis Angel Pérez Ramos
v2.0.0
New major update! LLM has been include to identify diagnosis from free text.
Ollama's docker image has been included to the project to leverage the llama3.2 model capabilities.
Most downloaded
MDX2JSON
By Eduard Lebedyuk
DeepSeeWeb
By Anton Gnibeda
ssl-client
By Evgeny Shvarov
WebTerminal
By Nikita Savchenko
ObjectScript-Math
By Peter Steiwer
iris-bi-utils
By Evgeniy Potapov
RESTForms2
By Henry Pereira
passwordless
By Sergey Mikhailenko
December, 2024Month at a GlanceInterSystems Open Exchange
Discussão (0)1
Entre ou crie uma conta para continuar
Pergunta
· jan 2

Nested queries

Hi Guys,

This Nested query is not working for some reason, but they work fine when executing  separately ?  

select id from FDRD_Com.List where vehicle in (select Car from FDRD_Com.Prod where ProductLineName='Toyota' and Car is not null)

 

Thanks

3 Comments
Discussão (3)2
Entre ou crie uma conta para continuar