I cannot connect to one particular IBM i server

[richardm90]

Describe the bug

I use Code for IBM i to connect to a number of my clients servers and have never had problems connecting but there is one client that I cannot connect and I cannot work out why.

Here's what I've checked.

• Code for IBM i = v2.14.5
• I can successfully connect to their server using SSH.
• QSSHD is enabled.
• I have the following in my .bashc file.

$ cat .bashrc
PATH=/QOpenSys/pkgs/bin:$PATH
export PATH

• I have /QOpenSys/pkgs/bin/bash in my path.

$ which bash
/QOpenSys/pkgs/bin/bash
$ echo $SHELL
/QOpenSys/pkgs/bin/bash

• Their QCCSID value is 285.
• They are running V7R5.
• I get a warning notification that says Code for IBM i will not function correctly until the temporary library has been corrected in the settings.. The temporary library is been set to ILEDITOR and I have permissions to this library, I have *ALLOBJ authority.
• The final notification is an error notification and says Not connection to myibmi! There is no way to run SQL on the system.
• When it fails to connect I get the following window.

Clicking reconnect results in the same Connection Lost window being displayed.

I never actually get a connection but if I monitor the Code for IBM i: myibmi output as it performs the various checks there is one repeating error that doesn't look correct.

/home/RICHARD: /home/RICHARD/.vscode/cqsh_1 -c "system \"call QSYS/QZDFMDB2 PARM('-d' '-i' '-t')\""
select cast(LONG_COMMENT as VarChar(200)) LONG_COMMENT from qsys2.sysroutines where routine_schema = 'ILEDITOR' and routine_name = 'GETMBRINFO'
{
    "code": 127,
    "signal": null,
    "stdout": "",
    "stderr": "qsh: 001-0019 Error found searching for command system. No such path or directory."
}

I can see this same errors being repeated when trying to run various commands. It seems it cannot find the PASE system command but I can definitely run this from an SSH session.

$ system "call QSYS/QZDFMDB2 PARM('-d' '-i' '-t')"
DB2>
^C
system "dspsysval qccsid"
                                                   System Values                                                        Page     1
5770SS1 V7R5M0  220415                                                                             MYIBMI  25/01/12  15:33:49 UTC
                Current                         Shipped
 Name           value                           value                           Description
 QCCSID      >  285                             65535                           Coded character set identifier
     Note:  > means current value is different from the shipped value
                                         * * * * *   E N D  O F  L I S T I N G   * * * * *

I'm guessing there must be something with the .vscode/cqsh_1 command that isn't picking up my $PATH correctly, maybe?

Anyone got any ideas?

[worksofliam]

qsh: 001-0019 Error found searching for command system

This is concerning!

From a pase shell, what happens if you run this command: -bash-5.2$ echo "which system" | /usr/bin/qsh

Here is my output:

-bash-5.2$ echo "which system" | /usr/bin/qsh
/QOpenSys/usr/bin/system

[richardm90]

@worksofliam, well done, you've got it!

$ echo "which system" | /usr/bin/qsh
qsh: 001-0019 Error found searching for command which. No such path or directory.
$ which system
/QOpenSys/usr/bin/system
$ echo $SHELL
/QOpenSys/pkgs/bin/bash

The system command exists in /QOpenSys/usr/bin not /QOpenSys/pkgs/bin.

This particular server has a system level PATH environment variable set to just /QOpenSys/pkgs/bin that I'm guessing is being used by QShell. When I run strqsh from 5250 and enter "echo $PATH" I get "/QOpenSys/pkgs/bin".

I'll dig a bit further to work out why my bash sessions have a good path but this must be the problem.

Many Thanks

[worksofliam]

Maybe there is an enhancement we should make where we use the explicit path to system.