Integrating Open Source on IBM i: Advanced Topics and Optimization

Pairing open source with traditional IBM i programs works great for APIs, web, and mobile applications. But how do you stay on top of your business’s requirements for speed and scalability?

OCEAN User Group recently asked Alan to help answer that question. In the recording of their November meeting (also linked from the graphic below), he covers:

Read more

What’s in Your ODBC Driver? A 2024 Update

ODBC with Db2 for IBM iSince IBM announced Yum support for installing the IBM i Db2 ODBC driver, as documented in our 2022 tutorial, users can update their driver more easily.

To help users determine what’s changed, IBM maintains a list of fixes and enhancements for each IBM i ODBC driver release.

Read more

Update Corrects an Issue Loading libpq.so

PostgreSQLIBM has delivered a fix for an issue with the libpq (PostgreSQL) package. The libpq RPM installer script had a subtle issue where the symbolic links did not get created correctly. IBM i users saw warnings like these:

Read more

Call/Parm Your Open Source Apps from RPG and CL with QSHCALL

QSHONI integration for IBM i RPG, CL and open sourceA few years back I created the QShell on IBM i (QshOni) project to allow QShell/PASE (open source) apps to be more easily integrated and used with traditional IBM i job streams written in RPG and CL. Since then, many developers have adopted QshOni to utilize their open source apps in conjunction with their classic traditional apps.

Recently I added several new commands to QshOni to make living the PASE life even easier for RPG developers. Today’s focus will be on the QSHCALL command.

Read more

Node.js v20 and Other Updated Packages Require New IBM i Repositories

IBM i open source for businessAs we mentioned in our article on installing ODBC via yum, the latest IBM i open source packages require new repositories.

A notable example is Node.js v20. When we hear users say, “I don’t see Node.js v20 listed in available packages, and yum returns ‘No package nodejs20 available‘,” the reason invariably is that the new repositories, ibmi-base and ibmi-release, have not been installed.

Read more

What IBM i Users Should Check when Learning of an Open Source Security Vulnerability

API & web security on IBM iA client asked about a vulnerability found in libwebp, which is used by PHP’s image-handling gd extension.

My first step was to find a reputable source for details. According to this trusted article about the vulnerability, the issue affected only libwebp versions 1.3.1 and earlier. I checked our own system and found we had a patched version from IBM, so we were safe. The client was, too.

Here is the procedure you can use for checking the version of this or any other open source package on IBM i. Read more

Rebuilding the Tomcat Plugin in IBM i 7.5

Apache Tomcat on IBM iOpen source saves the day once again.

When one of our open source support clients discovered that Tomcat plugin for Apache was not supported on their test IBM i 7.5 system, they needed a solution. They relied on Tomcat to serve their Java web applications.

Read more

Older 32-Bit PHP & PASE Apps Can Break in IBM i 7.5

This alert was originally published in Seiden Group’s July 2023 Support Bulletin.
Seiden PHP+ fully supports IBM i 7.5.

IBM i 7.5 includes OpenSSL 1.1.1, an upgrade that can disable older PASE applications that were tied to 1.0.2 or earlier.

Read more

How to Resolve Yum Command FTP Errors on IBM i

While installing packages from IBM’s original open source repository, ibm, users may encounter errors, including:

  • [​Errno 12] Timeout on: ftp://public.dhe.ibm.com/software/ibmi/products/pase/rpms/repo/repodata/repomd.xml: (28, ‘Connection time-out’) Trying other mirror. Error: Cannot retrieve repository metadata (repomd.xml) for repository: ibm. Please verify its path and try again.
  • [​Errno 14] FTP Error 451 – server did not report OK, got 451 Trying other mirror
  • [Errno 14] FTP Error 550 – Access denied: 550 Trying other mirror

Read more

Running the x86 IBM i ODBC driver on ARM Linux with Rosetta

ODBC with Db2 for IBM iI recently did some research on how to run the IBM i ODBC driver under Linux on newer macOS architecture and thought I’d share what I learned.

Over the last few years, macOS has changed from x86 (Intel) to ARM architecture. IBM has kept pace by updating its IBM i ODBC driver to support ARM on macOS as of version 1.1.0.15.

Developers who use a Linux virtual machine, however, will note that there is no ARM version of the Linux driver available yet. While an ARM-native version of the driver would be ideal, Mac users running a Linux virtual machine can run the existing x86 version of the driver using Rosetta for Linux. Read more